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 clients inspection.

9. Provide 3 various down payment options.

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

11. Use the banks prime rate of .75% as your base Prime Rate. Add 2.75% to the Banks 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.