Up Your Cashflow

Up Your Cash Flow

Business budget and cash flow forecasting software

Our Products

SmartStart XT-2 Advisory Services Free Trial Download! Free Training Webinar!
Where do we begin

 

15

 

All It Takes

Is Leadership

    The title of this chapter speaks for itself.

    Good luck and good skill.

Appendix

A Simplified Company Financial Statement

(A) YOUR COMPANY, INC.

BALANCE SHEET

As of _______________

ASSETS

 

 

 

 

 

 

 

 

(1)

CURRENT ASSETS

         
   

Cash

 

182,559

     
   

Accounts receivable—trade, net

of allowance for doubtful accounts

 

146,281

     
   

Inventory

 

160,993

     
   

Prepaid expenses

 

12,120

     
   

Deferred taxes

 

8,969

     

 

 

 

 

 

 

 

   

TOTAL CURRENT ASSETS

     

510,862

 

 

 

 

 

 

 

 

(2)

PROPERTY AND EQUIPMENT—At Cost

         
   

Automobiles

 

13,428

     
   

Office furniture and equipment

 

10,867

     
   

Plant machinery and equipment

 

125,019

     
   

Leasehold improvements

 

8,579

     
   

Land

 

126,150

     
       

284,043

     
   

Less accumulated depreciation

 

109,045

 

174,998

 

 

 

 

 

 

 

 

(3)

OTHER ASSETS

         
   

Investment

 

45,305

     
   

Deposits

 

2,050

     
   

Cash surrender value of officers’

life insurance

 

13,765

 

61,120

 

 

 

 

 

 

 

 

   

TOTAL ASSETS

     

746,980

 

 

 

 

 

LIABILITIES AND STOCKHOLDERS’ EQUITY

 

 

 

 

 

 

 

(4)

CURRENT LIABILITIES

         
   

Accounts payable

 

94,272

     
   

Accrued expenses

 

49,602

     
   

Payroll and sales taxes payable

 

7,308

     
   

Current portion of long-term debt

 

9,798

     
   

Income taxes payable

 

2,699

     
               
     

TOTAL CURRENT LIABILITIES

     

163,679

 
             
             

(5)

LONG-TERM DEBT,

Net of Current Portion Above

     

29,394

 
                 
     

TOTAL LIABILITIES

     

193,073

 
             
             

(6)

STOCKHOLDERS’ EQUITY

         
   

Common stock, no par value;

25,000 shares authorized,

3,180 shares issued and

outstanding

 

3,180

     
   

Retained earnings:

Balance—July 1, 19XX

431,240

         
   

Net income for the year ended—June 30, 19XX

119,487

 

550,727

 

553,907

 

 

 

 

 

 

 

 

 

   

TOTAL LIABILITIES AND

STOCKHOLDERS’ EQUITY

     

746,980

   

 

 

(B) YOUR COMPANY, INC.

STATEMENT OF INCOME

For the Period Ended _______________

 

 

     

Amount

 

%

(1)

SALES

   

 

1,336,454

 

 

100.0

                 

(2)

COST OF GOODS SOLD

         
   

Beginning inventory

146,653

       
   

Purchases

792,362

       
   

Total available

939,015

       
   

Less ending inventory

160,993

 

778,082

 

58.2

                 

(3)

GROSS PROFIT

   

558,372

 

41.8

                 

(4)

SELLING AND ADMINISTRATIVE EXPENSES

         
   

Selling expense

23,172

       
   

Administrative expense

88,031

 

111,203

 

8.3

                 
 

INCOME BEFORE OTHER INCOME

   

447,169

 

33.5

                 
 

OTHER INCOME

   

6,484

 

.4

                 

(5)

INCOME BEFORE OFFICERS’

       
   

COMPENSATION

   

453,653

 

33.9

                 

(6)

OFFICERS’ COMPENSATION

         
   

Salaries

250,600

       
   

Officers’ life insurance

1,566

 

252,166

 

18.9

                 

(7)

INCOME BEFORE PROVISION FOR

         
   

INCOME TAXES

   

201,487

 

15.0

                 
 

PROVISION FOR INCOME TAXES

   

82,000

 

6.1

                 

(8)

NET INCOME

   

119,498

 

8.9

(C) Your Company, Inc.

Statements of Cash Flows

For the Years Ended December 31,

 

         

2007

 

2006

 

 

 

 

 

 

 

 

CASH FLOWS FROM OPERATING ACTIVITIES

     
 

Cash received from customers

8,550,362

 

8,094,504

 

Cash paid to customers

(8,526,349)

 

(7,777,007)

 

Interest paid

(66,773)

 

(66,519)

 

Interest received

9,653

 

12,087

 

Income taxes received (paid)

51,515

 

(79,364)

   

NET CASH PROVIDED BY OPERATIONS ACTIVITIES

18,408

 

183,701

CASH FLOWS FROM INVESTING ACTIVITES

     
 

Purchase of property and equipment

(84,444)

 

(22,370)

 

Proceeds from sale of assets

 

6,465

 

Collections from (advances to) employees

1,032

 

(5,783)

   

NET CASH (USED IN) INVESTING ACTIVITIES

(83,412)

 

(21,688)

CASH FLOWS FROM FINANCING ACTIVITES

     
 

Net borrowings (payments) on long-term debt

28,456

 

(94,304)

 

Proceeds from common stock subscribed

8,000

 

4,942

   

NET CASH PROVIDED BY

36,456

 

(89,362)

     

(USED IN) FINANCING ACTIVITES

     

NET (DECREASE) INCRASE IN

(28,548)

 

72,651

 

CASH AND CASH EQUIVALENTS

     

CASH AND CASH EQUIVALENTS -

85,694

 

13,043

   

Beginning of Year

     

CASH AND CASH EQUIVALENTS -

57,146

 

85,694

   

End of Year

     

 

 

 

 

 

 

 

 

RECONCILIATION OF NET (LOSS) TO NET CASH

     
 

PROVIDED BY OPERATING ACTIVITIES

     
   

Net (loss)

(104,141)

 

(174,413)

   

Non-cash expenses included in net (loss):

     
     

Depreciation and amortization

134,339

 

180,166

     

Loss on sale of assets

 

10,954

     

Provision for deferred taxes

(62,348)

 

(60,900)

     

Allowance for bad debts

10,026

 

31,687

   

Changes in assets and liabilities

     
     

(Increase) decrease in accounts receivable

(61,405)

 

113,461

     

(Increase) decrease in unbilled

(129,187)

 

132,108

       

accounts receivable

     
     

(Increase) decrease in deposits

(15,010)

 

129,538

     

Decrease (increase) in prepaid income taxes

48,231

 

(97,512)

     

Increase (decrease) in accounts

215,775

 

(82,431)

       

payable and accrued expenses

     
     

(Decrease) increase in accrued

(17,872)

 

1,043

       

pension costs

     

NET CASH PROVIDED BY

18,408

 

183,701

 

OPERATING ACTIVITIES

     

 

(D) YOUR COMPANY, INC.

SCHEDULE OF SELLING AND ADMINISTRATIVE EXPENSES

For the Period Ended _______________

 

       

 

Amount

 

 

%

             

SELLING EXPENSES

     
 

Advertising

1,645

 

.1

 

Automobile

12,238

 

.9

 

Conventions

170

 

 

Commissions

4,532

 

.3

             
 

Freight-out

765

 

.1

 

Insurance

1,606

 

.1

 

Promotion

1,566

 

.1

 

Travel

650

 

.1

             
   

TOTAL SELLING EXPENSES

23,172

 

1.7

             
             

ADMINISTRATIVE EXPENSES

     
 

Bad debts

4,303

 

.3

 

Dues and subscriptions

370

 

 

Employee benefits

1,102

 

.1

 

Interest

4,257

 

.2

 

Janitors

1,924

 

.2

             
 

Office

2,783

 

.2

 

Professional fees

10,681

 

.8

 

Profit-sharing plan

48,308

 

3.6

 

Relocation

881

 

.1

 

Repairs

167

 

             
 

Rent

2,612

 

.2

 

Salaries-office

5,035

 

.4

 

Taxes and licenses

527

 

 

Taxes—payroll

784

 

.1

 

Telephone

4,297

 

.3

             
   

TOTAL ADMINISTRATIVE EXPENSES

88,031

 

6.5