Hello Can I get help with this question please?

It must be done in excel. If you can help me with the excel formulas as well that would be great! Thank you

-PLEASE DO ON EXCEL

1)In this problem you will investigate a 15 versus 30 year home loan

You have found a home for the price of $350000. You decide to make a downpayment of 10% of on the home. Your bank offers you a 15 year loan at 4.5% or a 30 year loan at 5.5%.

a)Determine the amount you have to borrow on the house

350000*.90 = $315,000

b)Determine your monthly payment on each loan

c)Create Amortization tables for each loan in Excel (make sure you have the columnsfor months, payment, applied to interest and applied to balance and balance).

d)Answer these questions about each loan

1)What is the total interest paid on the loan if you pay off the loan as scheduled

2)What is the interest paid in the first year? What is the interest paid in the last year

3)What is the total amount you paid for the house in each situation (be careful)

4)After you have made half of the payments you decide to pay off the loan. What is the payoff amount? Do this for each loan