Formulas are showing in the corresponding cell
A | B | C | D | |
1 | Expected Cash Collections : | Amount $ | Formula | |
2 | March Cash Collections | $ 5,100 | ='Budget Data'!D5 | |
3 | March Cash Collections on account | |||
4 | January Sales ($25,000 * 22%) | $ 5,500 | ='Budget Data'!B6*'Budget Data'!B12 | |
5 | February Sales ( $30,000 * 60%) | $ 18,000 | ='Budget Data'!C6*'Budget Data'!B11 | |
6 | March Sales ( $40,000 * 15%) | $ 6,000 | ='Budget Data'!D6*'Budget Data'!B10 | |
7 | Total Cash Collection | $ 34,600 | SUM(B2:B6) | |
8 | ||||
9 | Payments to Suppliers | Amount $ | ||
10 | Accounts payable for inventory purchase ($10,500* 40%) | $ 4,200 | ='Budget Data'!B15*'Budget Data'!B19 | |
11 | March Purchase ($23,500 * 60%) | $ 14,100 | ='Budget Data'!B16*'Budget Data'!B18 | |
12 | Total Cash Payments | $ 18,300 | SUM(B10:B11) | |
13 | ||||
14 | S & P Enterprises | |||
15 | Cash Budget | |||
16 | for month of March | Amount $ | Amount $ | Formula |
17 | ||||
18 | Cash Balance, March 1 | $ 11,500 | ='Budget Data'!B29 | |
19 | Add: Cash Receipts | |||
20 | Collection from Customers | $ 34,600 | =C7 | |
21 | Total Cash available before current financing | $ 46,100 | =C18+C20 | |
22 | Less: Disbursements | |||
23 | Payment to suppliers | $ 18,300 | =C12 | |
24 | Selling and administrative exps | $ 12,500 | ='Budget Data'!B21 | |
25 | Equipment purchases | $ 14,000 | ='Budget Data'!B25 | |
26 | Dividend Paid | $ 2,000 | ='Budget Data'!B26 | |
27 | Total Disbursements | $ (46,800) | =SUM(B23:B26) | |
28 | Excess (deficiency) of cash available for disbursements | $ (700) | =C21+C27 | |
29 | Financing : | |||
30 | Borrowings | $ 10,700 | ||
31 | Repayments | $ - | ||
32 | Interest | $ - | ||
33 | Total Financing | $ 10,700 | =SUM(C30:C32) | |
34 | Cash Balance, March 31 | $ 10,000 | =C28+C33 |
Please show formula !!! Preparing a Cash Budget with Supporting Schedules using Excel's Multi-Tab Cell Referencing...
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...
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...
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...
please answer thankyou 1 Overhead Analysis and Preparing Schedules of Cost of Goods using Excel's SUM and Basic Math Functions 10 pos Stanford Enterprises has provided its manufacturing estimated and actual data for the year and The Controller has asked you to compute the predetermined overhead rate the schedule of cost of goods manufactured, and the schedule of cost of goods sold Use the information included in the Excel Simulation and the Excel functions described below to complete the task...
Preparing a Performance Report using Excel's ABS, IF and SUM Functions Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. 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...
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...
velue 100.00 polnts Preparing a Classifled Balance Sheet using Excel's SUM Function and Cell Referencing Lantana Company has opened its company and has recorded its first month of transactions in T-accounts. The Controller has asked you to prepare the companys classified balance sheet at the month end based on those transactions. 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...
AC313 required: Preparing a Statement of Cash Flows Using the Direct Method using Excel's SUM Function and Multi- tab References Innovation Electronics, Inc. has provided you with the year end Income Statement Balance Sheet. The Controller has asked you to prepare the Statement of Cash Flows for the same year ended December 31, Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Multi-Tab Cell Reference: Allows you to refer to data...
Ac313 Preparing an Income Statement using Excel's SUM, IF and Basic Math Functions 2 Reading Readiness, Inc. has provided you its list of accounts and balances as of January 31. The Controller has asked you to prepare an Income Statement for the month ended January 31. Use the information included in the Excel Simulation and the Excel functions described below to complete the task nts Cell Reference; Allows you to refer to data from another cell in the worksheet. From...
Reporting Adjusted Account Balances using Excel's SUM, Basic Math Functions and Cell Referencing Maple Moving Company has provided a list of its account balances as of December 31, 2016 before year-end adjustments. The Controller has also provided you with a list of year end data to determine the adjusted account balances and has asked you to prepare the adjusted trial balance. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell...