In: Finance
Model x is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an economic life of five years. Depreciation is taken on a straight-line basis, with no expected salvage value. Net working capital required immediately is expected to be $100,000 and will be recovered in full upon the project's completion in five years. In the optimistic-scenario forecast, the annual sales volume is 47,000 units, while the sale price is $122 per unit with a variable cost of $60 per unit. Annual fixed costs are estimated to $1,036,000. If the appropriate discount rate is 11.50% and the tax rate 30%, what is the project's NPV?
$3,677,012 |
|
$3,776,391 |
|
$3,875,770 |
|
$3,975,148 |
|
$4,074,527 |
Total cost=working capital requirement+fixed asset investment=$100000+$1000000=$1100000
Again $100,000 working capital has to be added to Year5 cashflows due to its recovery in nature
All the formulas and how find the cashflows and NPV is given the below table
NPV can be calculated using NPV function in EXCEL
=NPV(rate, Year1 to Year5 cashflows)-Year0 cashflow
=NPV(11.5%,Year1 to Year5 cashflows)-$1100000
NPV=$3,975,148
option d is correct