Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedplease 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 Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Meaningful Money Handbook

Authors: Pete Matthew

1st Edition

0857196510, 978-0857196514

More Books

Students also viewed these Finance questions