You take out a 200000 mortgage for 30 years at 6 Fill out th

You take out a $200,000 mortgage for 30 years at 6%. Fill out the amortization table to answer the following questions. find beginning balance, interest, principal, ending balance for months 1-360

Solution

beginning balance Interest Principal Balance $2,00,000 $1,000 $199 $1,99,801 $1,99,801 $11,933 $2,456 $1,97,544 $1,97,544 $11,782 $2,608 $1,94,936 $1,94,936 $11,621 $2,768 $1,92,168 $1,92,168 $11,450 $2,939 $1,89,229 $1,89,229 $11,269 $3,120 $1,86,109 $1,86,109 $11,076 $3,313 $1,82,796 $1,82,796 $10,872 $3,517 $1,79,279 $1,79,279 $10,655 $3,734 $1,75,545 $1,75,545 $10,425 $3,964 $1,71,580 $1,71,580 $10,180 $4,209 $1,67,371 $1,67,371 $9,921 $4,468 $1,62,903 $1,62,903 $9,645 $4,744 $1,58,159 $1,58,159 $9,353 $5,037 $1,53,122 $1,53,122 $9,042 $5,347 $1,47,775 $1,47,775 $8,712 $5,677 $1,42,098 $1,42,098 $8,362 $6,027 $1,36,070 $1,36,070 $7,990 $6,399 $1,29,671 $1,29,671 $7,595 $6,794 $1,22,878 $1,22,878 $7,176 $7,213 $1,15,665 $1,15,665 $6,732 $7,658 $1,08,007 $1,08,007 $6,259 $8,130 $99,877 $99,877 $5,758 $8,631 $91,246 $91,246 $5,225 $9,164 $82,082 $82,082 $4,660 $9,729 $72,353 $72,353 $4,060 $10,329 $62,024 $62,024 $3,423 $10,966 $51,058 $51,058 $2,747 $11,642 $39,416 $39,416 $2,029 $12,361 $27,055 $27,055 $1,266 $13,123 $13,932 $13,932 $457 $13,932 $0