My Company, Inc. Name 2008 Start Yr
1 Start Mo 1 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
INSTRUCTIONS:
INCOME STATEMENT
% Mo SALES DIR COST OF SALES GROSS MARGIN Advertising/Promo Auto & Travel Contract Services Employee Benefits Insurance Leased Equipment Legal / Accounting Licenses & Permits Office Expense/ Post Operating Supplies Rent Repairs & Maintenance Utilities/Telephone Other Expense1 Other Expense2 Payroll Payroll Tax Salaries (Owners) OPER EXPENSES EBITDA Interest Depreciation Amortization Earn Before Taxes
www.missouribusiness.net/docs/fin_projInstructions.pdf
12 8.33% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2008 %Ch 100.00% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #### 2009 %Ch 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2010 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 % of Sales
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 Payroll Tax Rate
####
#### % EBT
BALANCE SHEET
Cash Accounts Receivable Inventory Equipment & Fixtures Leasehold Impr Buildings Tot Accm Dep (Neg) Intangibles Accum Amort (Neg) Other Non-Cur TOTAL ASSETS Accounts Payable ST Notes Payable Current Port LT Debt Accrued Liabilities Bank Loan LT Note Payable TOTAL LIABILITIES Paid-in Capital Retained Earnings EQUITY TOT LIAB & EQUITY 12/2007 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12/2008 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Ave 2008 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12/2009 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12/2010 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0 0.0 7 3 39 Days A/R Days Inventory Years Depr (Input 3 yrs or more) Years Depr (Input 3 yrs or more) Years Depr (Input 3 yrs or more)
3 Years Amort (Input 3 yrs or more)
0.0 Days A/P 9.00 % Inter 0.0 Days Accruals 7.00 % Inter 7.00 % Inter
60 Term (months) 60 Term (months)
0.00 Monthly payment 0.00 Monthly payment 0.00 Total monthly debt service
CASH FLOW STATEMENT
BEGINNING CASH OPERATIONS: EARN BEFORE TAX Plus: Depreciation & Amort Dec(Inc) Accounts Rec Dec(Inc) Inventory Inc(Dec) Accounts Pay Inc(Dec) Accrued Liab C/F FROM OPER INVESTING: Dec(Inc) Equipm & Fixt Dec(Inc) LH Impr Dec(Inc) Buildings Dec(Inc) Intangibles Dec(Inc) Other Non-Cur C/F FROM INVEST FINANCING: Inc(Dec) ST Debt Inc(Dec) LT Debt Paid-in Capital Addit C/F FROM FIN TOTAL C/F ENDING CASH 1 0 2 0 3 0 4 0 5 0 6 0 7 0 8 0 9 0 10 0 11 0 12 0 2008 0 2009 0 2010 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
INCOME STATEMENT
SALES DIRECT COST OF SALES GROSS MARGIN EXPENSES: Advertising/Promo Auto & Travel Contract Services Employee Benefits Insurance Leased Equipment Legal / Accounting Licenses & Permits Office Expense/ Post Operating Supplies Rent Repairs & Maintenance Utilities/Telephone Other Expense1 Other Expense2 Payroll Payroll Tax Salaries (Owners) OPERATING EXPENSES EBITDA Interest Depreciation Amortization EARNINGS BEFORE TAX 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
My Company, Inc.
3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2008 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2009 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2010 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BALANCE SHEET
Cash Accounts Receivable Inventory Equipment & Fixtures Leasehold Improvements Buildings Total Accum Depr (Neg) Intangibles Accumulated Amort (Neg) Other Non-Cur TOTAL ASSETS Accounts Payable ST Notes Payable Curr Portion of LT Debt Accrued Liabilities Long Term Liabilities TOTAL LIABILITIES Paid-in Capital Retained Earnings EQUITY TOTAL LIAB & EQUITY 12/2007 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
My Company, Inc.
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12/2008 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12/2009 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12/2010 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CASH FLOW STATEMENT
BEGINNING CASH OPERATIONS: EARNINGS BEFORE TAX Plus: Depreciation & Amortization Dec(Inc) Accounts Receivable Dec(Inc) Inventory Inc(Dec) Accounts Payable Inc(Dec) Accrued Liabilities C/F FROM OPERATIONS INVESTING: Dec(Inc) Fixed Assets Dec(Inc) Intangibles Dec(Inc) Other Non-Cur C/F FROM INVESTING FINANCING: Inc(Dec) ST Debt Inc(Dec) LT Debt Paid-in Capital Additions C/F FROM FINANCING TOTAL CASH FLOW ENDING CASH 1 0 2 0
My Company, Inc.
3 0 4 0 5 0 6 0 7 0 8 0 9 0 10 0 11 0 12 0 2008 0 2009 0 2010 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
MONTHLY SALES
1 1 1 1 1 1 0 $ 0 0 0 0
1
ANNUAL SALES
1 1 1 1 1 1 0 0 0 0 $ 0
2
CASH
1 1 1 1 1
1 03 0 0 0 0 4 5 6 7 8 9 10
$
Months 2008
SALES EARNINGS BEFORE TAXES
2009
Years 1 2 3 SALES 4
EARNINGS BEFORE TAXES
5
6
7
Months
CASH FLOW CASH BALANCE
10
11
12
2010
BEFORE TAXES
7
8
9
10
11
12
CASH BALANCE