Purchase Solution

Calculate the NPV, IRR, MIRR, and profitability index for this project.

Not what you're looking for?

Ask Custom Question

A company is considering a project with a 6-year economic life. The project is expected to cost $200,000 and have a salvage value of $30,000. 5 year MACRS depreciation will be used. The company has a 10% cost of capital and a marginal tax rate of 35%. Careful analysis reveals that the company should expect to sell 100,000 toys during the first year of operations at $5.00 per unit. The first year COGS is expected to be $3.75 per toy. It is expected that inflation will cause revenues to increase by 3.5% per year and the COGS to increase by 3.25% per year for the projects life. Increased demand is expected to increase the quantity produced and sold by 3% per year. The project will require a $25,000 increase in working capital at the beginning of the project.

a. Calculate the NPV, IRR, MIRR, and profitability index for this project.

b. If the cost of capital was to increase to 11%, recomputed the NPV, MIRRR, and profitability index for the project.

Note: Use excel spreadsheet, if possible

Purchase this Solution
Solution Summary

Tutorial is in Excel for you.

Purchase this Solution
Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

View More Free Quizzes
Related BrainMass Solutions

  • NPV, IRR, Profitability Index, and MIRR

    407811 NPV IRR Calculations Please view attachment for question. a. Calculate the NPV, IRR, Profitability Index, and MIRR for this project with a cost of capital of 12%.

  • IRR, MIRR, and Discounted Cashflow

    435808 IRR, MIRR, and Discounted Cashflow ** Please see the attached file for the data ** Calculate payback, internal rate of return (IRR), modified internal rate of return (MIRR), and net present value (NPV), and make a recommendation whether the

  • Capital Budgeting Problem

    Remember, NPV is always in dollars, IRR is a percentage, PI is an index number, and PB is in years. I have done PI and PB for you with project A. *Year 0 is your initial cost outlay -- the cost of the project.

  • NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback,

    566358 NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback, (10-1) NPV A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year for 7 years, and a cost of capital of 11%.

  • Capital budgeting

    By using the difference in the cash flows and finding the IRR, the crossover point comes at 8.68% The solution explains how to calculate NPV, IRR, PI and MIRR

  • Understanding Capital Budgeting Practice Problems

    Your tutorial is attached in excel and includes using NPV and MIRR formulas in Excel to get needed amounts, two graphs with crossover points circled, discussion about the graphs and an analysis of finding NPV from profitability index.

  • Project's MIRR and IRR

    2. suppose a potential customer wants to know the project's profitability index (PI). what is the value of the PI for Hoskins, and what is the rationale behind this measure?

  • Calculation of various items for two corporations

    If profitability index is say 1.2, it means that the project generates 1 dollar and 20 cents for each dollar of investment. Therefore, projects with higher profitability index are preferable to lower profitability index.

  • Capital Budgeting Parameters

    calculate Payback Period, Discounted Payback Rate, NPV, Profitability Index, IRR and MIRR for the given investment proposal.

View More Related Solutions