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...
公式示例:在Excel中计算修改后的内部收益率(MIRR) 假设您投资了$10,000最初用于年利率为7.5%,并且可以在未来四年中赚钱:1.850美元,3,500美元,4,600美元和3,780美元。 收入的再投资率为6.5%。 在这种情况下,您可以应用MIRR函数轻松计算出Excel中修改后的内部收益率。 在这种情况下,值是位于范围C10000,1850,35...
(1) The MIRR function returns #DIV/0! error value, if the values argument contains cash out (negative numbers) only or cash received (positive numbers) only. (2) The text, logical values, or empty cells will be ignored in the values argument; however, cells with the value zero are inc...
The MIRR function is a built-in function in Excel that is categorized as aFinancial Function. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the MIRR function can be entered as part of a formula in a cell of a worksheet. As...
Jos n on arvojen kassavirtojen määrä, pkorko on pääoma_korko ja ukorko on uudinvest_korko, niin MSISÄINEN-funktion kaava on: Esimerkki Kopioi esimerkkitiedot seuraavaan taulukkoon ja lisää se uuden Excel-laskentataulukon soluun A1. Kaavat näyttävät tuloksi...
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: Values (required) – an array or a range of cells that...
我們之前已經介紹了Excel IRR函數,該函數可以計算出項目的內部收益率。 內部收益率功能假設從項目中獲得的利益是由內部收益率本身投資的。 但是,從該項目獲得的正現金流量更有可能以其他比率進行再投資。 在這種情況下,您可以使用Excel MIRR函數來解決此問題。
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
程序集: Microsoft.Office.Interop.Excel.dll 返回某一连续期间内现金流的修正内部收益率。 函数 MIRR 同时考虑了投资的成本和现金再投资的收益率。 C# 复制 public double MIrr (object Arg1, double Arg2, double Arg3); 参数 Arg1 Object Values - 一个数组或对包含数字的单元格的引用。 这些数值代表固定...
Convert a comma separated string of values to an array of values for MIRR function Greetings Excel Wizards, Long-time (years) lurker here and am finally stumped with a question I can't find a solution for anywhere in the forum. I am trying to utilize the MIRR() function with a dynamic...