Theory of Interest: Sally takes out a $7,000 loan which requires 60 equal monthly payments starting at the end of the first month. The nominal annual interest rate is 8% convertible monthly. She arranges to make no payments for the first five months and then make the same payments she would have made plus an extra payment at the end of the 60th month. How much will this balloon payment be? Answer: $1,178.41. If you are using Excel worksheets, please tell what formulas are you using to solve the problem.
EMI = [P x R x (1+R)^N]/[(1+R)^N-1] | ||||||
Where, | ||||||
EMI= Equal Monthly Payment | ||||||
P= Loan Amount | ||||||
R= Interest rate per period (8%/12) | ||||||
N= Number of periods | ||||||
= [ $7000x0.007 x (1+0.007)^60]/[(1+0.0067)^60 -1] | ||||||
= [ $46.66662( 1.007 )^60] / [(1.007 )^60 -1 | ||||||
=$141.9347 | ||||||
The monthly payment would be = $141.9347 | ||||||
The first five month payment have been deferred till 60th payment hence we need to calculate | ||||||
future value of fisrt five months payment | ||||||
Month | Calculation | Future Value | ||||
1 | =$141.9347*(1.00667)^59 | $ 210.10 | ||||
2 | =$141.9347*(1.00667)^58 | $ 208.71 | ||||
3 | =$141.9347*(1.00667)^57 | $ 207.33 | ||||
4 | =$141.9347*(1.00667)^56 | $ 205.95 | ||||
5 | =$141.9347*(1.00667)^555 | $ 204.59 | ||||
Total | $ 1,036.68 | |||||
Ballon of payment = Deferred payment + 60th month's payment | ||||||
=$1036.68+141.93 | ||||||
=$1178.41 | ||||||
Kindly give a positive rating if you are satisfied with this solution and please ask if you have any queries. | ||||||
Theory of Interest: Sally takes out a $7,000 loan which requires 60 equal monthly payments starting...
A fifteen-year adjustable-rate mortgage of $117,134.80 is being repaid with monthly payments of $988.45 based upon a nominal interest rate of 6% convertible monthly. Immediately after the 60th payment, the interest rate is increased to a nominal interest rate of 7.5% convertible monthly. The monthly payments remain at $988.45, and there will be an additional balloon payment at the end of the fifteen years to pay the outstanding loan balance. (a) Calculate the loan balance immediately after the 84th payment....
3. A $300,000 home loan is amortized by equal monthly payments for 25 years, starting one month from the time of the loan at a nominal rate of 7% convertible monthly. a. Find the monthly payment amount. b. Find the outstanding balance when 10 years of payments remain. c. Find the total interest paid during the last 10 years of the loan? 4. Eddie is repaying a 20-year loan of 10,000 with payments at the end of each year. Each...
Suppose that a loan is being repaid with 60 equal monthly payments, the first coming a month after the loan is made. If the rate of interest is 7.5 percent convertible monthly, and the amount of principal in the 22nd payment is 210, how much interest is in the 44th payment?
Marsha takes out a loan for 20,000. She is to repay the loan by level monthly payments of 1500 with the final payment possibly being less than the previous payments. The nominal interest rate is 12% convertible monthly. Let n be the number of payments and X be the amount of the final payment. (a) Determine n. (b) Determine X
Chrome Co. borrows $1,665,000 at an interest rate of 7.32% APR monthly with equal monthly payments of $15,265 and a 4 year stop. a) What is the loan balance at the end of month 36? b)What is the balloon payment due, after the regular monthly payment, at the end of year 4? Please show work
Theory of Interest: The sale price of the car you wanted to buy is $25,456, but you decided to buy the car for a deal of 60 monthly payments of $559 each month. After a year, you decide it's time for some new wheels. You return to the dealer and want to trade in your car for a new model. The dealer offers you a trade-in value of $20,000. How much of a down payment will you be able to...
A person takes out a loan for $25000. The payback schedule is monthly payments for 4 years at 5% nominal annual interest compounded monthly. What is the monthly payment for this loan?
A homebuyer borrows 400,000 to be repaid over a 20 year period with level monthly payments beginning one month after the loan is made. The interest rate on the loan is a nominal annual rate of 12% convertible monthly. Find using mathematical formulas: a. the total principal paid on the loan over the first 15 years b. the total interest paid on the loan over the first 15 years
Erik receives an eight year annuity immediate with monthly payments. The first payment is $300 and the payments increase by $6 each month. The payments are deposited in an account earning interest at a nominal rate of 6% convertible monthly. What is the balance in the account at the end of eight years? Answer is 69,042.81 Do it without excel!!!
Vanna has just financed the purchase of a home for $200 000. She agreed to repay the loan by making equal monthly blended payments of $3000 each at 4%/a, compounded monthly. a. Create an amortization table using a Microsoft Excel spreadsheet. In your answer include all the formulas used.b.How long will it take to repay the loan?c. How much will be the final payment?d. Determine how much interest she will pay for her loan.e. Use Microsoft Excel to graph the amortization...