1) Write a VBA subroutine to calculate PMT. Your programme should have Input Boxes for users to provide Loan amount, Rate of returns (r) and the number of period (n). It should display the results in a message box.

2) Write a present value calculator subroutine. Your subroutine should ask the user for the cashflow value, the interest rate, and the number of periods. It should then display the result in a message box. Sensible default values should be supplied for all arguments. Do not use the Excel function PV ; write your own present value function and use it.