Financial Management - SCORE Northern Nevada

fivesenegaleseΔιαχείριση

10 Νοε 2013 (πριν από 3 χρόνια και 9 μήνες)

55 εμφανίσεις

Revised
05/30/13

Your Name &
Your Business
Name

Describe Your
Business

The benefit is
to help you
learn to
better
manage your
business

Create effective
relationships with
your trusted
advisors

Measure your
company’s
financial health
(and yours)

Understand basics
of Cost
Accounting

Manage Business
Risks and Cash

How to utilize
Cash Flow
Forecasting and
Budgeting



FINANCING (Description)
Month 1
Month 2
(s) Loan Principal Payment
(t) Capital Purchases [Specify]
(u) Other Start-up Costs
(v) Reserve and/or Escrow [Specify]
(w) Owner's Withdrawal
3,000
$

3,000
$

6. TOTAL CASH PAID OUT
[Total 5a thru 5w]
30,223
$

34,314
$

7. CASH POSITION
[End of month] (4 minus 6)
9,272
$

10,055
$

Monthly Cash Flow Projection

Enter Company Name Here

Enter Date Here



Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

TOTAL

1. CASH ON HAND

[Beginning of month]


$10,000


$ 9,272


$10,055


$ 9,298


$ 8,879


$ 5,830


$ 2,151


$ (912)


$ (1,710)


$ (63)


$ 4,357


$ 8,005



2. CASH RECEIPTS



(a)Sales (45% of Sales)


$12,500


$13,875


$14,290


$15,750


$ 16,785


$ 17,525


$ 18,525


$ 17,650


$ 17,325


$ 16,350


$ 15,675


$ 13,250


189,500

(b) Collections from Credit Accounts (55% of Previous Mo Sales)


$16,995


$16,222


$19,303


$19,851


$ 21,231


$ 20,909


$ 21,139


$ 21,815


$ 21,706


$ 21,467


$ 22,174


$ 20,817


243,629

(c) Loan or Other Cash Injection


$
-



$ 5,000


$ 2,500


$ 3,000


$
-



$
-



$
-



$
-



$
-



$ 2,500






13,000

3. TOTAL CASH RECEIPTS


[2a + 2b + 2c=3]


$29,495


$35,097


$36,093


$38,601


$ 38,016


$ 38,434


$ 39,664


$ 39,465


$ 39,031


$ 40,317


$ 37,849


$ 34,067


446,129

4. TOTAL CASH AVAILABLE


[Before cash out] (1 + 3)


$39,495


$44,369


$46,149


$47,900


$ 46,895


$ 44,263


$ 41,815


$ 38,553


$ 37,321


$ 40,254


$ 42,206


$ 42,072



5. CASH PAID OUT



(a) Purchases (Merchandise, Inventory, Raw Materials)


$11,798


$14,039


$16,242


$17,371


$ 19,008


$ 19,217


$ 19,832


$ 18,943


$ 17,564


$ 16,127


$ 15,140


$ 15,330


200,610

(b) Gross Wages (excludes withdrawals)


$ 7,500


$ 8,500


$ 8,500


$ 9,000


$ 9,250


$ 9,500


$ 9,500


$ 8,000


$ 8,000


$ 8,000


$ 7,500


$ 7,500


100,750

(c) Payroll Expenses (Taxes, Benefits, etc.)


$ 2,625


$ 2,975


$ 2,975


$ 3,150


$ 3,238


$ 3,325


$ 3,325


$ 2,800


$ 2,800


$ 2,800


$ 2,625


$ 2,625


35,263

(d) Outside Services


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


1,200

(e) Supplies (Office and operating)


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


$ 100


1,200

(f) Repairs and Maintenance


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


6,000

(g) Advertising


$ 1,500


$ 2,000


$ 2,250


$ 2,500


$ 2,500


$ 2,500


$ 2,500


$ 2,500


$ 2,000


$ 2,000


$ 2,000


$ 1,500


25,750

(h) Auto, Delivery, and Travel


$ 150


$ 150


$ 200


$ 300


$ 350


$ 350


$ 350


$ 300


$ 300


$ 250


$ 200


$ 150


3,050

(i) Accounting and Legal


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(j) Rent


$ 1,500


$ 1,500


$ 1,500


$ 1,500


$ 1,500


$ 1,500


$ 1,500


$ 1,500


$ 1,500


$ 1,500


$ 1,500


$ 1,500


18,000

(k) Telephone


$ 250


$ 250


$ 250


$ 250


$ 250


$ 250


$ 250


$ 250


$ 250


$ 250


$ 250


$ 250


3,000

(l) Utilities


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


6,000

(m) Insurance


$ 200


$ 200


$ 200


$ 200


$ 200


$ 200


$ 200


$ 200


$ 200


$ 200


$ 200


$ 200


2,400

(n) Taxes (Real Estate, etc.)


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(o) Interest on LOC


$
-



$
-



$ 33.33


$ 50.00


$ 70.00


$ 70.00


$ 70.00


$ 70.00


$ 70.00


$ 70.00


$ 86.67


$ 86.67


677

(p) Other Expenses [Specify each]


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


$ 500


6,000




-


(q) Miscellaneous [Unspecified]


-


(r) Subtotal


$27,223


$31,314


$33,850


$36,021


$ 38,065


$ 38,612


$ 39,227


$ 36,263


$ 34,384


$ 32,897


$ 31,201


$ 30,842


409,899

(s) Loan Principal Payment


-


(t) Capital Purchases [Specify]


-


(u) Other Start
-
up Costs


-


(v) Reserve and/or Escrow [Specify]


-


(w) Owner's Withdrawal


$ 3,000


$ 3,000


$ 3,000


$ 3,000


$ 3,000


$ 3,500


$ 3,500


$ 4,000


$ 3,000


$ 3,000


$ 3,000


$ 3,000


38,000

6. TOTAL CASH PAID OUT


[Total 5a thru 5w]


$30,223


$34,314


$36,850


$39,021


$ 41,065


$ 42,112


$ 42,727


$ 40,263


$ 37,384


$ 35,897


$ 34,201


$ 33,842


447,899

7. CASH POSITION


[End of month] (4 minus 6)


$ 9,272


$10,055


$ 9,298


$ 8,879


$ 5,830


$ 2,151


$ (912)


$ (1,710)


$ (63)


$ 4,357


$ 8,005


$ 8,230



Monthly Cash Flow Projection

Enter Company Name Here

Enter Date Here



Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

TOTAL

1. CASH ON HAND

[Beginning of month]


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-




2. CASH RECEIPTS



(a)Sales (45% of Sales)


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(b) Collections from Credit Accounts (55% of Previous Mo Sales)


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(c) Loan or Other Cash Injection


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-







-


3. TOTAL CASH RECEIPTS


[2a + 2b + 2c=3]


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


4. TOTAL CASH AVAILABLE


[Before cash out] (1 + 3)


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-




5. CASH PAID OUT



(a) Purchases (Merchandise, Inventory, Raw Materials)


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(b) Gross Wages (excludes withdrawals)


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(c) Payroll Expenses (Taxes, Benefits, etc.)


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(d) Outside Services


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(e) Supplies (Office and operating)


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(f) Repairs and Maintenance


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(g) Advertising


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(h) Auto, Delivery, and Travel


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(i) Accounting and Legal


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(j) Rent


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(k) Telephone


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(l) Utilities


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(m) Insurance


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(n) Taxes (Real Estate, etc.)


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(o) Interest on LOC


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(p) Other Expenses [Specify each]


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-





-


(q) Miscellaneous [Unspecified]


-


(r) Subtotal


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


(s) Loan Principal Payment


-


(t) Capital Purchases [Specify]


-


(u) Other Start
-
up Costs


-


(v) Reserve and/or Escrow [Specify]


-


(w) Owner's Withdrawal


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


6. TOTAL CASH PAID OUT


[Total 5a thru 5w]


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



-


7. CASH POSITION


[End of month] (4 minus 6)


$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-



$
-






Less Adjustments


Minus Cost of Goods Sold


Equals Gross Profits




Various Expense Categories


Equals Net Operating Income

INCOME STATEMENT (in
thousands)

2010

2011

2012

Sales Revenue

Less: Cost of Goods Sold

Gross Profits

Less: Operating Expenses:

Selling Expense

General / Admin. Exp.

Lease Expense

Depreciation Expense

Total Operating Expenses

Operating Profits

Less: Interest Expense

Net Profits Before Taxes

Less: Taxes

Net Profit After Taxes

Total Assets = Total Liabilities + Total
Equity


Current

Assets + Long Term = Total Assets


Current Liabilities + Long Term = Total
Liabilities


Equity

Total Assets
-

Total Liabilities =
Total
Equity


BALANCE SHEET ($000)

Current Assets:

2010

2011

2012

2013

2014

2015

Cash

Accounts Receivable

Inventories













Total Current Assets

$0

$0

$0

$0

$0

$0

Gross Fixed Assets (at cost):

Land & Buildings

Machinery and Equipment

Furniture & Fixtures

Vehicles

Other (Inc. Fin. Leases)













Total Gross Fixed Assets

$0

$0

$0

$0

$0

$0

Less: Accumulated Depreciation













Net Fixed Assets

$0

$0

$0

$0

$0

$0

Other Assets

$0

$0

$0

$0

$0

$0

Total Assets

$0

$0

$0

$0

$0

$0

Current Liabilities:

2010

2011

2012

2013

2014

2015

Accounts Payable

Notes Payable

Taxes Payable

Other Current Liabilities













Total Current Liabilities

$0

$0

$0

$0

$0

$0

L / T Debt (Inc. Financial Leases)













Total Liabilities

$0

$0

$0

$0

$0

$0

Common Stock

Paid
-
In Capital In Excess of Par

Retained Earnings













Total Stockholders' Equity

$0

$0

$0

$0

$0

$0

Total
Liabs
. &
Stockhldrs
' Equity

$0

$0

$0

$0

$0

$0

RATIO ANALYSIS

2010

2011

2012

Current Ratio

1.06

1.16

1.40

Quick Ratio

0.64

0.63

0.77

Inventory Turnover

6.90

5.39

5.20

Average Collection
Period

24.96

35.30

33.88

Fixed Asset Turnover

11.72

11.74

12.59

Total Asset Turnover

3.06

2.80

2.93

Debt Ratio

0.78

0.73

0.57

Debt
-
to
-
Equity

0.37

0.25

0.05

Times Interest Earned

3.70

3.07

7.20

Gross Profit Margin

33.33%

33.55%

38.82%

Operating Profit Margin

5.67%

5.74%

12.71%

Net Profit Margin

3.47%

3.10%

10.06%

Return on Total Assets
(ROA)

10.61%

8.68%

29.43%

Return on Equity (ROE)

47.71%

31.58%

68.40%

Earnings Per Share

$0.10

$0.10

$0.34

Price/Earnings Ratio

29.41

52.08

16.08

Increase Revenue
-

Profitability

Reduce Costs
-

Profitability

Increase Productivity
-

Efficiencies

Forecasting Models
-

Projections