Can you help me figure how to do the goal seek and scenario summary for this problem? They are C and D of the problem you helped me with on the cash budget. I will re-attach the assignment. Thank you. ATTACHMENT PREVIEW Download attachment 1 page ch6-07.xlsx Rosey’s Roses Cash Budget Operating activities Operating cash receipts Product sales revenue Collections in the year of sale Collections in the year following sale Operating cash receipts Operating cash payments Purchases Cost of expected sales Required ending inventory Beginning inventory Purchases Payments in the year of purchase Payments in the year following purchase Cash payments for purchases Expenses Advertising expense Interest expense Wages expense Supplies expense Utilities expense Expenses Operating cash payments Cash from (to) operating activities Investing activities Equipment purchases Equipment sales Cash from (to) investing activities Financing activities Loan proceeds Loan payments Cash from (to) financing activities Change in cash Beginning cash Ending cash Assumptions Sales growth each year Expense growth each year Collections in the year of sale Collections in the year following sale Payments in the year of purchase Payments in the year following purchase Cost of expected sales Required ending inventory Beginning inventory Interest expense Loan proceeds Annual loan payment Annual equipment purchases Annual equipment sales Year 1 equipment purchase Prior Year 150,000 127,500 16,000 143,500 90,000 20,700 (18,000) 92,700 83,430 6,000 89,430 15,000 20,000 1,000 3,300 39,300 128,730 14,770 14,770 5,430 20,200 1 2 3