Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

BALANCE SHEET 2015 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 $

BALANCE SHEET 2015
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.7 1.6
Quick Ratio 0.9 1 0.96 0.9
Operating Cash Flow n/a n/a ?
ASSET MANAGEMENT RATIOS 2013 2014 2015 Industry Average
Inventory Turnover 6 5 4.5 8.4
Average Collection Period 40 50 64.36 40
Fixed Asset Turnover n/a n/a
Total Asset Turnover 1.5 1.5 1.34 1.75
DEBT MANAGEMENT RATIOS 2013 2014 2015 Industry Average
Debt Ratio 60% 56% 53.3% 50%
Times Interest Earned 2.5 3.5 ? 4
PROFITABILITY RATIOS 2013 2014 2015 Industry Average
Gross Profit Margin 20% 19.70% 18.9% 20%
Operating Profit Margin 4.70% 4.80% 5.14% 6%
Net Profit Margin 2% 2.30% 2.53% 3%
Return on Investment 3.00% 3.50% ? 5.25%
Return on Equity 7.50% 7.95% ? 10.50%

I am not sure how to calculate the items with the ?; I've calculated the other 2015 figures. Can someone help by displaying the actual calculations and the values that correspond?

I am trying to understand rather than just get answers.

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

Students also viewed these Finance questions

Question

1. Write down two or three of your greatest strengths.

Answered: 1 week ago

Question

What roles have these individuals played in your life?

Answered: 1 week ago

Question

2. Write two or three of your greatest weaknesses.

Answered: 1 week ago