This paper circulates around the core theme of Do we have everything we need on sales and costs? together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
NPV and IRR calculations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cost of Capital |
1.00% |
|
|
|
|
|
|
|
| Time/yr |
0 |
1 |
2 |
3 |
4 |
5 |
|
|
| Cash flow Input here |
|
|
|
|
|
|
|
|
| Discounted CF |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
| NPV |
0 |
=cf1/((1+n)^1) |
=cf2/((1+n)^2) |
=cf3/((1+n)^3) |
=cf4/((1+n)^4) |
=cf5/((1+n)^5) |
|
|
| PV factor |
|
0.99009901 |
0.980296049 |
0.970590148 |
0.960980344 |
0.951465688 |
|
|
|
|
|
|
|
|
|
|
|
| IRR |
#NUM! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Year |
|
|
|
|
|
|
|
|
0 |
1 |
2 |
3 |
4 |
5 |
|
|
| Capital Outlay-30000000 |
|
|
|
|
|
|
|
|
| NWC Recovery |
|
|
|
|
|
|
|
|
| Sales |
|
|
|
|
|
|
|
|
Margin 60%
of sales or 40% CGS exp |
0 |
0 |
0 |
0 |
0 |
|
|
| SGA expense 10% of sales |
|
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
| Gross Profit |
|
0 |
0 |
0 |
0 |
0 |
|
|
Depreciation
Expense – Straight Line |
|
|
|
|
|
|
|
| Equip $25000000/5 |
|
|
|
|
|
|
|
|
| EBT |
|
0 |
0 |
0 |
0 |
0 |
|
|
| Tax Exp at 35% |
|
0 |
0 |
0 |
0 |
0 |
|
|
| Net Income |
|
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
| Outflow |
|
|
|
|
|
|
|
|
| Cashflow add Depreciation back in |
|
0 |
0 |
0 |
0 |
0 |
|
|
| NWC Recapture |
|
|
|
|
|
|
|
|
| Total Cashflow |
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
| Cost of Capital/Discount Rate |
|
|
|
|
|
|
|
|
|
|
NPV |
IRR |
|
|
|
|
|
|
|
$0.00 |
#NUM! |
|
|
