accounting
posted by sweet .
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.
EXCEL TEMPLATE

Here are some tutorials for Excel Template:
http://search.yahoo.com/search?fr=mcafee&p=excel+template+tutorial
Sra
Respond to this Question
Similar Questions

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 … 
finance
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
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 … 
college math
loverdaleNurseries 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 … 
Math
Stillwater hospital is borrowing $1,000,000 for its medical office building. The annual interest rate is 5 percent. What will be the equal annual payments on the loan if the length of the loan is four years and payments occurs at the … 
Maths
Firm has a $500,000 loan with 9% APR (compounded monthly) Loan is 5yr based on a 15yr 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, … 
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 … 
Accounting
On January 1, you will purchase a new car. The automobile dealer will allow you to make increasing annual December 31 payments over the following four years. The amounts of these payments are $4,000: $4,500: $5,000: $6,000. On the … 
Math
Suppose you borrowed $25,000 for a car at an APR of 8%, which you are paying off with monthly payments of $510 for 5 years. a) Whatâ€™s the loan principal? 
Corporate Finance
You have just taken a 30year mortgage loan for $200,000. The annual percentage rate on the loan is 8%, and payments will be made monthly. Estimate your monthly payments.