A 40 Pages Business Plan

profilesunny999
a_business_plan_accounting.xlsx
Home>Business & Finance homework help>Management homework help>A 40 Pages Business Plan

Sales Forecast

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales:
Beginning Inventory
ERROR:#VALUE!
Goods Available for Sale
ERROR:#VALUE!
Cost of Goods Sold
Gross Profit Margins
Operating Expenses:
Salaries
Wages
Benefits & Payroll Taxes
Insurance
Rent
Utilities
Telephone
Licenses
Accounting & Legal
Office Supplies
Maintenance & Cleaning
Promotion & Advertising
Direct Mail
Miscellaneous
Total Operating Expenses
Startup Expenses:
Office Equipment
Fixtures
Decor
Depreciation
Total Startup Expenses
Other Expenses:
Principle Payment
Interest
Total Other Expenses
Net Profit (Loss)

Cash Flow Statement

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Balance (opening)
Cash Receipts
Cash Sales
Credit Collections
Bank Loan Proceeds
Sales Revenue
Other
Total Cash Receipts
Cash Disbursements
Purchases
Salaries
Wages
Benefits & Payroll Taxes
Insurance
Rent
Utilities
Telephone
Licenses
Accounting & Legal
Office Supplies
Maintenance & Cleaning
Promotion & Advertising
Direct Mail
Loan Repanyment
Miscellaneous
Starttup Expenses
Office Equipemnt
Fixtures
Decor
Total Cash Disbursements
Beginning Cash Balance
ERROR:#NAME?
ERROR:#NAME?
End-of-Month Cash Balance
Repay
Borrow
Final Cash Balance

Startup Costs-Retail Store

Items Costs
Beginning inventory
Furniture and fixtures
Storage shelves
Display stands
Window display fixture
Special lighting
Counters
Outside sign
Installation costs
Other decorating and remodeling costs
Other assets:
Cash register
Safe
Land
Building
Automotive equipemnet
Other equipment and machinery
Deposits with public utilities
Legal and other professional fees
Licenses and permits
Advertising and promotion for opening
Accounts receivable
Prepaid items
Cash register
Other expenses
Monthly expenses (allowing for 3 to 4 months cash on hand)
Salary of owner/entrepreneur
Other salaries
Rent
Telephone
Other utilities
Advertising
Professional fees
Travel and entertainment
Delivery expense
Repairs and maintenance
Office supplies
Taxes
Interest
Miscellaneous expenses
TOTAL START-UP COSTS

Profit and Loss statement

Year 1 Year 2 Year 3 Year 4 Year 5
Revenues
Less: Cost of Sales
Gross Profit
Less:
Salary Expense
Payroll Expense
Other Services
Office Supplies
Maintenance & Repairs
Advertising
Automobile
Travel & Entertainment
Consulting Services
Rent
Telephone
Utilities
Insurance
Taxes
Interest
Deprciation
Other Expenses
Total Expenses
Operating Profit
Add: Other Income
Less: Other Expenses
Pretax Profit
Income Tax Provision
Net Income after Taxes

Balance sheet

Current Projected
Assets
Current Assets:
Cash and equivalents
Accounts receivable
Inventoury (net)
Office supplies
Prepaid items
Other current assets
Total Current Assets
Fixed Assets (net):
Furniture and fixtures
Leasehold improvements
Machinery and equipment
Land and building
Total Fixed Assets
Other Assets
Total Assets
Liabilities and net worth:
Current Liabilities:
Account payable
Taxes payable
Interest payable
Current portion of
long-term debt
Short-term debt
Miscellaneous payables
Total Current Liabilities
Long-term Liabilities
Long-term debt (net)
Convertible debentures
Total Long-Term Liabilities
Net Worth:
Captial stock
Paid-in surplus
Retained earnings
Total Net Worth
Total Liabilities and Net Worth