Bolster Inc. has decided to expand its operations to owning and operating car washes. The following is an excerpt from the conversation between the chief executive officer, Mike O'Brian, and the vice president of finance, John Ibison: Mike: John, have you given any thought to how we're going to manage the acquisition of Swiffer Car Wash? John: Well, the two basic options, as I see it, are to issue either preferred stock or bonds. The equity market is a little depressed right now. The rumor is that the Federal Reserve Bank's going to increase the interest rates either this month or next. Mike: Yes. I've heard the rumor. The problem is that we can't wait around to see what's going to happen. We'll have to move on this next week if we want any chance to complete the acquisition of Swiffer Car Wash. John: Well, the bond market is strong right now. Maybe we should issue debt this time around. Mike: That's what I would have guessed as well. Swiffer Car Wash's financial statements look pretty good, except for the volatility of it's income and cash flows. But that's characteristic of the industry. REQUIRED: Discuss the advantages and disadvantages of issuing preferred stock versus bonds.   Remember the company is issuing the bonds, be sure to discuss this from the Company's point of view not the investor's point of view.    a. You must have a source within your reply. You may use the book as your reference, but DO NOT copy information word-for-word. You also have the option to use another source. (2 points) b. There must be at least two advantages and two disadvantages listed with supporting information. (from company's point of view, who is issuing the bonds or stock not investors) (2 points)

Background of the Project:A home improvement store needs your help in analyzing a year’s work of sales by department and by departmental sales managers in order to support informed managerial decision making for the coming year. You are to analyze the past year’s sales data in Microsoft Excel for this hypothetical business analysis scenario.I. Retrieving your data - In this Microsoft Access database, you will find a single table that contains a year’s worth of sales data by department and by the manager who was managing that department during the indicated time periods. You should note that, during this year, department managers were managing different departments during different time periods on a rotating basis.Import the table in the Microsoft Access database into a blank Microsoft Excel workbook (Hint: you will find the process that you need by clicking on the on the Data tab while you are in Excel).The imported data should appear as a table in Excel. Use the various Excel table features such as filtering to get a feeling for how you can manipulate and analyze the data.II. Analyzing the data:Your task here is to carefully analyze the data to identify “findings” that management can use to support decisions related to departments and managers (all managers identified in the data are still working for the company).Now you are to select five factors within the dataset on which to base and support your recommendations to management. Once you have selected your five factors, you should then use the Pivot Table/Pivot Chart features in Excel to perform your analysis.a. Place your analysis and recommendation of each of the five factors in individual worksheets in your Excel workbook containing the table imported from Access. Name each worksheet with a clear and concise name to indicate its contents. E.g., A Worksheet could be named "Analysis #1" and contain data organized of Sales by department. b. In each worksheet, show the results of your analysis and, based on your analysis and finding(s), clearly state your recommendation to management by typing it in to a cell adjacent to your data analysis. You could also choose to use a "Shape" to type in your recommendation.III. Charting Task: Create two charts that “tell part of the story” about your analysis. Place each chart in one of your analysis worksheets. You may use any chart type that you feel would be effective in depicting a particular aspect of your data analysis work. You can experiment with different chart types to select two that will clearly depict some of your findings.Summary:Your completed assignment will be contained in a single Microsoft Excel workbook that contains six (6) worksheets: the yearly sales data, the five analysis and recommendation worksheets (two of which include charts). Many of you will find this to be a cognitively challenging assignment: be determined to succeed with your best effort! Start Early and Ask Questions! Submit your completed Excel workbook as an attachment to the assignment submission.