Question

Loan Amortization Your company is planning to borrow $2.25 million on a 5-year, 8%, annual payment, ly amortize term loan. Wh
Loan Amortization Assume that your aunt sold her house on December 31, and to his close the sale she took a second mortgage i
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer to Question 1:

Amount borrowed = $2,250,000
Number of payments = 5
Annual interest rate = 8%

Let annual payment be $x

$2,250,000 = $x/1.08 + $x/1.08^2 + $x/1.08^3 + $x/1.08^4 + $x/1.08^5
$2,250,000 = $x * (1 - (1/1.08)^5) / 0.08
$2,250,000 = $x * 3.99271
$x = $563,527.02

Annual payment = $563,527.02

First payment:

Beginning loan outstanding = $2,250,000.00

Interest paid = 8% * $2,250,000
Interest paid = $180,000.00

Principal repaid = $563,527.02 - $180,000.00
Principal repaid = $383,527.02

Ending loan outstanding = $2,250,000.00 - $383,527.02
Ending loan outstanding = $1,866,472.98

Second payment:

Beginning loan outstanding = $1,866,472.98

Interest paid = 8% * $1,866,472.98
Interest paid = $149,317.84

Principal repaid = $563,527.02 - $149,317.84
Principal repaid = $414,209.18

Fraction of principal repaid = Principal repaid / Amount paid
Fraction of principal repaid = $414,209.18 / $563,527.02
Fraction of principal repaid = 73.50%

Add a comment
Know the answer?
Add Answer to:
Loan Amortization Your company is planning to borrow $2.25 million on a 5-year, 8%, annual payment,...
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
  • Problem 4-29 Loan Amortization Assume that your aunt sold her house on December 31, and to...

    Problem 4-29 Loan Amortization Assume that your aunt sold her house on December 31, and to help close the sale she took a second mortgage in the amount of $50,000 as part of the payment. The mortgage has a quoted (or nominal) interest rate of 7%, but it calls for payments every 6 months, beginning on June 30, and is to be amortized over 5 years. Now, 1 year later, your aunt must inform the IRS and the person who...

  • O 28-17: Amortized Loans Problem 28-30 Loan Amortization Your company is planning to borrow $2.25 million...

    O 28-17: Amortized Loans Problem 28-30 Loan Amortization Your company is planning to borrow $2.25 million on a 5-year, 12%, annual payment, fully amortized term loan, what fraction of the payment made at the end of the second year will represent repayment of principal? Round your answer to two decimal places. 1%

  • Your company is planning to borrow $0.75 million on a 5-year, 14%, annual payment, fully amortized...

    Your company is planning to borrow $0.75 million on a 5-year, 14%, annual payment, fully amortized term loan. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places. __________% the answer is not .5 92....

  • Your company is planning to borrow $0.75 million on a 5-year, 14%, annual payment, fully amortized...

    Your company is planning to borrow $0.75 million on a 5-year, 14%, annual payment, fully amortized term loan. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places. ________ % screenshot of spreadsheet attached just...

  • Loan amortization Jan sold her house on December 31 and took a $10,000 mortgage as part...

    Loan amortization Jan sold her house on December 31 and took a $10,000 mortgage as part of the payment. The 10-year mortgage has a 10% nominal interest rate, but it calls for semiannual payments beginning next June 30. Next year Jan must report on Schedule B of her IRS Form 1040 the amount of interest that was included in the two payments she received during the year. a. What is the dollar amount of each payment Jan receives? Round your...

  • 22. Problem 5.22 (Loan Amortization) eBook Jan sold her house on December 31 and took a...

    22. Problem 5.22 (Loan Amortization) eBook Jan sold her house on December 31 and took a $15,000 mortgage as part of the payment. The 10-year mortgage has a 7% nominal interest rate, but it calls for semiannual payments beginning next June 30. Next year lan must report on schedule of her IRS Form 1040 the amount of interest that was induded in the two payments she received during the year, a. What is the dollar amount of each payment lan...

  • ​(Loan amortization​) To buy a new house you must borrow $ 140 comma 000$140,000. To do...

    ​(Loan amortization​) To buy a new house you must borrow $ 140 comma 000$140,000. To do this you take out a $ 140 comma 000$140,000​, 3030​-year, 88 percent mortgage. Your mortgage​ payments, which are made at the end of each year​ (one payment each​ year), include both principal and 88 percent interest on the declining balance. How large will your annual payments​ be?

  • 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...

  • Consider a 4-year amortizing loan. You borrow $2,700 initially and repay it in four equal annual...

    Consider a 4-year amortizing loan. You borrow $2,700 initially and repay it in four equal annual year-end payments. a. If the interest rate is 10%, what is the annual payment? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Annual payment b. Prepare an amortization schedule. (Do not round intermediate calculations. Round your answers to 2 decimal places. Leave no cells blank-be certain to enter "O" wherever required.) Year-End Interest DueTotal Year-End Amortization on Loan Balance ($)...

  • 8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be...

    8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal payments at the end of each of the next three years. The lender charges a 6 percent interest rate on the loan balance that is outstanding at the beginning of each year. 1) Calculate the payment the firm must repay each year. 2) Prepare the loan amortization schedule (fill all the numbers in each cell). Beginning Amount Repayment of Remaining...

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