Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problems 1 and 2 BALANCE SHEET 2015 INSTRUCTIONS: Analyze the firm's performance from both time-series and cross-sectional points of view using the key financial ratios

Problems 1 and 2
BALANCE SHEET 2015 INSTRUCTIONS: Analyze the firm's performance from both time-series and cross-sectional points of view using the key financial ratios provided. PROVIDE YOUR WRITTEN ANALYSIS IN THIS COLUMN.
Assets
Cash and Equivalents $ 237,500.00
Accounts Receivable $ 592,500.00
Inventory $ 607,500.00
Total Current Assets $ 1,437,500.00
Gross Fixed Assets $ 1,250,000.00
Less Accumulated Depreciation $ 187,500.00
Net Fixed Assets $ 1,062,000.00
Total Assets $ 2,500,000.00
Liabilities and Equity
Current Liabilities
Accounts Payable $ 222,500.00
Notes Payable $ 422,500.00
Accruals $ 217,500.00
Total Current Liabilities $ 862,500.00
Long Term Debt $ 470,000.00
Total Liabilities $ 1,332,500.00
Stockholder's Equity
Common Stock $ 637,500.00
Retained Earnings $ 530,000.00
Total Stockholders Equity $ 1,167,500.00
Total Liabilities & Equity $ 2,500,000.00
INCOME STATEMENT
Sales Revenue $ 3,360,000.00
Cost of Sales $ 2,724,960.00
Gross Profits $ 635,040.00
Less: Operating Expenses
Selling Expense $ 251,200.00
General S&A $ 163,200.00
Depreciation $ 48,000.00
Total Operating Expenses $ 462,400.00
Total Operating Profit $ 172,640.00
Less: Interest Expense $ 31,200.00
Net Profits Before Taxes $ 141,440.00
Less Taxes (40%) $ 56,576.00
Net Profits After Taxes $ 84,864.00
LIQUIDITY RATIOS 2013 2014 2015 Industry Average
Current Ratio 1.5 1.7 1.6
Quick Ratio 0.9 1 0.9
Operating Cash Flow n/a n/a
ASSET MANAGEMENT RATIOS 2013 2014 2015 Industry Average
Inventory Turnover 6 5 8.4
Average Collection Period 40 50 40
Fixed Asset Turnover n/a n/a
Total Asset Turnover 1.5 1.5 1.75
DEBT MANAGEMENT RATIOS 2013 2014 2015 Industry Average
Debt Ratio 60% 56% 50%
Times Interest Earned 2.5 3.5 4
PROFITABILITY RATIOS 2013 2014 2015 Industry Average
Gross Profit Margin 20% 19.70% 20%
Operating Profit Margin 4.70% 4.80% 6%
Net Profit Margin 2% 2.30% 3%
Return on Investment 3.00% 3.50% 5.25%
Return on Equity 7.50% 7.95% 10.50%

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

Probability For Risk Management

Authors: Matthew J. Hassett, Donald G. Stewart

2nd Edition

156698548X, 978-1566985482

More Books

Students also viewed these Finance questions