Question

In: Finance

Assume you take out a loan that you will make payments, once per year, for four...

Assume you take out a loan that you will make payments, once per year, for four years. Complete the table assuming the loan is for $10,000 and the interest rate on the loan is 4.25%.

Year

Beginning Balance

Total Payment

Interest Paid

Principal Paid

Ending Balance

1

2

3

4


Solutions

Expert Solution

Year Beginning Balance Total Payment Interest Paid Principal Paid Ending Balance
1 $          10,000.00 $         2,771.15 $         425.00 $        2,346.15 $           7,653.85
2 $ 7,653.85 $         2,771.15 $         325.29 $        2,445.86 $           5,207.99
3 $ 5,207.99 $         2,771.15 $         221.34 $        2,549.81 $           2,658.18
4 $ 2,658.18 $         2,771.15 $         112.97 $        2,658.18 $ -0.00
working:
Annual payment = Loan Amount/Present Value of annuity of 1
= $           10,000 /    3.60861
= $        2,771.15
Present Value of annuity of 1 = (1-(1+i)^-n)/i Where,
= (1-(1+0.0425)^-4)/0.0425 i      0.0425
=             3.60861 n 4

Related Solutions

1. You take out a $20,000, ten-year loan. Equal payments are to be made at the...
1. You take out a $20,000, ten-year loan. Equal payments are to be made at the end of each year at an interest rate of 10%. Calculate the appropriate loan table, showing the breakdown in each year between principal and interest. Cost 20,000 Payment $3,254.91 Interest 10% Years 10 Division of payment between: Year Principal at beginning of year Payment at end of year Interest Principal 1 2 3 4 5 6 7 8 9 10 0.00
You take out a loan for 10000. You pay off the loan with monthly payments of...
You take out a loan for 10000. You pay off the loan with monthly payments of 90 for 10 years. (a) What is the monthly effective rate? What is the annual effective rate? (b) What is the outstanding loan balance immediately after the 7th payment? Calculate using both the retrospective and prospective formulas. (c) Assume you miss the 13th and 53rd payments, what will be the outstanding loan balance after the 71st payment? actuarial science
You take out a 15-year $335,000 mortgage loan with a rate of 6% and annual payments....
You take out a 15-year $335,000 mortgage loan with a rate of 6% and annual payments. In 6 years you decide to pay off the mortgage. What is the principal balance on the loan after 6 years?
Assume you want to take out a $300,000 loan on a 25-year mortgage with end of...
Assume you want to take out a $300,000 loan on a 25-year mortgage with end of month payments. The annual rate of interest is 8 percent. 20 years from now, you need to make an ending additional lump sum payment of $45,000. Because you expect your income to increase, you want to structure the loan so that the beginning of each year your monthly payments increase by 2.5 percent. Determine the amount of each year’s monthly payment with Excel Solver.
You are taking out a $25,000 loan for a new car. You will make monthly payments...
You are taking out a $25,000 loan for a new car. You will make monthly payments for 5 years. You are given the choice between putting nothing down and a 7% APR OR putting $5000 down and a 5% APR. Which do you choose?
You go to the cash palace and take out a payday loan. you borrow 1500.00 and will make 25 total payments of 109.41 one every other week for a year
You go to the cash palace and take out a payday loan. you borrow 1500.00 and will make 25 total payments of 109.41 one every other week for a year. what is the effective annual rate of interest on this loan?
A business will take out a 10-year loan of $150,000. The interest rate is 10% per...
A business will take out a 10-year loan of $150,000. The interest rate is 10% per year and the loan calls for a $15,000 reduction in principal each year. What is the total payment in year 3? Please show work by using appropriate formulas. Thank you.
Anna decides to take out a four-year loan for $30,000 to purchase a new car. Her...
Anna decides to take out a four-year loan for $30,000 to purchase a new car. Her loan officer tells her that she will make equal, monthly payments for the loan at an interest rate of 8 percent per year. How much, in total, did Anna pay in interest over the course of the loan?
Anna decides to take out a four-year loan for $30,000 to purchase a new car. Her...
Anna decides to take out a four-year loan for $30,000 to purchase a new car. Her loan officer tells her that she will make equal, monthly payments for the loan at an interest rate of 8 percent per year. What will the balance of the loan be after 2 years of making payments?
You take out a $9,000 car loan that calls for 36 monthly payments starting after 1...
You take out a $9,000 car loan that calls for 36 monthly payments starting after 1 month at an APR of 9%. a. What is your monthly payment? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. What is the effective annual interest rate on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) c. Now assume the payments are made in four annual year-end installments. What...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT