Project Costing and Cash Flow Modelling
For the following project, calculate the undiscounted cash flow. You can do it in Excel and paste the result below:
Year |
0 |
1 |
2 |
3 |
4 |
5 |
Unit Price |
- |
$105 |
$110 |
$115 |
$120 |
$125 |
Units Sold |
- |
900 |
1000 |
1100 |
1200 |
1300 |
Net Sales |
- |
|||||
Variable Costs |
- |
$54,000 |
$60,000 |
$66,000 |
$72,000 |
$78,000 |
Fixed Costs |
- |
$15,000 |
$15,750 |
$16,538 |
$17,364 |
$18,233 |
Depreciation |
- |
$10,000 |
$10,000 |
$10,000 |
$10,000 |
$10,000 |
PBIT |
- |
|||||
Tax@40% |
- |
|||||
NOPAT |
- |
|
Place your answer (Excel) in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above.
In case of any doubts or Issues, please comment below
Get Answers For Free
Most questions answered within 1 hours.