Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have made below income statement and balance sheet of my own business of Event management for my project. I would like to make cash

I have made below income statement and balance sheet of my own business of Event management for my project.

I would like to make cash flow from the below income statement and balance sheet.

Below is the format of cash flow. if something is missing i would request you to make an assumption and put note there that on basis of this i have added this particular amount. also verify the income statement and balance sheet if something needs to change do the needful and put note so i can make correction.

Then prepare cash flow and breakeven point of my business.

Particular

2016

2015

Revenue:

Service revenue

$ 278,000.00

$ 250,000.00

Grant

$ -

$ -

Fund raising

$ -

$ -

Total Revenue

$ 278,000.00

$ 250,000.00

Expenses:

Advertising

$ 1,200.00

$ 1,100.00

Amortization

$ -

$ -

Bad Debts(5% of Revenue)

$ 11,000.00

$ 9,400.00

Bank Charges

$ 3,000.00

$ 3,000.00

Charitable Contributions(1% of Sales)

$ 2,780.00

$ 2,500.00

Commissions(5% of sales)

$ 13,900.00

$ 12,500.00

Contractor

$ 31,500.00

$ 28,500.00

Credit Card Fees

$ 1,680.00

$ 1,524.00

Delivery Expenses

$ 2,800.00

$ 2,500.00

Depreciation (Computer +Vehicle + office equipments+ Furniture)SLM

$ 3,500.00

$ 3,500.00

Dues and Subscriptions

$ 850.00

$ 800.00

Insurance($550 *12)*3 employee

$ 19,800.00

$ 19,800.00

Interest ($80,000 * 13%)

$ 10,400.00

$ 10,400.00

Maintenance

$ 1,300.00

$ 1,100.00

Miscellaneous

$ 1,400.00

$ 1,200.00

Office Expenses

$ 2,200.00

$ 2,000.00

Operating Supplies

$ 1,000.00

$ 1,500.00

Payroll Taxes

$ -

$ -

Permits and Licenses( Every 5 years Renew)

$ -

$ 600.00

Postage

$ 650.00

$ 600.00

Professional Fees

$ 1,400.00

$ 1,200.00

Property Taxes

$ -

$ -

Rent ($1500*12)( lease of 3 years )

$ 18,000.00

$ 18,000.00

Repairs

$ 900.00

$ 700.00

Telephone

$ 1,080.00

$ 1,080.00

Travel

$ 1,300.00

$ 1,100.00

Utilities( between $160 to $170 pm)

$ 2,000.00

$ 1,800.00

Vehicle Expenses

$ 2,000.00

$ 1,800.00

Wages($ 10 per hour)

$ 23,600.00

$ 15,200.00

Total Expenses

$ 159,240.00

$ 143,404.00

Earnings Before Income Tax

$ 118,760.00

$ 106,596.00

Tax Expenses 35%

$ 41,566.00

$ 37,308.60

Net Income

$ 77,194.00

$ 69,287.40

Balance sheet as on 31st Dec 2016

Amount $

Amount $

Assets

Current Assets:

Cash

$ 23,800.00

Accounts Receivable (25% of Revenue)

$69,500.00

Will not have AR but still few customer will not pay full amount so will consider 25% revenue would be our AR

Reserve for Bad Debts(20%)

$13,900.00

$ 55,600.00

Same customer who will either full or partial considered as a doubt full bad-debts

Prepaid Insurance ($800*2 years)

$ 19,200.00

Vehicle insurance we have to paid in advance

Notes Receivable

$ -

Total Current Assets (A)

$ 98,600.00

Fixed Assets:

Vehicles

$11,000.00

Accumulated Depreciation(15%) SLM

$ 1,650.00

$ 9,350.00

Computers

$ 4,500.00

Accumulated Depreciation(15%) SLM

$ 675.00

$ 3,825.00

Office Equipments

$ 3,500.00

Accumulated Depreciation(15%) SLM

$ 525.00

$ 2,975.00

Furniture and Fixtures

$ 6,500.00

Accumulated Depreciation(10%) SLM

$ 650.00

$ 5,850.00

Total Fixed Assets (B)

$ 22,000.00

Total Assets (A+B)

$ 120,600.00

Liabilities and Capital

Current Liabilities:

Contract Service Payable

$ 9,000.00

will pay every quarterly to our contactor so last quarter would be considering as payable

Interest Payable(80000*13%)

$ 900.00

last month interest will be paid in Jan. so will consider December month interest as a payable

Total Current Liabilities

$ 9,900.00

Long-Term Liabilities:

will not have any

Long-Term Notes Payable

$80,000.00

the loan which we have taken from bank would be our long term liabilities

Total Long-Term Liabilities

$ 80,000.00

Total Liabilities (C)

$ 89,900.00

Capital:

Owner's Equity

$ 5,000.00

my own investment

Net Profit

$ 25,700.00

I have transfer my own net profit to my balance sheet. Made 3 equal parts of income and added my own profit in balance sheet

Total Capital (D)

$ 30,700.00

Total Liabilities and Capital (C+D)

$ 120,600.00

Format of Cash flow and also make breakeven point of my business.

Cash Flow Budget Worksheet

[Mmmm Dd, 200X]

Beginning Cash Balance

Cash Inflows (Income):

Accts. Rec. Collections

Loan Proceeds

Sales & Receipts

Other:

Total Cash Inflows

Available Cash Balance

Cash Outflows (Expenses):

Advertising

Bank Service Charges

Credit Card Fees

Delivery

Health Insurance

Insurance

Interest

Inventory Purchases

Miscellaneous

Office

Payroll

Payroll Taxes

Professional Fees

Rent or Lease

Subscriptions & Dues

Supplies

Taxes & Licenses

Utilities & Telephone

Other:

Subtotal

Other Cash Out Flows:

Capital Purchases

Loan Principal

Owner's Draw

Other:

Subtotal

Total Cash Outflows

Ending Cash Balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions

Question

What has been your desire for leadership in CVS Health?

Answered: 1 week ago

Question

Question 5) Let n = N and Y Answered: 1 week ago

Answered: 1 week ago