Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Complete the schedule of expected cash collections. Schedule of Expected Cash Collections May June Cash sales Credit sales Total collections April $ 43,200 22,400 $ 65,600 $ Required 4 0 $ Quarter 0 $ Required 5 Required 1 Required 2 Required 3 Required 4 Required 5 Complete the merchandise purchases budget and the schedule of expected cash disburs Merchandise Purchases Budget April May $ 54,000 $57,750 46,200 100,200 57,750 43,200 $57,000 Budgeted cost of goods sold Add desired ending merchandise inventory Total needs Less beginning merchandise inventory Required purchases $57,750 $ Budgeted cost of goods sold for April = $72,000 sales x 75% = $54,000. Add desired ending inventory for April = $57,750 × 80% = $46,200. March purchases April purchases May purchases June purchases Total disbursements May Schedule of Expected Cash Disbursements-Merchandise Purchases June April $25,800 28,500 28,500 June $54,300 $28,500 0 0 0 Quarter $ 0 0 Quarter $ 25,800 57,000 82,800 Complete the cash budget. (Cash deficiency, repayments and interest should be indicated by a minus sign.) Shilow Company Cash Budget April Beginning cash balance Add collections from customers Total cash available Less cash disbursements: For inventory For expenses For equipment Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance $ 8,100 65,600 73,700 69 54,300 15,860 2,100 72,260 1,440 0 1,440 $ May 0 0 0 0 0 69 June 0 0 0 0 0 Quarter EA 0 0 0 0 0 Income Statement For the Quarter Ended June 30 Cost of goods sold: Selling and administrative expenses: 0 0 0 0 0 0 Required 1 Required 2 Required 3 Prepare a balance sheet as of June 30. ....... Current assets: Total current assets Total assets Stockholders' equity: Shilow Company Balance Sheet June 30 Assets Required 4 Liabilities and Stockholders' Equity Total liabilities and stockholders' equity Required 5 $ $ 0 0 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Complete the schedule of expected cash collections. Schedule of Expected Cash Collections May June Cash sales Credit sales Total collections April $ 43,200 22,400 $ 65,600 $ Required 4 0 $ Quarter 0 $ Required 5 Required 1 Required 2 Required 3 Required 4 Required 5 Complete the merchandise purchases budget and the schedule of expected cash disburs Merchandise Purchases Budget April May $ 54,000 $57,750 46,200 100,200 57,750 43,200 $57,000 Budgeted cost of goods sold Add desired ending merchandise inventory Total needs Less beginning merchandise inventory Required purchases $57,750 $ Budgeted cost of goods sold for April = $72,000 sales x 75% = $54,000. Add desired ending inventory for April = $57,750 × 80% = $46,200. March purchases April purchases May purchases June purchases Total disbursements May Schedule of Expected Cash Disbursements-Merchandise Purchases June April $25,800 28,500 28,500 June $54,300 $28,500 0 0 0 Quarter $ 0 0 Quarter $ 25,800 57,000 82,800 Complete the cash budget. (Cash deficiency, repayments and interest should be indicated by a minus sign.) Shilow Company Cash Budget April Beginning cash balance Add collections from customers Total cash available Less cash disbursements: For inventory For expenses For equipment Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance $ 8,100 65,600 73,700 69 54,300 15,860 2,100 72,260 1,440 0 1,440 $ May 0 0 0 0 0 69 June 0 0 0 0 0 Quarter EA 0 0 0 0 0 Income Statement For the Quarter Ended June 30 Cost of goods sold: Selling and administrative expenses: 0 0 0 0 0 0 Required 1 Required 2 Required 3 Prepare a balance sheet as of June 30. ....... Current assets: Total current assets Total assets Stockholders' equity: Shilow Company Balance Sheet June 30 Assets Required 4 Liabilities and Stockholders' Equity Total liabilities and stockholders' equity Required 5 $ $ 0 0
Expert Answer:
Answer rating: 100% (QA)
A Schedule of Expected Cash Collections Total sales A Cash sales A60 Credit ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Complete this question by entering your answers in the tabs below. Required Required Required Required 1 2 4 Complete the new performance report for the quarter, based on Flexible Budget Performance...
-
Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute gross profit for each department. Department Gross Profit Skis Snowboards < Required 1 Required 2 >
-
(a) Find each sum. 1 + 2 + 3 + 4 + 5 = ? 1 + 2 + 3 + 4 + 5 + 6 + 7 + 8 = ? 1 + 2 + 3 + 4 + 5 + 6 + 7 + 8 + 9 + 10 = ? (b) Use the formula below for the sum of the first n natural numbers to verify...
-
The system shown consists of 3 cables. For example; cable C12 joins points 1 and 2. The coordinates of point 1 are (6.4, 0, 0) m, those of point 2 are (0, 9.5, -6.1) m, and those of point 3 are (0,...
-
What two factors determine the amount of federal withholding taxes that will be deducted from gross earnings each pay period? Explain.
-
The outputs of registers R0, R1, R2, and R3 are connected through 4-to-1 multiplexers to the inputs of a ifth register, R4. Each register is 8 bits long. The required transfers, as dictated by four...
-
Air is supplied to a convergent-divergent nozzle from a reservoir where the pressure is \(100 \mathrm{kPa}\). The air is then discharged through a short pipe into another reservoir where the pressure...
-
Review the 2007 balance sheet data for Hewlett-Packard (HP) and Dell shown below. 1. Compute each companys current ratio for 2007. Based on the result, which company appears to be more liquid? 2....
-
Requirement Determine the amount and type of financing component in the following contracts. (Click the icon to view the independent contracts.) Future Value of $1 table Future Value of an Ordinary...
-
The following relate to auditors independence: a. Why is independence so essential for auditors? b. Compare the importance of independence of CPAs with that of other professionals, such as attorneys....
-
Most of the resistance of the human body comes from the skin, asthe interior of the body contains aqueous solutions that are goodelectrical conductors. For dry skin, the resistance between aperson's...
-
Write a memorandum to the controller comparing and contrasting the two methods (percentage-of-accounts-receivable balance vs. percentage of sales). Recommend the method you think Gold should use, and...
-
Give two different specific examples of actions Panera Bread has taken to increase its Customer Lifetime Value. Explain how each action has increased Panera's Customer Lifetime Value. Discuss each...
-
They not only ask you for a bid price, but also request that you prepare a bid in the form of a professional report (including recap sheets, bid forms, etc.). The details of the required sections of...
-
Financial reporting in the not-for-profit sector There are no required IFRS readings for this module. Required readings from the textbook are listed with each topic. Overview This module outlines the...
-
Thanks Timothy for your input and discussing the concept of the risk-return trade-off. Under what specific circumstances can risk magnify a company's earnings in a positive way? Is it also possible...
-
rad 1. Consider the schematic model below of a mechanism. A torque, T(t) is applied to the left end. A torsional spring has constant k = 2.3 Nm, and the torsional damping component has a coefficient...
-
Swifty company is a publicly held corporation whose $1 par value stock is actively traded at $30 per share. The company issued 3400 shares of stock to acquire land recently advertised at $93000. When...
-
The table shows the numbers an (in thousands) of residents of Alabama from 2010 through 2015. (a) Find the first differences of the data shown in the table. Then find a linear model that approximates...
-
Use absolute value notation to define the interval (or pair of intervals) on the real number line. 1. 2. 3. 4. 5. All real numbers at least three units from 7 6. All real numbers more than five units...
-
A warehouse operator has 24,000square feet of floor space in which to store two products. Each unit of product I requires 20 square feet of floor space and costs $12 per day to store. Each unit of...
-
Home Inc. (a US company) has a wholly-owned subsidiary, S, which it acquired on 1 January X0. The balance sheets of S as at 1 January X0 and 31 December X0 are as set out in Figure 15.1 in foreign...
-
An entitys functional currency is: A. The currency of its parents country. B. The currency of its own country. C. The currency in which the financial statements are presented. D. The currency of the...
-
Entity X based in one country (currency $) bought goods from Entity Y in another country (currency :) for :300,000 on 1 May 20X1. The spot rate on that date was $1 = :1. As at 31 December 20X1, the...
Study smarter with the SolutionInn App