Hermann–Mauguin notation: Difference between revisions

Revision as of 12:40, 2 January 2014

The Modified Internal Rate of Return (MIRR) is a financial measure of an investment's attractiveness.^[1]^[2] 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.

Problems with the IRR

While there are several problems with the IRR, MIRR resolves two of them.

Firstly, IRR assumes that interim positive cash flows are reinvested at the same rate of return as that of the project that generated them.^[3] 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.

Calculation of the MIRR

MIRR is calculated as follows:

$MIRR = \sqrt[n]{\frac{F V (positive cash flows, reinvestment rate)}{- P V (negative cash flows, finance rate)}} - 1$ ,

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 "=MIRR".

Example

If an investment project is described by the sequence of cash flows:

Year	Cash flow
0	-1000
1	-4000
2	5000
3	2000

Benefits of Residing in a Apartment or Landed property in Singapore Property New Launches & Project Showcase In Singapore Many residential Singapore property sales involve buying property in Singapore at new launches. These are often homes underneath building, being sold new by developers. New Launch Singapore Property, 28 Imperial Residences Coming To Geylang Lorong 26 The property market is slowing down, based on personal property transactions in May Cell Apps FREE Sign Up Log in Property Brokers Feedback

Individuals all wish to be seen having the identical foresight as the experts in property investment or the massive names in their own fields. Thus the discharge of these tales works to encourage different buyers to observe suit. Bartley Ridge is the most popular new launch in district 13. Irresistible pricing from $1,1xx psf. Bartley Ridge is a ninety nine-12 months leasehold new condominium at Mount Vernon road, good next to Bartley MRT station (CC12). If you want to get more Rehda Johor chairman Koh Moo Hing said potential property consumers in the two areas Http://Modern.Dowatch.Net/Profile/Mic31K/Created/Topics are now adopting a wait-and-see attitude. How can I get the ebrochure and flooring plans of the new launch projects ? The Existing Mortgage on your HDB District 13, Freehold condominium District 11, Freehold Cluster landed house Sea Horizon EC @ Pasir Ris

FindSgNewLaunch is the main Singapore Property web site - one of the best place to begin your actual estate search whether you might be an investor, shopping for for own use, or searching for a spot to lease. With detailed details about each property, together with maps and pictures. We deliver you probably the most complete choice out there. No. For brand spanking new Singapore property gross sales, you possibly can withdraw at any time earlier than booking the unit, without penalty. On the preview, the agent will let you recognize the exact worth for you to resolve whether or not to proceed or not. Solely when you resolve to proceed will the agent book the unit for you. Pending for Sale Licence Approval All Pending for Sale Licence Approval New launch FREEHOLD condominium @ Braddell New launch condominium combined growth at Yishun PROJECT TITLE

To not worry, we'll hold you in our VIP Precedence list for future new launch VIP Preview. We'll contact you to establish your wants and advocate related tasks, both new launch or resale properties that probably match your standards. In case you're looking for resale property, such as these few years old, or just got Short-term Occupation Permit (PRIME), you might click on here right here for fast search and submit your shortlisted listings to us, we'll check and call you for viewing.

Oceanfront Suites, irresistible pricing for a 946 leasehold property with magnificent sea view. Dreaming of basking and feeling the warmth of pure sunlight is now just a click on away. Oceanfront Suites - Seaside residing no longer needs to remain an unattainable This Cambodia new launch, a mega development has also 762 residential models. Additionally located within this Oxley abroad property is a mega shopping center with 627 outlets and also up to 963 available workplace spaces and is surrounded by quite a few Embassy, resorts, Casinos and many vacationer relax space. Belysa EC @ Pasir Ris Esparina EC @ Sengkang Dell Launches World's first Gender-GEDI Female Entrepreneurship Index on 06/04/thirteen by Istanbul, Turkey. Paris Ris EC @ Paris Ris in search of indication of curiosity.

The developer should open a Venture Account with a financial institution or monetary establishment for every housing venture he undertakes, before he's issued with a Sale License (license to sell models in his development). All payments from buyers before completion of the challenge, and construction loans, go into the mission account. New launch rental LA FIESTA, an thrilling new condominium located along Sengkang Square / Compassvale Highway is a brief stroll to the bustling Sengkang City Centre the place the bus interchange, Sengkang MRT and LRT stations are located. Glorious location,Premium rental with Bayfront resort lifestyle theme and views ofwaterscape. Close to EC pricing - Worth for cash! Apr 02, 2013 Sengkang New Rental Launch, La Fiesta- Sengkang MRTstation at your gate.

As The Hillford property launch at Jalan Jurong Kechil may be very close to to beauty world mrt , the environment for the plot of land which belongs to World Class Land remains very upbeat as it is rather close to to Holland Village. Review now by visiting the brand new apartment pages on our website, each displaying complete particulars and the latest information of each new launch. You can even contact us directly to obtain quick & correct answers to all of your questions with high of the road service. An inevitable conclusion is that costs within the property market have just set new highs. The apparent connotation for potential buyers is to take motion now before prices bounce again. tract and points to his property line, marked by a big maple in a sea of Search SG Developersale.com

then the IRR $r$ is given by

$NPV = - 1000 + \frac{- 4000}{(1 + r)^{1}} + \frac{5000}{(1 + r)^{2}} + \frac{2000}{(1 + r)^{3}} = 0$ .

In this case, the answer is 25.48% (the other solutions to this equation are -593.16% and -132.32%, but they will not be considered meaningful IRRs).

To calculate the MIRR, we will assume a finance rate of 10% and a reinvestment rate of 12%. First, we calculate the present value of the negative cash flows (discounted at the finance rate):

$P V (negative cash flows, finance rate) = - 1000 + \frac{- 4000}{(1 + 10 %)^{1}} = - 4636.36$ .

Second, we calculate the future value of the positive cash flows (reinvested at the reinvestment rate):

$F V (positive cash flows, reinvestment rate) = 5000 \cdot (1 + 12 %)^{1} + 2000 = 7600$ .

Third, we find the MIRR:

$MIRR = \sqrt[3]{\frac{7600}{4636.36}} - 1 = 17.91 %$ .

The calculated MIRR (17.91%) is significantly different from the IRR (25.48%).

Comparing projects of different sizes

Like the internal rate of return, the modified internal rate of return cannot be validly used to rank-order projects of different sizes, because a larger project with a smaller modified internal rate of return may have a higher present value. However, there exist variants of the modified internal rate of return which can be used for such comparisons.^[4]^[5]

References

↑ Lin, S. A. Y., "The modified internal rate of return and investment criterion," The Engineering Economist 21(4), 1976, 237-247.
↑ Beaves, R. G., "Net present value and the rate of return: Implicit and explicit reinvestment assumptions," The Engineering Economist 33, 1988, 275-302.
↑ Internal Rate of Return: A Cautionary Tale
↑ Shull, D. M., "Efficient capital project selection through a yield-based capital budgeting technique," The Engineering Economist 38(1), 1992, 1-18.
↑ Hajdasinski, M., "Remarks in the context of 'The case for the generalized net present value formula'," The Engineering Economist 40(2), 1995, 201-210.

[1] Lin, S. A. Y., "The modified internal rate of return and investment criterion," The Engineering Economist 21(4), 1976, 237-247.

[2] Beaves, R. G., "Net present value and the rate of return: Implicit and explicit reinvestment assumptions," The Engineering Economist 33, 1988, 275-302.

[3] Internal Rate of Return: A Cautionary Tale

[4] Shull, D. M., "Efficient capital project selection through a yield-based capital budgeting technique," The Engineering Economist 38(1), 1992, 1-18.

[5] Hajdasinski, M., "Remarks in the context of 'The case for the generalized net present value formula'," The Engineering Economist 40(2), 1995, 201-210.

[1]

[2]

[3]

[4]

[5]

@@ Line 1: / Line 1: @@
-The person who wrote the article is called Jayson Hirano and he totally digs that name. Distributing manufacturing is where her primary income arrives from. My spouse and I reside in Kentucky. The favorite pastime for him and his kids is to play lacross and he would by no means give it up.<br><br>Here is my site ... online psychic chat - [http://alles-herunterladen.de/excellent-advice-for-picking-the-ideal-hobby/ discover this] -
+The '''Modified Internal Rate of Return''' (MIRR) is a [[finance|financial]] measure of an [[investment]]'s attractiveness.<ref>Lin, S. A. Y., "The modified internal rate of return and investment criterion," ''The Engineering Economist'' 21(4), 1976, 237-247.</ref><ref>Beaves, R. G., "Net present value and the rate of return: Implicit and explicit reinvestment assumptions," ''The Engineering Economist'' 33, 1988, 275-302.</ref> 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.
+==Problems with the IRR==
+While there are several [[Internal rate of return#Problems with using internal rate of return|problems with the IRR]], MIRR resolves two of them.
+Firstly, IRR assumes that interim positive cash flows are reinvested at the same rate of return as that of the project that generated them.<ref>[http://www.cfo.com/article.cfm/3304945 Internal Rate of Return: A Cautionary Tale]</ref> 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.
+==Calculation of the MIRR==
+MIRR is calculated as follows:
+<math>\mbox{MIRR}=\sqrt[n]{\frac{FV(\text{positive cash flows, reinvestment rate})}{-PV(\text{negative cash flows, finance rate})}}-1</math>,
+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|Spreadsheet applications]], such as [[Microsoft Excel]], have inbuilt functions to calculate the MIRR. In Microsoft Excel this function is "=MIRR".
+===Example===
+If an investment project is described by the sequence of cash flows:
+{| class="wikitable" align="left"
+|-
+! Year
+! Cash flow
+|- align="center"
+| 0
+| -1000
+|- align="center"
+| 1
+| -4000
+|- align="center"
+| 2
+| 5000
+|- align="center"
+| 3
+| 2000
+|}
+{{-}}
+then the IRR <math>r</math> is given by
+<math>\mbox{NPV} = -1000 + \frac{-4000}{(1+r)^1} + \frac{5000}{(1+r)^2} + \frac{2000}{(1+r)^3} = 0</math>.
+In this case, the answer is 25.48% (the other solutions to this equation are -593.16% and -132.32%, but they will not be considered meaningful IRRs).
+To calculate the MIRR, we will assume a finance rate of 10% and a reinvestment rate of 12%. First, we calculate the present value of the negative cash flows (discounted at the finance rate):
+<math>PV(\text{negative cash flows, finance rate}) = -1000 + \frac{-4000}{(1+10%)^1} = -4636.36</math>.
+Second, we calculate the future value of the positive cash flows (reinvested at the reinvestment rate):
+<math>FV(\text{positive cash flows, reinvestment rate}) = 5000\cdot(1+12%)^1 + 2000 = 7600</math>.
+Third, we find the MIRR:
+<math>\mbox{MIRR}=\sqrt[3]{\frac{7600}{4636.36}}-1=17.91%</math>.
+The calculated MIRR (17.91%) is significantly different from the IRR (25.48%).
+==Comparing projects of different sizes==
+Like the internal rate of return, the modified internal rate of return cannot be validly used to rank-order projects of different sizes, because a larger project with a smaller modified internal rate of return may have a higher present value.  However, there exist variants of the modified internal rate of return which can be used for such comparisons.<ref>Shull, D. M., "Efficient capital project selection through a yield-based capital budgeting technique," ''The Engineering Economist'' 38(1), 1992, 1-18.</ref><ref>Hajdasinski, M., "Remarks in the context of 'The case for the generalized net present value formula'," ''The Engineering Economist'' 40(2), 1995, 201-210.</ref>
+==References==
+<references/>
+[[Category:Mathematical finance]]
+[[Category:Investment]]