Calculate and present this scenario using Excel workbook. Thanks

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. Use his current sailboat as a trade-in. The trade-in value will be 25% of the new purchase. You may also recommend to your client an increased down payment amount. Calculate this value and clearly display it in your quote. 1. Determine the trade-in value and calculate the down payment. 2. The trade-in value will be 25% of the new boat purchase. 3. Determine what will be financed. 4. Calculate the interest rate and make sure the Rate is described and displayed when you format your assignment. DO NOT USE an Internet purchase calculator. This MUST be calculated in Excel. 5. Calculate what your monthly payments would be if the loan was amortized over the following terms. a. 10 years b. 18 years c. 25 years 6. You must display all Terms (Monthly) calculation in your workbook 7. Provide 3 different Yacht/Sailboat options for your client's inspection 8. You can use the Same bank Rate for all 3 Yacht calculations 9. Provide 3 various down payment options, 10. Use the bank's prime rate of 1.55% as your base Prime Rate. Add 3.45% to the Bank's Prime rate to determine the consumer loan Interest Rate. 11. Insert a photograph of your recommended yacht purchase into your client Excel presentation sheets. 12. Provide a brief description of the Yacht/boat. 13. Invoice this client for just your services. 14. Use an Excel Invoice Template "Simple Invoice" included in the Moodle File to bill your client. 15. Invoice this client for your services only 16. 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. Use his current sailboat as a trade-in. The trade-in value will be 25% of the new purchase. You may also recommend to your client an increased down payment amount. Calculate this value and clearly display it in your quote. 1. Determine the trade-in value and calculate the down payment. 2. The trade-in value will be 25% of the new boat purchase. 3. Determine what will be financed. 4. Calculate the interest rate and make sure the Rate is described and displayed when you format your assignment. DO NOT USE an Internet purchase calculator. This MUST be calculated in Excel. 5. Calculate what your monthly payments would be if the loan was amortized over the following terms. a. 10 years b. 18 years c. 25 years 6. You must display all Terms (Monthly) calculation in your workbook 7. Provide 3 different Yacht/Sailboat options for your client's inspection 8. You can use the Same bank Rate for all 3 Yacht calculations 9. Provide 3 various down payment options, 10. Use the bank's prime rate of 1.55% as your base Prime Rate. Add 3.45% to the Bank's Prime rate to determine the consumer loan Interest Rate. 11. Insert a photograph of your recommended yacht purchase into your client Excel presentation sheets. 12. Provide a brief description of the Yacht/boat. 13. Invoice this client for just your services. 14. Use an Excel Invoice Template "Simple Invoice" included in the Moodle File to bill your client. 15. Invoice this client for your services only 16. The client will pay for their own products