Build a loan calculator subroutine that will display the total amount paid (interest and principal over the life of a loan. 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) Set your default loan amount to $30,000 Set the default term to 3 years Set the default frequency to 4 payments per year Set your default interest rate to 8% APR In a message box, output the interest portion of each payment. Hints: . You will need 4 input boxes. You can solve mathematically or utilize the Excel function IPMT to calculate the intere portion of the payment each period. You should calculate and display each payment's interest portion using a loop. • To display all the interest payments in one message box, you can create a variable to ho the loop contents (all the interest payments). • Chr(13) is the syntax for carriage return (new line). This is helpful to display each interest payment on a new line inside the message box. To check your result, you can determine the total loan payments and subtract the loan amount (principal).

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Build a loan calculator subroutine that will display the total amount paid (interest and principal)
over the life of a loan. 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)
Set your default loan amount to $30,000
Set the default term to 3 years
Set the default frequency to 4 payments per year
Set your default interest rate to 8% APR
In a message box, output the interest portion of each payment.
Hints:
.
•
You will need 4 input boxes.
You can solve mathematically or utilize the Excel function IPMT to calculate the interes
portion of the payment each period. You should calculate and display each payment's
interest portion using a loop.
•
To display all the interest payments in one message box, you can create a variable to hold
the loop contents (all the interest payments).
•
Chr(13) is the syntax for carriage return (new line). This is helpful to display each
interest payment on a new line inside the message box.
To check your result, you can determine the total loan payments and subtract the loan amount
(principal).
Transcribed Image Text:Build a loan calculator subroutine that will display the total amount paid (interest and principal) over the life of a loan. 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) Set your default loan amount to $30,000 Set the default term to 3 years Set the default frequency to 4 payments per year Set your default interest rate to 8% APR In a message box, output the interest portion of each payment. Hints: . • You will need 4 input boxes. You can solve mathematically or utilize the Excel function IPMT to calculate the interes portion of the payment each period. You should calculate and display each payment's interest portion using a loop. • To display all the interest payments in one message box, you can create a variable to hold the loop contents (all the interest payments). • Chr(13) is the syntax for carriage return (new line). This is helpful to display each interest payment on a new line inside the message box. To check your result, you can determine the total loan payments and subtract the loan amount (principal).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Returning value from Function
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education