You take out a $200,000 mortgage for 20 years at 6%.
What is your monthly payment?
What is the principle and interest on the first payment?
What is the principle and interest on the twelfth payment?
How much interest will you pay over the 20 years?
Please answer all four questions using excel and attach the excel document when answering.