60.1K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer