Purchase Solution

NPV, MIRR, and which year the present value cash flow

Not what you're looking for?

Ask Custom Question

Kim wants you to review a capital project the company is looking to undertake. The project is a new line of goods the company will produce. Kim has stated that the decision to move forward will be driven by the net present value of the project (it must be positive), and the modified internal rate of return must be at least 13%. Here are the key facts about the project:

- It is expected to produce US$3 million in revenue annually the first year and grow 5% per year thereafter.

- The project will increase operating expenses by US$1.75 million the first year and grow at 3% annually per year thereafter.

- The project cost US$6 million in capital, and the capital will be depreciated on a straight-line basis for 5 years.

- The US$6 million will all be spent in the year prior to the first year in which the company generates revenue.

- The company will evaluate the project over 5 years (not including year 0).

- The company has a 40% tax rate.

- For this project you will use a 12% cost of capital and a 13% reinvestment rate.

Given this information, find the NPV, MIRR, and which year the present value cash flows become positive. Submit your Excel spreadsheet along with slides explaining your work.

Purchase this Solution
Solution Summary

This provides the steps to calculate the NPV, MIRR, and which year the present value cash flow becomes positive

Solution Preview

For your reference purpose:

The investment decisions of a firm are generally known as the capital budgeting, or capital expenditure decisions. The firm's investment decisions would generally include expansion, acquisition, modernization and replacement of the long-term assets. Sale of a division or business (divestment) is also as an investment decision.
Decisions like the change in the methods of sales distribution, or an advertisement campaign or research and development programs have long-term implications for the firm's expenditures and benefits, and therefore, they should also be evaluated as investment decisions. Several different procedures are available to analyze potential business investments. Some concepts are better than others when it comes to reliability but all provide enough information to get the general scope of the investment.

The procedures that provide useful information are the Net present Value (NPV), the Internal Rate of Return (IRR), and the MIRR. These procedures will help rank the projects from the greatest ...

Purchase this Solution
Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Introduction to Finance

This quiz test introductory finance topics.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

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

View More Free Quizzes
Related BrainMass Solutions

  • NPV, IRR, MIRR

    Find NPV by finding the present value of each cash flow, including both inflows and outflows, discounted at the project's cost of capital.

  • Calculate the IRR, the NPV, and the MIRR for each project, and indicate the correct accept/reject decision for each.

    Find NPV by finding the present value of each cash flow, including both inflows and outflows, discounted at the project's cost of capital.

  • Capital Budgeting: Evaluate 3 Projects with the 6 Capital Budgeting Tools

    163442 Net Present Value, Internal Rate of Return, Profitability Index, Payback Period, Discount Payback Period, and Modified Internal Rate of Return Evaluate the following 3 projects with all of the 6 capital budgeting tools (Net Present Value, Internal

  • IRR and MIRR Calculations

    The internal rate of return is defined as that discount rate which equates the present value of a project's expected cash inflows to the present value of the project's costs: PV(Inflows) = PV(Investment costs), or the rate which forces the NPV to equal

  • Shellfish processing CFO: NPV, MIRR, and WACC

    A CFO is considering a project that has the following cash flow and WACC data. What is the project's MIRR? Note that a project's projected MIRR can be less than the WACC (and even negative), in which case it will be rejected.

  • Capital Budgeting Techiques

    MIRR is the disocunting rate which makes the discounted terminal year cash flow equal to the intial investment. In the example, the year 1 and year 2 cash flow would be compounded to year 3 at the compounding rate of 10%.

  • IRR and MIRR

    The internal rate of return is defined as that discount rate which equates the present value of a project's expected cash inflows to the present value of the project's costs: PV(Inflows) = PV(Investment costs), or the rate which forces the NPV to equal

  • Capital Budgeting: Key Financial Metrics

    Let us discuss each of the capital budgeting tools: Net Present Value (NPV): As per investopedia "Net Present Value is the difference between the present value of cash inflows and the present value of cash outflows.

  • Calculating NPV, IRR and MIRR,PI of given projects

    Project L should be added as it has higher NPV i.e. It adds more to firms value. Solution describes the steps to calculate NPV, IRR, MIRR and PI of given projects. It also determines the better project.

View More Related Solutions