Calculating Annuity with Functions

Written by Jade Wong Jie Yu 
Jade is a Year 2 BBA Student and part of the VBA Team in NUS Business Analytics Society.


After doing the exercises for Week 6’s session, I realized that functions were very useful. Since I was studying for my FIN2004 midterms, I figured, why not try using function to calculate present values and future values?

I wrote functions for present value of annuity, future value of annuity, present value of annuity due, future value of annuity due.

Code for Functions:

2017-09-21 Jade FIN Functions Code Blog

Sample Question: 

2017-09-21 Jade FIN Question Blog

Using Excel Functions to solve the question: 

2017-09-21 Jade FIN Question Blog 2

I would have to use a financial calculator to solve these questions (since I wouldn’t have Excel in the exam hall anyway). But it was still good to know I could do these using VBA! You can think about how you can apply it to your everyday work too! 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s