Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello I just need this problem for finance figured out thank you for the assistance BUSI 320 Comprehensive Problem 1 Spring D 2016 Use the

image text in transcribed

Hello I just need this problem for finance figured out

thank you for the assistance

image text in transcribed BUSI 320 Comprehensive Problem 1 Spring D 2016 Use the following information to answer the questions below: note: all sales are credit sales Income Stmt info: Sales $ less Cost of Goods Sold: Gross Profit 2014 1,100,000 $ 450,000 650,000 2015 1,188,000 481,500 706,500 Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Net Income $ 330,000 320,000 25,000 295,000 118,000 177,000 $ 346,500 360,000 30,000 330,000 132,000 198,000 Balance Sheet info: Cash Accounts Receivable 12/31/2014 60,000 $ 80,000 $ 12/31/2015 72,000 81,600 Inventory Total Current Assets Fixed Assets (Net) $ $ 110,000 $ 250,000 $ 300,000 $ 135,000 288,600 315,000 Total Assets $ 550,000 $ 603,600 Current Liabilities Long Term Liabilities Total Liabilities $ $ $ 130,000 $ 150,000 $ 280,000 $ 139,100 183,000 322,100 Stockholder's Equity $ 270,000 $ 281,500 Total Liab & Equity: $ 550,000 $ 603,600 Compute each of the following ratios for 2014 and 2015 and indicate whether each ratio was getting "better" or "worse" from 2014 to 2015 and was "good" or "bad" when compared to the Industry Avg in 2015 (round all numbers to 2 digits past the decimal place) 2014 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 Getting Better or Getting 2015 Worse? "Good" or "Bad" 2015 compared Industry to Industry Avg Avg 0.11 1.90 1.12 .28 0.55 18.00 21.20 8.25 0.55 11.15 *Assume a 360 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) BUSI 320 Comprehensive Problem 1 Spring D 2016 Use the following information to answer the questions on page 2 below: (note: all sales are credit sales) Income Stmt info: 2014 Sales $ 1,100,000 2015 $ 1,188,000 less Cost of Goods Sold: 450,000 481,500 Gross Profit 650,000 706,500 Operating Expenses 330,000 346,500 Earnings before Interest & Taxes 320,000 360,000 Interest exp 25,000 30,000 earnings before Taxes 295,000 330,000 Taxes 118,000 132,000 Net Income $ Balance Sheet info: 177,000 $ 12/31/2014 198,000 12/31/2015 Cash 60,000 $ 72,000 Accounts Receivable 80,000 $ 81,600 110,000 $ 135,000 Inventory Total Current Assets $ 250,000 $ 288,600 Fixed Assets (Net) $ 300,000 $ 315,000 Total Assets $ 550,000 $ 603,600 Current Liabilities $ 130,000 $ 139,100 Long Term Liabilities $ 150,000 $ 183,000 Total Liabilities $ 280,000 $ 322,100 Stockholder's Equity $ 270,000 $ 281,500 Total Liab & Equity: $ 550,000 $ 603,600 Compute each of the following ratios for 2014 and 2015 and indicate whether each ratio was getting "better" or "worse" from 2014 to 2015 and was "good" or "bad" when compared to the Industry Avg in 2015 (round all numbers to 2 digits past the decimal place) 2014 Profit Margin Current Ratio Quick Ratio Getting Better or Getting 2015 Worse? 2015 Industry Avg 0.11 1.90 "Good" or "Bad" compared to Industry Avg 1.12 Return on Assets .28 Debt to Assets .55 Receivables turnover 18.00 Avg. collection period* 21.20 Inventory Turnover** 8.25 Return on Equity 0.55 Times Interest Earned 11.15 *Assume a 360 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Finance Markets, Investments and Financial Management

Authors: Ronald W. Melicher, Edgar A. Norton

16th edition

1119398282, 978-1-119-3211, 1119321115, 978-1119398288

More Books

Students also viewed these Finance questions

Question

3. Call on low achievers as often as you do high achievers.

Answered: 1 week ago