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,...
-
Why is it important for the financial manager to understand the inventory control techniques used by production/operations managers? How does controlling inventory impact a firms profitability?
-
Which of the following will increase a companys current liabilities? 1. A company purchases a new truck with cash. 2. A company receives cash from taking out a long-term loan. 3. A company collects...
-
American Down and Out Call. Given \(K=100, T=\frac{1}{30}, S=100, \sigma=0.6, r=\) 0.01 , and \(B=95\). Construct a tree for all nodes below the barrier value \(=0\).
-
John Smith has developed the following forecasting model: Y = 36 + 4.3X1 Where Y = Demand for K10 air conditioners X1 = the outside temperature (F) (a) Forecast the demand for K10 when the...
-
How do servant leadership practices foster a culture of empowerment and innovation within hierarchical structures, particularly in knowledge-intensive industries ?
-
Larry, age 32, works for Horizon Corporation. His annual salary is $60,000 and he is not a key employee. Horizon provides the following benefits to all employees: Group term life insurance (each...
-
If 200 JD is deposited once at 8% interest per year, compounded continuously, how much will be in the account after 5 years? Select one: 298.36 JD 201.09 JD 100.55 JD 149.18 ID
-
A fluidized bed is used in the production of aniline by the hydrogenation of nitrobenzene. Single-stage cyclones, followed by candle filters, are used to remove fines from the gases leaving the...
-
Current assets are listed: a. in the reverse order of expected conversion to cash. b. by importance. c. by longevity. d. by size.
-
The order of the accounts in the ledger is: a. assets, revenues, expenses, liabilities, share capitalordinary, dividends. b. assets, liabilities, share capitalordinary, dividends, revenues, expenses....
-
Explain how a ledger and posting help in the recording process.
-
During 2025, Xia Lin Companys assets decreased 500,000 and its liabilities decreased 900,000. Its equity therefore: a. increased 400,000. b. decreased 1,400,000. c. decreased 400,000. d. increased...
-
5. Write a Java program to implement Breadth First Search for the graph given below: 1 3 2 6 5 7
-
A superior criticized a sales manager for selling high-revenue, low-profit items instead of lower-revenue but higher-profit items. The sales manager responded, My income is based on commissions that...
-
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...
-
Consider a two-level system, with basis \(|1angle,|2angle\), and in this basis, a Hamiltonian with elements \(\left(\begin{array}{ll}1 & 1 \\ 1 & 1\end{array} ight)\). Use the first form of the...
-
Use the practical variational method for the same harmonic oscillator ground state energy, with trial wave function \(\psi_{a}(x)=e^{-a y^{2}}\).
-
Use the Ritz variational method for the harmonic oscillator, with trial wave functions \(\psi_{1}(x)=\) \(e^{-y^{2} / 2}, \psi_{2}(x)=e^{-y^{2}}, \psi_{3}(x)=e^{-2 y^{2}}\), where \(y=x \sqrt{m...
Study smarter with the SolutionInn App