consumers for residential housing.  Your task is to create an application to be used by the loan officers of the company when presenting loan options to its customers.  The application will be a  mortgage calculator that determines a monthly payment for loans.   The company offers 10-, 15-, and 30-year fixed loans.  The interest rates offered to customers are based on the customer’s credit score.  Credit scores are classified into the following categories:   Table 1: Credit Score Categories Rating            Range Excellent         720-850 Good               690-719 Fair                  630-689 Bad                  300-629   The program should initially prompt the user (the loan officer) for the principle of the loan (i.e. the amount that is being borrowed).  It should then ask him or her to enter the customer’s credit score.  Based on the customer’s credit score, the program will randomly generate an interest rate based on the following ranges:   Table 2:  Interest Rate Assignments Rating            Interest Rate Excellent         2.75% - 4.00% Good               4.01% - 6.50% Fair                  6.51% - 8.75% Bad                  8.76% - 10.50%   The final input should be the number of years that the loan will be outstanding.  Because the company only offers three different terms ( 10-, 15-, and 30-year loans), the program should ensure that no other terms are entered.     Formulas   Payment Calculator [Adapted from Wittwer, J.W., "Amortization Calculation," From Vertex42.com, Nov 11, 2008.]   The formula to calculate the monthly payment for a fixed interest rate loan is as follows: where A = payment Amount per period P = initial Principal (loan amount) r = interest rate per period n = total number of payments or periods   Example: What would the monthly payment be on a 15-year, $100,000 loan with a 4.50% annual interest rate? P = $100,000 r = 4.50% per year / 12 months = 0.375% (or 0.00375) per period n = 15 years * 12 months = 180 total periods A = 100,000 * (.00375 * (1 + .00375)180)/((1+.00375)180 – 1)   Using these numbers in the formula above yields a monthly payment of $764.99. Start your program by prompting the user to enter a principle amount.  The data type of this number should be a double.  The amount must be positive and it must also be a numeric value.  For example, when prompted to enter a number, if the user enters “abc,” the program will not be able to process the loan appropriately. Likewise, if the user enters -100000, the program will again produce erroneous results.    Prompt the user to enter the customer’s credit score.  Again, appropriate error checking is essential here.  In addition to ensuring that values are numeric and positive, you must also ensure that the credit score entered does not exceed 850.  If a non-numeric, negative, or score that exceeds 850 is entered, prompt the user to re-enter the score.    If the credit score is below 300, display an error message to the user stating that the loan cannot be offered and exit the program.  Make certain that the error message is displayed for a long enough duration for the user to read it before the program closes.   Prompt the user to enter the term of the loan.  Valid terms are 10, 15, and 30 years.  Any other numbers should be rejected, and the user should be prompted to re-enter an appropriate value.   Once the inputs have been entered and validated, your program must generate an interest rate to be used in the loan calculation.  Create an enum to represent the possible credit ratings: EXCELLENT, GOOD, FAIR, and BAD. Assign the appropriate enum to the customer based on the ranges listed in Table 1 above. I recommend using if-statements for this. Using a SWITCH statement with the enum values as cases, assign an interest rate based on the customer’s credit rating.  Within each case, use a random number generator to create an interest rate for each category based on the ranges listed in Table 2 above. Because the random number generator that you have been taught generates only integer values, you will need to generate a number in the hundreds and divide that number by 100 to get a result within the valid range for interest rates.  Be careful with integer division here.  Remember that an int divided by an int equals an int (i.e. int/int=int).  To arrive at a double, you must make either the numerator or denominator a double to generate an interest rate with a decimal portion.   To perform the calculation for a monthly payment, create a function called CalcPayment that receives the principle, interest rate, and number of years as parameters.  The function should return the monthly payment that is calculated.     Your program should check for invalid data such as non-numeric and non-positive entries for principle, credit score, and term. Use proper indentation and style, meaningful identifiers, and appropriate comments.

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

consumers for residential housing.  Your task is to create an application to be used by the loan officers of the company when presenting loan options to its customers.  The application will be a  mortgage calculator that determines a monthly payment for loans.

 

The company offers 10-, 15-, and 30-year fixed loans.  The interest rates offered to customers are based on the customer’s credit score.  Credit scores are classified into the following categories:

 

Table 1: Credit Score Categories

Rating            Range

Excellent         720-850

Good               690-719

Fair                  630-689

Bad                  300-629

 

The program should initially prompt the user (the loan officer) for the principle of the loan (i.e. the amount that is being borrowed).  It should then ask him or her to enter the customer’s credit score.  Based on the customer’s credit score, the program will randomly generate an interest rate based on the following ranges:

 

Table 2:  Interest Rate Assignments

Rating            Interest Rate

Excellent         2.75% - 4.00%

Good               4.01% - 6.50%

Fair                  6.51% - 8.75%

Bad                  8.76% - 10.50%

 

The final input should be the number of years that the loan will be outstanding.  Because the company only offers three different terms ( 10-, 15-, and 30-year loans), the program should ensure that no other terms are entered.

 

 

Formulas

 

Payment Calculator

[Adapted from Wittwer, J.W., "Amortization Calculation," From Vertex42.com, Nov 11, 2008.]

 

The formula to calculate the monthly payment for a fixed interest rate loan is as follows:


where

A = payment Amount per period

P = initial Principal (loan amount)

r = interest rate per period

n = total number of payments or periods

 

Example: What would the monthly payment be on a 15-year, $100,000 loan with a 4.50% annual interest rate?

P = $100,000
r = 4.50% per year / 12 months = 0.375% (or 0.00375) per period
n = 15 years * 12 months = 180 total periods

A = 100,000 * (.00375 * (1 + .00375)180)/((1+.00375)180 – 1)

 

Using these numbers in the formula above yields a monthly payment of $764.99.

  1. Start your program by prompting the user to enter a principle amount.  The data type of this number should be a double.  The amount must be positive and it must also be a numeric value.  For example, when prompted to enter a number, if the user enters “abc,” the program will not be able to process the loan appropriately. Likewise, if the user enters -100000, the program will again produce erroneous results. 

 

  1. Prompt the user to enter the customer’s credit score.  Again, appropriate error checking is essential here.  In addition to ensuring that values are numeric and positive, you must also ensure that the credit score entered does not exceed 850.  If a non-numeric, negative, or score that exceeds 850 is entered, prompt the user to re-enter the score. 

 

If the credit score is below 300, display an error message to the user stating that the loan cannot be offered and exit the program.  Make certain that the error message is displayed for a long enough duration for the user to read it before the program closes.

 

  1. Prompt the user to enter the term of the loan.  Valid terms are 10, 15, and 30 years.  Any other numbers should be rejected, and the user should be prompted to re-enter an appropriate value.

 

  1. Once the inputs have been entered and validated, your program must generate an interest rate to be used in the loan calculation. 
    1. Create an enum to represent the possible credit ratings: EXCELLENT, GOOD, FAIR, and BAD.
    2. Assign the appropriate enum to the customer based on the ranges listed in Table 1 above. I recommend using if-statements for this.
    3. Using a SWITCH statement with the enum values as cases, assign an interest rate based on the customer’s credit rating. 
  1. Within each case, use a random number generator to create an interest rate for each category based on the ranges listed in Table 2 above. Because the random number generator that you have been taught generates only integer values, you will need to generate a number in the hundreds and divide that number by 100 to get a result within the valid range for interest rates.  Be careful with integer division here.  Remember that an int divided by an int equals an int (i.e. int/int=int).  To arrive at a double, you must make either the numerator or denominator a double to generate an interest rate with a decimal portion.

 

  1. To perform the calculation for a monthly payment, create a function called CalcPayment that receives the principle, interest rate, and number of years as parameters.  The function should return the monthly payment that is calculated.

 

 

Your program should check for invalid data such as non-numeric and non-positive entries for principle, credit score, and term. Use proper indentation and style, meaningful identifiers, and appropriate comments.

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 6 images

Blurred answer
Knowledge Booster
Running Time of Application
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