1) Prepare a common size income statement by expressing each item of the income
ID: 2739706 • Letter: 1
Question
1) Prepare a common size income statement by expressing each item of the income statement as a percent of total revenue. Based on your common size Income Statement, what is net income to sales average ratio over the period 2011 to 2015?
2) What was Glacier’s current ratio and total debt (liabilities) to equity ratio in 2015?
3)What was Glacier’s net profit margin and return on equity in 2015?
4) What was Glacier’s market-to-book ratio and price/earnings ratio in 2015?
5) What was Glacier’s implied tax rate and implied interest rate on debt in 2015? Please, calculate debt as average of long-term debt plus current debt over two years (2015 and 2014).
6) What was Glacier’s change in the Net working capital in 2015 as compared to 2014?
Standardized Annual Balance Sheet Report Date 1213112011 1213112012121311201312131120141213112015 ThousandsThousandsThousands Thousands Thousands $ 375,441$ 477,073$392,629$443,132$435,093 184,242 619.335 Cash& Equivalents Short Term Investments Cash & Equivs & ST Investments Receivables (ST) Inventories Current Ta Assets Prepayments(ST) Other Current Assets Total Current Assets Gross Property Plant & Equip Accumulated Depreciation Net Property Plant & Equip Long Term Investments Intangible Assets Deferred LT Assets 159,426 534,867 229,091 197,196 674.2659 205,117 99,960 134.684 527.313 192,620 103,309 37,085 185,783 628.915 175,947 100,328 38,805 89,392 32,010 11,989 949.467 517,037 415,184 101,853 46.484 572,840 89,865 21,738 832.780 $1,844,805 $ 1,915,351 $1,749,030 $1,831,222 1,782,247 6,587 1,073.253 421,901 288,582 133,319 50,333 608,802 953,565 385,491 255,444 130,047 9,937 901428 458,842 343,685 115,157 17,140 998,520 485,938 376,743 109.195 663,070 596,918 583,798 54,019 26,493 832.702 21,238 842.098 27,757 847,602 Total Non-Current Assets 891.240 Total Assets 89.983 103,950 84,640 116,515 6,250 179,188 386,593 Accounts Payable ed Expenses 124,975 6,250 181,707 421,104 97,543 122,187 rent Other Current Liabilities Total Current Liabilities I T neht &leases; 147,700 359.165 161,755 355,688 176,590 377,9686Explanation / Answer
Question 2) Year 2015
Current Ratio = Current assets / Current Liabilities = 949467 / 377966 = 2.51 : 1
Total debt (liabilities) to equity ratio = Total Liabilities / Total Equity = 729038 / 1053209 = 0.69
Question 3) Year 2015
Net Profit margin = Net Profit / Sales = 69975 / 1267225 = 0.0552 i.e., 5.52 %
Return on equity = Net income / Total Equity = 69975 / 1053209 = 0.0664 i.e., 6.64 %
Question 4) Year 2015
Market-to-book ratio = Market price per share / Book value per share
Market price per share = 12.59 (Given in question)
Book value per share = Common share capital + Additional paid-in capital / Total number of shares
= 66 + 1167701 / 132665
= 1167767 / 132665
= 8.80
Market-to-book ratio = 12.59 / 8.80 = 1.43
Price/earnings ratio = Market price per share / Earnings per share
Earnings per share = Net income / Number of shares outstanding = 69975 / 132665 = 0.53 (approx)
Price/earnings ratio = 12.59 / 0.53 = 23.75
Question 6) Glacier’s change in the Net working capital in 2015 as compared to 2014:-
Working capital in year 2015 = Total Current assets - Total Current Liabilities = 949467 - 377966 = $ 571501
Working capital in year 2014 = Total Current assets - Total Current Liabilities = 998520 - 421104 = $ 577416
Change in working capital = Working capital in year 2015 - Working capital in year 2014
= 571501 - 577416
= (-) 5915 Dollars.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.