In: Accounting
A mortgage of $100,000 is amortized over 25 years using level payments at the end of each quarter and the first interest payment at the end of the first quarter is $2411.37. Calculate the 62nd principal payment amount.
a. 1074.21
b. 1048.92
c. 1100.11
d. 1024.22
e. None of these answers
| Correct Answer b. 1048.92 | |||
| Step 1 : | Calcuation of interest rate per quarter | ||
| =$2411.37/100000 | |||
| 2.4114% | |||
| Step 2: | Calculation of Montly payment | ||
| 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 | |||
| N= Number of periods | |||
| = [ $100000x0.0241137 x (1+0.0241137)^100]/[(1+0.0241137)^100 -1] | |||
| = [ $2411.37( 1.0241137 )^100] / [(1.0241137 )^100 -1 | |||
| =$2656.56 | |||
| Step 3: | Calculation of balance of laon after 61st payment | ||
| Present Value Of An Annuity | |||
| = C*[1-(1+i)^-n]/i] | |||
| Where, | |||
| C= Cash Flow per period | |||
| i = interest rate per period | |||
| n=number of period | |||
| = $2656.56[ 1-(1+0.0241137)^-39 /0.0241137] | |||
| = $2656.56[ 1-(1.0241137)^-39 /0.0241137] | |||
| = $2656.56[ (0.6052) ] /0.0241137 | |||
| = $66,669.31 | |||
| Step 4: | Calculation of balance of laon after 62st payment | ||
| Present Value Of An Annuity | |||
| = C*[1-(1+i)^-n]/i] | |||
| Where, | |||
| C= Cash Flow per period | |||
| i = interest rate per period | |||
| n=number of period | |||
| = $2656.56[ 1-(1+0.0241137)^-38 /0.0241137] | |||
| = $2656.56[ 1-(1.0241137)^-38 /0.0241137] | |||
| = $2656.56[ (0.5956) ] /0.0241137 | |||
| = $65,620.40 | |||
| Step 5: | Calculation of principal paid | ||
| =$66669.31-65620.40 | |||
| =$1048.92 | |||