Your dient is the CrO of a high tech business, and she requires a new car. She has hired your brokerage company to find suitatide transportation for business. She entertains and meets with many foreign businesipeople, so the company image is important. She will use a company chauffeci. Provide your dient with $3$ different car modet options. You select the recommended car for the dient.

You determine the down payment.

Deternine what your bank loan will be$.$

Calculate the interest rate and make sure the Rate is described and displayed when you format your assignement. DO NOT USE an internet purchase calculator. This MUST be calculated in Excel.

Calculate what your monthly payment would be if the loan was amortized over the following terms.

a$.4$ wars

b$.5$ years

c$.9$ wears

You must display all $($Monthly$)$ Calculations in your workbook.

Provide $3$ different car options for your client to select from.

You can use the same Rate for all $3$ car calculations.

Use the bank's prime rate of $4\mathrm{.}95\%$ as your base Prime Rate. Add $3\mathrm{.}65\%$ to the Bank's Prime rate to determine the consumer loan Interest Rate.

Provide $3$ vanous down payment options.

From the $3$ possible cars you have provided for your cient you are to select one of them as vour recommendation. Insert a photograph of the recommended car purchase into your dient Excel presentation sheets.

Provide a brief description of the car.

invoice the dient just for your services,

Use an Excel immoice Template "Simple lavoice" included in the Moodle File to ball your