Purchase Solution

Compute NPV and IRR

Not what you're looking for?

Ask Custom Question

See attached file.

Prepare an analysis of Rondo's new project.

Use ONLY these assumptions for your analysis:

1. Project life is 5 years.
2. Initial investment is $6,250,000 for equipment invoice, transportation, and installation.
3. Worker training for operating new equipment is $15,000.
4. First year sales are projected to be $7,500,000 escalated at 3% each year thereafter.
5. Operating overhead (excluding depreciation) is estimated at 27% of annual sales.
6. Administrative overhead is estimated at 35% of annual sales.
7. Depreciation is straight line, 7 years.
8. The tax rate is 40%.
9. The new equipment can be salvaged at the end of the project (end of YR 5) for $1,500,000.
10. Use Rondo's WACC of 10% to discount the project cash flows.

Create an Excel cash flow spreadsheet and calculate the NPV and IRR.

Make your recommendation on the project.

Hint: You are only interested in the incremental cash flows. Create a spreadsheet from the above assumptions since they represent the incremental cash flows. Save yourself a big headache by not trying to incorporate other financial statement data exhibited in the case.

Also, list your assumptions and build the spreadsheet by incorporating the assumption value cells into the spreadsheet. The spreadsheet should automatically flow if an assumption value is changed.

Attachments
Purchase this Solution
Solution Summary

The solution explains how to calculate the compute NPV and IRR for Rondo's new project

Purchase this Solution
Free BrainMass Quizzes
Learning Lean

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

Introduction to Finance

This quiz test introductory finance topics.

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.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

View More Free Quizzes
Related BrainMass Solutions

  • NPV

    Therefore, it is easier to use financial calculator to compute IRR for us. Project B IRR = 13.18% You can also use function in excel to compute IRR for you. Please see the attached file.

  • Capital Budgeting Methods

    Compute PB b. Compute DPB c. Compute NPV d. Compute IRR e. Compute MIRR f. Compute MNPV Where does the 9% required rate of return and the 13% re-investment rate figure into the problem/equation?

  • Discount Rate, IRR, NPV

    b) Compute the NPV of this project. c) To select a project would you use IRR or NPV? Explain. d) What is the economic interpretation of IRR and NPV?

  • Compare two investment projects using IRR and NPV

    IRR for project A is 34.9% IRR for project B is 31.6% B Compute the net present value for each project if the firm has a 10 percent cost of capital We use the NPV function to calculate the NPV.

  • NPV and IRR of the Project

    Compute the NPV and IRR of the project. For your NPV calculations, assume a cost of capital of 15 percent.

  • Calculating equity required return and weighted average cost of capital

    , based on NPV criterion Determine the best alternative among HI TECH, DISTRIBUTOR, and CURRENT, based on IRR criterion Discuss the strengths and weaknesses of the NPV technique Discuss the strengths and weaknesses of the IRR technique Discuss the

  • aftertax cash flows

    Yes, because NPV is greater than 0, and the IRR is greater than the cost of capital. This solution is comprised of a detailed explanation to calculate the NPV, IRR, and answer whether to accept the project or not.

  • Payback period, NPV, IRR , accounting rate of return

    155857 Compute the payback period. Is this a good measure of profitability? 2. Compute the NPV. Should Simon accept the proposal? Why or why not? 3. Compute the IRR. How does this compare with the required rate of return?

  • ABC Widgets

    This solution is comprised of a detailed explanation to find NPV and IRR for two projects.

  • Calculating Payback, NPV and IRR

    503746 Calculating Payback, NPV and IRR Winston Clinic is evaluating a project that costs $52,125 and has expected net cash flows of $12,000 per year for eight years.

View More Related Solutions