In: Finance
Year |
Total Contribution Margin |
1 |
$180,000 |
2 |
$300,000 |
3 |
$360,000 |
4-6 |
$440,000 |
The contribution margin if the “Standard Classic” is chosen is expected to be the following:
Year |
Total Contribution Margin |
1 |
$175,000 |
2 |
$280,000 |
3 |
$355,000 |
4-6 |
$438,000 |
Year |
Total Other Fixed Costs |
1-2 |
$180,000 |
3 |
$150,000 |
4-6 |
$120,000 |
Present Value(PV) of Cash Flow: | |||||||||||
(Cash Flow)/((1+i)^N) | |||||||||||
i=discount rate=Required Return=9%=0.09 | |||||||||||
N=Year of Cash Flow | |||||||||||
Income Tax Rate is not mentioned | |||||||||||
Income Tax is not taken into consideration | |||||||||||
ANALYSIS OF "NEW TECH MACHINE" INVESTMENT | |||||||||||
Annual Depreciation =(421000-26000)/6= | $65,833 | ||||||||||
N | Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | |||
A | Initial investment in machine | -$421,000 | |||||||||
B | Initial investment in Working Capital | -$53,000 | |||||||||
c | Contribution Margin | $180,000 | $300,000 | $360,000 | $440,000 | $440,000 | $440,000 | ||||
d | Cost of machine maintenance | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | -$50,000 | ||||
e | Other Fixed Costs | -$180,000 | -$180,000 | -$150,000 | -$120,000 | -$120,000 | -$120,000 | ||||
f | Depreciation expenses | -$65,833 | -$65,833 | -$65,833 | -$65,833 | -$65,833 | -$65,833 | ||||
g=c+d+e+f | Operating Income | -$115,833 | $4,167 | $94,167 | $204,167 | $204,167 | $204,167 | ||||
h | Add:Depreciation (Non Cash expense) | 65,833 | 65,833 | 65,833 | 65,833 | 65,833 | 65,833 | ||||
X=g+h | Annual Operating Cash Flow | -$50,000 | $70,000 | $160,000 | $270,000 | $270,000 | $270,000 | ||||
Y | Terminal Salvage Cash Flow | $26,000 | |||||||||
Z | Working Capital Release | $53,000 | |||||||||
CF=A+B+X+Y+Z | Net Cash Flow | -$474,000 | -$50,000 | $70,000 | $160,000 | $270,000 | $270,000 | $349,000 | SUM | ||
PV=CF/(1.09^N) | Present Valure | -$474,000 | -$45,872 | $58,918 | $123,549 | $191,275 | $175,481 | $208,097 | $237,449 | ||
NPV=Sum of PV | Net Present Value | $237,449 | |||||||||