3 You are a commercial lending officer for a local bank. Lester Corporation has 4 come to the bank requesting a $150,000 short term loan to meet operating needs. 5 Lester has good, but not excellent credit and has been in business for a number of years, 6 and has a history of profitablility, although not excessively profitable in recent years. 7 The loan would be for one year at 8%. If the bank made the loan, the bank would eam 8 $12,000 in interest income in addition to lending fees of approximately $3,000 9 At the end of the year, Lester is expected to repay the loan in full. 10 11 Lester Corporation has presented a copy of the current year's income statement cash flow 12 and a comparative balance sheet for 2020 and 2019. Other information is provided along 13 with industry averages. 14 15 REQUIRED: 16 17 You are to: 18 19 a. Compute all ratios for Lester listed in the industry averages. 20 21 b. Compare each ratio to industry averages and rate on the following scale 22 23 24 Below average Average Above average 25 26 27 28 c. Provide an overal comment of the following on Lester's: 29 30 31 32 33 34 d. Would you lend yeso? Why or Why not? 35 36 37 38 39 Liquidity Profitablility Solvency E F 47 Lester Corporation 48 Balance Sheets 49 For the Years Ended December 21, 2020 and 2019 50 51 2020 2019 52 Cash $ 160,000 80,000 53 Short-term investments 75,000 200,000 54 Accounts receivable 250,000 300,000 55 Inventory 500,000 450,000 56 Pre-paid costs 50,000 30,000 57 Property, Plant & Equip. 1.100.000 1,140,000 58 Total Assets 2.135.000 2.200.000 59 60 Liabilities and Stockholder Equity 61 62 Current liabilities 400,000 550,000 63 Mortgage payable 425,000 500,000 64 Stockholder equity 1,310,000 1.150.000 65 66 Total liabilities & S/E 2.135.000 2.200.000 67 68 Lester Corporation 69 Income Statement Cash Flow Statement 70 For the Year Ended December 31,2020 71 72 Sales Revenue: Cash flow from Operations 73 Net Sales Revenue 2,500,000 74 Cash Flow From Investing 75 Cost of Goods Sold 2,000,000 76 Gross Profit 500,000 Cash Flow from Financing 77 Operating Expenses 250,000 30,000 125,000 (75,000) DU B E F 80,000 D 250,000 250,000 Increase in Cash 50,000 200,000 Cash, January 1, 2020 40,000 160,000 Cash, December 31, 2020 80,000 160,000 50,000 $52 per share 77 Operating Expenses 78 Net Income before int, and taxes 79 Interest expense 80 Net Income before tax 81 Income tax expense 82 Net income 83 84 Other Information 85 Number of shares outstanding 86 Stock price 87 88 89 Industry Averages: 90 91 Liquidity 92 Current ratio: 93 Accounts receivable turnover 94 Average collection period 95 Inventory turnover 96 Days in inventory 97 98 Profitablity 99 Gross profit % 100 Profit margin 101 Return on average stockholder equity 102 Earnings per share 103 Price earnings ratio 104 105 Solvency 106 Debt to asset ratio 107 3:1 9 times per year 40 days 4 times per year 90 days 17-18% 5% 10% $2.50 to 3.00 per share 12 times earnings 4096 108 b. Compare Rating 107 b. Compare Rating Above Average Average Below Computations average 108 109 a. Compute: 110 111 Liquidity 112 Current ratio for 2020 113 Accounts receivable turnover 114 Average collection period 115 Inventory turnover 116 Days in inventory 117 118 Profitablity 119 Gross profit % 120 Profit Margin 121 Return on average stockholder equity 122 Earnings per share 123 Price earnings ratio 124 125 Solvency 126 Debt to asset ratio for 2020 127 128 129 130 131 132 133 134 135 136 c. Comment 137 138 1. Liquidity 139 140 137 138 1. Liquidity 139 140 141 142 143 144 2. Profitability 145 146 147 148 149 3. Solvency 150 151 152 153 154 155 156 d. Decide - Lend? Yes/No, Why 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174