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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Income Tax Fundamentals 2013
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
31st Edition
1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516
