Question

In: Finance

You are planning on taking a loan for $ 49 ,000. You will repay the loan...

You are planning on taking a loan for $ 49 ,000. You will repay the loan in annual payments over the next 7 years and the loan has a stated interest rate of 6 %. For the very last payment on your loan, how much of this is repayment of principal? For example, if the loan payment is $400 of which $30 is interest and $370 is principal, your answer is $370. Enter your answer to the nearest $.01. Do not use $ or , signs in your answer. Enter your answer as a positive number.

Solutions

Expert Solution

Step-1:Calculation of Monthly Payment
Annual Payment = Loan Amount/ Present Value of annuity of 1
= $       49,000 / 5.5823814
= $   8,777.62
Working:
Present Value of annuity of 1 = (1-(1+i)^-n)/i Where,
= (1-(1+0.06)^-7)/0.06 i 6%
= 5.5823814 n 7
Step-2:Preparation of Loan Amortization Schedule
Year Beginning Loan amount Interest Expense Annual Payment Reduction in Principal Ending Loan Balance
1 $ 49,000.00 $ 2,940.00 $ 8,777.62 $ 5,837.62 $ 43,162.38
2 $ 43,162.38 $ 2,589.74 $ 8,777.62 $ 6,187.87 $ 36,974.51
3 $ 36,974.51 $ 2,218.47 $ 8,777.62 $ 6,559.15 $ 30,415.37
4 $ 30,415.37 $ 1,824.92 $ 8,777.62 $ 6,952.69 $ 23,462.67
5 $ 23,462.67 $ 1,407.76 $ 8,777.62 $ 7,369.86 $ 16,092.82
6 $ 16,092.82 $     965.57 $ 8,777.62 $ 7,812.05 $   8,280.77
7 $   8,280.77 $     496.85 $ 8,777.62 $ 8,280.77 $            0.00
Thus,
Repayment of Last payment in the form of Principal $ 8,280.77

Related Solutions

You are planning on taking a loan for $ 49 ,000. You will repay the loan...
You are planning on taking a loan for $ 49 ,000. You will repay the loan in annual payments over the next 7 years and the loan has a stated interest rate of 6 %. For the very last payment on your loan, how much of this is repayment of principal? For example, if the loan payment is $400 of which $30 is interest and $370 is principal, your answer is $370. Enter your answer to the nearest $.01. Do...
You are planning to borrow OMR 3,500. You can repay the loan in 40 monthly payments...
You are planning to borrow OMR 3,500. You can repay the loan in 40 monthly payments of OMR 103.25 each or 36 monthly payments of OMR 112.94 each. You decide to take the 40-month loan. During each of the first 36 months you make the loan payment and place the difference between the two payments (OMR 9.69) into an investment account earning 10% APR. Beginning with the 37th payment you will withdraw money from the investment account to make your...
If you borrow a principal amount of $11,778 and are required to repay the loan in...
If you borrow a principal amount of $11,778 and are required to repay the loan in ten equal installments of $2,000, what is the interest rate associated with the loan?
Thinking of a trip that you or someone you know, is planning on taking. In planning...
Thinking of a trip that you or someone you know, is planning on taking. In planning a budget for the trip, what types of costs should be included in the budget? List at least five costs. Classify the costs as either fixed or variable, explaining what the variable cost drivers are.
You are contemplating taking a loan to expand your business. If the loan is approved, you...
You are contemplating taking a loan to expand your business. If the loan is approved, you could increase your profit by $6,000 per month, so you do not wish to pay more than that amount in monthly loan payments. The amount you would need to borrow to implement this expansion is $300,000. The bank is offering an interest rate of 4.25% per year. What is the shortest loan duration you would accept?
You are looking to take out a ​$53 ​,000 loan to pay for school. The loan...
You are looking to take out a ​$53 ​,000 loan to pay for school. The loan would be a​ five-year loan. The lender offers you a 8 ​% interest rate on the loan and also offers to structure it in one of three​ ways: ​a) As a discount loan ​b) As an​ interest-only loan ​c) As an amortized loan. Rounded to the nearest whole​ dollar, what will be your balance at the end of year 1 if you take the...
If you borrowed $30,000 at 25% annual interest. You agreed to repay the loan with five...
If you borrowed $30,000 at 25% annual interest. You agreed to repay the loan with five equal annual payments. How much of the total amount repaid is interest? How much of the third annual payment is interest, and how much principal is there? If you decided to pay off your loan after the third payment, how much will you pay? please i want the result step by step by hand not using excel! thanks in advance
If you borrowed 24000 at 6% annual interest. You agreed to repay the loan with five...
If you borrowed 24000 at 6% annual interest. You agreed to repay the loan with five equal annual payments. How much of the total amount repaid is interest? How much of the third annual payment is interest, and how much principal is there? If you decided to pay off your loan after the third payment, how much will you pay?
You have just borrowed $300,000 to buy a condo. You will repay the loan in equal...
You have just borrowed $300,000 to buy a condo. You will repay the loan in equal monthly payments of $3,950.37 over the next 20 years. a-1. What monthly interest rate are you paying on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) a-2. What is the APR? (Do not round intermediate calculations. Enter your answer as a whole percent.) b. What is the effective annual rate on that loan? (Do...
You have just borrowed $160,000 to buy a condo. You will repay the loan in equal...
You have just borrowed $160,000 to buy a condo. You will repay the loan in equal monthly payments of $1,287.40 over the next 30 years. a-1. What monthly interest rate are you paying on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) a-2. What is the APR? (Do not round intermediate calculations. Enter your answer as a whole percent.) b. What is the effective annual rate on that loan? (Do...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT