what is the formula for each column for example what is the formula for the weak economic condition?

BAY WATER CERAMICS Cash Budget April - June February March (Actual) (Actual) April (Forecast) May (Forecast) CASH RECEIPTS BUDGET Sales Credit Sales 75% Cash sales 25% Collections current month 40% Collections next month 35% Collections 2nd month 25% Total Credit Collections Total Cash Receipts CASH PAYMENTS BUDGET Purchases Payments current month 40% Payments following month 60% Depreciation Net Cash Expenses Interest expense New Equipment TOTAL CASH PAYMENTS CASH BUDGET Opening Cash Balance Cash receipts Cash Payments CLOSING CASH BALANCELeases Increase by 2% Increase by 4% Increase by 7% Other nancial expenses Decrease by 2% Increase by 3% Increase by 8% REQUIRED Open the excel spreadsheet le FNSACC412_AE_Sk_1of3_SR_lof1.xlsx. Open the worksheet 'Budget Plan2go' The Chief Financial Ofcer is unsure of the direction of the economy for 20X2. You have been asked to prepare 3 budgeted income statements for 20x2, based on: 0 Average economic conditions 0 Poor economic conditions ' Strong economic conditions Use the templates in the excel file to create your 3 budgets, based on the above information. The template contains the actual revenue and expense data for 20X1. 20X1 was a year of average economic conditions. Open the excel spreadsheet file FNSACC412_AE_Sk_1of3_SR_1of1.:-clsx. Open the worksheet 'Budget Plan2go Unit Cost Table". Complete the table using the data you calculated from question 1 above. Review the statements from Plan2go's strategic plan 20X1 -2OX3. Analyse the data in the tables completed in the worksheet for part 2 above and answer the following questions