Question

Crab State Bank has offered you a $1,250,000 5-year loan at an interest rate of 10.25...

Crab State Bank has offered you a $1,250,000 5-year loan at an interest rate of 10.25 percent, requiring equal annual end-of-year payments that include both principal and interest on the unpaid balance. Develop an amortization schedule for this loan. Round your answers to the nearest dollar. End of Year Payment Interest (10.25%) Principal Reduction Balance Remaining 0 $1,250,000 1 $ $ $ 2 3 4 5

can you explain the steps please.

Homework Answers

Answer #1

First of all lets find installment amount

Installment = Loan amount/PVIFA(r%,n)

here r = rate of interest = 10.25%

n = no. of years = 5 years

PVIF(YTM%,n)
PVIFA(YTM%,n) = [1-(1/(1+r)^n / r ]
PVIFA(15%,10) = [1-(1/(1+10.25%)^5 / 10.25%]
=[1-(1/(1+0.1025)^5 / 0.1025]
=[1-(1/(1.1025)^5 / 0.1025]
=[1-0.6139 / 0.1025]
=0.3861/0.1025
=3.7667
Thus Installment = 1250000/3.7667
= 3,31,855.47$

Amortization schedule

Towards
Year Opening balance Installment Interest @ 10.25% Principal Closing balance
A B C = A x 10.25% D = B-C E = A- D
1 1250000 331855 128125 203730 1046270
2 1046270 331855 107243 224613 821657
3 821657 331855 84220 247636 574021
4 574021 331855 58837 273018 301003
5 301003 331855 30853 301003 0
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
Crab State Bank has offered you a $1,250,000 5-year loan at an interest rate of 10.25...
Crab State Bank has offered you a $1,250,000 5-year loan at an interest rate of 10.25 percent, requiring equal annual end-of-year payments that include both principal and interest on the unpaid balance. Develop an amortization schedule for this loan. Round your answers to the nearest dollar. End of Year Payment Interest (10.25%) Principal Reduction Balance Remaining    0       $1,250,000 1 $ $ $ 2 3 4 5
You receive a 4-year $11,000 negative amortization loan with an interest rate of 5% p.a., to...
You receive a 4-year $11,000 negative amortization loan with an interest rate of 5% p.a., to be repaid in four annual installments. The loan requires that you make total payments of $300 at t = 1, $400 at t = 2, and $300 at t = 3, with the remaining loan balance paid at maturity. What is the total payment amount at t = 4, rounded to the nearest dollar?
Prepare an amortization schedule for a three-year loan of $75,000. The interest rate is 8 percent...
Prepare an amortization schedule for a three-year loan of $75,000. The interest rate is 8 percent per year, and the loan agreement calls for a principal reduction of $25,000 every year. How much total interest is paid over the life of the loan? (Enter rounded answers as directed, but do not use rounded numbers in intermediate calculations. Leave no cells blank. You must enter '0' for the answer to grade correctly.) Year Beginning Balance Total Payment Interest Payment Principal Payment...
You company has just purchased some new computers using a 5-year bank loan of $54,000. The...
You company has just purchased some new computers using a 5-year bank loan of $54,000. The interest rate on the loan is 9 percent annually, and the loan calls for equal annual payments. Prepare an amortization schedule for the 5-year loan. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Leave no cells blank - be certain to enter "0" wherever required.)    Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance...
1. European Designs, Inc. has negotiated a commercial loan with TLC Bank. The terms are that...
1. European Designs, Inc. has negotiated a commercial loan with TLC Bank. The terms are that the company will borrow $210,000 for three years at 6.75% interest with level total payments. Do an amortization schedule for the loan and answer the following questions: Amount of the interest payment in year one ________________ Amount of the principal payment in year two _______________ Amount of the total payment in year three _________________ Balance of the loan at the end of year two...
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...
Prepare an amortization schedule for a seven year loan of $90,000. The interest rate is 4%...
Prepare an amortization schedule for a seven year loan of $90,000. The interest rate is 4% per year, and the loan calls for equal annual payments (see example in book, do not use the monthly amortization schedule from Canvas). Using the information from the amortization schedule (which you must include with your answers), please answer the following questions. A. How much total interest is paid over the life of the loan? B. How much interest will be paid during the...
Construct an amortization schedule for a $20,000, 3.45% annual rate loan with 3 equal payments.  Please complete...
Construct an amortization schedule for a $20,000, 3.45% annual rate loan with 3 equal payments.  Please complete the schedule below as you see fit. Year          Beg. Balance        Payment           Interest             Principal           End Balance
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $35,000...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $35,000 for 1 year at 12% compounded quarterly Period Payment Interest Balance Reduction Unpaid Balance $35,000 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ $
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $35,000...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $35,000 for 1 year at 12% compounded quarterly Period Payment Interest Balance Reduction Unpaid Balance $35,000 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ $
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT