APPLICANT NAME:
Bank Financial Planner
S.B.A. Preferred Lender Assumption Footnotes
Cash Flow Forecast - 12 Months
Month: Projected Revenues/Billings: 1 2 3 4 5 6
Beginning Cash Balance:
Receipts: Cash sales Collections from credit sales Other Total Receipts Payments 0 0 0 0 0 0
1 2 3
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
Cash purchases Payments to vendors/suppliers Owner Salaries/Draws Salaries and wages Employee benefits Payroll taxes Rent Utilities Repairs and maintenance Insurance Travel Telephone Postage Office supplies Advertising Marketing/promotion Professional fees Training and development Bank charges Miscellaneous Loan repayments Tax payments Other Other Total Payments Cashflow Surplus/Deficit (-) Opening Cash Balance Closing Cash Balance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
APPLICANT NAME:
Bank Financial Planner
S.B.A. Preferred Lender
Cash Flow Forecast - 12 Months
Month: Projected Revenues/Billings: 7 8 9 10 11 12
TOTAL YR. 1
Totals
Receipts Cash sales Collections from credit sales Other Total Receipts Payments Cash purchases Payments to vendors/suppliers Owner Salaries/Draws Salaries and wages Employee benefits Payroll taxes Rent Utilities Repairs and maintenance Insurance Travel Telephone Postage Office supplies Advertising Marketing/promotion Professional fees Training and development Bank charges Miscellaneous Loan repayments Tax payments Other Other Total Payments Cashflow Surplus/Deficit (-) Opening Cash Balance Closing Cash Balance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
APPLICANT NAME:
REVENUE ASSUMPTIONS:
( What were Revenue Assumptions based on and how were each month's revenues actually calculated?)
CASH RECEIPT AND EXPENSE PAYMENT ASSUMPTIONS: (How were actual cash collections calculated and how was each expense category estimated?) 1. 2. 4. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21.
Year 1
Total Revenue
Less COGS:
Gross Revenue: Expenses
Accounting Advertising
$ 665,563 $ 332,781 $ 332,782
100.0% 50.0% 50.0%
Amortization
Automobile Bank Charges Building Maintance Contributions Credit Cards
Depreciation
Dues & Subscriptions Equipment Maintance Insurance Garbage Greens
Interest
Misc./Office Payroll Supplies Taxes Telephone Utilities Vending Total Expenses Net Income
+ Depreciation + Interest
Total Cash Flow Debt Service Debt Service Coverage
$ 2,500 0.4% $ 19,967 3.0% $ 700 0.1% $ 2,400 0.4% $ 2,656 0.0% $ 1,662 0.2% $ 0.0% $ 2,100 0.3% $ 111,621 16.8% $ 100 0.0% $ 2,000 0.3% $ 9,400 1.4% $ 500 0.1% $ 0.0% $ 78,538 11.8% $ 500 0.2% $ 114,515 17.2% $ 1,000 0.2% $ 2,700 0.4% $ 3,600 0.5% $ 9,500 1.4% $ 0.0% $ 365,959 55.0% $ (33,177) $ 112,321 $ 78,538 $ 157,682 $ 83,800 1.88
APPLICANT NAME:
CASH RECEIPT AND EXPENSE PAYMENT ASSUMPTIONS CONTINUED: (How were actual cash collections calculated and how was each expense category estimated?) 22. 23. 24. 25. 26. 27. 29.