Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Check my work Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Initial investment Revenues Variable costs Fixed cost Working
Check my work Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Initial investment Revenues Variable costs Fixed cost Working capital Rango Pessimistic Optimistic + 500 - 250 - 158 + 258 + 258 - 158 + 250 - 308 405 305 Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet 10.1 and accompanying data as a starting point for the analysis (Po not round Intermediate calculations. Negative amounts should b indicated by a minus sign. Enter your answers in thousands rounded to the nearest whole dollar.) Project NPV Expected Pessimistic Optimistic Initial investment Revenues Variable costs Fixed costs Working capital Calibri (Body) A Wrap Text General Copy Pasta B 1 U Margo & Contar- $ 00 Format A1 4 x A D E F G H 1 2. 3 4 5 6 2 3 9 10 A. Inputs Initial investment is thousands) Salvage value is thousands Initial revenues ($thousands) Variable costs of revenues) Initial fuced costs (Sthousands) Inflation rate (M) Discount rate 10 Receivables ( of sales) Inventory of next year's casts Tax rate (N) 10,000 2,000 15,000 40.0% 4,000 S.OX 12.0N 16.7% 15.0% 21.0 12 13 Year: 0 1 2 3 15 10,000 . Fixed assets Investments in foed assets Sales of fixed assets Cash flow from foxed assets 1.580 1,580 -10,000 17 11 19 20 21 22 23 24 25 26 27 28 C Operating cash flow Revenues Variable expenses Fixed expenses Depreciation Pretax profit Tax Profit after tax Operating cash flow 15,000 6,000 4,000 2,000 3.000 630 2,370 4,370 15,750 6,300 4,200 2,000 3,250 683 2.568 4,565 16,538 6,615 4,410 2,000 3,513 738 2.775 4,775 17,364 6.946 4,631 2,000 3.788 796 2.993 4,993 18,233 7,293 4,862 2,000 4,078 856 3,221 5,221 1,500 1,500 -1,500 4,075 2,575 -2,575 0.408 4,279 204 -204 0.408 4,493 214 -214 0.408 4,717 225 -225 0.408 3,039 1,679 1,679 0.250 0 -3,039 3,039 30 D. Working capital Working Capital Change in working capital Cash flow from investment in working capital E Project valuation Total project cash flow Discount factor PV of cash flow Net present value 35 30 57 -11,500 1.000 11,500 61131 1.795 0.893 1,603 4,364 0.797 3,479 4.561 0.712 3,246 0.63 3,030 6.900 0.567 3,915 4,619 0.507 2.340 42 Sheet1 Road
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started