Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show excel formulas per each section. Thanks. If possible show screenshots of the formulas within excel. A firm is considering a new project. The
Please show excel formulas per each section. Thanks. If possible show screenshots of the formulas within excel.
A firm is considering a new project. The project has 11 years' life. This project requires initial investment of $150 million to purchase land, construct building, and purchase equipment, and $10 million for shipping \& installation fee. The fixed assets fall in the 10 -year modified accelerated cost recovery system (MACRS) class. The salvage value of fixed assets is $50 million. The number of units of the new product expected to be sold in the first year is 1,000,000 and the expected annual growth rate is 8%. The sales price is $200 per unit and the variable cost is $150 per unit in the first year, but they should be adjusted accordingly based on the estimated annualized inflation rate of 3%. The company is in the 40% tax bracket. The project's discount rate is 8%. a) Compute the depreciation basis and annual depreciation of the new project. b) Estimate annual cash flows for the 11 years. c) Draw a time line of the cash flows. d) What is the NPV of this project? Should the project be taken? Why
Step 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