Management Info System

20/11 In this exercise, you volition use spreadsheet software to analyze company financial statements and create charts classical financial data As part of your analysis of the company for the management, you hurl been asked to analyze data on discoloration Bikess financial slaying and prepare a report for management . Review vulgarism Bikess selected financial data in the introduction to obscenity Bikess, which can be found at the laudon weathervane site .There you will find Dirt Bikess income statement and summary balance sheet data from 2002/2006, and heart and soul domesticateds versus internationalistic sales between2002 and 2006 Use your spreadsheet software to create graphs of Dirt Bikess sales history from 2002 to 2006 and its domestics versus international sales from 2002 to 2006 select the type of graph that is most appropriate for presenting the data you are analyzing.Use the instruction at the laudon web site and your spreadsheet software to calculate the gros s and net margins in Dirt Bikess income statements from 2004 to 2006. You can also create graphs showing trends in selected pieces of Dirt Bikess income statement and balance sheet data if you wish (You may want to rearrange the historical ordering of the data if you decide to do this) 1. What are dirt Bikess best-and worst- performing products? What is the proportion of domestic to international sales?Have international sales grown relative to domestic sales? 2. Are sales (revenues) growing steadily, and, if so, at what rate? What is the apostrophize of goods sold compared to revenues? Is it increasing or decreasing? Are the firms gross and net margins increasing or decreasing? Is the firm severely in debt? Does he have sufficient assets to pay for operational expenses and to pay the development of new products and information systems? 3. Prepare a slide show that summarizes your analysis of dirt Bikess performance