Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

provide a short write up (2-3 paragrpahs) of the cashflow situation at this company after you completed the budgets. What are your concerns and what

provide a short write up (2-3 paragrpahs) of the cashflow situation at this company after you completed the budgets. What are your concerns and what would you recommend to management?
BELOW ARE THE NUMBERS TO HELP WITH THE SHORT WRITE UP!!! image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Required: Using the data above, for the 2 nd quarter ending June 302020 , prepare the following: a. The schedule of the expected cash collections b. The merchandise purchases budget: c. The schedule of expected cash disbursements - merchandise purchases. d. The schedule of expected cash disbursement-Selling and administrative expenses e. The cash budget: f. An absorption costing income statement, for the quarter ending June 302020 g. A balance sheet as of June 30,2020 "Provide a short write up (2-3 paragraphs) of the cashflow situation at this company after you completed the budgets. What are your concerns and what would you recommend to management? C. schedule of cash disbursements-merchandise purchases \begin{tabular}{|l|l|l|l|} \hline particulars & april(\$) & may($) & june(\$) \\ \hline purchases & 49,138 & 43,758 & 41,886 \\ \hline \end{tabular} cash disbursements payment in cash (50\%) payment in the following month (50%) total cash distribution f 24,569 22,400 21,879 20,943 46,969 24,569 21,879 46,44842,822 D. schedule of cash disbursements- selling and administrative expenses particular april ($) may($) june(\$) commissions rent other expenses ( 7% of sales) total cash disbursement 8,500 2,000 8,5008,500 3,850 2,000 2,000 14,350 14,490 14,280 E. Cash budget particulars april($) may($) june(\$) receipts: collections for customers total receipts 43,550 55,520 56,220 43,55055,52056,220 payments: payment for purchases payment for expenses purchase of assets total payments cash surplus (deficit) 20,769 8,918 882 finance: borrowings repayments \begin{tabular}{|r|r|r|} \hline 46,969 & 46448 & 42,822 \\ \hline 14,350 & 14,490 & 14,280 \\ \hline 3,000 & 3,500 & 0 \\ \hline 64,319 & 64,438 & 57,102 \\ \hline \end{tabular} interest payments 20,000 cash balance at the beginning cash balance at the end 4,000 9,000 1,000 0 0 0 0 0 3,231

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Artificial Intelligence In Accounting And Auditing Creating Value With Al Volume 5

Authors: Miklos A. Vasarhelyi, Dan O'Leary

1st Edition

1558761780, 978-1558761780

More Books

Students also viewed these Accounting questions