Search the internet to purchase the following items using the 2 scenarios listed below. Calculate and present all 2 scenarios using 1 Excel workbook. Add an additional Worksheet for your Reflective Summary. This is 1 File to Upload.

SCENARIO NO.1 – Assume you are a Broker. Provide the following information for you client.

Purchase a Company Executive Car:

Your client is the CEO of a high tech business and she requires a new car. She has hired your brokerage company to find suitable transportation for business. She entertains and meets with many foreign business people so company image is important. She will use a company chauffer.

Provide your client with 3 different car model options. You select the recommended car for the client.

Go Online and google Executive Car Sales.

1.            You determine the down payment.

2.            Determine what your bank loan will be.

3.            Calculate the interest rate and make sure the Rate is describe and displayed when you format your assignment. DO NOT USE an Internet purchase calculator. This MUST be calculated in Excel.

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

a.            3 years

b.            5 years

c.             7 years

1.            You must display all 3 (Monthly) Calculations in your workbook using the PMT Function. The client would like to know what Monthly Payment Options would be.

5.            Provide 3 different car options to your client to select from.

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

7.            Use the Prime Rate of 3.25% as your base Rate. Add 2.75% to the Bank’s Prime rate to determine the Consumer loan Interest Rate. Make sure you read this section carefully! NOTE: Banks will always add an additional Bank Prime Rate to the Basic Prime when you take out a loan Rate.

8.            Provide 3 various down payment options. NOTE: You cannot borrow money from the bank if you do not invest some of your own money. Make up your down payment.

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

10.          Provide a brief description of the car.

11.          Invoice this client just for your services.

12.          Use an Excel Invoice Template “Simple Invoice” included in the Moodle File to bill your client.

13.          Include a GST tax of 6% for your services and calculate the results.

14.          REMEMBER The client will pay for their own products.

SCENARIO NO. 2 - Assume you are a Yacht Broker. Provide the following information for a different client.

Purchase a Sailboat: Your client is the owner of a manufacturing business and he would like to purchase another larger sailboat/yacht for personal use. He currently owns a C&C 27 ft. sailboat. He has hired your yacht brokerage company to find a suitable sailboat/yacht. He would like his next boat to sleep between 6 and 13 people. The trade-in value will be 25% of the new purchase. Calculate this value and clearly display it in your quote. Go online and Google Yacht Sales.

2.            Determine the trade-in value and calculate the down payment.

3.            The trade-in value will be 25% of the new boat purchase.

4.            Determine what will be financed (borrowed from the bank).

5.            Calculate the interest rate and make sure the Rate is describe and displayed when you format your assignment. DO NOT USE an Internet purchase calculator. This MUST be calculated in Excel.

6.            Calculate what your monthly payments would if the loan was amortized over the following terms. Your client would like monthly payment options.

a.            10 years

b.            15 years

c.             20 years

7.            You must display all 3 Terms (Monthly) calculation in you workbook. The client would like to know what Monthly Payment Option He has.

8.            Provide 3 different Yacht/Sailboat options for your client’s inspection.

9.            Provide 3 various down payment options.

10.          You can use the same bank Rate for all 3 Yacht calculations.

11.          Use the bank’s prime rate of .75% as your base Prime Rate. Add 2.75% to the Bank’s Prime rate to determine the Consumer Loan Interest Rate.

12.          Insert a photograph of your recommended yacht purchase into your client Excel presentation sheets.

13.          Provide a brief description of the Yacht/boat.

14.          Invoice this client for just your services.

15.          Use an Excel Invoice Template “Simple Invoice” included in the Moodle File to bill your client.

16.          Invoice this client for your services only.

17.          The client will pay for their own products.

Presentation Instructions:

I have included an Assignment Reflection Summary requirement for this project. PLEASE READ this document. Your Assignment Reflection demonstrates to me you have learned certain processes/functions which can assist you in your business education. SELECT a minimum of 4 points from the Assignment Reflective Summary and Presentation Guidelines List. Your Reflection will

A.            Create a name for your Brokerage Company and display it on your pages.

Also title it BrokerPMT.

B.            Insert your company name in the footer

C.            Upload your Excel workbook with all your client’s calculations.

D.            Name each work Sheet Tab using this Naming list:

i.              Car

ii.             Boat

iii.            Assignment Reflection Summary

E.            Apply formatting to your sheets

YOU MUST DEMONSTRATE AND SHOW ALL YOU CALCULATIONS ON YOUR WORKSHEETS. You must USE the PMT FUNCTION!

F.            Create an invoice for your services.

a.            Your broker fees will be calculated as a flat 14.35% on the total price of your recommend Car/Boat.

b.            Select and use only 1 of the 3 quotes for each of the scenarios. IE; 1 brokerage fee for the car purchase, 1 fee for the yacht/sailboat purchase.

Use supplied Excel Invoice ONLY.

c.             Create your brokerage company’s address.

d.            Create a Billing Address for each client.

e.            Add a GST tax of 6% for your services and calculate the results.

f.             Clearly display all of the financial information for you client’s inspection on the invoice.

G.           Remember you are a business. Presentation to the client is paramount.

Answer rating: 100% (QA)

Scenario No1 A Purchase a Company Executive Car You determine the down payment The down payment for the car will depend on the model of car chosen and the total value of the car Generally the down pay... View the full answer