Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting An Introduction To Concepts Methods And Uses

Authors: Clyde P. Stickney, Roman L. Weil

12th Edition

0324381980, 978-0324381986

More Books

Students also viewed these Accounting questions