Question: Show work using Excel please. 8. (Excel available) A project involving sale of a new automobile accessory requires expenditure today of $108 million. This expenditure

Show work using Excel please.
8. (Excel available) A project involving sale of a new automobile accessory requires expenditure today of $108 million. This expenditure can be depreciated straight-line over 12 years. The project involves sales of 3,000,000 items each year in years 1 through 2 and 4,000,000 items per year in years 3 through 12 (sales and expenses are projected in accordance with standard accounting). Each item will sell for $14. Variable expenses are $7 per item, and there are also fixed costs of $6 million each year. The tax rate is 40%. In addition, the project will have account balances over times as follows: Year O 1......11 12 13 Cash $1 M $2 M 0 0 Accounts Receivable 0 $1 M SIM 0 Inventory 0 $1.7M 0 0 Accounts Payable 0 $0.4M 0 0 If required return on the project is 8.5%, what is the NPV of this project
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
