**Loan Amortization Table Construction**This example demonstrates how to create a loan amortization table for a loan of $7,000 with an Annual Percentage Rate (APR) of 9% and a loan term of 10 years. The objective is to verify that with monthly payments of $88.67, the loan balance will be reduced to $0 after 120 months.*Instructions for Part (a)***Objective:** Use technology to construct a table showing the interest payment, principal payment, and loan balance after each month.*Note:* Do not round until the final answer. Then, round to the nearest cent as needed.**Loan Amortization Details:**- **Initial Loan Amount:** $7,000- **Monthly Payment:** $88.67- **APR:** 9%- **Loan Term:** 10 years (120 months)| Month | Interest | Principal | Balance ||-------|----------|-----------|----------|| 0 | | | $7,000.00|| 1 | $52.50 | $36.17 | $6,963.83|| 2 | | | || ... | | | || 119 | | | || 120 | | | |**Diagram Explanation:**- The table is structured to show each month from the start of the loan (month 0) to the end (month 120).- Under each month, the columns display the interest payment, principal payment, and remaining loan balance.- The interest for the first month is calculated as $52.50, and the principal payment is $36.17, reducing the initial balance from $7,000.00 to $6,963.83.- The process repeats, with monthly payments continuing until month 120 when the balance should reach $0.

Loan is $7000 APR is 9% Loan term is 10 years. Monthly payment is $88.67 To Verify: Balance at the end of 120th month is zero calculations by considering $88.67 as monthly paymnet.This will give us approximate result as this will give us approximate result as monthly payment is rounded upto 2 decimal places. Excel Workings: Excel Calculations: Therefore; at the end of 12oth payment $0.59, this is because of monthly payment that we are taking only upto two decimal. Now lets calculate monthly payment with formula and prepare repayment schdule. Excel Workings: Excel Calculations: Therefore; It is being verified that loan balnce reaches zero after 120th payment.

Business

Finance

Consider a loan of $7000 with an APR of 9% and a loan term of 10 years. Complete parts (a) through (c) below. a. Use technology to construct a table showing the interest payment and loan balance after each month. Verify that, with monthly payments of $88.67, the loan balance reaches $0 after 120 months. (Do not round until the final answer. Then round to the nearest cent as needed.) Month Interest Principal Balance $7000.00 S6963 83 S52.50 S36.17 1 119 120

Consider a loan of $7000 with an APR of 9% and a loan term of 10 years. Complete parts (a) through (c) below. a. Use technology to construct a table showing the interest payment and loan balance after each month. Verify that, with monthly payments of $88.67, the loan balance reaches $0 after 120 months. (Do not round until the final answer. Then round to the nearest cent as needed.) Month Interest Principal Balance $7000.00 S6963 83 S52.50 S36.17 1 119 120

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

How would I complete this?
A loan has quarterly payments. The APR is 16%, and interest is compounded 12 time(s) per year. The effective interest rate that would be needed to find the payment amount for the loan is _%. Margin of error for correct responses: +/-.02 (%) Rounding and Formatting instructions: Do not enter dollar signs, percent signs, commas, X, or any words in your response. Do not round any intermediate work, but round your *final* response to 2 decimal places (example: if your answer is 12.3456, 12.3456%, or $12.3456, you should enter 12.35).
You have just been hired as a loan officer at a national bank. Your first assignment is to calculate the amount of the periodic payment (in $) required to amortize (pay off) the following loan being considered by the bank (use Table 12-2). (Round your answer to the nearest cent.) LoanPayment PaymentPeriod Term ofLoan (years) NominalRate (%) Present Value(Amount of Loan) $ every month 1 3 4 6 $40,000
Suppose you borrow $14,000. The interest rate is 11%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter "0". Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ fill in the blank 60 $ fill in the blank 61 $ fill in the blank 62 $ fill in the blank 63 $ fill in the blank 64 2 $ fill in the blank 65 $ fill in the blank 66 $ fill in the blank 67 $ fill in the blank 68 $ fill in the blank 69 3 $ fill in the blank 70 $ fill in the blank 71 $ fill in the blank 72 $ fill in the blank 73 $ fill in the blank 74 4 $ fill in the blank 75 $ fill in the blank 76 $ fill in the blank 77 $ fill in the blank 78 $ fill in the blank 79
Find the monthly payment for the loan. (Round your answer to the nearest cent.) $700 loan for 12 months at 15%
PLEASE Use the correct function on EXCEL
Find the monthly payment and estimate the remaining balance. Assume interest is on the unpaid balance. 5-year computer loan for $2770 at 6.7%; remaining balance after 2 years. The monthly payment is (Round to the nearest cent as needed
Find the monthly payment and estimate the remaining balance. Assume interest is on the unpaid balance. 4-year computer loan for $3106 at 5.7%; remaining balance after 2 years. The monthly payment is $. (Round to the nearest cent as needed.) The remaining balance is $. (Round to the nearest dollar as needed.)
Suppose you secure a home improvement loan in the amount of $5,000 from a local bank. The loan officer gives you the following loan terms:• Contract amount = $5,000• Contract period = 24 months• Annual percentage rate = 12%• Monthly installment = $235 .37Shown is the cash flow diagram for this loan. Construct the loan payment schedule by showing the remaining balance, interest payment, and principal payment at the end of each period over the life of the loan.
The loan below was paid in full before its due date. (a) Obtain the value of h from the annual percentage rate table. Then (b) use the actuarial method to find the amount of unearned interest, and (c) find the payoff amount. Regular Monthly Payment $445.22 Remaining Number of Scheduled Payments after Payoff 6 APR 11.0% Click the icon to view the annual percentage rate table. (a) h=$ (b) The unearned interest is $ (c) The payoff amount is $ (Round to the nearest cent as needed.) (Round to the nearest cent as needed.)
Watch the video and then solve the problem given below. Click here to watch the video. You are considering a loan with an annual rate of 8%. The mortgage is $130,000 with 180 monthly payments of $1242.35 for 15 years. Complete the first two months of the amortization table. (Simplify your answers. Round to the nearest cent as needed.) Payment number Interest payment Principal payment Balance of loan 1
Suppose you have a student loan of $45,000 with an APR of 12% for 20 years. Complete parts (a) through (c) below. a. What are your required monthly payments? The required monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.)

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS