Question

In: Accounting

Assume you have bought a property worth 210,000 $ with a downpayment of $10,000 and Interest...

Assume you have bought a property worth 210,000 $ with a downpayment of $10,000 and Interest rate = 5%, Total number of installments to be made =24, monthly interest rate = 5%/12

How do we calculate all of these payment step by step ?

Mortgage Balance,   Monthly Payment,    Interest Payment, Principal Payment,     Ending Mortgage Balance

Solutions

Expert Solution

Equated Monthly Installment - EMI for short - is the amount payable every month to the bank or any other financial institution until the loan amount is fully paid off. It consists of the interest on loan as well as part of the principal amount to be repaid. The sum of principal amount and interest is divided by the tenure, i.e., number of months, in which the loan has to be repaid. This amount has to be paid monthly. The interest component of the EMI would be larger during the initial months and gradually reduce with each payment. The exact percentage allocated towards payment of the principal depends on the interest rate. Even though your monthly EMI payment won't change, the proportion of principal and interest components will change with time. With each successive payment, you'll pay more towards the principal and less in interest.

Here's the formula to calculate EMI:

where

E is EMI

P is Principal Loan Amount

r is rate of interest calculated on monthly basis. (i.e., r = Rate of Annual interest/12/100. If rate of interest is 10.5% per annum, then r = 10.5/12/100=0.00875)

n is loan term / tenure / duration in number of months

If we apply all the given values,

we get EMI= $8774.28

Month Principal(USD) Interest(USD) Balance(USD)
1 7940.94 833.33 192059.06
2 7974.03 800.25 184085.02
3 8007.26 767.02 176077.77
4 8040.62 733.66 168037.15
5 8074.12 700.15 159963.02
6 8107.77 666.51 151855.26
7 8141.55 632.73 143713.71
8 8175.47 598.81 135538.24
9 8209.54 564.74 127328.70
10 8243.74 530.54 119084.96
11 8278.09 496.19 110806.87
12 8312.58 461.70 102494.29
13 8347.22 427.06 94147.07
14 8382.00 392.28 85765.07
15 8416.92 357.35 77348.15
16 8451.99 322.28 68896.15
17 8487.21 287.07 60408.94
18 8522.57 251.70 51886.37
19 8558.08 216.19 43328.28
20 8593.74 180.53 34734.54
21 8629.55 144.73 26104.99
22 8665.51 108.77 17439.48
23 8701.61 72.66 8737.87
24 8737.87 36.41 0.00

ekkarill92 answered 3 months ago
Next > < Previous

Related Solutions

You opened a brokerage account a year ago. At that time, you bought $10,000 worth of...
You opened a brokerage account a year ago. At that time, you bought $10,000 worth of shares of XYZ stock on margin - you used $5,000 of your own cash and borrowed $5,000 from the brokerage Örm. (a) Right now, XYZ stock is up 6% from a year ago and you decide to get out of your XYZ holdings. Assume the brokerage Örm charges 4% interest on its margin loans, Compute your investmentís holding period return. (b) Would you have...
You have bought a property and have four different options on how to pay for the property purchase. The four options are:
                     Part a. You have bought a property and have four different options on how to pay for the property purchase. The four options are: $ 200,000 p.a. paid every year for five years with the first payment paid at the end of the first year. $250,000 p.a. for six years with the first payment paid at the end of the first year. $1,000,000 at the end of the fifth year...
Lance contributed investment property worth $512,500, purchased Five years ago for $210,000 cash, to Cloud Peak...
Lance contributed investment property worth $512,500, purchased Five years ago for $210,000 cash, to Cloud Peak LLC in exchange for an 65 percent profits and capital interest in the LLC. Cloud Peak owes $520,000 to its suppliers but has no other debts. a. What is Lance’s tax basis in his LLC interest? b. What is Lance’s holding period in his interest? c. What is Cloud Peak’s basis in the contributed property? d. What is Cloud Peak’s holding period in the...
Part a. You have bought a property and have four different options on how to pay for the property purchase. The four options are
Part a.            You have bought a property and have four different options on how to pay for the property purchase. The four options are:$ 200,000 p.a. paid every year for five years with the first payment paid at the end of the first year.$250,000 p.a. for six years with the first payment paid at the end of the first year.$1,000,000 at the end of the fifth year and $1,250,000 at the end of the 10th year.A $20,000 deposit paid now...
You purchased a property for P4.25M. In the first month that you bought the property, you...
You purchased a property for P4.25M. In the first month that you bought the property, you spent quarter of a million on repairs and remodelling. Immediately after the property was fixed, somebody offered you P5.45M for the property. After some thought, you decided to keep the property and have it rented for P45K per month starting two months after the remodelling. You collected rent for 15 months and then sold the property for P6M. If the interest rate was 1.5%...
Suppose you bought a new home for $210,000 using a 33-year mortgage with semiannual payments of...
Suppose you bought a new home for $210,000 using a 33-year mortgage with semiannual payments of $6,609.301. The annual interest rate of the mortgage is 5.1%. Right after the first 7 years (26 years left), approximately how much money have you paid in interest and how much in principal?
You have just bought a house and have a $125,000, 25-year mortgage with a fixed interest...
You have just bought a house and have a $125,000, 25-year mortgage with a fixed interest rate of 8.5 percent with monthly payments. Over the next five years, what percentage of your mortgage payments will go toward the repayment of principal?.
Assume you are looking to invest $10,000 and you have two friends each of which is...
Assume you are looking to invest $10,000 and you have two friends each of which is offering to sell you a 25% stake in his/her business in exchange for your $10,000. list at least 5 questions you would ask each of your two friends for each question explain how the answer would help you make your investment decision for each question explain what concerns you would have regarding the answers received.
Assume that you have $10,000 to invest in a term deposit. In this situation, explain which...
Assume that you have $10,000 to invest in a term deposit. In this situation, explain which of the three (3) deposits listed below (a. – c.) you would select if the selection strategy is totally depend on the higher percentage per annum (per year). a) a 90-day deposit that has a maturity value of $10,250. b) a 130-day deposit that has a maturity value of $10,390. c) a 145-day deposit that has a maturity value of $10,420.
Assume that you have $10,000 to invest in a term deposit. In this situation, explain which...
Assume that you have $10,000 to invest in a term deposit. In this situation, explain which of the three (3) deposits listed below (a. – c.) you would select if the selection strategy is totally depend on the higher percentage per annum (per year). a) a 90-day deposit that has a maturity value of $10,250. b) a 130-day deposit that has a maturity value of $10,390. c) a 145-day deposit that has a maturity value of $10,420
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT