finance

posted by .

John borrows $150,000. The terms of the loan are 7.5% over the next 5 years. It is important to note that he makes annual rather than monthly payments.



Construct a loan amortization schedule that shows the 5 payments of John's loan.

  • finance -

    hard to show charts on here, since columns don't line up.

    First you have to find the payment, solve for x

    150000 = x(1 - 1.075^-5)/.075
    (I got 37 074.71 )

    make a table with headings
    Time -- payment --interest --- repayment -- balance
    1 -- 37074.71 -- 11250 --- 25824.71 --- 124175.29
    2 --- 37074.71 --9313.15 -- 27761.56 -- 96413.73
    .....

    (mine came out exactly to the last penny)

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Finance

    Consider the following scenario: John buys a house for $150,000 and takes out a five year adjustable rate mortgage with a beginning rate of 6%. He makes annual payments rather than monthly payments. Unfortunately for John, interest …
  2. Finance

    Consider the following scenario: John buys a house for $150,000 and takes out a five year adjustable rate mortgage with a beginning rate of 6%. He makes annual payments rather than monthly payments. Unfortunately for John, interest …
  3. accounting

    John borrows $150,000. The terms of the loan are 7.5% over the next 5 years. It is important to note that he makes annual rather than monthly payments. Construct a loan amortization schedule that shows the 5 payments of John's loan. …
  4. college math

    loverdale-Nurseries obtained a $60,000 loan at 7.5% compounded monthly to build an additional greenhouse. Construct a partial amortization schedule for payments of $1000 per month (except for a smaller final payment)showing details …
  5. Maths

    Firm has a $500,000 loan with 9% APR (compounded monthly) Loan is 5-yr based on a 15-yr amortization, meaning loan payments will be calculated as if you take 15 years to pay off the loan, but actually must do so in 5 yr. To do this, …
  6. Finance

    You have arranged for a loan on your new car that will require the first payment today. The loan is for $32,000, and the monthly payments are $620. Required: If the loan will be paid off over the next 60 months, what is the APR of …
  7. Finance - Loans problem please help

    A company borrows $170000, which will be paid back to the lender in one payment at the end of 5 years. The company agrees to pay monthly interest payments at the nominal annual rate of 7% compounded monthly. At the same time the company …
  8. Please Help me with a Finance - Loan problem

    A company borrows $170000, which will be paid back to the lender in one payment at the end of 5 years. The company agrees to pay monthly interest payments at the nominal annual rate of 7% compounded monthly. At the same time the company …
  9. hospitality

    Tanya is trying to prepare her loan amortization schedule for the renovation of her bed-and-breakfast facility. Her banker is quoting her an interest rate of 12% for four years. The loan amount of $25,000. Prepare the loan amortization …
  10. Corporate Finance

    You have just taken a 30-year mortgage loan for $200,000. The annual percentage rate on the loan is 8%, and payments will be made monthly. Estimate your monthly payments.

More Similar Questions