Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer the whole question using excel showing the formula Project cash flow and NPV. The managers of Classic Autos Incorporated plan to manufacture classic
please answer the whole question using excel showing the formula
Project cash flow and NPV. The managers of Classic Autos Incorporated plan to manufacture classic Thunderbirds (1957 replicas). The necessary foundry equipment will cost a total of $3,900,000 and will be depreciated using a five-year MACRS life, :. Projected sales in annual units for the next five years are 290 per year. If the sales price is $27,000 per car, variable costs are $18,000 per car, and fixed costs are $1,100,000 annually, what is the annual operating cash flow if the tax rate is 35%? The equipment is sold for salvage for $525,000 at the end of year five. What is the after-tax cash flow of the salvage? Net working capital increases by $600,000 at the beginning of the project (year 0) and is reduced back to its original level in the final year. What is the incremental cash flow of the project? Using a discount rate of 13% for the project, determine whether the project should be accepted or rejected according to the NPV decision model. First, what is the annual operating cash flow of the project for year 1? $ 1254500 (Round to the nearest dollar.) What is the annual operating cash flow of the project for year 2? $ (Round to the nearest dollar.) Data Table MACRS Fixed Annual Expense Percentages by Recovery Class Click on this icon to download the data from this table Year 3-Year 5-Year 7-Year 10-Year 1 33.33% 20.00% 14.29% 10.00% 2 44.45% 32.00% 24.49% 18.00% 3 14.81% 19.20% 17.49% 14.40% 4 7.41% 11.52% 12.49% 11.52% 5 11.52% 8.93% 9.22% 6 5.76% 8.93% 7.37% 7 8.93% 6.55% 8 4.45% 6.55% 9 6.55% 10 6.55% 11 3.28% Print DoneStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started