The modified internal rate of return (MIRR) is a financial measure of an investment's attractiveness. It is used in capital budgeting to rank alternative investments of equal size. As the name implies, MIRR is a modification of the internal rate of return (IRR) and as such aims to resolve some problems with the IRR.
While there are several problems with the IRR, MIRR resolves two of them.
Firstly, IRR is sometimes misapplied, under an assumption that interim positive cash flows are reinvested elsewhere in a different project at the same rate of return offered by the project that generated them. This is usually an unrealistic scenario and a more likely situation is that the funds will be reinvested at a rate closer to the firm's cost of capital. The IRR therefore often gives an unduly optimistic picture of the projects under study. Generally for comparing projects more fairly, the weighted average cost of capital should be used for reinvesting the interim cash flows.
Secondly, more than one IRR can be found for projects with alternating positive and negative cash flows, which leads to confusion and ambiguity. MIRR finds only one value.
MIRR is calculated as follows:
where n is the number of equal periods at the end of which the cash flows occur (not the number of cash flows), PV is present value (at the beginning of the first period), FV is future value (at the end of the last period).
The formula adds up the negative cash flows after discounting them to time zero using the external cost of capital, adds up the positive cash flows including the proceeds of reinvestment at the external reinvestment rate to the final period, and then works out what rate of return would cause the magnitude of the discounted negative cash flows at time zero to be equivalent to the future value of the positive cash flows at the final time period.
Spreadsheet applications, such as Microsoft Excel, have inbuilt functions to calculate the MIRR. In Microsoft Excel this function is .
Cette page est générée automatiquement et peut contenir des informations qui ne sont pas correctes, complètes, à jour ou pertinentes par rapport à votre recherche. Il en va de même pour toutes les autres pages de ce site. Veillez à vérifier les informations auprès des sources officielles de l'EPFL.
Capital budgeting in corporate finance, corporate planning and accounting is area of capital management that concerns the planning process used to determine whether an organization's long term capital investments such as new machinery, replacement of machinery, new plants, new products, and research development projects are worth the funding of cash through the firm's capitalization structures (debt, equity or retained earnings). It is the process of allocating resources for major capital, or investment, expenditures.
La finance renvoie à un domaine d'activité , aujourd'hui mondialisé, qui consiste à fournir ou trouver l'argent ou les « produits financiers » nécessaire à la réalisation d'une opération économique. La finance permet de faire transiter des capitaux des agents économiques excédentaires (qui disposent d'une épargne à faire fructifier) aux agents économiques déficitaires, qui en ont besoin (pour se financer, croître, etc.) La finance regroupe à la fois le système financier et les opérations financières qui ont lieu dans ce système.
The course provides a market-oriented framework for analyzing the major financial decisions made by firms. It provides an introduction to valuation techniques, investment decisions, asset valuation, f
Introduction to economic analysis applied to environmental issues: all the necessary basic concepts, including cost-benefit analysis, for environmental policy making and its instruments (examples: cli
Venture debt lending is a form of start-up financing that lies at the intersection of venture capital and traditional debt. We analyze the lending decision criteria of 55 senior U.S. venture debt lenders (VDLs) using a discrete choice experiment in order t ...
The internal rate of return (IRR) is generally considered inferior to the net present value (NPV) as a tool for evaluating and ranking projects, despite its inherently useful comparability to the cost of capital and the return of other investment opportuni ...
EPFL CDM MTEI2013
The internal rate of return (IRR) is generally considered inferior to the net present value (NPV) as a tool for evaluating and ranking projects, despite its inherently useful comparability to the cost of capital and the return of other investment opportuni ...