Answered step by step
Verified Expert Solution
Question
1 Approved Answer
BUSI 320 Textbook Assignment 1 NAME: Balance Sheet info: Cash Accounts Receivable Inventory Total Current Assets Fixed Assets (Net) 12/31/2016 60,000 $ 80,000 $ 110,000
BUSI 320 Textbook Assignment 1 NAME: Balance Sheet info: Cash Accounts Receivable Inventory Total Current Assets Fixed Assets (Net) 12/31/2016 60,000 $ 80,000 $ 110,000 $ 250,000 $ 300,000 $ 550.000 5 12/31/2017 63,600 84,000 126,500 274,100 312,000 586.100 Compute each of the following ratios for 2016 and 2017 and indicate whether each ratio was getting "better" or "worse" from 2016 to 2017 and was "good" or "bad"compared to the Industry average for 2017. (round all numbers to 2 digits past the decimal place. ex: 22.94%) Total Assets Type your answers in the table below and submit this document. Current Liabilities Long Term Liabilities Total Liabilities Stockholder's Equity Total Liab & Equity: 130,000 $ 150,000 $ 280,000 $ 270,000 $ 550,000 Ratios Enter "Better" or "Worse" 149,500 170,000 319,500 266,600 585.100 2017 Enter "Good" or Industry | "Bad" compared to Industry Avg 2016 2017 Avg $ $ Profit Margin Current Ratio Quick Ratio Return on Assets Debt to Assets Receivables turnover Avg. collection period Inventory Turnover++ Return on Equity Times Interest Earned 0.09 1.80 32 1.12 33 0.18 0.60 12.00 36 22.10 37 8.25 0.16 29 8.1540 10 *Assume a 380 day year Inventory Turnover can be computed 2 different ways. Use the formula listed in the text (the one the text indicates many credit reporting agencies generally use) Use the following information to answer the questions:_(Balance Sheet on the next page) note: all sales ore credit sales Income Stmt info: Sales $ less Cost of Goods Sold:- Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Net Income $ 2016 975,000 $ 325,000 650,000 575.000 75,000 25,000 50,000 20,000 30,000 $ 2017 1,072,500 346,125 726,375 609.500 116,875 31,000 85,875 34,350 51,525
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