Investment Model

Project #1 Initial Investment Acqisition Cost Investment Length (yrs) Depreciation Method Tax Benefit

1,000,000 10,000 10 Straight-Line Method

Revenues F. Expense

0.0500

Salvage Value

125,000

Beginning Book Value

Total Outflow

960,000

Depreciation

Year of Investmet

2010

Ending Book Value

Cash Flows Initial Revenues

150,000

Initial Variable Cost as %

0.1000

Initial Fixed Cost as %

0.1000

Revenues

Tax Rate

0.2500

Variable Expenses Fixed Expenses

Discount Rate

0.0800

Ebitda * Depreciation

End of Investment

2020

Net Present Value

210,466

Internal Rate of Return

13%

Ebit Taxes Cash Flows Discounted CF

* Ebitda=Earnings Before Interest T

ect #1 Projected Growth Rates 2010

2011

2012

2013

2014

2015

2016

0.1000

0.1000

0.1000

0.1000

0.1000

0.1000

0.1000

0.1000

0.1000

0.1000

0.1000

0.1000

1,000,000

912,500

825,000

737,500

650,000

562,500

87,500

87,500

87,500

87,500

87,500

87,500

912,500

825,000

737,500

650,000

562,500

475,000

Value

Book Value 1,000,000

Projected Operating Cash Flows 2010

2011

2012

2013

2014

2015

2016

150,000

165,000

181,500

199,650

219,615

241,577

265,734

15,000

16,500

18,150

19,965

21,962

24,158

26,573

15,000

18,150

19,965

21,962

24,158

26,573

29,231

120,000

130,350

143,385

157,724

173,496

190,845

209,930

0

87,500

87,500

87,500

87,500

87,500

87,500

120,000

42,850

55,885

70,224

85,996

103,345

122,430

30,000

10,713

13,971

17,556

21,499

25,836

30,607

-870,000

119,638

129,414

140,168

151,997

165,009

179,322

-870,000

119,638

119,828

120,171

120,660

121,287

122,044

arnings Before Interest Taxes Depreciation and Ammortization

-870000

119637.5

129413.75

140167.63 151996.89

165009.08 179322.48

2017

2018

2019

2020

0.1000

0.0000

0.0000

0.0000

0.1000

0.0000

0.0000

0.0000

475,000

387,500

300,000

212,500

87,500

87,500

87,500

87,500

387,500

300,000

212,500

125,000

2017

2018

2019

2020

292,308

292,308

292,308

292,308

29,231

29,231

29,231

29,231

32,154

29,231

29,231

29,231

230,923

233,846

233,846

233,846

87,500

87,500

87,500

87,500

143,423

146,346

146,346

146,346

35,856

36,587

36,587

36,587

195,067

197,260

197,260

197,260

122,925

115,099

106,573

98,679

195067.23

197259.54

197259.54

197259.54

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

28 ###

0

1

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

Follow the steps to enable your Investment Model. >>

This template is prepared for calculating effective rates for different time periods.

1)

Type the name of the project, investment, etc that you want to model: Project #1

>>

Your Investment Model is ready to use. Following steps are for online use.

2)

Visit the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password to create your Personal Budget.

3)

Visit the site below: http://trial.spreadsheetweb.com/spreadsheetweb/ Login to page with your new account information.

4)

Click "Add Web Application" to upload this file. Check "Single Record Application", this will enable to save t Your Personal Budget will be created automatically. You can simply use the Personal Budget from that link or place it on your website.

>>

Your Personal Budget will look like:

http://www1.spreadsheetweb.com/SpreadSheetWeb/Output.aspx?ApplicationId=4a9bd8bf-7d89-468b-b7d9 >>

In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm

Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/

odel.

this will enable to save the model online.

4a9bd8bf-7d89-468b-b7d9-bdbb4c6e2029

%3c%3fxml+version%3d%221.0%22+encoding%3d%22utf-16%22%3f%3e%0d%0a%3cWizardSettin ergedSavingCell%3e%0d%0a++++++++++%3cName%3ePSWMergedSavingCell_1_2%3c% sControlVisible%3e%0d%0a++++++++++%3c%2fInputCell%3e%0d%0a++++++ ++++++++++%3cListItemsAddress+%2f%3e%0d%0a++++++++++++ ++%3cCellLink%3eDEFAULT%3c%2fCellLink%3e%0d%0a++++++ ++++++++++++++++%3cCellHasFormula%3eFalse%3 idth%3e59.25%3c%2fWidth%3e%0d%0a++++++ ++++%3cImages+%2f%3e%0d%0a+++ %0a++++++++++++++++% +%3cAddress%3e%3d'M

UEsFBgAAAAAAAAAAAAAAAAAAAAAAAA%3d%3d

t%3eFalse%3c%2fWrapText%3e%0d%0a++++++++++++++++%3cFontSize%3e11%3c%2fFontS %3cRequiresValidation%3efalse%3c%2fRequiresValidation%3e%0d%0a+++++++++++++ 3e%0d%0a++++++++++++++++%3cInputCell%3e%0d%0a++++++++++++ 2fCellHasFormula%3e%0d%0a++++++++++++++++%3cFontName%3e IsHidingEnabled%3e%0d%0a++++++++++++++++++%3cIsDi ++++++++++++%3cInputCell%3e%0d%0a++++++++ +++++++++++%3cY%3e10%3c%2fY%3e%0d% 0d%0a++++++++++++++++%3cExp %230%3c%2fFormat%3e%0d%0 3cWidth%3e67.5%3c%2

tSize%3e11%3c%2fFontSize%3e%0d%0a++++++++++++++++%3cX%3e6%3c%2fX%3e%0d%0 0a++++++++++++++++%3cText+%2f%3e%0d%0a++++++++++++++++%3cHeigh +++++++++++%3cImages+%2f%3e%0d%0a++++++++++++++++%3cForm e%0d%0a++++++++++++++++%3cVerticalAlign%3eCenter%3c%2fVer +++++++++++++%3cTD%3e%0d%0a+++++++++++++++ ge%3eFalse%3c%2fMerge%3e%0d%0a++++++++++++ 0a++++++++++++++++%3cColSpan+%2f%3 ++++++++++++++%3cFontName%3e +++++%3cIsControlEnabled%3e ge%3eFalse%3c%2fMerg

+++++++++++++%3cCellHasFormula%3eTrue%3c%2fCellHasFormula%3e%0d%0a+++++++++ %3cGrid+%2f%3e%0d%0a++++++++++++++++%3cExport+%2f%3e%0d%0a++++++ Format%3e%23%2c%23%230%3c%2fFormat%3e%0d%0a++++++++++++++++ ibri%3c%2fFontName%3e%0d%0a++++++++++++++++%3cWrapText 2fStyle%3e%0d%0a++++++++++++++++%3cMerge%3eFalse 3eCenter%3c%2fVerticalAlign%3e%0d%0a++++++++++ %0a++++++++++++++%3c%2fTD%3e%0d%0 +++++++++++++++%3cRowSpan+% +++++++++++%3cY%3e28%3 4.5%3c%2fWidth%3e%0

4.5%3c%2fWidth%3e%0d%0a++++++++++++++++%3cText+%2f%3e%0d%0a++++++++++++++++

a++++++++++++++++%3cHeight%3e15.75%3c%2fHeight%3e%0d%0a++++++++++++++++%3cAlign

+++++++++++%3cAlign%3eLeft%3c%2fAlign%3e%0d%0a++++++++++++++++%3cVerticalAlign%3eCe

++%3cVerticalAlign%3eCenter%3c%2fVerticalAlign%3e%0d%0a++++++++++++++++%3cCel lHasFormula

++++%3cCel lHasFormula%3eFalse%3c%2fCellHasFormula%3e%0d%0a++++++++++++++++%3cFontNam

+++++++++%3cFontName%3eCalibri%3c%2fFontName%3e%0d%0a++++++++++++++++%3cWrapText

++++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d%0a++++++++++++++++%3cFontSize%3e1

+++++%3cFontSize%3e11%3c%2fFontSize%3e%0d%0a++++++++++++++++%3cX%3e24%3c%2fX%3e %

%3cX%3e24%3c%2fX%3e %0d%0a++++++++++++++++%3cY%3e29%3c%2fY%3e%0d%0a++++++++++

3e%0d%0a++++++++++++++++%3cImages+%2f%3e%0d%0a++++++++++++++++%3cFormControls

++++++%3cFormControls+%2f%3e%0d%0a++++++++++++++++%3cGrid+%2f%3e%0d%0a++++++++

f%3e%0d%0a++++++++++++++++%3cExport+%2f%3e%0d%0a++++++++++++++%3c%2fTD%3e%0

+++++%3c%2fTD%3e%0d%0a++++++++++++++%3cTD%3e %0d%0a++++++++++++++++%3cPSCF

+++++++++++%3cPSCFormated%3efalse%3c%2fPSCFormated%3e%0d%0a++++++++++++++++%3cSt

++++++++++++%3cStyle%3eClass645%3c%2fStyle%3e%0d%0a++++++++++++++++%3cMerge%3eF

+++++++%3cMerge%3eFalse%3c%2fMerge%3e%0d%0a++++++++++++++++%3cRowSpan+%2f%3e%0

%3cRowSpan+%2f%3e%0d%0a++++++++++++++++%3cColSpan+%2f%3e%0d%0a+ ++++++++++++

%0a+ +++++++++++++++%3cFormat%3eGeneral%3c%2fFormat%3e%0d%0a++++++++++++++++%

+++++++++++++++%3cWidth%3e64.5%3c%2fWidth%3e%0d%0a++++++++++++++++%3cText+%2f

+++++++%3cText+%2f%3e%0d%0a++++++++++++++++%3cHeight%3e15.75%3c%2fHeight%3e%0d%

5%3c%2fHeight%3e%0d%0a++++++++++++++++%3cAlign%3eLeft%3c%2fAlign%3e%0d%0a+++++++

n%3e%0d%0a+++++++++ +++++++%3cVerticalAlign%3eCenter%3c%2fVerticalAlign%3e%0d%0a+++++