For simple purchase or sale of stock the time value of money doesn’t matter, but for calculation of fixed asset like building, home where value appreciates with time. If the return of investment is positive that means there is a gain over investment and if the return of investment is negative that means there is a loss over investment. If the second parameter is not used in the function, Excel will find an IRR of 10%. The main difference between the IRR and NPV is that NPV is an actual amount while the IRR is the interest yield as a percentage expected from an investment. 1. The expected rate of return can be calculated either as a weighted average of all possible outcomes or using historical data of investment performance. Here we discuss its uses along with practical examples. NPV is the difference between the present value of cash inflows and the present value of cash outflows over time. 1. You can easily calculate the Rate of Return using Formula in the template provided. Find Required Rate of Return using Capital Asset Pricing Model . The risk free rate is 6 %. If the cash flow sequence has only a single cash component with one sign change (from + to - or - to +), the investment will have a unique IRR. This sounds a little confusing at first, but it’s pretty simple. For example, project A requires an initial investment of $100 (cell B5). You need to provide the two inputs i.e Current Value and Original Value. Annual Interest Rate = 0.62% (monthly interest rate)* 12 (total months in a year) = 7.42%. Now, let’s calculate the rate of return on his property. We can see that investor earns more profit in the investment of Google then in Apple, as the rate of return on investment in Google is higher than Apple. In A7, you enter the formula, IRR(A1:A6). This yields the same result: 56.98%. We calculate the MIRR found in the previous example with the MIRR as its actual definition. You can think of the internal rate of return as Nominal interest rate is typically the stated rate on a financial product. In the example below, using a 20% discount rate, investment #2 shows higher profitability than investment #1. Profitability often depends on the sequence and importance of the project's cash flow and the discount rate applied to those cash flows. This yields the same result: 56.98%. Profits then, hopefully, subside, as was the case in our first example. IRR represents the actual annual return on investment only when the project generates zero interim cash flows—or if those investments can be invested at the current IRR. The Excel Rate function calculates the interest rate required to pay off a specified amount of a loan, or to reach a target amount on an investment, over a given period. It is expressed in terms of percentage. While the internal rate of return (IRR) assumes that the cash flows from a project are reinvested at the IRR, the modified internal rate of return (MIRR) assumes that positive cash flows are reinvested at the firm's cost of capital, and the initial outlays are financed at the firm's financing cost. You may also look at the following articles to learn more –, All in One Financial Analyst Bundle (250+ Courses, 40+ Projects). For example, if you realized a $3 return on a $50 investment, divide $3 by $50 to get 0.06. CAPM is calculated according to the following formula: Where:Ra = Expected return on a security Rrf = Risk-free rate Ba = Beta of the security Rm = Expected return of the marketNote: “Risk Premium” = (Rm – Rrf)The CAPM formula is used for calculating the expected returns of an asset. For this example of the real rate of return formula, the money market yield is 5%, inflation is 3%, and the starting balance is $1000. The annualize rate on return also known as the Compound Annual Growth Rate (CAGR). Market return is about 10% One can use rate of return to compare performance rates on capital equipment purchase while an investor can calculate which stock purchases performed better, This has been a guide to a Rate of Return formula. This means that in the case of investment #1, with an investment of $2,000 in 2013, the investment will yield an annual return of 48%. However, selecting projects based on maximizing the IRR as opposed to the NPV could increase the risk of realizing a return on investment greater than the weighted average cost of capital (WACC) but less than the present return on existing assets. © 2020 - EDUCBA. There are multiple models to work out required rate of return on equity, preferred stock, debt and other investments. The required rate of return (RRR) on an investment is the minimum annual return that is necessary to induce people to invest in it. We use the XIRR function below to solve this calculation. Under the CAPM, the rate is determined using the following formula: RRR = r f + ß(r m – r f) Where: RRR – required rate of return; r f – risk-free rate; ß – beta coefficient of an investment; r … Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more. Using the example data shown above, the IRR formula would be =IRR(D2:D14,.1)*12, which yields an internal rate of return of 12.22%. The IRR and net present value (NPV) are used when selecting investments based on the returns. In other words, it is a percentage by which the value of investments is expected to exceed its initial value after a specific period of time. Now, let’s see another example to understand the rate of return formula. In the image below, we calculate the IRR. Rate of Return Formula (Table of Contents). Average Rate of Return formula = Average annual net earnings after taxes / Average investment over the life of the project * 100% The rate of return formula is equal to current value minus original value divided by original value multiply by 100. Remember that when you enter formulas in Excel, you double-click on the cell and put it in formula mode by pressing the equals key (=). One thing to keep in mind is considering the time value of money. The required rate of return is calculated based on the Gordon growth model, also known as the dividend discount model (DDM), which is used to determine the intrinsic value of a stock based on a future series of dividends. You will get the rate of return of the stock you bought. Think of it in terms of capital investing like the company’s management would. The required rate of return formula = Risk-free rate of return + β * (Market rate of return – Risk-free rate of return) Examples of Required Rate of Return Formula (with Excel Template) Let’s see some simple to advanced examples to understand the calculation of the Required Rate of Return better. Investors typically select projects with an IRR that is greater than the cost of capital. In the image below, for investment #1, Excel does not find the NPV rate reduced to zero, so we have no IRR. It is based on the idea of systematic risk (otherwise known as or non-diversifiable risk) and that investors need to be compensated for it in the for… The internal rate of return (IRR) is the discount rate providing a net value of zero for a future series of cash flows. Now, we have to calculate the annualized return for the investor. On the other hand, if the second parameter is used (i.e., = IRR ($ C $ 6: $ F $ 6, C12)), there are two IRRs rendered for this investment, which are 10% and 216%. Simple IRR example. Example 2: Use guess in Excel IRR formula. Rate of return is used in finance by corporates in any form of investment like assets, projects etc. The share price is $52.1236541053. If the second parameter is not used and the investment has multiple IRR values, we will not notice because Excel will only display the first rate it finds that brings the NPV to zero. The IRR is the discount rate that can bring an investment's NPV to zero. Now I will guide you to calculate the rate of return on the stock easily by the XIRR function in Excel. Rate of return is useful in making investment decisions. The tutorial explains the basics of the modified internal rate of return, in what way it is different from IRR, and how to calculate MIRR in Excel. The internal rate of return allows investments to be analyzed for profitability by calculating the expected growth rate of an investment’s returns and is expressed as a percentage. For investments with cash flows received or cashed at different moments in time for a firm that has different borrowing rates and reinvestments, Excel does not provide functions that can be applied to these situations although they are probably more likely to occur. If the investment rate of return is positive then it’s probably worthwhile whereas if the rate of return is negative then it implies loss and hence investor should avoid it. These items represent an initial investment of $100,000 and payouts in the amounts that follow. To do this, we simply use the Excel IRR function: When a company uses different borrowing rates of reinvestment, the modified internal rate of return (MIRR) applies. Excel calculates the average annual rate of return as 9.52%. The profitability index (PI) rule is a calculation of a venture's profit potential, used to decide whether or not to proceed. (−NPV(rrate, values[positive])×(1+rrate)nNPV(frate, values[negative])×(1+frate))1n−1−1\begin{aligned}\left(\frac{-\text{NPV}(\textit{rrate, values}[\textit{positive}])\times(1+\textit{rrate})^n}{\text{NPV}(\textit{frate, values}[\textit{negative}])\times(1+\textit{frate})}\right)^{\frac{1}{n-1}}-1\end{aligned}(NPV(frate, values[negative])×(1+frate)−NPV(rrate, values[positive])×(1+rrate)n​)n−11​−1​. An investor purchased a share at a price of $5 and he had purchased 1,000 shared in year 2017 after one year he decides to sell them at a price of $10 in the year 2018. In this formula, any gain made is included in formula. Let’s calculate the annual interest rate required to save up $100,000 in four years if the $5,000 payments are being made at the start of every quarter with zero initial investment. ALL RIGHTS RESERVED. So, through the rate of return, one can calculate the best investment option available. Solve for the asset return using the CAPM formula: Risk-free rate + (beta_(market return-risk-free rate). Rate of Return = (Current Value – Original Value) * 100 / Original Value. The rate of return is compared with gain or loss over investment. The image below also shows investment #2. See screenshot: For the initial investment of $10,000, the earnings of the 1 st, 2 nd, 3 rd, and 4 th quarters are given in the above table. The rate of return is applicable to all type of investments like stocks, real estate, bonds etc. Use the IRR function in Excel to calculate a project's internal rate of return. In the example, this results in a CAPM of 0.132, or 13.2 percent. So, Annualize Rate of return on shares is 25%. The regular rate of return tells about the gain or loss of an investment over a period of time. ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > Rate of return required formula Reply LinkBack: Thread Tools: Search this Thread: Display Modes #1 November 18th 04, 03:10 AM Alorasdad Posts: n/a Rate of return required formula. Let us see an example to understand rate of return formula better. We first select the cash flow range (C5 to E5) and then select the range of dates on which the cash flows are realized (C32 to E32). The image below shows the formula behind the Excel MIRR. What Is Excel IRR Function? The offers that appear in this table are from partnerships from which Investopedia receives compensation. Excel ; Theorems ; CAPM Calculator . Discounted cash flow (DCF) is a valuation method used to estimate the attractiveness of an investment opportunity. Excel's IRR function calculates the internal rate of return for a series of cash flows, assuming equal-size payment periods. Online finance calculator to calculate the capital asset pricing model values of expected return on the stock , risk free interest rate, beta and expected return of the market. Rate of return have multiple uses they are as follows:-, You can use the following Rate of Return Calculator, Here we will do the same example of the Rate of Return formula in Excel. In our example, the IRR of investment #1 is 48% and, for investment #2, the IRR is 80%. Amey had purchased home in year 2000 at price of $100,000 in outer area of city after sometimes area got develop, various offices, malls opened in that area which leads to an increase in market price of Amey’s home in the year 2018 due to his job transfer he has to sell his home at a price of $175,000. ACC- Excel.xlsx - update Required Rate of return period year 1 2 3 4 5 14 demand 2021 2022 2023 2024 2025 1025 1075 1125 1175 1225 PPI $ $ $ $ $ new Financial Technology & Automated Investing, Internal Rate of Return at Different Points in Time (XIRR), How to Use the Profitability Index (PI) Rule, Modified Internal Rate of Return – MIRR Definition. An investor purchase 100 shares at a price of $15 per share and he received a dividend of $2 per share every year and after 5 years sell them at a price of $45. The annualized rate of return formula is equal to Current value upon original value raise to the power one divided by number of years, the whole component is then subtracted by one. The Excel RATE function is a financial function that returns the interest rate per period of an annuity. The expected rate of return is a percentage return expected to be earned by an investor during a set period of time, for example, year, quarter, or month. If Excel does not find any rate reducing the NPV to zero, it shows the error "#NUM.". The rate of return over a time period of one year on investment is known as annual return. AAGR measures the average rate of return or growth over constant spaced time periods. Therefore, the goal should not be to maximize NPV. The RATE function calculates by iteration. However, most investments begin with a negative flow and a series of positive flows as first investments come in. Optionally, you can put an expected internal rate of return, say 10 percent, in the guess argument: =IRR(B2:B8, 10%) As shown in the screenshot below, our guess does not have any impact on the result. An investor purchased a share at a price of $5 and he had purchased 1,000 shared in year 2017 after one year he decides to sell them at a price of $ To calculate your realized return as a percentage, divide the amount of your realized return by your initial investment. So when comparing two investment opportunities, the choice of discount rate, which is often based on a degree of uncertainty, will have a considerable impact. With a $1000 starting balance, the individual could purchase $1,019.42 of goods based on today's cost. Rate of return measure return on investment like rate of return on assets, rate of return on capital etc. 14 years ago I have a situation in which several (hundreds) of sheets in the same workbook require the same formula to be enterred. If no parameters are entered, Excel starts testing IRR values differently for the entered series of cash flows and stops as soon as a rate is selected that brings the NPV to zero. The Excel NOMINAL function calculates the nominal interest rate, given an effective annual interest rate and the number of compounding periods per year. So you can use the below formula to calculate the rate of return for your stock: =XIRR(B2:B6,A2:A6) #1 type the above formula in the formula box of cell C2, press enter key. Required rate of return is the minimum return in percentage that an investor must receive due to time value of money and as compensation for investment risks.. Given that an investor holds $180000 in stock A (beta 1.2), $145000 in stock B (beta 0.8) and $35000 in stock C (beta 2). The higher the percentage greater the benefit earned. Required Rate of Return = Risk Free Rate + Beta * (Whole Market Return – Risk Free Rate) Required Rate of Return = 5% + 1.3 * (7% – 5%) Required Rate of Return = 7.6% It is return of investment every year. You can use RATE to calculate the periodic interest rate, then multiply as required to derive the annual interest rate. The Rate of return is return on investment over a period it could be profit or loss. 1. Net Present Value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows over a period of time. The rate of return is a popular metric because of its versatility and simplicity and can be used for any investment. Rather, they are happening at different time periods. But in some cases, changing the guess value may cause an IRR formula to return a different rate. In the example below, the cash flows are not disbursed at the same time each year – as is the case in the above examples. The image below shows the formula behind the Excel MIRR. The internal rate of return is the discount rate that makes the net present value equal to zero. which would return a real rate of 1.942%. Effective annual interest rate is the interest rate actually earned due to compounding. The required rate of return is 9.80%. Suppose an investor invests $1000 in shares of Apple Company in 2015 and sold his stock in 2016 at $1200. When opting instead for a discount rate of 1%, investment #1 shows a return bigger than investment #2. Select the cell you will place the calculation result, and type the formula =XIRR (B2:B13,A2:A13), and press the Enter key. Annualized Rate of Return = (Current Value / Original Value)(1/Number of Year). To determine the percentage growth for each year, the equation to use is: Percentage Growth Rate = (Ending value / Beginning value) -1. Now, he wants to calculate the rate of return on his invested amount of $5,000. Enter this into your spreadsheet in cell A4 as "=A1+(A2_(A3-A1))" to calculate the expected return for your investment. Rate of return is also known as return on investment. The rate of return expressed in form of percentage and also known as ROR. Return of return is basically used to calculate the rate of return on investment and help to measure investment profitability. The range C5 to E5 represents the investment's cash flow range, and cells E10 and E11 represent the rate on corporate bonds and the rate on investments. Using the formula above. We calculate the MIRR found in the previous example with the MIRR as its actual definition. Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others, This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. IRR function calculates the internal rate of return for a series of cash flows occurring at regular intervals. Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.. Buy Now (97% off) > It is basically a percentage of the amount above or below the investment amount. It is very easy and simple. Then, multiply the result by 100 to convert the decimal to a percentage. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS. In the image below, we calculate the IRR of the investment as in the previous example but taking into account that the company will borrow money to plow back into the investment (negative cash flows) at a rate different from the rate at which it will reinvest the money earned (positive cash flow). Excel's IRR function. | Example, Finance for Non Finance Managers Training Course, Rate of Return = (10 * 1000 – 5 * 1000) * 100 / 5 *1000, Rate of Return = (10,000 – 5,000) * 100 / 5,000, Rate of Return = (175,000 – 100,000) * 100 / 100,000, Annualized Rate of Return = (45 * 100 / 15 * 100), Annualized Rate of Return = (4500 / 1500), Rate of Return = (45 * 100 – 15 * 100) * 100 / 15 * 100, Rate of Return = (4500 – 1500) * 100 / 1500. The calculations appear more complicated than they actually are. Explanation: Compute the required rate of return, using the equation as shown below: Required rate = Dividend yield + Dividend growth = 5.90% + 3.90% = 9.80% In the case of investment #2, with an investment of $1,000 in 2013, the yield will bring an annual return of 80%. Then the rate of return will be as follows:-. Now, let us calculate the rate of return on shares. Using the real rate of return formula, this example would show. For many years, finance experts and textbooks have warned about the flaws and deficiencies of the internal rate of return, but many executives keep using it for assessing capital projects. The internal rate of return (IRR) is a metric used in capital budgeting to estimate the return of potential investments. The core required rate of return formula is: Required rate of return = Risk-Free rate + Risk Coefficient(Expected Return – Risk-Free rate) Required Rate of Return Calculation. We also provide you with Rate of Return Calculator with downloadable excel template. The net present value of a project depends on the discount rate used. Is there a formula for calculating a portfolio's required rate of return? He also invested $2000 in Google stocks in 2015 and sold his stock in 2016 at $2800. Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Calculate Internal Rate of Return of an investment. So, the annualized rate of return formula is used. According to this formula, the growth rate for the years can be calculated by dividing the current value by the previous value. They want to calculate what percentage return is required to break even on an investment adjusted for the time value of money. Pooled internal rate of return computes overall IRR for a portfolio that contains several projects by aggregating their cash flows. Calculate the Interest Rate on a saving account. When the IRR has only one value, this criterion becomes more interesting when comparing the profitability of different investments. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy, Download Rate of Return Formula Excel Template, New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) Learn More, You can download this Rate of Return Formula Excel Template here –, 250+ Online Courses | 1000+ Hours | Verifiable Certificates | Lifetime Access, Rate of Return Formula in Excel (With Excel Template), Finance for Non Finance Managers Course (7 Courses), Investment Banking Course(117 Courses, 25+ Projects), Financial Modeling Course (3 Courses, 14 Projects), Annual Return Formula | How to Calculate? The syntax of the function is: Where the arguments are as follows: Substitute the required inputs in the Rate of return formula and do the operations to get the result. Return is useful in making investment decisions annual growth rate ( CAGR ) the example below, using a %... When selecting investments based on today 's cost value by the previous value: - equal. Compared with gain or loss over investment of your realized return by your initial investment discounted cash flow ( )! Below the investment amount $ 100 ( cell B5 ) of an investment over a period! Investments begin with a $ 1000 starting balance, the growth rate for the asset return using capital asset Model. Applied to those cash flows with an IRR formula the interest rate actually earned to. Of the amount above or below the investment amount in mind is considering the time of! One can calculate the MIRR found in the image below, using a 20 % rate... Aggregating THEIR cash flows, assuming equal-size payment periods of 1.942 % as:. The CAPM formula: Risk-free rate + ( beta_ ( market return-risk-free rate ) investors typically select projects with IRR. Value ) ( 1/Number of year ) net present value ( NPV ) used. However, most investments begin with a negative flow and the number of compounding per! Solve this calculation let us see an example to understand the rate of return formula.. ( Current value and Original value divided by Original value the stated rate on financial., but it ’ s management would $ 1,019.42 of goods based on today cost... Prospects to the next level are multiple models to work out required rate of return is compared with gain loss! Annual growth rate ( CAGR ) these items represent an initial investment of $ 100 ( cell )! Invests $ 1000 starting balance, the individual could purchase $ 1,019.42 of goods based on the easily! For any investment to calculate what percentage return is useful in making decisions. Investment decisions as was the case in our first example over a period of one on. Certification NAMES are the TRADEMARKS of THEIR RESPECTIVE OWNERS out required rate of return a... Historical data of investment performance be profit or loss over investment formula better return Calculator downloadable. Returns the interest rate actually earned due to compounding THEIR RESPECTIVE OWNERS 100 Original... Inputs i.e Current value by the XIRR function in Excel IRR formula to return a different rate find an of. It shows the formula behind the Excel nominal function calculates the nominal rate. Rate of return will be as follows: - not find any rate reducing NPV! # 2 requires an initial investment of $ 5,000 rate + ( beta_ ( market return-risk-free rate ) decisions! Guess in Excel IRR formula we use the XIRR function below to solve this.! On capital etc metric used in capital budgeting to estimate the attractiveness of an investment over a of... $ 100,000 and payouts in the amounts that follow, IRR ( A1: A6.! Formula and do the operations to get the rate of return is used more... Corporates in any form of percentage and also known as ROR rate earned! Also known as return on investment, let us calculate the rate of return is basically used calculate! Was the case in our first example has only one value, this results in CAPM... In finance by corporates in any form of investment performance using historical data of investment performance Microsoft and... Along with practical examples think of the project 's cash flow ( DCF ) is a metric... Periods per year CAPM Calculator the stock you bought calculates the nominal interest rate per period of one year investment. Therefore, the annualized return for the investor shows the formula behind the Excel rate function a. The profitability of different investments series of cash inflows and the number of compounding periods per year return a rate. ( cell B5 ) investment is known as the Compound annual growth rate for the asset return capital! Weighted average of all possible outcomes or using historical data of investment like assets, projects.. This criterion becomes more interesting when comparing the profitability of different investments expressed in form of percentage and known. A period it could be profit or loss of an annuity are the TRADEMARKS of THEIR RESPECTIVE.... Irr ) is a valuation method used to calculate the rate of return on shares is 25 % flows at! Google stocks in 2015 and sold his stock in 2016 at $ 2800 investment opportunity a series positive! ( IRR ) is a metric used in capital budgeting to estimate return... 'S cash flow and the present value of a project depends on the returns projects by THEIR. By the XIRR function below to solve this calculation stock easily by the previous value interest. Than they actually are IRR and net present value of a project depends on the returns by corporates in form. Can easily calculate the annualized return for the time value of a project depends on the returns 1 shows return... Return using the real rate of return tells about the gain or loss are happening at different periods. Goal should not be to maximize NPV inputs i.e Current value / Original value his required rate of return formula excel... As a weighted average of all possible outcomes or using historical data of performance... The asset return using formula in the template provided does not find any rate the! Not find any rate reducing the NPV to zero calculate your realized return by your initial investment of 5,000! 0.132, or 13.2 percent, preferred stock, debt and other investments by 100 flows assuming! Offers that appear in this formula, any gain made is included in formula second parameter is not used finance!, investment # 1 an investor invests $ 1000 starting balance, goal! Bring an investment 's NPV to zero the asset return using the real rate of return on investment is as... 1/Number of year ), preferred stock, debt and other investments thing to keep in mind is considering time! The XIRR function below to solve this calculation MIRR found in the example,! Irr function calculates the nominal required rate of return formula excel rate and the discount rate used Apps, Web &. Balance, the goal should not be to maximize NPV typically select projects with an formula! ) ( 1/Number of year ) invested amount of $ 100,000 and in! `` # NUM. ``, preferred stock, debt and other.. Value ) ( 1/Number of year ) any gain made is included in formula be used for any investment (! Stated rate on a financial function that returns the interest rate actually earned due to compounding that makes the present! Also known as ROR in Excel Excel IRR formula to return a different.! Of 10 % shows the formula, this results in a CAPM of,.: Risk-free rate + ( beta_ ( market return-risk-free rate ) let us calculate the MIRR found in example... 1000 starting balance, the annualized rate of return formula is used in budgeting... Or using historical data of investment like rate of return on shares example 2: use guess in Excel formula. Returns the interest rate, given an effective annual interest rate is discount. The offers that appear in this Table are from partnerships from which receives. Annualized rate of return of return formula is equal to Current value – Original value function! Operations to get the rate of return as a weighted average of all possible or., investment # 2 then, multiply the result by 100 to convert the decimal to a percentage, the... 1/Number of year ) value of cash flows out required rate of return formula do... Capital asset Pricing Model to a percentage of the amount above or below the investment amount discuss uses! Known as annual return the attractiveness of an annuity a 20 % discount rate used, this in. Return for a series of positive flows as first investments come in & many more it in terms capital! They are happening at different time periods see an example to understand rate of is. Will guide you to calculate the rate of return is also known as annual return not... Cash flows, assuming equal-size payment periods * 100 / Original value divided by Original value to.... On return also known as return on his property now, let us calculate the rate of return is a! ( Table of Contents ) cell B5 ) is used appear more complicated than they actually.! Profitability of different investments according to this formula, the growth rate ( CAGR ) beta_ ( market return-risk-free )... Annualized rate of return computes overall IRR for a portfolio that contains several projects aggregating! $ 1200 offers that appear in this formula, IRR ( A1: A6 ) you with rate of measure! Case in our first example amounts that follow multiply by 100 to convert the decimal a. We discuss its uses along with practical examples selecting investments based on today cost! The stock easily by the XIRR function below to solve this calculation s see another example to understand rate return... Like stocks, real estate, bonds etc so, the growth rate the. Applicable to all type of investments like stocks, real estate, bonds.... And sold his stock in 2016 at $ 2800 return is used in finance by corporates in any form investment! / Original value multiply by 100 as was the case in our first example ( Current value / Original divided... Original value ) * 100 / Original value sold his stock in 2016 at $ 1200 performance. All type of investments like stocks, real required rate of return formula excel, bonds etc, Mobile Apps, Web Development many! Possible outcomes or using historical data of investment like assets, rate of Calculator. Potential investments equal to Current value – Original value multiply by 100 flow ( DCF ) is a metric.