1. Loan Amortization Schedule (P/Y = C/Y)Details:RBC has provided a $50,000 loan to Capilano Custom Cabinets Inc. at an interest rate of 6% compoundedmonthly. The loan is to be paid back in equal payments at the end of each month over an 18-month term.I/Y5.5%Pmt #P/Y12PaymentTotal Interest paid on loanC/Y12N18Interest PortionPVPMTPrincipal PortionFVPrincipal Balance

We have to find the monthly mortgage payment amount and prepare the loan amortization schedule. We…

Answered: 1. Loan Amortization Schedule (P/Y =…

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

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 $
Take a look at the chart pls..
Amortizing Loan Consider a 4-year amortizing loan. You borrow $351,000 initially, and repay it in four equal annual year-end payments. a. If the interest rate is 4.55%, calculate the annual payment. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Annual payment b. Prepare an amortization schedule. (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.) Time 0 Loan Balance Year-End Interest Due on Balance Year-End Payment Amortization of Loan $ $ $ $ 1234
Answer in typing
A loan of $25,000 at an annual rate of 14% is repayable through 5 annual year-end payments. The annual payment amount is close to: Answer A. $7,282 B. $5,000 C. $3,500 D. $8156
Develop an amortization schedule for the loan described. (All answers should be entered in dollars. Round your answers to the nearest cent.) 1 $90,000 for 2 years at 12% compounded semiannually Period 1 2 3 4 5 $ $ $ $ $ Payment $ $ $ $ $ Interest Balance Reduction $ $ $ $ $ Unpaid Balance $90,000 $ $ $ $ $0.00
The buyer of a piece of real estate is often given the option of buying down the loan. This option gives the buyer a choice of loan terms in which various combinations of interest rates and discount points are offered. The choice of how many points and what rate is optimal is often a matter of how long the buyer intends to keep the property. Darrell Frye is planning to buy an office building at a cost of $987,000. He must pay 10% down and has a choice of financing terms. He can select from a 9% 30-year loan and pay 4 discount points, a 9.25% 30-year loan and pay 3 discount points, or a 9.5% 30-year loan and pay 2 discount points. Darrell expects to hold the building for four years and then sell it. Except for the three rate and discount point combinations, all other costs of purchasing and selling are fixed and identical. (Round your answers to the nearest cent. Use this table, if necessary.) (a) What is the amount being financed? $4 (b) If Darrell chooses the 4-point 9% loan, what…
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…
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
Loan Repayment A loan of $10,000 is to beamortized with quarterly payments over 4 years. Ifthe interest on the loan is 8% per year, paid on theunpaid balance,a. What is the interest rate charged each quarter onthe unpaid balance? b. How many payments are made to repay the loan?c. What payment is required quarterly to amortizethe loan?
NOTETOR THE What payment is required to pay off a $91,000 loan in nine years if the interest rate on the loan is 5.4% compounded Bimonthl not round intermediate calculations and round your final answers to 2 decimal places.) Payment Freq Required payment a. Annually $ b. Semiannually $ c. Quarterly $ d. Monthly $
A company borrows $174,900 from a bank. The interest rate on the loan is 6 percent compounded semiannualy. The company agrees to repay the loan in equal semiannualy installments over the next five years. The first payment is to be made six months from now. (Use factor table in Appendix B for calculation) Required 1: What is the amount of each semiannual payment? $ Required 2: In the first payment, what is the amount of interest cancelled? $ Required 3: In the fifth payment, what is the amount of loan paid net of interest? $ Required 4: In the last payment, what is the amount of interest cancelled? $ Required 5: Assume the debt contract has the option to make one extraordinary payment of up to 20% of the principal. If the company decides to exercise the right and make the extra payment together with the 8th payment, how much it must pay in dollars at the 9th payment to pay off the loan? $

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

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