I need help calculating this in Excel - First House 3,500,000 - Second House 4,000,000 - Third House 5,950,000 ( need every question except agent information) please help

1. Search Real Estate sales in Great Briton for Luxury properties suitable for the family. 2. Present 3 possible real estate options for the client to chose from. 3. Calculate their monthly Mortgage payments for each property based on the following information: a. Their down payment will be 25 percent of the property. b. Calculate the interest Rate: i. Bank of England has set the Prime Rate of 1.75%. ii. The Mortgage Lender has set the Mortgage Rate at 2.25% Plus the Bank Prime Rate. iii. Use this Rate for all three properties iv. Provide and calculate 3 various Terms for the Properties. 1. 1 Property Term will be 10 Years 2. 1 Property term will be 15 Years. 3. 1 property term will be 30 Years. c. Provide a photo and some information of each selected property in you presentation. 4. Calculate their monthly Mortgage Payment for each property. 5. Each property must be inserted onto its own worksheet formatting applied. 6. Of the Three Properties presented select the one you think best for your client. 7. Calculate your Service Fee using the Supplied Simple Invoice Template. Modify the Invoice to suit your presentation needs: Agent information: 1. Your Service Fee is 12.25% of the price of the selected property. 2. Mark up in the invoice information, Company Name, Address, etc. 3. Provide a brief description of your service on your invoice. 4. Add 6.25% Sales Tax. 5. Calculate the amount the client owes you