{"id":218687,"date":"2018-09-16T16:17:00","date_gmt":"2018-09-16T16:17:00","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/16\/hcs-380-wileyplus-exercise-13-13-solution-with-excel-file\/"},"modified":"2018-10-24T08:53:29","modified_gmt":"2018-10-24T08:53:29","slug":"hcs-380-wileyplus-exercise-13-13-solution-with-excel-file","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/hcs-380-wileyplus-exercise-13-13-solution-with-excel-file\/","title":{"rendered":"HCS 380 Wileyplus   Exercise 13 13 (Solution with Excel file)"},"content":{"rendered":"<p>Just enter the value and get the answer, this excel file will work for any value\t\u00a0\t\u00a0\tThe condensed financial statements of Elliott Company for the years 2013 and 2014 are presented below.\t\u00a0\tELLIOTT COMPANY\tBalance Sheets\tDecember 31 (in thousands)\t2014\u00a0\u00a0\u00a0 2013\tCurrent assets\t\u00a0\u00a0 Cash and cash equivalents\u00a0\u00a0 $330\u00a0\u00a0\u00a0 $360\t\u00a0\u00a0 Accounts receivable (net)\u00a0\u00a0\u00a0 648 \ufffd 578\t\u00a0\u00a0 Inventory\u00a0\u00a0\u00a0\u00a0 655 \ufffd 585\t\u00a0\u00a0 Prepaid expenses \ufffd 130 \ufffd 160\t\u00a0\u00a0\u00a0\u00a0 Total current assets \ufffd \ufffd\u00a0 1,763\u00a0\u00a0 1,683\tProperty, plant, and equipment (net)\u00a0 410 \ufffd 380\tInvestments\u00a0\u00a0\u00a0\u00a0 188 \ufffd 188\tIntangibles and other assets\u00a0\u00a0\u00a0 530 \ufffd 510\t\u00a0\u00a0\u00a0\u00a0 Total assets $2,891 $2,761\tCurrent liabilities \ufffd\u00a0\u00a0\u00a0 $998\u00a0\u00a0\u00a0 $968\tLong-term liabilities\u00a0\u00a0\u00a0 675 \ufffd 575\tStockholders&#8217; equity&#8221;\ufffdcommon \ufffd\u00a0\u00a0\u00a0 1,218\u00a0\u00a0 1,218\t\u00a0\u00a0\u00a0\u00a0 Total liabilities and stockholders&#8217; equity\u00a0\u00a0 $2,891 $2,761\t\u00a0\tELLIOTT COMPANY\tIncome Statements\tFor the Year Ended December 31 (in thousands)\t2014\u00a0\u00a0\u00a0 2013\tSales revenue\u00a0 $3,995 $3,655\tCosts and expenses\t\u00a0\u00a0 Cost of goods sold\u00a0\u00a0 1,148\u00a0\u00a0 1,068\t\u00a0\u00a0 Selling &#038; administrative expenses\u00a0\u00a0 2,400\u00a0\u00a0 2,330\t\u00a0\u00a0 Interest expense \ufffd\u00a0 10 \ufffd\u00a0\u00a0 20\t\u00a0\u00a0\u00a0\u00a0 Total costs and expenses\u00a0\u00a0\u00a0 3,558\u00a0\u00a0 3,418\tIncome before income taxes\u00a0\u00a0 437 \ufffd 237\tIncome tax expense\u00a0\u00a0\u00a0 175 \ufffd 95\tNet income \ufffd $ 262\u00a0\u00a0 $ 142\t\u00a0\tCompute the following ratios for 2014 and 2013. (Round all answers to 2 decimal places, e.g. 1.83 or 12.61%.)\t\u00a0\t(a) \ufffd\u00a0\u00a0 Current ratio.\t(b) \ufffd\u00a0\u00a0 Inventory turnover. (Inventory on December 31, 2012, was $400.)\t(c) \ufffd\u00a0\u00a0 Profit margin.\t(d) \ufffd\u00a0 Return on assets. (Assets on December 31, 2012, were $2,700.)\t(e) \ufffd\u00a0\u00a0 Return on common stockholders&#8217; equity. (Equity on December 31, 2012, was $990.)\t(f) \ufffd\u00a0\u00a0 Debt to assets ratio.\t(g) \ufffd\u00a0\u00a0 Times interest earned.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Just enter the value and get the answer, this excel file will work for any value \u00a0 \u00a0 The condensed financial statements of Elliott Company for the years 2013 and 2014 are presented below. \u00a0 ELLIOTT COMPANY Balance Sheets December <a href=\"https:\/\/www.benedictsol.com\/blogs\/hcs-380-wileyplus-exercise-13-13-solution-with-excel-file\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-218687","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/218687","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=218687"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/218687\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=218687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=218687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=218687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}