Ariel & Eric, the owners of Flounder Enterprises Limited are considering opening a second location and feel they will need to obtain a loan from the bank to finance the expansion. You have just been hired by the local bank and your manager, Sebastian, has asked you to decide whether or not the bank should lend money to Flounder Enterprises Limited. To assist you with your decision Eric and Ariel have provided you with the income Statement, Balance Sheet and Statement of Cash Flows for the year ended December 31, 2019. Sebastian also provided you with the industry standards and prior years ratios for select ratios. Required: 1. Calculate 12 ratios to help you analyze the company. 2. Review the Statement of Cash Flows for Flounder Enterprises and describe 3 strengths or weaknesses. 3. Based on your answers from Part 1 and 2 would you be willing to lend the company money. You must discuss at least 4 ratios in providing your answer. SHOW YOUR WORK Flounder Enterprises Industry averages-2019 2018 55.00% 53.00% 3.50% Gross profit margin ratio Net profit margin ratio Rate of return on assets Debt ratio Current ratio A/R turnover 0.65 1.60 9.20 1.72 9.06 FLOUNDER ENTERPRISES LIMITED INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2019 Sales $ 1,450,000 Cost of goods sold 696,000 754.000 Selling expenses Administrative expenses Depreciation 313,500 269,300 5,625 588,425 Income from operations 165,575 Interest expense 16,500 Income before tax 149,075 Income tax expense 37,800 Net income 111,275 FLOUNDER ENTERPRISES LIMITED BALANCE SHEET DECEMBER 31, 2019 ASSETS Cash Accounts receivable Inventory $ 67,750 131,800 124,200 323,750 LIABILITIES AND SHAREHOLDER'S EQUITY Accounts payable $ 176,900 Income taxes payable 37,800 Wages payable 9.250 223,950 Note payable 175,000 398,950 Building Accumulated depreciation Land - 235,000 13,125 70,000 291,875 Shareholder's Equity Common shares Retained Earnings 10,000 206,675 216,675 S 615.625 $ 615,625 FLOUNDER ENTERPRISES LIMITED STATEMENT OF CASH FLOWS YEAR ENDING DECEMBER 31, 2019 2,019 2018 Cash flow from operating activities $ 111,275 $ 5,625 58,800 2,500 Net income Add depreciation Adjustment to reconcile net income to net cash provided by operating activities Net increase in current assets other than cash Net increase in current liabilities 200 30,400 81,050 167,550 34,900 26,200 Cash flow from Financing activities Payment of dividends New loan proceeds Repayment of loans 15,000 - 120,000 45,000 60,000 20,000 60,000 10,000 30,000 Cash flow from investing activities Purchase of land and building 180,000 39,000 Net cash inflow 47,550 17,200 Beginning cash 20,200 3,000 Ending cash 67,750 $ 20,200 Selected data from the December 31, 2018 financial statements: Accounts receivable $ 129,600 Inventory $ 96,000 Accounts payable $ 124,200 Total assets $363,300 1. Gross profit margin ratio Gross profit Net sales 2. Return on sales (Net profit margin ratio) Net income Net sales 3. Rate of return on assets ratio 4. Asset turnover ratio 5 86. Receivables turnover ratio and days sales outstanding 7 & 8. Inventory turnover ratio and days inventory outstanding Net income Average total assets Net sales Average total assets Net sales Average accounts receivable and 365 Accounts receivable turnover Cost of goods sold Average inventory and 365 Inventory turnover ratio Cost of goods sold Average accounts payable and 365 Accounts payable turnover Days inventory outstanding days sales outstanding - days payables outstanding Current assets Current liabilities Cash + short-term investments current receivables Current liabilities Total liabilities Total assets Income from operations Interest expense 9 & 10. Payables turnover and days payables outstanding 11. Cash conversion cycle 12. Current ratio 13. Quick ratio 14. Debt ratio 15. Times interest earned