1) Write a VBA subroutine to calculate PMT. Your programme should have Input Boxes for users to...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: