Prepare a monthly budgeted cash flow, income statement and balance sheet:

Sales Projection for next 3 months

October	$30,000
November	$70,000
December	$50,000

75 % of sales are expected to be Collected in current month and the remaining 25% to be collected in the following month.

Cost of Goods equals =45% of sales (Materials) 15% of sales (direct labor) 15% of sales (subcontractors)

*Materials and subcontractors and paid in the following month while direct labor is paid in the month worked*

The owners Debbie and Mark will deposit $20,000 in the bank at the beginning of October. $100 of these funds will be used to pay for their common shares and the remaining $19,900 will be set up as a loan from the share holder with no interest and no set terms of repayment.

The corporate income tax is 17%

Operating Expenses

Depreciation

Truck	cost $38,000, useful life 5 years, residual value 20% of costs (sold to the company by the owners in exchange for a non-interest baring share holder loan)
Tools	cost $18,000, useful life 8 years (sold to the company by the owners in exchange for a non-interest baring share holder loan)
Office Furniture	cost $5000, useful life 3 years
Building	Cost $50,000 useful life 20 years

Other expenses

Insurance	Quote received $6900 for property & liability and quote received $1500 for vehicle
Interest on long term debt	Mortgage on building- Full amount required/ Bank quoted 4.25% for 20 years amortization. Refer to the loan amort. schedule included below
property taxes	Re building- annual taxes $420

Other Operating Expenses

Administrative salaries	October 4,800.00 November 3900.00 December 3500.00
Accounting & legal	October 4,000.00
Advertising & promotions	October 3,000.00 November 1000.00 December 1000.00
Business fees & licenses	$ -
Depreciation Expenses	$
Insurance	$
interest & bank charges	$ 35.00 per month
interest on long term debt	$ -
office supplies	$ 100.00 for October 25 each month after
property tax	$ 420 annually
motor vehicles expenses	$ 450.00 per month
repair & maintenance
telephone	$ 165.00 per month
travel & entertainment	$ 40.00 per month
Utilities	$ 250.00 per month

Loan Calculator

Loan amount $50,000.00

Annual interest rate 4.25%

Loan period in years 20

Start date of loan 10/01/2019

Monthly payment $309.62

Number of payments 240

Total interest 24308.14

total cost of loan 74308.14

No 1	11/01/2019 (payment date)	50,000 (beg balance)	309.62 (Payment)	132.53 (Principal)	177.08 (interest)	49867.47 (ending balance)
2	12/1/2019	49867.47	309.62	133.00	176.61	49734.46
3	1/01/2020	49734.46	309.62	133.47	176.14	49600.99

All operating expenses are to be paid in the month following the purchase with the exception of the following shich do not have credit terms:

insurance, property taxes, business fees and licenses and interest and bank charges