# Help excel

## Excel Help for Help Excel in Valuing Investments and Businesses

### Help Excel

Rate this:
(3/5 from 1 vote)
 if i deposit 1000 each year to a pension saving fund for 41 years with an inflation of 1.40% and an interest of 4.40% (yearly), then how am i able to get the answer in one FV formula. I've already made a table for each year but am unable to get the answer in one formula. Adriaan Posted by Adriaan on 17 Mar 2022
 Replies - Displaying 1 to 4 of 4 Order Replies By: Most recent | Chronological | Highest Rated
 Rate this: (3/5 from 1 vote) There is a detailed explanation of how to make this calculation here Excel Business Forums Administrator Posted by Excel Helper on 23 Mar 2022
 Rate this: (3/5 from 1 vote) Dear,Is it possible to find the solution by using the FV formula combined with another formula? I'm really struggling.Thanks in advance. Adriaan Posted by Adriaan on 23 Mar 2022
 Rate this: (4/5 from 2 votes) I've done that and used it into my FV formula but i still don't get my the correct answer. I used: -FV(2.95857988%,41,1768.300847,1000,1). I'm very close to the answer (149 926.15) but i think i use a wrong PMT. Adriaan Posted by Adriaan on 18 Mar 2022
 Rate this: (4/5 from 2 votes) Since the FV formula will only accept one interest rate, the easiest option would be to adjust the interest rate for inflation: (1 + Interest Rate) / (1 + Inflation) - 1 TRANSLATE with x   TRANSLATE with COPY THE URL BELOW EMBED THE SNIPPET BELOW IN YOUR SITE Enable collaborative features and customize widget: Bing Webmaster Portal Back Excel Business Forums Administrator Posted by Excel Helper on 17 Mar 2022
 Displaying page 1 of 1