I need help how to get the required ending inventory, how to get operating cash payment and cash from (to) operating activities, as well change in cash. I need the formulas pls. in the spread sheet attached

Waren Sports Supply Cash Budget 2016 2017 2018 2019 500,000 470,000 27,000 497,000 610,000 573,400 30,000 603,400 744,200 699,548 36,600 736,148 907,924 853,449 44,652 898,101 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 Marketing expense Interest expense Salaries expense Wages expense Supplies expense Utilities expense Expenses Operating cash payments Cash from (to) operating activities Investing activities Facility 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 First year sales Sales growth each year Sales in 2015 Purchases in 2015 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 Beginning cash Advertising expense Marketing expense Depreciation expense Interest expense Salaries expense Wages expense Supplies expense Utilities expense Loan proceeds Annual loan payment Annual facility purchases Annual equipment sales 500,000 122% 450,000 200,000 105% 94% 6% 93% 7% 45% 10% 32,000 20,000 10,000 6,000 8,000 35,000 150,000 65,000 7,500 10,000 300,000 81,171 75,000 10,000 Cash Budget Waren Sports Supply is planning to invest $300,000 in a new storage facility. They need to borrow this money from the bank. The bank has requested a 4-year cash budget, broken down by year (2016 - 2019). You have been provided with a template that includes an assumption area, as well as the data for the assumption area. Your job is to create the cash budget based on the data provided below and on the worksheet. First, some principles of good spreadsheet design: 1. Whenever possible, isolate data that may change into an assumptions area. This will help you immensely if you need to change the assumptions and facilitates \"what-if\" analysis. When management says, \"I think 22% growth in sales per year is overly optimistic. What happens if we project it at 18%?\" you should be able to change cell B44 on the spreadsheet and the change should propagate through the spreadsheet. The assumptions are has been provided for you with this project. 2. Use range names when appropriate. In this case, you should use range names for cells B43:B67. This makes it easier to read the formulas in cells B5:E40, as they will be written in \"English\