Please help with question #2! In need of help to create scenario summary!

1. (5 points) You intend to purchase a new house. The amount of money you need to borrow (with a 15-year repayment period) ranges between $300,000 and $650,000. You also expect the annual interest rate (APR) that you will receive to range between 5% and 8%. Prepare a worksheet based on the information above. Then: (1) Determine how your monthly payment will depend on the amount borrowed and the annual interest rate. (2) Create a report tabulating monthly payments for the following scenarios: Scenario Amount Borrowed Annual Interest Rate 4% Number of Years to Repay Loan 30 Lowest payment Most-likely payment Highest payment $300,000 $400,000 $550,000 6% 20 8% 15 1. (5 points) You intend to purchase a new house. The amount of money you need to borrow (with a 15-year repayment period) ranges between $300,000 and $650,000. You also expect the annual interest rate (APR) that you will receive to range between 5% and 8%. Prepare a worksheet based on the information above. Then: (1) Determine how your monthly payment will depend on the amount borrowed and the annual interest rate. (2) Create a report tabulating monthly payments for the following scenarios: Scenario Amount Borrowed Annual Interest Rate 4% Number of Years to Repay Loan 30 Lowest payment Most-likely payment Highest payment $300,000 $400,000 $550,000 6% 20 8% 15