Please answer all question. Thank you

Develop an amortization spreadsheet. The following inputs should be provided in the spreadsheet Annual interest rate Loan term (in years) Payments per year Loan amount Also include the following values (to be calculated from your input values) Scheduled number of payments (based upon the loan duration) Actual number of payments (when the loan is actually paid off) Scheduled payment (this is your annual A amount for the loan and is equivalent to the scheduled payment identified below) At a minimum, the spreadsheet should include the following columns or calculations. (The list below does not represent the order of these items within the spreadsheet.) Payment Number (period) Balance Scheduled payment Principal Additional payment Cumulative Principal Interest Cumulative Interest Although not required for this assignment, consider adding a chart to graphically show how the balance, cumulative principal, and cumulative interest change over the life of the loan. Problem 1 Home loan - You want to buy a new house. The home costs $250,000, you are required to put 20% down. Payments are made monthly. Find the following. 1. Determine the scheduled payment for the following loan terms a. 30 year loan at 3.5% interest b. 20 year loan at 3.25% interest c. 15 year loan at 3.0% interest 2. Determine the total interest paid over the life of the loan for the following loan terms a. 30 year loan at 3.5% interest b. 20 year loan at 3.25% interest c. 15 year loan at 3.0% interest 3. Apply the 30 year loan at 3.5% interest loan term and find the following a. The cumulative principal and interest paid at months 12, 60, 120, and 180. b. How much interest do you save over the life of the loan if you double the principal payment over: i. the first year of the loan. ii. The first five years of the loan c. For problem 3.b. In how many months will the loan be paid off? d. How fast will you pay off the loan if you add $50 extra principal each month for i. The first 10 years ii. The first 15 years e. How much interest do you save over the life of the loan if you make a one-time additional payment (extra principal) of $1000 at months 1, 60, or 120. Month 1 - Month 60 - Month 120 - f. When will you pay off the loan if you apply an extra payment annually (extra payment applied as principal reduction). i. How much interest does this save over the life of the loan.