Hi I need help with this excel assignment. The yellow cells are what I'm supposed to fill in to do this assignment. I have to input formulas not just numbers. So please don't just put a number like "14,000" it would have to be "=B25", otherwise the software will mark me incorrect. After I input the formula the software will fill in the cell with the total answer. The grey cells are ones that I missed too many times and the software input the correct answer for me although it is marked wrong. Please help me!!! ? If you can't read the assignment click on "attachment1.png" and you should be able to zoom in! Thank you!!!

Preparing a Cash Budget with Supporting Schedules using Excel's Multi-Tab Cell Referencing and Basic Math Functions S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. . Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell on the Budget Data tab, "=85" was entered, the formula would output the result from cell B5, or 1,600 in this example. b Cell Reference: Allows you to refer to data from another cell in a separate tab in the worksheet. When using the multi-tab cell reference, type the equal sign first, then click on the other tab and then click on the cell you want to reference. The syntax of a mulu-tab cell reference looks different than a normal cell refer by apostrophes and also an exclamation point before the cell locati Jules and Cash Budget tab *='Budget Data'!C7" was entered, the formula would output the result from cell C7 in the Budget Data tab, or 33,750 in this example. functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), * (asterisk si an to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell on the Budget Data tab, "=B1 ould add the values from those cells and output the result, or 34,000 in this example. If using the other mat . SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. From the Excel Simulation below, if in a blank cell "=SUM(B10,B11,B12)" was entered, the formula would output the result of a those three separate cells, or 97% in this example. Similarly, if in a blank cell *=SUM(B10:812)" was entered, the formula would output the same result of adding those cells, except they are expressed as ge in the formula, and the result would be 97% in this example. Supporting Lash Collections and Disbursements sch HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW on In P 5 . . & - : Cash Budget with Supporting Cash Collections and Disbursements Schedules . Excel 7 20 - x FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calculate Now unction Defined For Calculate Now Calculation E Calculate Sheet Function Defined Formula Calculation Calculate Sheet Calculation Library " Names - Auditing - O Calculation 245 Y I X V & Al vi x v & Expected cash collections: S & P Enterprises needs a cash budget for March. The following Information is available. March cash collections 3 Data January February March $ 5,100 Actual January and February and expected March sales: March collections on account: Cash sales $ 1,600 $ 3,750 $ 5,100 January sales 5,500 Sales on account 25,000 30,000 40,000 February sale 18,000 March sales 6,000 Total Sales $ 26.600 $ 33.750 $ 45.100 Total cash collections Accounts Receivable Collections: Month of sale 9Payments to suppliers: Month following sale 15% Accounts payable for Inventory purchases, beginning balance Second month following sale Uncollectible 22% 11 March purchases 14,100 2Total cash payment 5 Accounts payable for Inventory purchases, March 1 balance $10,500 14 S & P Enterprises 6 Budgeted Inventory pu $23,500 15 Cash Budget 16 7 Inventory payments: or the Month of March th of purchase 60% 18 Cash bala 19 Month following purchase 40%% $ 11,500 Add cash receipts: 1 Total budgeted selling & administrative expenses in March $12,500 20 Collections from customers 34,600 2 Budgeted selling & administrative depreciation in March $3,200 21 Total cash available before current financing 46,100 12 Less disbursements: 4 Inther budgetord each dichurcomments in March Payments to suppliers $ 24,600 * .. Budget Data Schedules and Cash Budget | ... 4 selling and adminisat Data .Schedules and Cash Budget ... 1 6 - @. & - : Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel 7 - 8 x H 5 . . & . : Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel 7 20 - 8 x HOME PAGE LAYOUT FORMULAS DATA REVIEW VIEW HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calculate Now fx | Calculate Now ibrary " Names Auditing - Options Function Defined Formula Calculation # Calculate Sheet Library " Names Auditing - Op Calculation Calculation A45 " I X V & Al vi x y & Expected cash collections : 2 Budgeted selling & administrative depreciation in March $3,200 14 15 S & P Enterprises 24 Other budgeted cash disbursements in March 16 Cash Budget Equipment purchases $14,000 for the Month of March Dividends to be paid $2,000 18 Cash balance, March $ 11,500 28 Minimum cash balance to be maintained $10,000 19 Add cash receipts: 29 March 1 cash balance $11,50 o Collections from customers 30 March 1 outstanding borrowings SO 21 Total cash available bef 46,100 31 March 1 interest due 22 Less disbursements: 24 Sell Selling and administratly $ 24,600 3 The company has a line of credit available to bolst 25 Equ Equipment purchases 85 When preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules. 6 Dividends paid 27 Total disbursements 37 Click the Schedules and Cash Budget tab to prepare the following: po cess (deficiency) of cash available over disbursements 38 1. Schedule of expect lions for March. 29 Financing: 39 2. Schedule of expected cash disbursements for Inventory purchases for March. 30 Borrowings 3. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that 31 Repayments 41 any interest will not be paid until the following month. 2Interest 93 Total financing 34 Cash balance, March 31 35