Question

Find the following for a $200,000 fixed rate mortgage and the given information a) Monthly mortgage payment (principal and interest) b) Monthly house payment (including property taxes and insurance) c) Initial monthly interest d) Income tax deductible portion of initial house payment e) Net initial monthly cost for the home (considering tax savings) Annual Owner's Term of Interest Property Annual Income Tax Mortgage Rate Tax Insurance Bracket 20 years 7% $1284 $384 25% a) The monthly mortgage payment is (Round to the nearest dollar as needed) b) The monthly house payment is s (Round to the nearest dollar as needed c) The initial monthly interest is 5 (Round to the nearest dollar as needed d) The Income tax deductible portion of the initial house payment is {Round to the nearest dollar as needed)

Answer 1

Formula for calculating EMIs is:

EMI = [P x R x (1+R)^N]/[(1+R)^N-1]

Where, P = principal amount = $200000

R = Monthly Rate of Interest = 0.07/12 = 0.005833

N = No of Months = 20 * 12 = 240

EMI = 200000*(0.005833*(1+0.005833)^240/((1+0.005833)^240-1)) = 1550.55

The answer to given questions are

a) Monthly mortgage payment is = $ 1550

b) Monthly House payment is = ($1284 + $384) / 12 = $139

c) The initial monthly interest is = $200,000 * 0.005833 = $1167

d) The income tax deductible portion of the initial house payment = $139 * 25% = $35

e) Net Initial monthly cost of the home = Monthly installment + monthly house payment - tax saving on interest component - tax saving on house payment = 1550.55 + 139 - (25% * 1166.67) - (25% * 139) = $ 1363