Extend Your Skills EA10-et Prepare Budgets and a CVP Analysis for Environmental Adaptations Co. In the prepare cash and patches budgets and CVP analyses for Environmental Apa You will first cate a cash budget, adjusting it appearance to facilitate data cam You will then create a purchases budget and adjust print settings to ensure readability and you will use Goal Seek and Solver to create three CVP analyses Open EA10-E1-Budget On the Cash Budget tab, create a cash budget based on a beginning balance of $10,400 and this data: Quarter 1 $184.000 Quarter #2 $172.000 Quarter #3 5201,300 Quarter #4 $153,000 $26,200 $ $13,500 $1,000 $900 SO $14.000 $200 $800 $0 $129,600 $18,500 $700 $ 1.100 $3,200 $141.000 $900 SO $147.300 Cash Receipts from In-Store Customer Sales Cash Receipts from Delivery Sales Reduction in Accounts Receivable Interest Received Sale of Furniture Cash Disbursements for Merchandise Purchases Cash Disbursements for Operating Expenses Loan Payments Principal Loan Payments interest $122.600 568.100 $72,000 $51,300 $53,600 $3,600 SO $3,600 $3,600 $850 $850 $0 $850 Also enter the necessary formulas. Set up the budget to print with narrow margins and in Landscape orientation. Adjust the third line of the header to read For Quarters Ended in 2017. Insert page breaks such that data for each quarter appears on a separate page and use the Print Titles option to display the three line header and the headers in columns A-B on every printed page. Set the print area to include only the cash data through row 15. Create a horizontal split that displays the itemized cash receipts directly above the itemized cash disbursements (only the split bar between them). On the Purchases Budget tab, create a purchases budget based on this data: $545,000 Budgeted Cost of Goods Sold Desired Ending Inventory Beginning inventory $35,000 $39,500