Adjust for inflation Google sheets

ABCDEFGH0.00Amount Invested per year:10000.00Important Formula:

Inflation = Compound Interest = P * (1 + r / 100) ^ n

Annualised retrun of Mutual Fund = Compound Annual Growth rate (CAGR)
= [(Final Amount / Initial Amount) ^ (1 / n)] - 1

Annualised Return = Return received by the investor every year for n years

Annual increase considered in investment amount (percentage)11500Frequency of investment:AnnualNo. of years for which amount is invested:1,3Rate of Return:Inflation considered:0,2YearAmount investedTotal amount invested
at the start of yearRate of ReturnTotal ReturnsTotal Amount invested till dateCumulative Amount (Total Cash accumulated)Inflation adjusted amount (equivalent to today's value)110000.0010000.000.0010000.0010000.00#VALUE!210000.0020000.000.0020000.0020000.00#VALUE!310000.0030000.000.0030000.0030000.00#VALUE!410000.0040000.000.0040000.0040000.00#VALUE!510000.0050000.000.0050000.0050000.00#VALUE!610000.0060000.000.0060000.0060000.00#VALUE!710000.0070000.000.0070000.0070000.00#VALUE!810000.0080000.000.0080000.0080000.00#VALUE!910000.0090000.000.0090000.0090000.00#VALUE!1010000.00100000.000.00100000.00100000.00#VALUE!1110000.00110000.000.00110000.00110000.00#VALUE!1210000.00120000.000.00120000.00120000.00#VALUE!1310000.00130000.000.00130000.00130000.00#VALUE!1410000.00140000.000.00140000.00140000.00#VALUE!1510000.00150000.000.00150000.00150000.00#VALUE!1610000.00160000.000.00160000.00160000.00#VALUE!1710000.00170000.000.00170000.00170000.00#VALUE!1810000.00180000.000.00180000.00180000.00#VALUE!1910000.00190000.000.00190000.00190000.00#VALUE!2010000.00200000.000.00200000.00200000.00#VALUE!2110000.00210000.000.00210000.00210000.00#VALUE!2210000.00220000.000.00220000.00220000.00#VALUE!2310000.00230000.000.00230000.00230000.00#VALUE!2410000.00240000.000.00240000.00240000.00#VALUE!2510000.00250000.000.00250000.00250000.00#VALUE!2610000.00260000.000.00260000.00260000.00#VALUE!2710000.00270000.000.00270000.00270000.00#VALUE!2810000.00280000.000.00280000.00280000.00#VALUE!2910000.00290000.000.00290000.00290000.00#VALUE!3010000.00300000.000.00300000.00300000.00#VALUE!One TimeMonthlyAnnualQuarterlyHalf YearlyAnnual

Quotes are not sourced from all markets and may be delayed by up to 20 minutes. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice.Disclaimer