Write a payment schedule calculator subroutine so it displays the payments broken down into interest and principal payments. Make this interactive so that the user will be prompted for: The loan Amount The number of Years The frequency (number of payments per year) The Interest Rate (APR) The payment schedule should look something like this (if it were $1,000, 5%, and 5 years of quarterly payments):

Set your default loan amount to $10,000 Set the default term to 2 years Set the default frequency to 12 months per year Set your default interest rate to 4% Hints: You will need 4 input boxes You will want to use a loop to output the results Inside the message box which outputs the answers, you will want to use tab to set up the columns Chr(13) is the syntax for carriage return (new line) Chr(9) is the syntax for tab

There are some hints on the PDF. Here are some more hints: It involves looping

-Youll want to use a loop to calculate the interest portion of the payment each iteration. Youll use that to figure out the capital portion of the payment.

-Then before the next iteration, youll need to recalculate the balance on the loan so that in the next iteration the new interest portion of the payment can be calculated and applied to the loan.