公式示例:在Excel中计算修改后的内部收益率(MIRR) 假设您投资了$10,000最初用于年利率为7.5%,并且可以在未来四年中赚钱:1.850美元,3,500美元,4,600美元和3,780美元。 收入的再投资率为6.5%。 在这种情况下,您可以应用MIRR函数轻松计算出Excel中修改后的内部收益率。 在这种情况下,值是位于范围C10000,1850,35...
In Microsoft Excel, theMIRRfunction estimates the likely profitability of an investment or project. Introduction to the MIRR Function MIRR(Modified Internal Rate of Return) considers the reinvestment of the net present value (calculated withthe NPV function) of the capital inflows at a rate equal t...
This article describes the formula syntax and usage of the MIRR function in Microsoft Excel. Description Returns the modified internal rate of return for a series of periodic cash flows. MIRR considers both the cost of the investment and the interest received on reinvestment of cash. Syntax MIRR...
We have introduced the Excel IRR function before, which can figure out the internal rate of return for a project. The IRR function assumes the interests received from the project are invested at the IRR itself. However, the positive cash flows received from the project are more likely to be ...
我們之前已經介紹了Excel IRR函數,該函數可以計算出項目的內部收益率。 內部收益率功能假設從項目中獲得的利益是由內部收益率本身投資的。 但是,從該項目獲得的正現金流量更有可能以其他比率進行再投資。 在這種情況下,您可以使用Excel MIRR函數來解決此問題。
The MIRR function can also be used in VBA code in Microsoft Excel. For example: Dim LNumber As Double Static Values(5) As Double Values(0) = -7500 Values(1) = 3000 Values(2) = 5000 Values(3) = 1200 Values(4) = 4000 LNumber = Mirr(Values(), 0.05, 0.08) ...
In this article, we will learn about how to use the MIRR function in Excel. MIRR function returns the Modified interest rate of return for the financial data having Investment, finance rate & reinvestment_rate. The MIRR function returns modified interest rate of return in percentage. ...
The Modified Internal Rate of Return (MIRR) is a function in Excel that takes into account the financing cost (cost of capital) and a reinvestment rate for cash flows
The MIRR function in Excel calculates the modified internal rate of return for a series of cash flows that occur at regular intervals. The syntax of the MIRR function is as follows: MIRR(values, finance_rate, reinvest_rate) Where:
This tutorial demonstrates how to use theExcel MIRR Functionin Excel to calculate the modified internal rate of return. MIRR FunctionOverview The MIRR Function Calculates the rate of return. To use the MIRR Excel Worksheet Function, select a cell and type: ...