Search results
Results from the WOW.Com Content Network
Internal rate of return (IRR) is a method of calculating an investment's rate of return. The term internal refers to the fact that the calculation excludes external factors, such as the risk-free rate, inflation, the cost of capital, or financial risk. The method may be applied either ex-post or ex-ante. Applied ex-ante, the IRR is an estimate ...
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 unequal 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.
Was one of the big three spreadsheets (the others being Lotus 123 and Excel). EasyOffice EasySpreadsheet – for MS Windows. No longer freeware, this suite aims to be more user friendly than competitors. Framework – for MS Windows. Historical office suite still available and supported. It includes a spreadsheet.
The modified Dietz method [1] [2] [3] is a measure of the ex post (i.e. historical) performance of an investment portfolio in the presence of external flows. (External flows are movements of value such as transfers of cash, securities or other instruments in or out of the portfolio, with no equal simultaneous movement of value in the opposite direction, and which are not income from the ...
The rate of return on a portfolio can be calculated indirectly as the weighted average rate of return on the various assets within the portfolio. [3] The weights are proportional to the value of the assets within the portfolio, to take into account what portion of the portfolio each individual return represents in calculating the contribution of that asset to the return on the portfolio.
The internal rate of return (IRR) (which is a variety of money-weighted rate of return) is the rate of return which makes the net present value of cash flows zero. It is a solution r {\displaystyle r} satisfying the following equation:
Practically, these are usually built as Excel spreadsheets and then consist of the following interlinked sheets (see Outline of finance § Financial modeling for further model-build items), with broad groupings: Project build and operation (Data input): operating assumptions; Capital costs (construction); Insurance; Taxes; Depreciation; Financing
A backup of an Excel Spreadsheet Add-in (DLL) .xll: Adds custom functionality; written in C++/C, Fortran, etc. and compiled into a special dynamic-link library: Macro .xlm: A macro is created by the user or pre-installed with Excel. Template .xlt: A pre-formatted spreadsheet created by the user or by Microsoft Excel. Module .xlv