Capital Budgeting
Not what you're looking for?
I have a company that has a 8 year project life. The project requires an initial investment of $300 million to construct building and purchase equipment, and $20 million for shipping & installation fee. The fixed assets fall in the 7-year MACRS class. Salvage value of the fixed assets is $15 million. The number of units of the new product expected to be sold in the first year is 2,000,000 and the expected annual growth rate is 10%. Sales price= $300 per unit; variable cost= $220 per unit in the first year adjusted based on the estimated annualized inflation rate of 2.8%. Required net operating working capital (NOWC) is 12% of sales. Corporate tax rate = 40.48 %. The discount rate is a WACC of 7.67%
a) Compute the depreciation basis & annual depreciation of the new project using MACRS allowances
b) Estimate annual cash flows for the 8 years.
c) Draw a time line of cash flows.
d) Using WACC of 7.67 as the discount rate, compute (NPV, IRR, MIRR, PI, Payback, Discounted Payback) to analyze the new project.
c) Please perform a sensitivity analysis(in excel) for the effects of sales growth rate, cost of capital, unit costs, sales price on the estimated NPV or IRR in order to demonstrate the sensitivity of the model. Please perform a scenario on these variables.
Please determine whether this project should be accepted based on the WACC and NPV.
Purchase this Solution
Solution Summary
The solution does a great job of answering the question. The solution is detailed and very easy to follow along. All the steps are clearly shown and Excel formulas are provided so that the student can answer similar questions in the future. It can be easily understood by anyone with a basic understanding of the topic. Overall, an excellent solution.
Purchase this Solution
Free BrainMass Quizzes
Motivation
This tests some key elements of major motivation theories.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.