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 5 of 5

Order Replies By: Most Recent | Chronological | Highest Rated

	Combine rates into one 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 English Arabic Hebrew Polish Bulgarian Hindi Portuguese Catalan Hmong Daw Romanian Chinese Simplified Hungarian Russian Chinese Traditional Indonesian Slovak Czech Italian Slovenian Danish Japanese Spanish Dutch Klingon Swedish English Korean Thai Estonian Latvian Turkish Finnish Lithuanian Ukrainian French Malay Urdu German Maltese Vietnamese Greek Norwegian Welsh Haitian Creole Persian     TRANSLATE with COPY THE URL BELOW Back 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

	Help part 2 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

	FV formula 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

	Detailed calculation description 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

	FV Formula Rate this: (3/5 from 1 vote) Instead of a table, you can use Excel’s FV formula. Just adjust for inflation and enter it all in one line. I found it much quicker and easier for long-term calculations like yours!
	Posted by Henna Minkow on 27 Sep 2024

Displaying page 1 of 1