Chapter9_BlooperSpreadsheetModel (1)

Chapter9_BlooperSpreadsheetModel (1) - Formulaview A 1 2 3...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Page 1 A. Inputs Spreadsheet Name Initial investme 10,000 Investment Salvage value 2,000 Salvage Initial revenue 15,000 Initial_rev Initial expenses 10,000 Initial_exp Inflation rate 0.05 Inflation Discount rate 0.12 Disc_rate Acct receiv. as    1/ 6 A_R Inven. as % of  0.15 Inv_pct Tax rate 0.35 Tax_rate Year: 0 1 2 3 4 5 6 B. Fixed assets Investment in fi 10,000 Sales of fixed assets 1,300 CF, invest. in fi -10,000 0 0 0 0 0 1,300 C. Operations Revenues 15,000 15,750 16,538 17,364 18,233 Expenses 10,000 10,500 11,025 11,576 12,155 Depreciation 2,000 2,000 2,000 2,000 2,000 Pretax profit 3,000 3,250 3,513 3,788 4,078 Tax 1,050 1,138 1,229 1,326 1,427 Profit after tax 1,950 2,113 2,283 2,462 2,650 Operating Cash flow 3,950 4,113 4,283 4,462 4,650 D. Working capital Working capita 1,500 4,075 4,279 4,493 4,717 3,039 0 1,500 2,575 204 214 225 -1,679 -3,039 CF, invest. in w -1,500 -2,575 -204 -214 -225 1,679 3,039 E. Project valuation Total project ca -11,500 1,375 3,909 4,069 4,238 6,329 4,339 Discount factor 1.0 0.8929 0.7972 0.7118 0.6355 0.5674 0.5066 PV of cash flow -11,500 1,228 3,116 2,896 2,693 3,591 2,198 Net present val 4,223 Change  in work A B C D E F G H 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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/27/2011 for the course ECON 6000 taught by Professor Fayissa during the Spring '10 term at Middle Tennessee State University.

Page1 / 4

Chapter9_BlooperSpreadsheetModel (1) - Formulaview A 1 2 3...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online