Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Conduct a financial analysis of the firm including calculating ratios in the following areas: Liquidity Asset management Debt Management Profitability Internal and Sustainable Growth Write

  1. Conduct a financial analysis of the firm including calculating ratios in the following areas:
    • Liquidity
    • Asset management
    • Debt Management
    • Profitability
    • Internal and Sustainable Growth
  2. Write Executive Summary about the firm's performance based on your analysis.
Balance Sheet (000's omitted) YR 7 Debits Credits YR 8 Debits Credits YR 9
Assets






Cash and cash equivalents 6,600
767 5,833 1,241
7,074
Accounts receivable 1,820 1,700
3,520 300
3,820
Allowance for Doubtful Accounts (20) 0
(20) 0
(20)
Net Accounts Receivable 1,800

3,500

3,800
Inventory 6,880 13,500
20,380 2,507
22,887
Other Current Assets 7,000 100
7,100 1,150
8,250
Current Assets 22,280

36,813

42,011








Property, Plant, and Equipment 35,200 105,616
140,816

140,816
Less Depreciation 3,200
15,436 18,636
13,524 32,160
Property, Plant, and Equipment, net 32,000

122,180

108,656
L-T Investments 12,500
4,000 8,500 2,000
10,500
Intangible Assets 0

0

0
Other L-T Assets 12,370 5,350
17,720
2,507 15,213
Total Assets 79,150

185,213

176,380








Liab. & Equity






Accounts payable 3,250
4,091 7,341
383 7,724
LOC Payable 8,600
900 9,500 900
8,600
Other Current Liabilities 0
0 0
0 0
Accrued Liabilities 2,027
2,646 4,673
450 5,123
Current Maturities Long Term Debt 5,500
9,500 15,000
0 15,000
Total Current Liabilities 19,377

36,514

36,447








Long-Term Notes Payable - Bank 0
40,000 40,000 10,000
30,000
Long-Term Notes Payable - Former Owners Chicago 0
45,000 45,000 5,000
40,000
Total Liabilities 19,377

121,514

106,447








Shareholders' Equity






Common Stock, par value $0.01 per share, 20,000,000 authorized; 5,000,000 issued and outstanding on December 31, 2007 50

50

50
Additional Paid-In Capital 4,950

4,950

4,950
Retained Earnings 54,773
3,926 58,699
6,234 64,933
Total Shareholders' Equity 59,773 126,266 126,266 63,699 23,098 23,098 69,933
Total Liabilities and Shareholders' Equity 79,150
0 185,213
0 176,380
















































Income Statement YR 7 Debits Credits YR 8 Debits Credits YR 9
Company-Operated Retail 77,652
182,360 182,360
187,000 187,000
Other Sales -Commercial/ Internet 3,828
11,640 11,640
13,000 13,000
Total Net Sales 81,480

194,000
200,000 200,000
Total Cost of Sales and related occupancy costs 32,590 83,420
83,420 88,078
88,078
Store employees PT counter staff, inventory 27,500 64,356
64,356 68,425
68,425
Store Supervisors 5,090 19,064
19,064 19,653
19,653
Gross Margin 48,890

110,580

111,922
Operating Expenses 30,148

69,840 72,000
72,000
General and Administrative Expenses 4,237

9,500

9,600
Executives Salaries/Benefits and Fringes 678 1,520
1,520 1,536
1,536
Human Resources Salaries and Benefits 362 811
811 820
820
Training 88 198
198 200
200
Advertising and Recruiting:HR 128 287
287 290
290
Finance &Accounting 287 643
643 650
650
Professional Services 79 178
178 180
180
New Product Development 66 148
148 150
150
Public Relations 45 102
102 103
103
(MIS)IT : Salaries and Benefits 1,472 3,300
3,300 3,335
3,335
IT opns cost and telecommunications 692 1,550
1,550 1,565
1,565
Travel and Entertainment 221 496
496 501
501
Occupancy 119 267
267 270
270
Marketing Expenses 815 2,250
2,316 2,250
2,316
Salaries, Benefits and Training 226

624

624
Advertising 191

527

527
Promotions 385

1,065

1,065
Web Development 13

100

100
EBITDA 13,690

28,924

28,006








Depreciation and Amortization 3,200 15,436
15,436 13,524
13,524
Earnings from Operations 10,490

13,488

14,482








Interest Income 831
649 649
860 860
Interest Expense 664 6,575
6,575 5,606
5,606
Earnings Before Income Taxes (EBIT) 10,657

7,562

9,736
Income Taxes 3,730

3,636 3,502
3,502
Net Income 6,927

3,926

6,234
















Statement of Cash Flows


YR 8

YR 9
Cash Flows From Operating Activities






Net Income


3,926

6,234
Adjustments to reconcile net earnings to net cash provided by operating activities






Depreciation


15,436

13,524
(Increase) decrease in Inventory


(13,500)

(2,507)
(Increase) in Accounts Receivable


(1,700)

(300)
(Increase) decrease in Other Current Assets


(100)

(1,150)
(Increase) decrease in Other Long Term Assets


(5,350)

2,507
Increase (decrease) in Accounts Payable


4,091

383
Increase (decrease) in Accrued Liabilities


2,646

450
Net Cash Provided by Operating Activities


5,449

19,141








Cash Flows from Investing activities






(Increase) decrease in Property, Plant, Equipment


(105,616)

0
(Increase) decrease in LT Investments


4,000

(2,000)
(Increase) decrease in Intangible Assets


0

0
Net cash flows from investing activities


(101,616)

(2,000)








Cash Flows from Financing activities






Increase (decrease) in LOC Payable


900

(900)
Increase (decrease) Current Maturities Long Term Debt


9,500

0
Increase (decrease)in Loan Payable Bank


40,000

(5,000)
Increase (decrease) in LT Notes Payable Former Owners


45,000

(10,000)
Net cash flows from financing activities


95,400

(15,900)








Net (decrease) increase in cash and cash equivalents


(767)

1,241








Beginning Cash


6,600

5,833
Ending Cash


5,833

7,074




5,833

7,074
  1.  


  1.  

Step by Step Solution

3.38 Rating (139 Votes )

There are 3 Steps involved in it

Step: 1

Answer YouConduct a financial analysis of the firm including calculating ratios in the following areasLiquidityAsset managementDebt ManagementProfitabilityInternal and Sustainable GrowthWrite Executiv... 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

Principles of Finance

Authors: Scott Besley, Eugene F. Brigham

6th edition

9781305178045, 1285429648, 1305178041, 978-1285429649

More Books

Students also viewed these Finance questions

Question

=+e) What probably happened to earnings after the initial 17 days?

Answered: 1 week ago