Question

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

Crab State Bank has offered you a $500,000 5-year loan at an interest rate of 9.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. Do not round intermediate calculations.

End of Year Payment Interest (9.25%) Principal Reduction Balance Remaining
0 - - - $500,000
1 $   $   $       
2                    
3                    
4                    
5                    
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Year Opening Balance Installment Closing balance
total Interest capital
1    500,000.00    129,381.14    46,250.00      83,131.14     416,868.86
2    416,868.86    129,381.14    38,560.37      90,820.77     326,048.09
3    326,048.09    129,381.14    30,159.45      99,221.69     226,826.40
4    226,826.40    129,381.14    20,981.44    108,399.70     118,426.70
5    118,426.70    129,381.17    10,954.47    118,426.70                      -  
Calculation of installement amount
PV = $ 500,000.00
n = 5 years
r = 9.25%
P = ?
PV = P((1-(1+r)^-n)/r)
   500,000.00 = P((1-(1+.0925)^-5)/r)
P = 129,381.17
Add a comment
Know the answer?
Add Answer to:
Crab State Bank has offered you a $500,000 5-year loan at an interest rate of 9.25...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. Mr Jones bought a building for $60,000, payable on the following terms: a $10,000 down...

    1. Mr Jones bought a building for $60,000, payable on the following terms: a $10,000 down payment and 25 equal annual payments to include principal and interest of 10 percent per annum. Calculate the amount of the installment payments. How much of the first year's payment goes toward reducing the principal amount? 2. Crab the State Bank has offered you a $1,00,000 five- year loan at an interest of 11.25 percent, requiring equal annual end-of-year payments that include both principal...

  • Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of...

    Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual end-of-year payments Calculate the annual end of year loan payment b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a. The amount of the...

  • 2) You have received a 3-year $10,000 loan from your bank. This is an amortized loan...

    2) You have received a 3-year $10,000 loan from your bank. This is an amortized loan which means you have to make 3 equal annual payments to the bank. The bank is charging you 12% APR (annual percentage rate) for this loan. a. Complete the following amortization schedule. (25 points) Amortization schedule Beginning Balance Annual Payment Interest Balance Reduction year End Balance Expense $10,000 $0.00 How much in total you end up paying back to the bank? (5 points) Assume...

  • Prepare an amortization schedule for a three-year loan of $15,000. The interest rate is 10 percent...

    Prepare an amortization schedule for a three-year loan of $15,000. The interest rate is 10 percent per year and the loan calls for equal annual end-of-year payments (Enter rounded answers as directed, but do not use rounded numbers in intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16). Leave no cells blank. You must enter '0' for the answer to grade correctly) Beginning Balance Total Interest Principal Payment Ending Balance Year Payment Payment 1 S 2 3

  • 32. Partial amortization schedule for mortgages. Margie Rogers secures a mortgage loan of $112,000 from Hanover...

    32. Partial amortization schedule for mortgages. Margie Rogers secures a mortgage loan of $112,000 from Hanover National Bank. The terms of the mortgage require monthly payments of $802.40 for 20 years. The interest rate to be applied to the unpaid balance is 6% per year compounded monthly. Prepare an amortization schedule showing payments, interest reduction in principal and remaining balance for the first six months of the loan.  SEGMENT 3: Other Topics

  • A thirty year monthly payment mortgage loan for 500,000 is offered at a nominal rate of 8.4% convertible monthly. Find...

    A thirty year monthly payment mortgage loan for 500,000 is offered at a nominal rate of 8.4% convertible monthly. Find the a) monthly payment, b) the total principal and interest that would be paid on the loan over 30 years c) the balance in 5 years and d) the principal and interest paid over the first 5 years.

  • Consider this incomplete amortization schedule for a five-year loan of $71,500. The interest rate (r) is...

    Consider this incomplete amortization schedule for a five-year loan of $71,500. The interest rate (r) is 7 percent compounded annually, and the loan calls for equal annual payments at the end of each year, starting with year 1. Answer all of the following questions based on this information. Quantity Year 0 ye 1 2 3 4 5 BOP Balance NA Loan Payment NA Interest portion NA Amortization NA EOP Balance $71,500 What is the BOP balance in year 2? (Do...

  • repare an amortization schedule for a five-year loan of $45,000. The interest rate is 8% per...

    repare an amortization schedule for a five-year loan of $45,000. The interest rate is 8% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $ $ $ $ $ 2 3 4 5 How much interest...

  • Prepare an amortization schedule for a five-year loan of $33,000. The interest rate is 9% per...

    Prepare an amortization schedule for a five-year loan of $33,000. The interest rate is 9% per year, and the loan calls for equal annual payments. (Do not round intermediate calculations. Enter all amount as positive value. Round the final answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) Beginning Balance $ Total Payment $ Interest Payment $ Principal Payment $ Year Ending Balance $ 2 3 4 5 How much interest is...

  • The following instalment payment schedule is for a long-term bank loan payable: Reduction of Interest Cash...

    The following instalment payment schedule is for a long-term bank loan payable: Reduction of Interest Cash Payment Principal Interest Period Principal Balance Expense $79,000.00 Issue date $4,740.00 $18,754.32 $14,014.32 64,985.68 1 2 18,754.32 3,899.14 14,855.18 50,130.50 15,746.49 3 18,754.32 3,007.83 34,384.01 4 18,754.32 2,063.04 16,691.28 17,692.73 5 18,754.32 1,061.59 17,692.73 0.00 Is the above schedule a fixed principal plus interest or blended principal and interest payment schedule? LINK TO TEXT Assuming payments are made annually, what is the interest rate...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT