Question: Use excel to build a monthly amortization table for a 30-year 5% fix-rate mortgage on a $320,000 home, with a $15,000 down payment. a. How

Use excel to build a monthly amortization table for a 30-year 5% fix-rate mortgage on a $320,000 home, with a $15,000 down payment.

a. How much money will you still owe on the loan after making one full year of payments?

b. How much money will you still owe on the loan after making 15 full years of payments?

c. If you want to refinance after 8 years of making payments, how much financing would you need to secure from your bank to do so?

d. How much money can you expect to pay in interests alone during the full life of the mortgage?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

7A) Use excel to build a monthly amortization table for a 30-year 5% fix-rate mortgage on a $320,000 home, with a $15,000 down payment. [Please be good to the forests and cut and paste only the first...

Q:

It's due tommorow and need help with these following problems. Please solve the following problems. Show all relevant time lines and calculations and make sure to highlight the final answer to the...

Q:

8) Using excel, build a monthly amortization table for a 30-year mortgage on a $350,000 home, no money down. Use 7% as the yearly interest on the loan. 9) Using the amortization table you built for...

Q:

Using excel, build a monthly amortization table for a 30-year mortgage on a $350,000 home, no money down. Use 7% as the yearly interest on the loan. Also,Using the amortization table you built for...

Q:

I have attached a file with real estate mortgage problems. Real Estate and Society Spring 2017 1. You have borrowed $550,000 for Bank of America. The loan is a traditional fixed mortgage loan at...

Q:

AutoSave Pvc ... OF Lesson/AClassActivity (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X [G Y Paste Verdana v 12 ~ A ab Wran Text Insert v General v x Delete BIU...

Q:

Download A Alternativ class. You must provide me with an Excel file that has 4 tabs. You may use the CH 17 Excel file as a basis for the file that you e-mail to me. The file should be e-mailed by...

Q:

help please GF2106Project5Q Brooks.pdf X + ontent/FA19/MGF2106_107F_FA19 WE/Projects%20Fall%202019/MGF2106ProjectsQ_Brooks.pdf be Maps Apple Bing Google Yahoo Sign In daytona state A Login for aleks...

Q:

really just need help with part 2 and the part 3 on this. Part 1: Mortgage A mortgage is a loan used to purchase a home. It is usually paid back over a period of 15, 20, or 30 years. The interest...

Q:

Part 1: Mortgage A mortgage is a loan used to purchase a home. It is usually paid back over a period of 15, 20, or 30 years. The interest rate is determined by the term of the loan (the length of...

Q:

American Chip Corporation's fiscal year-end is December 31. The following is a partial adjusted trial balance as of December 31, 2011. Required: Prepare the necessary closing entries at December 31,...

Q:

Hines Moving Company held a fixed-rate debt of $2 million. The company wanted to hedge its fair value exposure with an interest rate swap. However, the only notional available at the time, on the...

Q:

Isaac is 6 7 years old and would like to transfer some of his assets to his adult son, Murray. Isaac does not want to incur any gift tax liability, and also needs some cash flow, so he is considering...

Q:

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Q:

3-7 Why are disruptive technologies so difficult for even the companies that develop them?

Q:

3-6 It has been said that the advantage that leading- edge retailers such as Dell and Walmart have over their competition isnt technology; its their management. Do you agree? Why or why not?

Q:

3. Are there any disadvantages to mining customer data? Explain your answer. With the amount of data available to companies doubling every year, new sources of data, and innovations in data...