Question

In: Finance

Model x is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...

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

Solutions

Expert Solution

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


Related Solutions

A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...
A company 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 expected-scenario forecast, the annual sales volume is 49,200 units, while the sale price is $133 per unit with a variable cost of...
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...
A company 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 expected-scenario forecast, the annual sales volume is 44,700 units, while the sale price is $121 per unit with a variable cost of...
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...
A company 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 expected-scenario forecast, the annual sales volume is 35,700 units, while the sale price is $97 per unit with a variable cost of...
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...
A company 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 53,400 units, while the sale price is $138 per unit with a variable cost of...
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...
A company 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 expected-scenario forecast, the annual sales volume is 53,700 units, while the sale price is $145 per unit with a variable cost of...
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...
A company 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 expected-scenario forecast, the annual sales volume is 50,700 units, while the sale price is $137 per unit with a variable cost of...
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...
A company 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 expected-scenario forecast, the annual sales volume is 41,700 units, while the sale price is $113 per unit with a variable cost of...
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...
A company 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 pessimistic-scenario forecast, the annual sales volume is 30,300 units, while the sale price is $95 per unit with a variable cost of...
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...
A company 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 34,200 units, while the sale price is $90 per unit with a variable cost of...
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...
A company 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 expected-scenario forecast, the annual sales volume is 43,200 units, while the sale price is $117 per unit with a variable cost of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT