Mortgages and Taxes: Deb and Rusty have just gotten married and wish to buy a home. They both work in Boston and have a combined income of $90,000. They found a modest starter house which they are buying for $350,000. 1. They plan to use their $40,000 is savings to cover the closing costs the bank will charge them, which are 1% of the amount they borrow from the bank. The rest of the savings will be used as a down payment. For example, if they borrow $330,000 using $20,000 for a down payment, the closing costs will be $3,300, which still leaves them some savings. Determine the largest amount they can use for a down payment and still pay the closing costs. 2. Open Excel and create an 20 year amortization schedule, giving monthly payments for the amount they borrowed at a 4.5% annual interest rate. Title this worksheet Amortization. For your answer to this question write "See Excel Workbook". 3. Use the amortization schedule to compute the total amount of interest they will pay to the bank over the 20 years. 4. Deb and Rusty know that buying a house will save them money on taxes because they get to deduct the interest they pay to the bank each year and the property taxes they pay each year. First create an separate worksheet from the amortization schedule. Title this worksheet Analysis. In this worksheet, create an column titled Income starting at $90,000 and increasing at 3% for 20 years. What is their income after 20 years? 5. Next create the following columns in your new Excel worksheet. For your answer to this question write "See Excel Workbook". Property Taxes which are currently $3,100 a year and will also increase by 3% a year. Interest paid to the bank each year (careful here, your amortization schedule is monthly). Yearly Deduction: Do an Google search for Standard Deduction for current year/married filing jointly Taxable Income (Taxable Income = Income - Deductions). 6. Go to www.savewealth.com click on Tax Forms, Income Tax Rates, and then Married Filing Jointly to find the tax formula for Deb and Rusty. Create an column computing the yearly Federal Income Taxes. 7. Assume the rent is now $1000 a month and will increase by 3% each year. Compute their yearly federal income taxes (which are higher when renting because they don't have the deductions). 8. By renting they are saving a lot of money each year! They pay less for rent than a mortgage, and they don't pay property taxes (they do however pay more in income tax). Assume the extra money (include the $40,000 in savings as initial deposit) they have from renting versus buying is all invested at 10% a year, and every year their extra money is added to this account. Create an column titled Extra Money. How much extra money do they have after 20 years? 9. Assume the house increases in value by 3% a year. Which option ends up with more money for Deb and Rusty to retire on assuming they sell the house after 20 years?