Question
I completed some of the sheets I need help doing the rest and making sure the balance sheet balances and with the empty spaces it
I completed some of the sheets I need help doing the rest and making sure the balance sheet balances and with the empty spaces it can be made up information if needed it is for a made up business plan for a cleaning company! thank you...
6. FINANCIAL PROJECTIONS
6.1 Profit & Loss
| Year 1 | Year 2 | Year 3 |
---|---|---|---|
Sales | 90,000 | 150,000 | 300,000 |
Costs/Goods Sold | 0 | 0 | 0 |
GROSS PROFIT OPERATING EXPENSES |
|
|
|
Salary (Office & Overhead) | 0 | 12,000 | 20,000 |
Payroll (taxes, etc.) | 9,000 | 12,000 | 15,000 |
Outside Services | 0 | 9,000 | 13,000 |
Supplies (Office & Operation) | 5,000 | 8,000 | 9,000 |
Repairs & Maintenance | 0 | 0 | 0 |
Advertising | 5600 | 8500 | 20,000 |
Car, Delivery & Travel | 5,000 | 7,000 | 10,000 |
Accounting & Legal | 1,000 | 2,400 | 3,200 |
Rent | 0 | 10,000 | 15,000 |
Telephone | 2000 | 2400 | 2600 |
Utilities | 1000 | 1200 | 1500 |
Insurance | 986 | 986 | 1,090 |
Taxes (Real Estate, etc.) | 0 | 0 | 0 |
Interest | 1,500 | 1,600 | 1,800 |
Depreciation | 0 | 0 | 0 |
Other Expenses (supplies) | 6,000 | 8,000 | 17,000 |
TOTAL EXPENSES | 37,086 | 83,986 | 129,190 |
NET PROFIT BEFORE TAXES |
|
|
|
Income Taxes | 7,500 | 9,000 | 24,000 |
NET PROFIT AFTER TAX |
|
|
|
Owner Draw/Dividends | 45,414 | 57,014 | 146,910 |
ADJUSTED TO RETAINED |
|
|
|
6.2 Cash Flow Complete section 6.3 of your business plan outline
| Pre-Startup EST. | Year 1 | Year 2 | Year 3 | Total Item EST. |
Cash on Hand | 10,000 | 45,414 | 57,014 | 146,910 | 259,338 |
CASH RECEIPTS |
|
|
|
|
|
Cash Sales | 0 | 90,000 | 150,000 | 300,000 | 540,000 |
Collections from CR Accounts | 0 | 0 | 0 | 0 | 0 |
Loan/Cash Injection | 10,000 | 5,000 | 0 | 0 | 15,000 |
TOTAL CASH RECEIPTS |
|
|
|
|
|
TOTAL CASH AVAILABLE | 20,000 | 50,414 | 57,014 | 146,910 | 274,338 |
CASH PAID OUT |
|
|
|
|
|
Purchases | 6,000 | 12,000 | 10,000 | 14,000 | 42,000 |
Gross Wages | 3,000 | 9,000 | 12,000 | 15,000 | 39,000 |
Outside Services | 0 | 0 | 2,500 | 3,900 | 6,400 |
Supplies | 1,500 | 6,000 | 8,000 | 17,000 | 32,500 |
Repairs & Maintenance | 0 | 0 | 0 | 0 | 0 |
Advertising | 500 | 5,600 | 8,500 | 20,000 | 34,600 |
Car, Delivery & Travel | 1,000 | 5,000 | 7,000 | 10,000 | 23,000 |
Accounting & Legal | 0 | 1,000 | 2,400 | 3,200 | 6,600 |
Rent | 0 | 10,000 | 15,000 | 15,000 | 40,000 |
Telephone | 1,000 | 2,000 | 2,400 | 2,600 | 8,000 |
Utilities | 900 | 1,000 | 1,200 | 1,500 | 4,600 |
Insurance | 986 | 986 | 986 | 986 | 3,944 |
Taxes (Real Estate, etc.) | 0 | 0 | 0 | 0 | 0 |
Interest | 0 | 1,500 | 1,600 | 1,800 | 4,900 |
Other Expenses | 900 | 0 | 0 | 0 | 900 |
SUBTOTAL |
|
|
|
|
|
Loan Principal Payment | 450 | 500 | 500 | 500 | 1,950 |
Capital Purchase | 0 | 0 | 0 | 0 | 0 |
Other Startup Costs | 900 | 0 | 0 | 0 | 900 |
Reserve and/or Escrow | 0 | 0 | 0 | 0 | 0 |
Others Withdrawal | 0 | 0 | 0 | 0 | 0 |
TOTAL CASH PAID OUT |
|
|
|
|
|
CASH POSITION |
|
|
|
|
|
6.3 Balance Sheet
Assets | Start Date: | End Date: |
CURRENT ASSETS |
|
|
Cash in Bank |
|
|
Accounts Receivable |
|
|
Inventory |
|
|
Prepaid Expenses |
|
|
Other Current Assets |
|
|
TOTAL CURRENT ASSETS |
|
|
FIXED ASSETS |
|
|
Machinery & Equipment |
|
|
Furniture & Fixtures |
|
|
Leaseholder Improvements |
|
|
Land & Buildings |
|
|
Other Fixed Assets |
|
|
TOTAL FIXED ASSETS (net of depreciation) |
|
|
OTHER ASSETS |
|
|
Intangibles |
|
|
Deposits |
|
|
Other |
|
|
TOTAL OTHER ASSETS |
|
|
TOTAL ASSETS |
|
|
Liabilities & Equity |
|
|
CURRENT LIABILITIES |
|
|
Accounts Payable |
|
|
Interest Payable |
|
|
Taxes Payable |
|
|
Notes, Short Term (due in 12 months) |
|
|
Current Part, Long-Term Debt |
|
|
TOTAL CURRENT LIABILITIES |
|
|
LONG TERM DEBT |
|
|
Bank Loans Payable |
|
|
Notes Payable to Stockholders |
|
|
LESS: Short-Term Portion |
|
|
Other Long-Term Debt |
|
|
TOTAL LONG-TERM DEBT |
|
|
TOTAL LIABILITIES |
|
|
OWNER'S EQUITY |
|
|
Invested Capital |
|
|
Retained Earnings |
|
|
TOTAL OWNERS EQUITY |
|
|
|
|
|
TOTAL LIABILITIES & EQUITY |
|
|
Customers
6.4 Break-Even Analysis
DIRECT COSTS | Fixed Costs ($) | Variable Costs (%) |
Cost of Goods Sold |
|
|
Inventory |
|
|
Raw Materials |
|
|
Direct Labor |
|
|
INDIRECT COSTS |
|
|
Salaries |
|
|
Supplies |
|
|
Repairs & Maintenance |
|
|
Advertising |
|
|
Car, Delivery & Travel |
|
|
Rent |
|
|
Telephone |
|
|
Utilities |
|
|
Insurance |
|
|
Taxes |
|
|
Interest |
|
|
Depreciation |
|
|
Other Costs |
|
|
Total Fixed Costs |
|
|
Total Variable Costs |
|
|
BREAK-EVEN SALES LEVEL: |
|
|
6.5 Financial Assumptions
6.5.1 Assumptions for Profit and Loss Projections
Our projected profit and loss is shown in section 6.1 on the table. With the profit of the sales of our services increasing in the first year to the third. The projected profits for the first year are $45,414, and in the second year $57,014, and in the third year a profit of $146,910. Our profits may not seem that impressive in the first three years, but are relatively good for a start-up firm in our business. Therefore, Simply the Best cleaners expects to more than break-even in the first year of operation because the business owner is included in the operations which keeps labor costs low and allows more profit, and because we are selling services, not a product that we have to pay for.
6.5.2 Assumptions for Cash Flow Analysis
6.5.3 Assumptions for Balance Sheet
6.5.4 Assumptions for Break-Even Analysis
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started