ALL BUSINESS ENGLISH ARTICLES MICROSOFT EXCEL TIPS ΧΡΗΜΑΤΟΟΙΚΟΝΟΜΙΚΑ

Computing Future Value for a Specified Period

You wish to save some money for renovating your house in 5 years. You deposit 2,000 EUR to your saving account at an interest rate of 3% compounded quarterly. Furthermore, you are going to add 100 EUR at the beginning of each month. How much money will there be in your saving account in 5 years?

Formula for Cell B11 (Future Value)

=FV(B7/B5;B6*B5;B9;B8;B10)

According to Excel FV calculator – around 4,300 EUR.

 

FB Tags :

#excel_tips #calculations #future_value #softexperia / fb : Softexperia.com / www.softexperia.com

Read also

Data Analysis

Αν θέλετε να κάνετε κάποια συλλογή/ανάλυση δεδομένων για να βελτιώσετε τις δραστηριότητες σας, μπορούμε να σας βοηθήσουμε.
Μην διστάσετε να επικοινωνήσετε μαζί μας.

Email : info@softexperia.com
Mobile : 6945 849400

www.softexperia.com

Follow us on Linkedin : Softexperia

#softexperia #data_analysis #python #excel_tips #decision_making #dataanalysis #dataanalytics

Views: 6

Comments are closed.

Pin It