Question

Given the following terms a loan amount of $1,200,000; annual rate of 5.33%; a 5 year...

Given the following terms a loan amount of $1,200,000; annual rate of 5.33%; a 5 year term with a future payoff balance of $60,000. Determine what's your a. monthly payment, b. interest portion of your payment in month 5, and c. principal payments paid in year 3

Homework Answers

Answer #1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Excel assignment Loan amount $ 67,500 Interest rate 7% Loan term 5 Complete the following analysis....
Excel assignment Loan amount $ 67,500 Interest rate 7% Loan term 5 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Loan payment:..................... year- beginning balance- total payment- interest paid- principal paid- ending balance 1 2 3 4 5 Total interest paid.................
Loan Amortization GIVEN: A $12,000 4-year loan at 5%. FIND for each year: a. Annual loan...
Loan Amortization GIVEN: A $12,000 4-year loan at 5%. FIND for each year: a. Annual loan payment b. Beginning-of-year balance .c. Annual interest d. Annual principal e. End-of-year balance
You take out a 20-year loan in the amount of $450,000 at a 4 percent annual...
You take out a 20-year loan in the amount of $450,000 at a 4 percent annual rate. The loan is to be paid off by equal monthly installments over 20 years. Draw an amortization table showing the beginning balance, total payment, principal repayment, interest payment and ending balance for each month. How much is the total interest payment for the first four months? (show only four months on the table).
5. Consider a loan with the following terms for an ARM: Loan Amount = $150,000 Starting...
5. Consider a loan with the following terms for an ARM: Loan Amount = $150,000 Starting Rate = 5% Term = 30 Years Adjustment Interval = 1 Year Payment Cap = 6% What is the initial monthly payment? What is the loan balance at the end of year 1? Suppose the new composite rate at the beginning of year 2 is 8%. What is the new monthly payment at the beginning of year 2? HINT: read the above information carefully
you are borrowing 200,000 for an amortized loan with terms that include annual payments, 5 year...
you are borrowing 200,000 for an amortized loan with terms that include annual payments, 5 year loan, and interest rate of 7.5 per year. How much of the first year's payment would be applied toward reducing the principal
Please create a Variable Interest Rate Loan Amortization schedule with the columns: Year, Amount owed on...
Please create a Variable Interest Rate Loan Amortization schedule with the columns: Year, Amount owed on the principal at the beginning of the year, Annuity payment, Interest portion of the annuity, Repayment of the principal portion of the annuity, outstanding loan balance at year end For the following: You obtain a $6,000 loan from a furniture dealer at a variable interest rate. The loan payments is adjusted every year based on the annuity amount implied by interest rate of year...
A 10-year loan in the amount of $527,000 is to be repaid in equal annual payments....
A 10-year loan in the amount of $527,000 is to be repaid in equal annual payments. What is the remaining principal balance after the sixth payment if the interest rate is 5 percent, compounded annually? Show work.
Loan payments and interest: Schuyler Company wishes to purchase an asset costing ​$116,000. The full amount...
Loan payments and interest: Schuyler Company wishes to purchase an asset costing ​$116,000. The full amount needed to finance the asset can be borrowed at 14.2 % interest. The terms of the loan require equal​ end-of-year payments for the next 6 years. Determine the total annual loan​ payment, and break it into the amount of interest and the amount of principal paid for each year.   ​(​Hint:Use the techniques presented in Chapter 5 to find the loan​ payment.) The amount of...
Assume the following information for a home mortgage: Original loan amount = $250,000 Annual interest rate...
Assume the following information for a home mortgage: Original loan amount = $250,000 Annual interest rate = 7.35% Term of loan = 10 years For year two, how much interest and principal was paid, and what is the balance due at the end of year two? using financial calculator. answer: $18,922.69 of principal; $16,453.43 of interest; balance due $213,491.61
An amortization table reports the amount of interest and principal contained within each regularly scheduled payment...
An amortization table reports the amount of interest and principal contained within each regularly scheduled payment used to repay an amortized loan. Example Amortization Schedule Year Beginning Amount Payment Interest Repayment of Principal Ending Balance 1 2 3 Consider the amount of the interest payments included in each of the payments of an amortized loan. Which of the following statements regarding the pattern of the interest payments is true? The portion of the payment going toward interest is smaller in...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT