7/8/2023 0 Comments Cagr formula excel![]() ![]() Remember, compounding periods are important. Start in the cell with =RRI( and then type the inputs as shown below. What is the equivalent rate of return? In these examples, we will type the formula directly into the cell and not use the function wizard. The inputs required are the number of periods, the present value and the future value.Īs an example, let’s say you invested $100,000 for 8 years compounded annually and the investment grows to a value of $150,000. ![]() It returns the equivalent interest rate for the growth of an investment. RRIis a new function that was introduced in Excel 2013. Below is an excerpt from our Excel Time Value of Money course written by Joseph Helstrom,CPA.
0 Comments
Leave a Reply. |