Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I work out the Sensitivity Analysis for this project? 0 1 2 3 4 5 6 7 8 9 10 INITIAL INVESTMENT -$980,517.50
How do I work out the Sensitivity Analysis for this project?
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
| INITIAL INVESTMENT | -$980,517.50 | |||||||||||
| OPERATING CASH FLOW | ||||||||||||
| Cashflow before tax and depreciation | $636,070.50 | $795,088.13 | $954,105.75 | $1,097,221.61 | $1,206,943.77 | $1,146,596.58 | $1,089,266.75 | $1,034,803.41 | $983,063.24 | $933,910.08 | ||
| Depreciation Costs | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | ||
| CF before Tax | $547,823.92 | $706,841.55 | $865,859.17 | $1,008,975.03 | $1,118,697.19 | $1,058,350.00 | $1,001,020.17 | $946,556.83 | $894,816.66 | $845,663.50 | ||
| Tax | -$164,347.18 | -$212,052.46 | -$259,757.75 | -$302,692.51 | -$335,609.16 | -$317,505.00 | -$300,306.05 | -$283,967.05 | -$268,445.00 | -$253,699.05 | ||
| After Tax | $712,171.10 | $918,894.01 | $1,125,616.92 | $1,311,667.54 | $1,454,306.35 | $1,375,855.00 | $1,301,326.22 | $1,230,523.88 | $1,163,261.66 | $1,099,362.55 | ||
| Depreciation | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | -$88,246.58 | ||
| Operating Cash Flow | $623,924.52 | $830,647.43 | $1,037,370.34 | $1,223,420.96 | $1,366,059.77 | $1,287,608.42 | $1,213,079.64 | $1,142,277.30 | $1,075,015.08 | $1,011,115.97 | ||
| TERMINAL CASHFLOW | $373,574.25 | |||||||||||
| FREE CASH FLOW | -$356,592.98 | -$149,870.07 | $56,852.84 | $242,903.46 | $385,542.27 | $307,090.92 | $232,562.14 | $161,759.80 | $94,497.58 | $404,172.72 | ||
| NPV & IRR | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
| Actuals | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | ||
| Cash Flows | -$980,518 | $623,925 | $830,647 | $1,037,370 | $1,223,421 | $1,366,060 | $1,287,608 | $1,213,080 | $1,142,277 | $1,075,015 | $1,011,116 | |
| Disc Rate (WACC)| | 10.00% | |||||||||||
| NPV | $6,444,854 | $567,204 | $686,485 | $779,392 | $835,613 | $848,216 | $726,821 | $622,502 | $532,881 | $455,911 | $389,829 | |
| IRR | 84.60% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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
The Laymans Guide To Managing Your Investments
Authors: Thomas Dunleavy
1st Edition
979-8763592214
