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

The Answer is in the image, click to view ...

Question: 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%

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock