Question
Baker & Co. has applied for a loan from the Trust Us Bank in order to invest in several potential opportunities. In order to evaluate
Baker & Co. has applied for a loan from the Trust Us Bank in order to invest in several potential opportunities. In order to evaluate the firm as a potential debtor, the bank would like to compare Baker & Co. to the industry. The following are the financial statements given to Trust Us Bank:
Balance Sheet | Income Statement | |||||
2019 | 2018 | 2019 | 2018 | |||
Assets | Sales (100% credit) | 1,330 | 1,100 | |||
Cash | 270 | 305 | Cost of goods sold | 760 | 600 | |
Accounts receivable | 290 | 275 | Gross profit | 570 | 500 | |
Inventory | 580 | 600 | Operating expenses | 30 | 20 | |
Current assets | 1,140 | 1,180 | Depreciation | 200 | 160 | |
Plant and equipment | 1,940 | 1,700 | Net operating income | 340 | 320 | |
Less: acc depr | -600 | -500 | Interest expense | 57 | 64 | |
Net plant and equipment | 1,340 | 1,200 | Net income before taxes | 283 | 256 | |
Total assets | 2,480 | 2,380 | Taxes | 96 | 87 | |
Net income | 187 | 169 | ||||
Liab. and Owners' Equity | ||||||
Accounts payable | 200 | 150 | ||||
Notes payable | 0 | 125 | ||||
Current liabilities | 200 | 275 | ||||
Bonds | 500 | 500 | ||||
Owners' Equity | ||||||
Common stock | 305 | 165 | ||||
Paid-in-capital | 775 | 775 | ||||
Retained earnings | 700 | 665 | ||||
Total Owners' Equity | 1,780 | 1,605 | ||||
Total Liab. and Owners' Equity | 2,480 | 2,380 |
Part 1 (8 marks). Compute the following ratios (to facilitate computation, first copy the information above and the ratio table below into Excel; second, complete the ratio table in Excel; third, paste it from Excel into the text box below).
2019 | 2018 | Industry | |
Current ratio | 5.00 | ||
Acid test ratio | 3.00 | ||
Inventory turnover | 2.20 | ||
Avg collection period (days) | 90 | ||
Debt ratio | 0.33 | ||
Times interest earned | 7.00 | ||
Total asset turnover | 0.75 | ||
Fixed asset turnover | 1.00 | ||
Operating profit margin | 20.00% | ||
Net profit margin | 12.00% | ||
Return on total assets | 9.00% | ||
Return on equity | 10.43% |
Part 2 (6 marks). In order to evaluate the firm, the bank would like to compare Baker & Co. to the industry. Discuss the strengths and weaknesses of Baker & Co. from this perspective (at least 3 strengths and 3 weaknesses, including an explanation for why you consider them strengths and weaknesses).
Part 3 (2 marks). Should the bank make the loan? Why or why not?
Step 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