Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need all on excel spreadsheet, please its urgent ang i will highly appreciate you PROBLEM: You find a $750,000 house you want to purchase.

i need all on excel spreadsheet, please its urgent ang i will highly appreciate you
image text in transcribed
image text in transcribed
image text in transcribed
PROBLEM: You find a $750,000 house you want to purchase. You plan to take out a 30 -year mortgage. I. Down Payment: You must give a 15% down payment. Determine the amount of your down payment and the amount to finance (after the down payment). Must show your work. 11. 30-Year Mortgage: Calculate your monthly payment for a 30-year loan (round up to the nearest cents). For the 30 -year loan, use an annual interest rate of 5.235%. Must show your work. III. Amortization Schedule. Create an amortization schedule excel spread sheet showing all 360-month mortgage payments. Attach the schedule to your paper. The amortization schedule must include the following key columns (and calculations): payment number, Mortgage payment, Principle (associated with that payment), Interest (associated with that payment), unpaid balance. Also include a totals row. IV. Find the payment number of first payment where more of the payment goes toward the principle than interest? Must show your work. V. Since mortgage payments are for principal and interest only, you also have monthly payments for home insurance and property taxes. As a wise homeowner, you decide that you monthly mortgage principal and interest payment should not exceed 36% of your monthly takehome pay. What minimum monthly take-home pay should you have to meet this goal? Show your calculations. VI. It is also important to note that your net or take-home pay (after taxes) is less than your gross pay (before taxes). Assuming that your net pay is 63% of your gross pay, what minimum 5 gross annual salary would you need to make to have the monthly new salary stated above? Must show your work. VII. Selling the House. After living in the house for 10.5 years you want to sell. The value of the real estate increased over time. To calculate the value of an investment such as real estate we use continuous compound interest. Find the value of the home 10.5 years after purchase assuming a continuous interest rate of 3.75%. Use the full selling price as the principal. Must show your work. VIII. Suppose you want to pay off your mortgage after your 120th payment. What amount would you have to pay the bank to close the mortgage (this is sometimes called your payoff amount)? VIII. Suppose you want to pay off your mortgage after your 120th payment. What amount would you have to pay the bank to close the mortgage (this is sometimes called your payoff amount)? IX. As an aside research, your look at an alternative option. Suppose with each mortgage payment you include an extra $1000 that would only be directed against the principal. After how many payments (monthly mortgage +$1000 extra applied towards principal) would the loan be paid off? How much interest would be saved with this alternative option vs the option to pay just the monthly mortgage amount? PROBLEM: You find a $750,000 house you want to purchase. You plan to take out a 30 -year mortgage. I. Down Payment: You must give a 15% down payment. Determine the amount of your down payment and the amount to finance (after the down payment). Must show your work. 11. 30-Year Mortgage: Calculate your monthly payment for a 30-year loan (round up to the nearest cents). For the 30 -year loan, use an annual interest rate of 5.235%. Must show your work. III. Amortization Schedule. Create an amortization schedule excel spread sheet showing all 360-month mortgage payments. Attach the schedule to your paper. The amortization schedule must include the following key columns (and calculations): payment number, Mortgage payment, Principle (associated with that payment), Interest (associated with that payment), unpaid balance. Also include a totals row. IV. Find the payment number of first payment where more of the payment goes toward the principle than interest? Must show your work. V. Since mortgage payments are for principal and interest only, you also have monthly payments for home insurance and property taxes. As a wise homeowner, you decide that you monthly mortgage principal and interest payment should not exceed 36% of your monthly takehome pay. What minimum monthly take-home pay should you have to meet this goal? Show your calculations. VI. It is also important to note that your net or take-home pay (after taxes) is less than your gross pay (before taxes). Assuming that your net pay is 63% of your gross pay, what minimum 5 gross annual salary would you need to make to have the monthly new salary stated above? Must show your work. VII. Selling the House. After living in the house for 10.5 years you want to sell. The value of the real estate increased over time. To calculate the value of an investment such as real estate we use continuous compound interest. Find the value of the home 10.5 years after purchase assuming a continuous interest rate of 3.75%. Use the full selling price as the principal. Must show your work. VIII. Suppose you want to pay off your mortgage after your 120th payment. What amount would you have to pay the bank to close the mortgage (this is sometimes called your payoff amount)? VIII. Suppose you want to pay off your mortgage after your 120th payment. What amount would you have to pay the bank to close the mortgage (this is sometimes called your payoff amount)? IX. As an aside research, your look at an alternative option. Suppose with each mortgage payment you include an extra $1000 that would only be directed against the principal. After how many payments (monthly mortgage +$1000 extra applied towards principal) would the loan be paid off? How much interest would be saved with this alternative option vs the option to pay just the monthly mortgage amount

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

Health Auditing As A Tool For Quality Care Case Studies

Authors: Camila Freire

1st Edition

6206344169, 978-6206344162

More Books

Students also viewed these Accounting questions

Question

What are the market opportunities and challenges in Greater China?

Answered: 1 week ago