Based on the information below prepare a: (1) Sales Budget (2) Purchase Budget (3) Cash Budget for Jan thru March (30 pts) Remember prepare thru Excel. Set up your template based on the information below and link as much information as possible. (30 pts) ABC Company Balance Sheet, December 31 Cash Accounts receivable Finished goods Land Plant and equipment Less: accumulated depreciation $41,700 192,000 55,000 100,000 $750,000 25,000 725,000 Total assets $1,113,700 Accounts payable to suppliers $55,000 Common Stock $200,000 Retained Earnings 858,700 Total liabilities and equity 1,058,700 $1,113,700 Estimated sales of product Z January 10,000 February 10,700 March 11,200 April 11,000 May 10,500 Selling price $75 Collections from customers Selling price Collections from customers Collected in month of sale Collected the following month Desired finished goods inventory (% of next month's unit sales) Beginning Inventory units & cost Product Z Cost Purchases Paid in the month of purchase Paid in the subsequent month Selling and administrative expenses (includes $25,000 depreciation) Variable Expense $75 72% 28% 20% 2,200 $25 75% 25% $175,000 fixed $ 15 per unit sold