Excel Spreadsheet

Service_Template_Simple

You must be logged in to download this document
Reviews
Shared by: Mike Sheridan
Stats
views:
267
rating:
not rated
reviews:
0
posted:
10/5/2007
language:
English
pages:
0
Company Name: Corporate Tax Rate: Starting Cash Position: [Enter company name here] 20% 0 [Enter company name here] Projected Profit & Loss Statement - Y Month 1 Sales Cost of Goods Gross Profit Staffing Salaries Benefits Payroll Taxes Sub-Contractors Marketing Travel/Entertainment Advertising Trade Shows Facilities Rent Utilities Insurance Telephone Office supplies Repairs and Maintanence Furniture & Fixtures Professional Services Legal Accountant Business Consultant Magazine, Journal and Database Subscriptions Capital Equipment Depreciation Other Total Operating Exp Total Operating Profit Other Income/Expense Interest (Income)/Expense Total Other Inc/Exp Month 2 Month 3 Month 4 Month 5 - - - - - Net Income Before Tax Taxes Net Income - - - - - 0 - [Enter company name here] jected Profit & Loss Statement - Year 1 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 TOTAL - - - - - - - - - - - - - - - - - - - - - [Enter company name h Projected Balance Sheet Month 1 Assets Current assets: Cash and cash equivalents Accounts receivable Inventories Prepaid expenses Total Current Assets Fixed Assets Furniture and Fixtures Equipment Less accumulated depreciation Furniture, Fixtures & Equipment Other Assets Total Assets Liabilities and stockholders' equity Current liabilities: Short-term debt Accounts payable Other accrued liabilities Income taxes payable Total current liabilities Long-term liabilities Long-term debt Deferred tax liabilities Total Liabilities Stockholders' equity: Retained earnings Total stockholders' equity Total liabilities and stockholders' equity Month 2 Month 3 Month 4 - - - - - - - - - - - - - - - - [Enter company name here] Projected Balance Sheet - Year 1 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - TOTAL - - - - Month 1 Cash Start Cash In Collections Investments Total Cash In Cash Out Cost of Goods Payables Deposits Total Cash Out Cash End Accounts Receivables Start Billings Collections Write-offs Accounts Receivables End Accounts Payable Start Invoices Payments Write-offs Accounts Payable End Month 2 Month 3 Month 4 Month 5 Month 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 TOTAL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 [Enter company name here] Projected Cash Flow Statement - Y Pre-Startup Cash On Hand Cash In Cash Sales Collections from Credit Accounts Loan or Other Cash Injection Total Cash In Total Cash Available Cash Paid Out Rent Purchases and Subscriptions Salaries (excludes withdrawals) Payroll Expenses (Taxes, etc.) Supplies (Office and operating) Repairs and Maintenance Marketing and Advertising Auto, Delivery, and Travel Legal, Accounting and Consultants Utilities and Telephone Insurance Taxes (Real Estate, etc.) Loan Interest Payment Loan Principal Payment Capital Purchases [Specify] Other Start-up Costs Owner's Withdrawal Other Expenses [Specify each] Other Expenses [Specify each] Total Cash Paid Out Cash Position Month 1 - Month 2 - Month 3 - Month 4 - - - - - - - - - - - [Enter company name here] jected Cash Flow Statement - Year 1 Month 5 - Month 6 - Month 7 - Month 8 - Month 9 - Month 10 Month 11 Month 12 - TOTAL - - - - - - - - - - - - - - - - - -

Shared by: Mike Sheridan
Other docs by Mike Sheridan
Global Debt Network Pitch
Views: 86  |  Downloads: 6
Technology_Template_Detailed
Views: 429  |  Downloads: 33
Service_Template_Detailed
Views: 190  |  Downloads: 8
Retail_Template_Simple
Views: 212  |  Downloads: 17
Retail_Template_Detailed
Views: 268  |  Downloads: 35
Manufacturing_Template_Simple
Views: 202  |  Downloads: 8
Technology_Template_Simple
Views: 271  |  Downloads: 8