PLEASE SHOW INSTRUCTIONS TO DO ON EXCEL!!! THIS IS IMPORTANT.
As part of your analysis of the company for management, you have been asked to analyze data on Dirt Bikes's financial performance. Review Dirt Bikes's selected financial data in the Introduction to Dirt Bikes, which can be found at the Laudon Web site. There you will find Dirt Bikes's income statement and summary balance sheet data from 2005 to 2007, annual sales of Dirt Bikes models between 2003 and 2007, and total domestic versus inter- national sales between 2003 and 2007. 6 7 Model & Enduro 250 9 Enduro 550 10 Moto 300 -11 Moto 450 12. TOTAL 13 Sales by Model 2003 2004 2005 1201 1663 2291 2832 3290 3759 1755 1932 2454 463 598 661 6251 7483 9165 2006 2312 4078 2615 773 9778 2007 2195 3647 2627 823 9292 Use spreadsheet software to create graphs of Dirt Bikes's sales history from 2003 to 2007 and its domestic versus international sales from 2003 to 2007. Select the type of graph that is most appropriate for presenting the data you are analyzing. Use the instructions at the Laudon Web site and your spreadsheet software to calculate the gross and net margins in Dirt Bikes's income statements from 2005 to 2007. You can also create graphs showing trends in selected pieces of Dirt Bikes's 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.) As part of your analysis of the company for management, you have been asked to analyze data on Dirt Bikes's financial performance. Review Dirt Bikes's selected financial data in the Introduction to Dirt Bikes, which can be found at the Laudon Web site. There you will find Dirt Bikes's income statement and summary balance sheet data from 2005 to 2007, annual sales of Dirt Bikes models between 2003 and 2007, and total domestic versus inter- national sales between 2003 and 2007. 6 7 Model & Enduro 250 9 Enduro 550 10 Moto 300 -11 Moto 450 12. TOTAL 13 Sales by Model 2003 2004 2005 1201 1663 2291 2832 3290 3759 1755 1932 2454 463 598 661 6251 7483 9165 2006 2312 4078 2615 773 9778 2007 2195 3647 2627 823 9292 Use spreadsheet software to create graphs of Dirt Bikes's sales history from 2003 to 2007 and its domestic versus international sales from 2003 to 2007. Select the type of graph that is most appropriate for presenting the data you are analyzing. Use the instructions at the Laudon Web site and your spreadsheet software to calculate the gross and net margins in Dirt Bikes's income statements from 2005 to 2007. You can also create graphs showing trends in selected pieces of Dirt Bikes's 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.)
