Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose you take out a mortgage so you can buy a house. The loan is for $100,000 at 6% interest for 30 years. The

  

Suppose you take out a mortgage so you can buy a house. The loan is for $100,000 at 6% interest for 30 years. The bank has calculated your payment to be $599.55 per month. (Note: This is the payment on the loan only. Banks usually include escrow in your monthly payments. Escrow is an account that pays the property taxes and insurance. In reality, you would have to pay more than $599.55 a month.) 1) Create an Excel spreadsheet similar to the one below, also called an amortization table, to analyze this loan. Fill in the top three rows and the bottom three rows of the table below. * Recall: I-P* APR/n Month Remaining Principal Monthly Interest Payment Payment Principal** Payment ** Principal Payment- Monthly Payment- Interest Payment 3 subtract each month's 358 principal payment from the remaining principal at the 359 beginning of that month to 360 find what is still owed at the beginning of the next month After you have completed the spreadsheet, highlight the cell at the bottom of the monthly payment column. If you click on the button at the top of the page that is marked , Excel will add the column up for you. Use this button to find the sum of the monthly payments. 2) How much did you pay in order to pay off the $100,000 loan? 3) Repeat the same procedure to find the sum of the interest payment column. How much did you pay in interest over the 30 years? 4) Notice some patterns in the mortgage spreadsheet. At the beginning of the loan, your monthly payment is mostly interest. In the first month of the loan, what percent of your monthly payment is interest?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Thomas Garman, Raymond Forgue

12th edition

9781305176409, 1133595839, 1305176405, 978-1133595830

More Books

Students also viewed these Finance questions