Transcribed Image Text
BUSINESS DECISION: FINANCIAL RATIOSThe years 2005 to 2009 saw a coffe company's revenues grow bymore than 50%. Use the following financial data to answer thequestions below.Starbucks - Selected Financial Data(In millions, except earnings per share)Sept. 27,Sept. 28,Sept. 30,Oct. 1,Oct. 2,20092008200720062005As of and for the fiscal year ended(52 wks)(52 wks)(52 wks)(52 wks)(52 wks)Results of OperationsNet revenues:Company-operated retail$8,180.3$8,771.6$7,998.3$6,583.1$5,391.7Specialty:Licensing$1,222.1$1,171.8$1,026.1$860.7$673.3Food service and other$372.2$439.5$386.6$343.2$304.3Total specialty$1,594.3$1,611.3$1,412.7$1,203.9$977.6Total net revenues$9,774.6$10,382.9$9,411.0$7,787.0$6,369.3Operating income$562.1$503.7$1,053.6$894.2$780.6Earnings before cumulative effect of change in$390.5$315.5$672.7$581.7$494.1accounting principleCumulative effect of accounting change for assetretirement obligations, net of taxes___17.4_Net earnings$390.5$315.5$672.7$564.3$494.1Earnings per common share before cumulativeeffect of change in accounting principle - diluted ("EPS")$0.53$0.46$0.81$0.71$0.67Cumulative effect of accounting change for assetretirement obligations, net of taxes - per common share___0.08_EPS - diluted$0.53$0.46$0.81$0.63$0.67Net cash provided by operating activities$1,389.4$1,258.9$1,331.4$1,331.8$922.5Capital ependitures (additions to property, plantand equipment)$445.7$984.6$1,080.3$771.3$643.2Balance SheetTotal assets$5,576.5$5,672.7$5,343.5$4,428.5$3,513.9Short-term borrowings0.0713.2710.2700.2277.3Long-term debt (including current portion)549.7550.2550.82.63.6Shareholders' equity$3,045.7$2,490.9$2,284.1$2,228.8$2,090.2a. Calculate the asset turnover ratio for 2008 and 2009. Roundto the nearest hundredth.2008:2009:b. Calculate the net profit margin for 2007, 2008, and 2009.Round to the nearest tenth.Do not enter the percent symbol in your answer.2007: %2008: %2009: %c. Calculate the return on investment for 2007, 2008, and 2009.Round to the nearest tenth.Do not enter the percent symbol in your answer.2007: %2008: %2009: %d. Prepare a trend analysis of the net revenue and total assetsfor 2005 through 2009.Round to the nearest tenth. Do not enter the percent symbol inyour answer.20092008200720062005Net Revenue%%%%%Total Assets%%%%%e. Prepare a trend analysis multiple-line chart for theinformation in part d.