ALL BUSINESS ENGLISH 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

Comments are closed.

Pin It

By continuing to use the site, you agree to the use of cookies. / Συνεχίζοντας να χρησιμοποιείτε την ιστοσελίδα, συμφωνείτε με τη χρήση των cookies. more information / περισσότερες πληροφορίες

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close