1.Create an excel with a budgeted income statement for each of the first two months
2.prepare a cash flow analysis for the two month period
3. Compute what the accounts receivable and accounts payable balances will be at the end of the two month period.

At the start if business operation is $10,000
On the first day of the first month of business, an insurance premium of $6,000 is due. The term of this policy is for one year.

Never use plagiarized sources. Get Your Original Essay on
Business Finance – Accounting Assignment
Hire Professionals Just from $11/Page
Order Now Click here

The owner provides the following estimates for the first two months of business:

Sales:$40,000 in first month, and $60,000in second month.
Cost of sales: 35%
Cost of labor: 30%
Cost of related payroll(payroll taxes, benefits):25% of payroll
Supplies:5% of sales
Advertising: $600 monthly 
Depreciation: $1,000 monthly 
Rent: $3,000 monthly 
All other expenses: 12% of sales

The owner provides the following statistical information bases on industry studies and personal estimates:

Sales are estimated to be 80% cash and 20% accounts receivable. The accounts receivable are collected in the month following the sales 

Cost of sales represent purchases. The purchase are estimated to be 90% on accounts payable and 10 percent cash. The accounts payable are paid In the month following the sale

All other expenses are paid in the current month 

A delivery truck is required for the second month of business. This vehicle will cost $25,000 and requires a $4,000 down payment. Payments on the note start the third month of business.

Need a custom written plagiarism free essay? Click here to order now.

Open chat
Lets chat on via WhatsApp
Hello, Welcome to our WhatsApp support. Reply to this message to start a chat.