Purchase Solution

Project evaluation using NPV and IRR

Not what you're looking for?

Ask Custom Question

Hi,

I need help with these two problems from my homework. I am stuck and don't know where to begin. If someone could show me in Excel how to do these problems it would be greatly appreciated.

Thank you!!

************

Questions
1) Project Evaluation
Aguilera Acoustics (AAI), Inc., projects unit sales for a new seven-octave voice emulation implant as follows:
Year Unit Sales
1 $85,000
2 $98,000
3 $106,000
4 $114,000
5 $93,000
Production of the implants will require $1,500,000 in net working capital to start and additional net working capital investments each year equal to 15 percent of the projected sales increase for the following year. Total fixed costs are $900,000 per year, variable production costs are $240 per unit and the units are priced at $325 each. The equipment needed to begin production has an installed cost of $21,000,000. Because the implants are intended for professional singers, this equipment is considered industrial machinery and thus qualifies as 7-year MACRS property. In five years, this equipment can be sold for about 20 percent of its acquisition cost. AAI is in the 35 percent marginal tax bracket and has a required rate of return on all of its projects of 18 percent. Based on these preliminary project estimates, what's your recommendation? Hint: use NPV and IRR as decision criteria.

2) Project Analysis Evaluation
Dickinson Brothers Inc. is considering investing in a machine to produce key boards. The price of the machine will be $400,000 and its economic life is 5 years. The machine will be fully depreciated by the straight-line method. The machine will produce 10,000 key boards each year. The price of each key board will be $40 in the first year and will increase by 5% per year. The production cost per key board will be $20 in the first year and will increase in the first year and will increase by 10% per year. The project will have an annual fixed cost of $50,000 and require an immediate investment of $25,000 in net working capital. The corporate tax rate for the company is 34%. If the appropriate discount rate is 15%, would you recommend that the project be implemented? Why is it important to capture the inflation effects in project analysis?

Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

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.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

View More Free Quizzes
Related BrainMass Solutions

  • Payback period, NPV, IRR

    The 3 main tools used to make this evaluation are the pay-back period, net present value (NPV), and internal rate of return (IRR).

  • Project evaluation

    282352 Evaluate project using NPV and IRR.

  • Capital Budgeting-NPV and IRR

    19135 Project evaluation-investments, cash flow, NPV, and IRR: Revenues generated by a new fad product are forecast as follows:c. If the opportunity cost of capital is 12%, what is the project NPV?d. What is the project IRR? Project Evaluation.

  • Examine and discuss the characteristics of NPV and the role that this method plays in capital investment decision making

    PP and ARR ignores time value of money, whereas NPV takes care of time value of money. - Net present value (NPV) and internal rate of return (IRR) Internal rate of return refers to the return earned from the project. At IRR, NPV= zero.

  • Capital budgeting decisions

    This solution is comprised of a detailed explanation to answer what method is the better one for making capital budgeting decisions---IRR or NPV and which might not be realistic if using IRR.

  • Mutually Exclusive Projects and Net Cash Flow

    The IRR for Project L comes to 18.1% and for Project S it is 23.6% The solution explains the evaluation of two mutually exclusive projects.

  • Discounted Payback, IRR

    ) IRR is the discount rate at which NPV is ZERO Project A IRR (Internal rate of return) is calculated using Excel function IRR Year Cash flow

  • Project evaluation

    If the opportunity cost of capital is 12 percent, what is project NPV? 4. What is project IRR? Please see the attached files. The solution explains the calculation of cash flows for a project and the evaluation of the project using NPV and IRR

  • Capital Budgeting - Payback, NPV, PI, IRR

    105592 Project evaluation processes- Payback, NPV, PI, IRR Can someone please describe the following project evaluation processes for me: Payback, NPV, PI, IRR. Is any one evaluation process better the others? Why?

  • 10 Business Finance Questions

    Using the information below, calculate the payback period and the NPV.

View More Related Solutions