Complete the Mini Case in Chapter 2 of your text. Use formulas to calculate the
ID: 2382703 • Letter: C
Question
Complete the Mini Case in Chapter 2 of your text. Use formulas to calculate the ratios, clearly label the analysis, and round to one decimal place. You must complete all requirements of the case study.
Jaedan Industries has the following account balances as of December 31, 2010 (Found on pages 64-65 of the text). The firm’s dividend payout ratio is 25% and the tax rate is 34%. The firm’s stock price on December 31, 2009, was $42.89 and on December 31, 2010, it was $56.82. Construct an income statement, balance sheet, statement of retained earnings, and statement of cash flows for 2010. Also, determine the firm’s free cash flow and calculate the liquidity, activity, debt, profitability, and market ratios for Jaedan industries. Perform a DuPont analysis and compare the firm to the industry ratios (see last table in this sequence). Evaluate the financial strengths and weaknesses Jaedan Industries may have.
Explanation / Answer
Ans
Income Statement for the year ended 2013 Green Inc Sales % 420,00,000.00 Less: Cost of Goods sold 63% 264,60,000.00 Gross proft 37% 155,40,000.00 Less: Operating Expense: Selling,general,and administration expense 16,21,000.00 Depreciation 8,00,000.00 Operating Expense 24,21,000.00 Earnings Before Interest and Taxes 131,19,000.00 Interest expense 3,75,200.00 Earnings Before Taxes 127,43,800.00 Less:Taxes @ 34% 34% 43,32,892.00 Net Income 84,10,908.00 Less: Dividend Paid 25% 21,10,727.00 To Retained Earnings 63,00,181.00 Jeadan Industries Balance sheet as of Decemeber 31, 2009 Assets Amount Liabilities & Equity Amount Cash 36,89,000.00 Accounts Payable 31,36,000.00 Accounts Receivable 54,23,000.00 Notes Payable 7,06,000.00 Marketable Securities 18,36,000.00 Accruals 5,00,000.00 Inventory 41,18,000.00 Total Current Liabilities 43,42,000.00 Total Current Assets 150,66,000.00 Long term Bond Outstanding 30,46,000.00 Fixed Assets 148,11,000.00 Preferred stock 1,00,000.00 Less Accumulated Depreciation -59,60,000.00 Common Stock 40,00,000.00 Net Fixed Assets 88,51,000.00 Paid in capital in excess of Par 45,00,000.00 Reatined earnings 79,29,000.00 Total Assets 239,17,000.00 Total Liabilities and equity 239,17,000.00 Statement of Retained Earnings Amount Balance at the beginning 16,28,819.00 Add:Net income 63,00,181.00 Balance at the end 79,29,000.00 Cash flow statement for the period 2013, Jeadan Industries Details Amount Amount Net Income Befor Tax 127,43,800.00 Add: Interest expense 3,75,200.00 Add:Depreciation 8,00,000.00 Less: Tax Paid -43,32,892.00 Cash from Operating Activities before WC chages Increase in current assets -17,12,500.00 Less: Increase In current laibilities 3,62,000.00 Cash flow from operating activities 82,35,608.00 Purchase of fixed assets -29,32,000.00 Cash used in investing activities -29,32,000.00 Interest paid -3,75,200.00 Dividend Paid -21,10,727.00 Cash used in financing activities -24,85,927.00 Cash and cash equivalent at the beginning 8,71,319.00 Increase in cash & cash equivalents 28,17,681.00 Cash and cash equivalent at the end 36,89,000.00 Free Cash Flow for equity Cash flow from operating activities 82,35,608.00 Less investment in fixed assets -29,32,000.00 Less Interest -3,75,200.00 49,28,408.00 Ratios Formula Amount Liquidity Ratio Current Ratio Current asssets/Current Liabilities 3.5 Remark Quick Ratio (Current asssets-(Inventory+Account receivable)/Current Liabilities 1.27 Activity Ratio Inventory Turnover COGS/Average Inventory 7.22 Avreage collection Period 365/Sales/Average receivables 36.02 Average Payment Period 365/Sales/Average receivables 55.93 COGS *.75 Fixed Asset Turnover ratio Sales /Average Fixed assets 1.35 Total Asset Turnover ratio Sales /Average total Assets 0.51 Debt ratio Debt ratio Debt including current liabilities /Total Assets 0.31 Asset to Equity Ratio Total Assets/Equity 1.45 Debt to Equity Ratio LT Debt/Equity+LT Debt 0.16 Times interest earned Earning before interest/Interest 34.97 Profitability Ratios Gross profit margin Gross Profit/sales 37% Operating profit margin Operating profit/sales 31% Net Profit Margin Net Profit/Sales 20% Earning Per share Earning to Equity share holders /No of equity shares 6.30 Return on total assets Operating profit/Total assets 55% Return on common equity (Net Income -less Prferred dividend)/Common equity 51% Market Ratios Price Earning ratio Price/Earning 9.02 Market/Book Ratio Market Price/Book value per share 3.46Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.