Create a Cash Budget for the months April through June with the information given below. Create a Pro forma Income Statement and Balance Sheet for the same period.

Sales are shown in the table below:

Month Sales

February $$10,000$

March $$73,500$

April $$65,000$

May $$75,000$

June $$85,000$

July $$90,000$

$$ Sales are $29\%$ cash and $70\%$ credit, $1\%$ bad debt

$$ Of the credit sales, $50\%$ are collected in the month following the sale, and $50\%$ are collected two months following the sale.

$$ Cost of Goods Sold is strictly materials and is $55\%$ of sales.

$$ All inventory $($material$)$ purchases are paid for one month after they are made.

$$ The store follows a policy of purchasing enough inventory one month in advance of sales.

$$ A minimum cash balance of $$8,000$ is desired.

$$ All $$Accrued Wages$$ and $$Other Current Liabilities$$ remain unchanged. Wages April through June are paid as incurred.

$$ The corporate tax rate is $35\%.$ No tax payments are due during this quarter.

$$ A $$6,000$ dividend payment will be made in April