Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need the analysis report for the following: a. The Income Statement b. Comprehensive Income and Shareholder Equity Statement (Statement of Changes in Equity) c.
I need the analysis report for the following:
a. The Income Statement
b. Comprehensive Income and Shareholder Equity Statement (Statement of Changes in Equity)
c. Statement of Financial Position
d. Statement of Sources and Uses of Funds
e. Statement of Cash Flows
f. Financial Ratios
g. Sustainable Growth Rate
Please can someone help me out. Thank you.
Statement of Income 2013 2014 2015 Revenue 1,564,000 2,052,000 2,216,160 Cost of sales Purchases Freight in Labour Depreciation/amortization Other charges Total cost of sales 630,000 44,000 529,000 4,000 0 1,207,000 825,000 74,000 665,000 8,000 0 1,572,000 850,000 84,000 460,000 25,000 0 1,419,000 Gross profit 357,000 480,000 797,160 Other income 0 0 0 Distribution costs Salaries Commissions Travelling Advertising Depreciation/amortization Other charges Total distribution costs 41,000 47,000 16,000 10,000 3,000 0 117,000 65,000 68,000 32,000 20,000 5,000 0 190,000 70,000 80,000 35,000 30,000 10,000 0 225,000 Administrative expenses Salaries Leasing Depreciation/amortization Other charges Total administrative expenses 107,000 26,000 24,000 16,000 173,000 117,000 31,000 30,000 17,000 195,000 120,000 40,000 25,000 13,000 198,000 Financing costs 14,000 34,000 110,000 Total expenses less other income 304,000 419,000 533,000 Profit before taxes 53,000 61,000 264,160 Income taxe expense 12,000 14,000 64,000 Profit for the year 41,000 47,000 200,760 Statement of Comprehensive Income 2013 2014 2015 41,000 47,000 200,160 Profit for the year Other comprehensive income (loss) Exchange differences on translating foreign operations Cash flow hedges Gains on property revaluation Total other comprehensive income/loss) Total comprehensive income for the year Oo 0 0 41,000 goooo 0 0 0 0 200,160 47,000 Statement of Changes in Equity 2013 2014 2015 125,000 Common shares Balance at beginning of year Common shares issued Other changes Balance at end of year 0 25,000 0 25,000 25,000 100,000 0 125,000 125,000 Retained earnings Balance at beginning of year Profit applicable to common shareholders Sub-total Dividends paid to shareholders Balance at end of year 171,000 41,000 212,000 o 212,000 212,000 47,000 259,000 0 259,000 259,000 200,160 459,160 64,096 395,064 0 Accumulated other comprehensive income/(loss) Balance at beginning of year Other comprehensive income/loss) Balance at end of year 0 OOO OOO 0 Total shareholders' equity 237,000 384,000 520,064 2013 2014 2015 238,000 14,000 0 0 252,000 93,000 538,000 14,000 0 0 552,000 136,000 538,000 14,000 300,000 0 852,000 196,000 159,000 416,000 656,000 210,000 298,000 4,000 13,000 297,000 400,000 4,000 15,000 0 0 175,000 285,000 4,000 25,000 100,000 0 0 525,000 716,000 589,000 684,000 1,132,000 1,245,000 1 Statement of Financial Position 2 3 Assets 4 Non-current assets 5 Property, plant and equipment 6 Goodwill 7 Investments 8 Other non-current assets 9 Sub-total 10 Accumulated depreciation/amortization 11 12 Total non-current assets 13 14 Current assets 15 Inventories 16 Trade receivables 17 Prepaid expenses 18 Cash and cash equivalents 19 Short-term deposits 20 Other current asset 2 21 22 Total current assets 23 24 Total assets 25 26 Equity and liabilities 27 Share capital 28 Retained earnings 29 Other comprehensive income/(loss) 30 31 Total equity attributable to owners 32 33 Total non-current liabilities 34 35 Current liabilities 36 Trade and other payables 37 Short-term borrowings 38 Current portion of long-term debt 39 Accruals 40 Other current liability 41 Total current liabilities 42 43 Total labilities 44 45 Total equity and liabilities 46 47 Net: Assets = Equity + Liabilities 48 49 50 51 25,000 212,000 0 125,000 259,000 0 125,000 395,064 0 237,000 384,000 520,064 74,000 300,000 270,000 137,000 0 198,000 38,000 0 373,000 200,000 0 208,000 40,000 0 448,000 235,000 120,000 63,936 36,000 0 454,936 447,000 748,000 724,936 684,000 1,132,000 1,245,000 0 0 0 2015 Change 1 Statement of Sources and Uses of Funds 2 3 2013 2014 Change 4 5 Property, plant and equipment 238,000 538,000 -300,000 6 Goodwill 14,000 14,000 0 7 Investments 0 0 0 8 Other non-current assets 0 0 0 9 Accumulated depreciation/amortizatio 93,000 136,000 43,000 10 Inventories 210,000 297,000 -87,000 11 Trade receivables 298,000 400,000 -102,000 12 Prepaid expenses 4,000 4,000 0 13 Cash and cash equivalents 13,000 15,000 -2,000 14 Short-term deposits 0 0 0 15 Other current asset 2 0 0 0 16 Share capital 25,000 125,000 100,000 17 Retained earnings 212,000 259,000 47,000 18 Other comprehensive income/(loss) 0 0 0 19 Total non-current liabilities 74,000 300,000 226,000 20 Trade and other payables 137,000 200,000 63,000 21 Short-term borrowings 0 0 0 22 Current portion of long-term debt 198,000 208,000 10,000 23 Accruals 38,000 40,000 2,000 24 Other current liability 0 0 0 25 Adjustment 0 26 Total O 27 28 Guidelines to determine whether the item is a source of use of funds 29 30 Source of funds 1 31 Decrease in asset accounts 32 Increase in liability accounts 33 Increase in equity accounts 34 35 Use of funds -1 36 Increase in asset accounts 37 Decrease in liability accounts 38 Decrease in equity accounts 39 40 538,000 0 14,000 0 300,000 -300,000 0 0 196,000 60,000 175,000 122,000 285,000 115,000 4,000 0 25,000 -10,000 100,000 -100,000 0 0 125,000 0 395,064 136,064 0 0 270,000 -30,000 235,000 35,000 120,000 120,000 63,936 -144,064 36,000 -4,000 0 0 0 0 Statement of Cash Flows 3 2014 Total 2015 Total OVOU AWN- 47,000 43,000 -87,000 -102,000 0 0 0 63,000 0 10,000 2,000 0 200,160 60,000 122,000 115,000 0 -100,000 0 35,000 120,000 -144,064 -4,000 0 16 -24,000 404,096 0 100,000 0 226,000 0 -30,000 -64,096 326,000 -94,096 5 Operating activities 6 Profit for the year Depreciation/amortization Inventories 9 Trade receivables 10 Prepaid expenses 11 Short-term deposits 12 Other current asset 2 13 Trade and other payables 14 Short-term borrowings 15 Current portion of long-term debt Accruals 17 Other current liability 18 Total operating activities 19 20 Financing activities 21 Share capital 22 Other comprehensive income/(loss) 23 Total non-current liabilities 24 Dividends paid to shareholders 25 Total financing activities 26 27 Investing activities 28 Property, plant and equipment 29 Goodwill 30 Investments 31 Other non-current assets 32 Adjustment 33 Total investing activities 34 35 Increase (Decrease) 36 Cash and equ. - Beginning of year 37 Cash and equ. - End of year 38 Total.Net 39 40 41 42 43 44 45 46 -300,000 -300,000 0 -2,000 -10,000 -2,000 13,000 15,000 -10,000 15,000 25,000 0 300,000 1 Financial Ratios 2 2013 2014 2015 COU AWN- 4 5 6 Liquidity Ratios Net working capital ($000) 8 Current ratio (times) 9 Cash ratio (times) 10 Quick ratio (times) 11 Working capital turnover ratio (times) 12 Days of working capital ratio 13 Cash conversation efficiency ratio 14 Using operating activities cash flow (percent) 15 Using profit for the year + deprec./amortization (percent) 152,000 1.41 0.03 0.84 10.29 86.6 268,000 1.60 0.03 0.94 7.66 88.4 134,064 1.29 0.05 0.91 16.53 -NM 37.1 -1.2% 4.4% 18.2% 11.7% 4.6% 16 65.35 1.89 4.79 2.33 66.08 1.95 2.79 1.94 58.23 1.39 3.40 2.76 69.55 5.25 71.15 5.13 46.94 7.78 5.75 5.29 7.45 6.91 8.11 12.66 17 Debt/Coverage Ratios 18 Debt-to-total assets ratio (percent) 19 Debt-to-equity ratio (times) 20 Times-interest-earned ratio (times) 21 Fixed-charges-coverage ratio (times) 22 23 Asset Management Ratios 24 Accounts receivable performance measures 25 Average collection period (days) 26 Accounts receivable turnover (times) 27 Inventory performance measures 28 Turnover performance measures 29 Using cost of sales (times) 30 Using revenue (times) 31 Day's sales to inventory performance measures 32 Using cost of sales (days) 33 Using revenue (days) 34 Asset ratios 35 Capital assets turnover ratio (times) 36 Total assets turnover ratio (times) 37 38 Profitability Ratios 39 Gross profit to revenue ratio (percent) 40 Operating income to revenue ratio (percent) 41 Profit for the year to revenue ratio (percent) 42 Return on total assets ratio (percent) 43 Return on invested capital ratio (percent) 44 Return on equity ratio (percent) 45 46 64 49 69 53 45 29 9.84 2.29 4.93 1.81 3.38 1.78 22.83 4.28 2.62 5.99 13.18 17.30 23.39 4.63 2.29 4.15 6.87 12.24 35.97 16.88 9.03 16.08 25.33 38.49 1 Cash Flow 2013 2014 2015 COVOAWN- 5 Profit for the year 41,000 47,000 200,160 4,000 3,000 24,000 31,000 8,000 5,000 30,000 43,000 25,000 10,000 25,000 60,000 72,000 90,000 260,160 2013 2014 2015 53,000 61,000 264,160 14,000 34,000 110,000 67,000 95,000 374,160 7 Depreciation/amortization expense Cost of sales Selling 10 Administration 11 Total depreciation/amortization expense 12 13 Cash Flow 14 15 16 Earnings before interest and 17 and taxes (EBIT) 18 19 20 Profit before taxes 21 22 Financing costs 23 24 EBIT 25 26 27 Earnings before interest, taxes, 28 depreciation/amortization 29 (EBITDA) 30 31 32 EBIT 33 34 Depreciation/amortization expense 35 36 EBITDA 37 38 39 40 41 42 43 2013 2014 2015 67,000 95,000 374,160 31,000 43,000 60,000 98,000 138,000 434,160 Sustainable Growth Rate 2013 2014 2015 NMOND 6 1. Ratio profit for the year to sales (M) 0.03 0.02 0.09 1.00 1.00 0.68 1.89 1.95 1.39 0.44 0.55 0.56 20.92% 13.95% 35.43% 31.20% 8.00% 8 2. Ratio of reinvested income to 9 income before dividends (R) 10 11 3. Ratio of total liabilities 12 to net worth (D/E) 13 14 4. Ratio of assets to sales (A) 15 16 The growth formula 17 18 (M) (R) (1 +D/E) 19 (A) - (M) (R) (1 +D/E) 20 21 Sustainable or potential growth rate 22 23 24 Company's growth rate 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started