Based on the information below prepare a: (1) Sales Budget (2) Purchase Budget (3) 5 & A Budget (4) 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. ABC Company Balance Sheet, December 31 inform Cash Accounts recenable Finnhed goods Land Plant and equipment Less accumulated depreciation Total assets $41,700 192.000 55.000 100,000 $750,000 25,000 725,000 $1.113.700 $55,000 Accounts payable to suppliers Common Stock Retained Earnings Total abilities and equity $200,000 358,700 1,058,700 51.113,700 Estimated sales of product z January February March April Muy Selling price Collections from customers Collected in month of sale Colected the following month Deswed finhed goods leventer 15 of next month's males) 10,000 10,700 11.200 11,000 10.500 $70 75% 25N 20 Deponing torris & cost Produd Cou 2,200 125 Padithe purchase Puld the wheel month 197.000 55.co 100.000 Cad Accountable Finished goods Land Puant and court Les acted recon Total 5750.000 25.000 725.000 $1,111,100 $55.000 Acres able to super Cocond Betained Totallaties and quity $200,000 350.00 1.050,700 $1,113,700 Esimte les of product 10.00 10,700 11.200 11.000 10.500 $70 February March April May Seine Collections from comes Collected in onth of sale Colected the following month Deared finished goods into of next months at sales) 75 25 -20% trentary unit & con Produd Cou 2,200 Pulduws Paid in the innihal pucha Paid in the went month BOX 204 Sen and te opene (edule stageeration) wishes 3175.000 310 uved per sold 18