Financial Statement Analysis provides information that


Question Description:

30

Financial Statement Analysis provides information that indicates how a company is performing. By comparing financial statements of different years, a manager can make informed decisions about investments, expenditures, and activities that impact revenues. Directions: Read the chapter in the text titled “Financial Statement Analysis.” Using the comparative financial statements for Baby Cakes International Inc. (see “BabyCakes_Financial_Project_Data.xls” linked in the lesson activities) , complete the following tasks. Note: The market price of BabyCakes Int’l, Inc. common stock was $20 on December 31, 2008. • Complete the 19 ratios listed below. Determine the following measures for 2008: • Working Capital • Current ratio • Quick ratio • Accounts receivable turnover • Number of days’ sales in receivables • Inventory turnover • Number of days’ sales in inventory • Ratio of fixed assets to long-term liabilities • Ratio of liabilities to stockholders’ equity • Number of times interest charges earned • Number of times preferred dividends earned • Ratio of net sales to assets • Rate earned on total assets • Rate earned on stockholders’ equity • Rate earned on common stockholder’s equity • Earnings per share on common stock • Price-earnings ratio • Dividends per share of common stock • Dividend yield • Explain what the results of each ratio indicate about the company. • Complete a horizontal analysis for the Income Statement, and explain your findings. • Complete a vertical analysis for the Income Statement, and explain your findings. ATTACHMENT PREVIEW Download attachment 3 pages Baby_Cakes_Financial_Project_Data_Correc-2.xlsx Baby Cakes International Inc Statement of Retained Earnings for the Years ended December 31, 2008 and 2007 December 31, 2008 Retained Earnings, January 1 Net income for year Total Dividends Paid Preferred Stock Common Stock Total Dividends Paid Retained Earnings December 31 December 31, 2007 $375,000 68,000 $443,000 $327,000 67,000 $394,000 $15,000 7,000 $22,000 $421,000 $12,000 7,000 $19,000 $375,000 Baby Cakes International Inc Income Statement for the Years ended December 31, 2008 and 2007 2008 Sales Sales returns Sales Allowances Sales Discounts Net Sales Cost of Goods Sold Gross Profit Selling Expenses Administrative Expenses Total operating expenses Income from Operations Other income Other expense Income before Tax Income Tax Expense NET INCOME $1,055,000 1,000 1,500 2,500 $1,050,000 400,000 $650,000 $270,000 195,000 $465,000 $185,000 20,000 $205,000 96,000 $109,000 41,000 $68,000 2007 $966,000 3,000 1,000 2,000 $960,000 390,000 $570,000 $275,000 165,000 $440,000 $130,000 15,000 $145,000 48,000 $97,000 30,000 $67,000 Baby Cakes International Inc Balance Sheet December 31, 2008 and 2007 ASSETS December 31, 2008 Current Assets Cash Securities A/R Inventory Prepaids Total Current Assets December 31, 2007 $165,000 398,000 199,000 84,000 25,000 $871,000 300,000 1,040,000 $2,211,000 200,000 760,000 $1,575,000 $290,000 $250,000 300,000 600,000 $900,000 $1,190,000 Long Term Investments Plant Property and Equipment (net of depreciation) Total Assets $126,000 254,000 165,000 52,000 18,000 $615,000 400,000 $400,000 $650,000 $250,000 350,000 421,000 $1,021,000 $2,211,000 $200,000 350,000 375,000 $925,000 $1,575,000 LIABILITIES Accounts Payable Long Term Liabilities Mortgage note payable , 8% due 2011 Bonds Payable, 12% due 2015 Total Long-term liabilities Total Liabilities Stockholders’ Equity Preferred $6 stock, $100 par Common Stock, $10 par Retained Earnings Total Stockholder’s Equity Total liabilities and stockholders’ equity Read more shannharrod
posted a question · May 02, 2014 at 2:37pm

Answer

30