Create an Amortization Schedule for a home costing $300,000 at 4% for 30 years and $300,000 at 3.5% for 15 years. The amortization schedule is to be...

Create an Amortization Schedule for a home costing $300,000 at 4% for 30 years and $300,000 at 3.5% for 15 years. The amortization schedule is to be completed in Excel with all work shown in Excel. Thus, I should be able to click on any cell and see your work embedded in that cell.

Assume you pay the full asking price and make a 20% down-payment. Please make your own amortization table and do not use an online table. 

Please make your schedule for both 180 months (15 years) and 360 months (30 years). 

Remember to divide your interest by 12 to get a monthly rate. 

Also, How much interest will you pay over the life of each loan?