Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You buy a house $275,000. You pay $25,000 down and you take out a mortgage at 3.15% compounded monthly on the balance for 30 years.

You buy a house $275,000. You pay $25,000 down and you take out a mortgage at 3.15% compounded monthly on the balance for 30 years. 1. Find your monthly payment. 2. Find the total amount of interest you will pay for 30 years. 3. Create an amortization table on the excel with the titles below. Payment Monthly Number Payment Interest for per month Portion to Principal Principal at the end of a year 0. 1. 2. 4. On the table your last payment can be different than the other payments. You can adjust the amount of the final payment and make the final balance zero. 5. Now, calculate the total interest on your amortization table by adding all values in column of interest. Compare this number with interest you find #2. 6. Answer of questions should be written on a word document, and copy and paste first five and last five rows of the table into your word document

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

Step: 3

blur-text-image

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

Finance Construction 17 Corporate Ifrs Gaap Engineering Technologies No 10 501 11 000 Of 111 111 Laws

Authors: Tim Asikin, Steve Asikin

1st Edition

1078350590, 978-1078350594

More Books

Students also viewed these Accounting questions