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:
Sample Question:
Using Excel Functions to solve the question:
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! 🙂