Prepare an amortization schedule for a five-year loan of $60,000. The interest rate is 9percent per year, and the loan calls for equal annual payments. (Do not roundintermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)PrincipalPaymentEndingBalanceTotalBeginningBalanceInterestYearPaymentPayment13.4How much total interest is paid over the life of the loan? (Do not round intermediatecalculations and round your answer to 2 decimal places, e.g., 32.16.)Total interest paid< Prev10 of 10Next

Using Excel PMT function to calculate the monthly payment, Loan Amortization Schedule is as under -

Prepare an amortization schedule for a five-year loan of $60,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Beginning Balance Principal Payment Ending Balance Total Interest Year Payment Payment 1 2 N 3 4

Prepare an amortization schedule for a five-year loan of $60,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Beginning Balance Principal Payment Ending Balance Total Interest Year Payment Payment 1 2 N 3 4

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

n.c.
You have taken a loan of $78,000.00 for 20 years at 4.9% compounded quarterly. Fill in the table below, rounding all values to the nearest cent. Note that the principal column is listed before the interest column even though the interest calculation is done first. Many lending institutions use this order in the amortization schedules they provide to their customers. Payment number Payment amount Principal Amount Interest 0) 1) 2) 3) $ S $ $ s Balance $78,000.00 $
Prepare an amortization schedule for a five-year loan of $47,000. The interest rate is 7% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank - be certain to enter "O" wherever required.) Year 1 Beginning Balance $ 2 2 3 4 5 Total Payment $ Interest Payment Principal Payment Ending Balance $ How much interest is paid in the third year? (Do not round intermediate calculations. Round the final answer to 2 decimal places.) Interest paid $ How much total interest is paid over the life of the loan? (Do not round intermediate calculations. Round the final answer to 2 decimal places.) Total interest $
What are the repayment schedules for each of the following five-year, 9 percent $11,000 term loans? Use Appendix D to answer the questions. Do not leave any cells blank. If the answer is zero, enter "0". Do not round intermediate calculations. A. Equal annual payments that amortize (retire) the principal and pay the interest owed on the declining balance. Round your answers to the nearest cent. Balance Interest Principal Year payment repayment on loan $ $ $ $ $ 1 2 3 4 5 $ $ $ $ $ Interest Principal Balance Year payment repayment on loan 1 $ $ 2 is B. Equal annual principal repayment, with interest calculated on the remaining balance owned. Round your answers to the nearest dollar. $ $ 3 $ $ $ 4 5 es $ $ $ $ $ $ $ $ $ $ $ $ $
Manual solving. No excel A loan of amount 10,000 at a nominal annual interest rate of 12% compounded monthly is repaid by 6 monthly payments, starting one month after the loan is made. The first three payments are amount X each and the final three payments are amount 2X each. Construct the amortization schedule forthis loan.
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
Please answer with explanation Thank you so much
Find the amortization table for a $8,000 loan amortized in five annual payments if the interest rate is 4.3% per year compounded annually. (Round your answers to the nearest cent.) End ofPeriod RepaymentMade InterestCharged PaymentTowardPrincipal Outstanding principle 0 8,000 1 2 3 4 5
3. Complete an amortization schedule for a $38,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 7% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Balance $ % Interest Year 1 2 3 ɔ. What percentage of the payment represents interest and what percentage represents principal for each of the 3 years? Do not round intermediate calculations. Round your answers to two decimal places. % Principal Payment $ % % % % Interest $ % Repayment. of Principal $ Year 1: Year 2: Year 3: % Why do these percentages change over time? I. These percentages change over time because even though the total payment is constant the amount of interest paid each year is declining as the remaining or outstanding balance declines. Remaining Balance $ II. These percentages change over time because even though the total payment is constant the amount of interest paid…
Prepare an amortization schedule for a three-year loan of $117,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? Note: Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Year 1 2 3 $ Beginning Balance 117,000.00 Total Payment Total interest Interest Payment Principal Payment Ending Balance
A partially amortizing loan for $92,000 for 10 years is made at 6 percent interest. The lender and borrower agree that payments will be monthly and that a balance of $20,000 will remain and be repaid at the end of year 10. Required: a. Assuming 4 points are charged by the lender, what will be the yield if the loan is repaid at the end of year 10? b. What must the loan balance be if it is repaid after year 4? c. What will be the yield to the lender if the loan is repaid at the end of year 4? Note: For all requirements, do not round intermediate calculations, round your final answers to 2 decimal places.
The interest rate on a $15,300 loan is 9.7% compounded semiannually. Semiannual payments will pay off the loan in nine years. (Do not round intermediate calculations. Round the PMT and final answers to 2 decimal places.) a. Calculate the interest component of Payment 12. $ b. Calculate the principal component of Payment 5. Principal c. Calculate the interest paid in Year 8. Interest paid d. How much do Payments 5 to 8 inclusive reduce the principal balance? Principal reduction Interest

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