THIS IS THE PROJECT

Project 1: Buying a House The purpose of this project is to help you understand purchasing a home. You will make a 10%down payment to avoid escrow costs and finance the balance over 30 years. Payments and compounding will occur monthly. Round all dollar amounts to the nearest cent. Don't just list the numbers, you should also add your own understanding and explanations. Present it as a written project, not just Q&A. Find a home in Westchester or any state or county you like by visitinghttp://www.realtor.com or https://www.zillow.com or some other online real-estate system. a. Indicate the Address of home b. What is the asking price of home c. What is the mortgage amount (or amount of loan) after 10% down payment. d. Find the current interest rate for your mortgage (from your bank or online). In particular, find the rates for 30-year mortgage. e. If you take a 30-year mortgage, find the monthly payment (must show your work). Then the total payments to repay loan if regular payments are made for the full 30 years (the loan does not include the down payment) ( #of payments times the monthly payment). f. What is the amount of interest paid if the loan goes full term? (Total payments minus the mortgage) g. What happens to all the questions above if you take a loan only for 15 years? h. Amortization Schedule for the 30-year mortgage. Create a amortization schedule excel spread sheet showing the 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.

THIS IS WHAT I HAVE SO FAR!!!!!

1. 1851 North Stanley Avenue Los Angeles, California, 90046 United States, is the address of the home.
2. The asking price of the home is 38,000,000 USD.
3. The mortgage amount is equal to the asking price minus the downpayment of ten percent.
   1. 38,000,000 - 3,800,000 = 34,200,000 USD
      1. So, the mortgage amount is 34,200,000 USD
4. The current interest rate for a thirty year mortgage rate in California is roughly 7.75% according tousbank.com. But this depends all on the buyer's credit score and the lender.
5. In order to calculate the monthly payment for a thirty year mortgage this will be the formula in use.