Ads
related to: free irr excel template printable word free pdf
Search results
Results From The WOW.Com Content Network
For information on using this template, see Template:Routemap. For pictograms used, see Commons:BSicon/Catalogue . Note: Per consensus and convention, most route-map templates are used in a single article in order to separate their complex and fragile syntax from normal article wikitext.
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 ...
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 "risk-free" rate on US dollar investments is the rate on U.S. Treasury bills, because this is the highest rate available without risking capital. The rate of return which an investor requires from a particular investment is called the discount rate, and is also referred to as the (opportunity) cost of capital.
Excel for the web is a free lightweight version of Microsoft Excel available as part of Office on the web, which also includes web versions of Microsoft Word and Microsoft PowerPoint. Excel for the web can display most of the features available in the desktop versions of Excel, although it may not be able to insert or edit them.
The yield to maturity (YTM), book yield or redemption yield of a fixed-interest security is an estimate of the total rate of return anticipated to be earned by an investor who buys it at a given market price, holds it to maturity, and receives all interest payments and the capital redemption on schedule.