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).
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
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education