The monthly payment for a given loan pays the principal and the interest. The monthly interest is computed by multiplying the monthly interest rate and the balance (the remaining principal). The principal paid for the month is therefore the monthly payment minus the monthly interest. Write a program that lets the user enter the loan amount, number of years, and interest rate, and then displays the amortization schedule for the loan. Here is a sample run: Loan Amount: 10000 Enter Number of Years: 1 Enter Annual Interest Rate: 7 - Enter Monthly Payment: 865.26 Total Payment: 10383.21 Principal 806.93 811.64 Balance Payment# 1 2 Interest 58.33 53.62 9193.07 8381.43 ... 11 10.00 855.26 860.27 12 5.01 860.25 0.01

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

PYTHON ONLY PLEASE

PYTHON ONLY PLEASE

Question 1
The monthly payment for a given loan pays the principal and the interest. The monthly interest is computed by
multiplying the monthly interest rate and the balance (the remaining principal). The principal paid for the month
is therefore the monthly payment minus the monthly interest. Write a program that lets the user enter the loan
amount, number of years, and interest rate, and then displays the amortization schedule for the loan.
Here is a sample run:
Loan Amount: 10000
JEnter
Number of Years: 1
JEnter
Annual Interest Rate: 7 - Enter
Monthly Payment: 865.26
Total Payment: 10383.21
Principal
806.93
811.64
Payment#
Interest
Balance
58.33
53.62
9193.07
8381.43
2
11
10.00
855.26
860.27
12
5.01
860.25
0.01
Note: The balance after the last payment may not be zero. If so, the last payment should be the normal monthly
payment plus the final balance.
Hint:
Мonthly Paymеnt
1
[1-
Loan Amount
interest rate
(1+ interest rate)"]
n = number of payment periods
The interest rate is the effective rate per month (i.e. annual interest rate divided by 12)
Hint: The following statement will print the header of the table
print(format("Payment#", "<15s"), format("Interest", "<15s"), format("Principal", "<15s"), format("Balance",
"<15s"))
Hint: The following statement will print the contents of the table below the header
print(format(i, "<15d"), format(interest, "<15.2f"), format(principal, "<15.2f"), format(balance, "<15.2f"))
Transcribed Image Text:Question 1 The monthly payment for a given loan pays the principal and the interest. The monthly interest is computed by multiplying the monthly interest rate and the balance (the remaining principal). The principal paid for the month is therefore the monthly payment minus the monthly interest. Write a program that lets the user enter the loan amount, number of years, and interest rate, and then displays the amortization schedule for the loan. Here is a sample run: Loan Amount: 10000 JEnter Number of Years: 1 JEnter Annual Interest Rate: 7 - Enter Monthly Payment: 865.26 Total Payment: 10383.21 Principal 806.93 811.64 Payment# Interest Balance 58.33 53.62 9193.07 8381.43 2 11 10.00 855.26 860.27 12 5.01 860.25 0.01 Note: The balance after the last payment may not be zero. If so, the last payment should be the normal monthly payment plus the final balance. Hint: Мonthly Paymеnt 1 [1- Loan Amount interest rate (1+ interest rate)"] n = number of payment periods The interest rate is the effective rate per month (i.e. annual interest rate divided by 12) Hint: The following statement will print the header of the table print(format("Payment#", "<15s"), format("Interest", "<15s"), format("Principal", "<15s"), format("Balance", "<15s")) Hint: The following statement will print the contents of the table below the header print(format(i, "<15d"), format(interest, "<15.2f"), format(principal, "<15.2f"), format(balance, "<15.2f"))
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
Introduction to computer system
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
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