Create an Amortization Schedule for a $300,000.00 home.The amortization schedule is to be completed in Excelwith all work shown in Excel.Thus, I should be able to click on any cell and see your work embedded in that cell. If this is not done, it will be an automatic 50% deduction.

Assume you pay the full asking price and make a 20% down-payment.Do not use an online amortization schedule.

Note the textbook amortization schedule is using an annual payment.Please do the schedule for both 180 months (15 years) at 3.625% APR and 360 months (30 years) at 4.25% APR for a $300,000 home with 20% down.

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

After completing the amortization schedule, attach your amortization sheet to a new post and discuss what you found. How much interest will you pay over the life of each loan?You can determine this by summing all the payments and subtracting the amount borrowed.

You must post your own discussion thread before you will be able to view those of your classmates.Once you have posted your thread you need to post two replies. All this isdue by April 1st.