The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 286 Weeks Ago, 6 Days Ago |
| Questions Answered: | 27237 |
| Tutorials Posted: | 27372 |
MCS,MBA(IT), Pursuing PHD
Devry University
Sep-2004 - Aug-2010
Assistant Financial Analyst
NatSteel Holdings Pte Ltd
Aug-2007 - Jul-2017
QUESTION 3. Ratio AnalysisÂ
The financial statements of Skye Plumbing Inc. appear below:Â
SKYE PLUMBING INC.Â
Comparative Balance SheetÂ
December 31Â
Assets 2014 2013Â
Cash .............................................................................................. $ 25,000 $ 40,000Â
Trading securities ........................................................................... 15,000 60,000Â
Accounts receivable ....................................................................... 50,000 30,000Â
Inventory ........................................................................................ 170,000 120,000Â
Total Current Assets: ...................................................................... 260,000 250,000Â
Property, plant, and equipment (net) .............................................. 160,000 200,000Â
Total assets .............................................................................. $420,000 $450,000Â
Liabilities and shareholders' equityÂ
Accounts payable ........................................................................... $ 20,000 $ 30,000Â
Short-term notes payable ............................................................... 40,000 40,000Â
Total Current Liabilities 60,000 70,000Â
Bonds payable ............................................................................... 100,000 160,000Â
Total Liabilities: 160,000 230,000Â
Common shares ............................................................................. 170,000 145,000Â
Retained earnings .......................................................................... 90,000 75,000Â
Total liabilities and shareholders' equity ................................... $420,000 $450,000Â
Page 3 of 4Â
SKYE PLUMBING INC.Â
Income StatementÂ
Year Ended December 31, 2014Â
Net sales ........................................................................................ $360,000Â
Cost of goods sold ......................................................................... 184,000Â
Gross profit .................................................................................... 176,000Â
ExpensesÂ
Interest expense ...................................................................... $24,000Â
Operating expenses ................................................................ 50,000Â
Total expenses ................................................................... 74,000Â
Net Income before income taxes .................................................... 102,000Â
Income tax expense ....................................................................... 30,000Â
Net Income after taxes ................................................................... $ 72,000Â
Â
Required:Â
A) Using the financial statements , calculate the following ratios for Skye Plumbing Inc. for 2014. Show all calculations, round to nearest two decimal places.Â
a. Current ratio _________Â
b. Return on shareholders equity (use Net income after taxes) _________Â
c. Debt to total assetsÂ
e. Age of Receivables _________Â
f. Times Interest earned (use Net Income before taxes)_________Â
g. Net Income margin (use Net Income after taxes)_________Â
h. Inventory turnover _________Â
i. Return on assets (use Net Income after taxes)_________Â
Â
B) Select 5 ratios you calculated above, and comment on which ratios performed well and which ratios were not that strong and why, what do they measure? You may want to calculate 2013 ratios to compare to 2014 ratios.
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------