2. Prepare a memo to the CEO of Halloran company summarizing your findings about the financial health of the company, using your calculations from above as evidence to support your conclusions. 3.
HALLORAN COMPANY Trend Analysis Income Statements For the year Ended December 31,2017-2013 (S thousands) 2017 2016 2015 Sales 143% 126% 116% Cost of goods sold 166% 137% 120% Gross profit 103% 107% 108% Operating Expenses 225% 175% 100% Net Income 41% 72% 81% 2014 107% 107% 106% 116% 101% 2013 100% 100% 100% 100% 100% 2015 2014 2013 HALLORAN COMPANY Trend Analysis balance sheet For the year Ended December 31,2017-2013 (S thousands) 2017 2016 Assets Cash 88% 89% Accounts receivable, net 154% 162% Merchandise inventory 196% 146% Other current assets 129% 114% Long-term Investments 0% 0% Plant assets, net 206% 206% Total assets 179% 160% Liabilities and equity Current liabilities 223% 191% Long-term liabilities 223% 197% Common stock (118% 118% Other paid-in Capital 158% 147% Retained Earnings 195% 164% Total Liabilities and equity 179% 160% 94% 146% 129% 52% 10% 179% 141% 95% 113% 110% 124% 100% 96% 104% 100% 100% 100% 100% 100% 100% 100% 131% 112% 192% 98% 118% 100% 147% 100% 126% 114% 127% 104% 100% 100% 100% 100% 100% 100% HALLORAN COMPANY Trend Analysis Income Statements For the year Ended December 31,2017-2013 (S thousands) 2017 2016 2015 Sales 143% 126% 116% Cost of goods sold 166% 137% 120% Gross profit 103% 107% 108% Operating Expenses 225% 175% 100% Net Income 41% 72% 81% 2014 107% 107% 106% 116% 101% 2013 100% 100% 100% 100% 100% 2015 2014 2013 HALLORAN COMPANY Trend Analysis balance sheet For the year Ended December 31,2017-2013 (S thousands) 2017 2016 Assets Cash 88% 89% Accounts receivable, net 154% 162% Merchandise inventory 196% 146% Other current assets 129% 114% Long-term Investments 0% 0% Plant assets, net 206% 206% Total assets 179% 160% Liabilities and equity Current liabilities 223% 191% Long-term liabilities 223% 197% Common stock (118% 118% Other paid-in Capital 158% 147% Retained Earnings 195% 164% Total Liabilities and equity 179% 160% 94% 146% 129% 52% 10% 179% 141% 95% 113% 110% 124% 100% 96% 104% 100% 100% 100% 100% 100% 100% 100% 131% 112% 192% 98% 118% 100% 147% 100% 126% 114% 127% 104% 100% 100% 100% 100% 100% 100%