BCPT $123$ PMT ProjectProject Information:Client Number $1$:Jay z and Beyonce would like to purchase a Country Estate in Great Briton for the family including all three children.Jay z has hired you as their agent to search for suitable properties and present three possible purchase options. They have placed no limits on the purchase price; the properties must reflect their status.Zay z and Beyonce have a household staff of $12$ fulltime live$-$in employees who manage the care of the home. Four of these employees will live onsite the balance of the employees will live nearby and Rent suitable accommodations.Instructions:$1.$ Search Real Estate sales in Great Briton for Luxury properties suitable for the family$\mathrm{.}2.$ Present $3$ possible real estate options for the client to chose from$\mathrm{.}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\mathrm{.}75\%.$ii$.$ The Mortgage Lender has set the Mortgage Rate at $2\mathrm{.}25\%$ Plus the Bank Prime Rate.iii. Use this Rate for all three propertiesiv. Provide and calculate $3$ various Terms for the Properties$\mathrm{.}1.1$ Property Term will be $10$ Years$2.1$ Property Term will be $15$ Years$\mathrm{.}3.1$ property term will be $30$ Years.c$.$ Provide a photo and some information of each selected property in you presentation$\mathrm{.}4.$ Calculate their monthly Mortgage Payment for each property$\mathrm{.}5.$ Each property must be inserted onto its own worksheet formatting applied$\mathrm{.}6.$ Of the Three Properties presented select the one you think best for your client$\mathrm{.}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\mathrm{.}25\%$ of the price of the selected property$\mathrm{.}2.$ Mark up in the invoice information, Company Name, Address, etc$\mathrm{.}3.$ Provide a brief description of your service on your invoice$\mathrm{.}4.$ Add $6\mathrm{.}25\%$ Sales Tax$\mathrm{.}5.$ Calculate the amount the client owes you.