This assignment is to use your knowledge of Chap 1-5 to generate the following amortization table in a file given user’s input of loan amount, annual interest rate, term or number of years, and additional principal the borrower is willing to pay per month. You’ll use the formula of the monthly Payment as follows: monthlyPayment = (loanAmount * annualInterest/12)/(1- 1/pow(1+annualInterest/12,numberOfYears*12)) Then, you can use the following formula to compute Principal, Interest and Balance for the ith month. Balance(0) = Loan Amount; Actual Payment = Monthly Payment + Additional Principal Interest(i) = Balance(i-1) * Annual Interest Rate/12; Principal(i) = Actual Payment – Interest(i) Balance(i) = Balance(i-1) – Principal(i) When additional principal is greater than 0, it means that the loan will be paid off earlier than the loan term. So, your amortization table should end when the balance becomes zero or negative. So, when the balance is less than the actual payment, the next month’s principal is the same as the previous month’s balance, a
This assignment is to use your knowledge of Chap 1-5 to generate the following amortization table in a file given user’s input of loan amount, annual interest rate, term or number of years, and additional principal the borrower is willing to pay per month. You’ll use the formula of the monthly Payment as follows: monthlyPayment = (loanAmount * annualInterest/12)/(1- 1/pow(1+annualInterest/12,numberOfYears*12)) Then, you can use the following formula to compute Principal, Interest and Balance for the ith month. Balance(0) = Loan Amount; Actual Payment = Monthly Payment + Additional Principal Interest(i) = Balance(i-1) * Annual Interest Rate/12; Principal(i) = Actual Payment – Interest(i) Balance(i) = Balance(i-1) – Principal(i) When additional principal is greater than 0, it means that the loan will be paid off earlier than the loan term. So, your amortization table should end when the balance becomes zero or negative. So, when the balance is less than the actual payment, the next month’s principal is the same as the previous month’s balance, a
Chapter3: Performing Calculations With Formulas And Functions
Section: Chapter Questions
Problem 2.11CP
Related questions
Question
This assignment is to use your knowledge of Chap 1-5 to
generate the following amortization table in a file given
user’s input of loan amount, annual interest rate, term or
number of years, and additional principal the borrower is
willing to pay per month.
You’ll use the formula of the monthly Payment as follows:
monthlyPayment = (loanAmount * annualInterest/12)/(1-
1/pow(1+annualInterest/12,numberOfYears*12))
Then, you can use the following formula to compute
Principal, Interest and Balance for the ith month.
Balance(0) = Loan Amount;
Actual Payment = Monthly Payment + Additional Principal
Interest(i) = Balance(i-1) * Annual Interest Rate/12;
Principal(i) = Actual Payment – Interest(i)
Balance(i) = Balance(i-1) – Principal(i)
When additional principal is greater than 0, it means that
the loan will be paid off earlier than the loan term. So,
your amortization table should end when the balance becomes
zero or negative. So, when the balance is less than the
actual payment, the next month’s principal is the same as
the previous month’s balance, a
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 4 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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage