Purchase Solution

Calculating the Internal Rate of Return

Not what you're looking for?

Ask Custom Question

You are a boss of a restaurant considering the purchase of a self-ordering machine.
The upfront cost is estimated to be $23,828.
The machine will increase revenues by $10,000 per year and incur a maintenance cost of $4,000 every year.
The machine has a 5-year useful life after which can be sold for $2,000.
The project has a negative NPV at 12%.
Whats is IRR?
Ignore taxes

Purchase this Solution
Solution Summary

This solution illustrates how to compute a project's internal rate of return using Excel 97-2003.

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

Importance of Critical Thinking

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

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.

Motivation

This tests some key elements of major motivation theories.

Basics of corporate finance

These questions will test you on your knowledge of finance.

View More Free Quizzes
Related BrainMass Solutions

  • The internal rate of return of a project

    The internal rate of return of a project can be found by calculating the interest rate, which will equate the present value of all cash inflows to the present value of all cash outflows. This means, with the internal rate of return, NPV = 0.

  • Capital budgeting Practice True False Exam Questions

    The internal rate of return is a method of calculating the expected gain or loss from a project by discounting all expected future cash inflows and outflows to the present point in time. 4.

  • NPV, Payback Period, IRR, Profitibility Index & Project NPV

    Calculating internal rate of return (IRR) for cash flows: Calculate the internal rate of return for the cash flows of the two projects in the table below. Problem 3.

  • Calculating Cost of Capital and Rate of Return

    why Please see the attached file. Excel spreadsheet shows the present value and internal rate of return for an investment.

  • Investment: The Internal Rate of Return

    165803 Investment: The Internal Rate of Return Please use Excel showing a cash flow time line to provide the internal rate of return on an investment with the following cash flows: Year Cash Flow 0 -$123,400 1 $36,200 2

  • Calculating equity required return and weighted average cost of capital

    Alternative Compute the project's Internal Rate of Return, IRR, and determine if the project should be accepted or rejected for the HI TECH Alternative Compute the project's Internal Rate of Return, IRR, and determine if the project should be accepted

  • Calculate Weighted and Internal Returns

    r1 = (44,000-40,000)/40,000 = 10% r2 = (54,000-50,000) / 50,000= 8% Now, we have to compound the returns rA = (1+0.1)* (1+0.08) - 1 = 18.8% b) The formula for calculating the internal rate of return is, W2/(1 + r)2

  • Long Term Financing Analysis: Capital Investment & Analyses

    498992 Long Term Financing Analysis: Capital Investment & Analyses Explain the concepts of net present value and internal rate of return analysis.

  • Multiple Choice Questions

    The same value as the market s risk premium 3. Which of the following capital budget model does not use Time Value of Money calculations? a. Internal Rate of Return (IRR) b. Modified Internal Rate of Return (MIRR) c. Payback d.

View More Related Solutions