Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I want to know these questions. This question is just getting answer of chart. AGBM 200 Cash Flow Problem Cash Outflows: A. Estimated Sales B.
I want to know these questions. This question is just getting answer of chart.
AGBM 200 Cash Flow Problem Cash Outflows: A. Estimated Sales B. Purchases C. Payment of Accounts Payable D. Selling & Adm. Expenses E. Total Cash Outflows (C+D) Jan. J. Beginning Cash Balance K. Cash Inflow (I) L. Total Cash Available (J+K) M. Cash Outflow (E) N. Net Cash Position (L-M) O. Needed Borrowings P. Loan Repayments Q. Ending Cash Balance R. Cumulative Borrowings May June 160 200 400 240 120 Answer 3 Answer 4 Answer 5 Answer 6 Answer 7 Answer 8 Answer 9 Answer 10 Answer 11 Answer 12 Answer 13 Answer 14 Answer 15 Answer 16 Answer 17 Answer 18 Answer 19 Answer 20 Answer 21 Answer 22 Answer 23 May June 70 100 Cash Flow Budget Apr. Answer 2 F. Estimated Sales I. Total Cash Inflows (G+H) Mar. 100 Jan. H. Collection Sales 2 Months Ago Feb Answer 1 Cash Inflows G. Collection Sales Last Month Page 1 of 2 Feb 160 Answer 24 Mar. 200 Apr. 400 240 120 Answer 25 Answer 26 Answer 27 Answer 28 Answer 29 Answer 30 Answer 31 Answer 32 Answer 35 Answer 36 Answer 37 Answer 38 60 50 Answer 33 Jan. 60 Answer 34 May June Answer 39 Answer 40 Feb Answer 41 Mar. Answer 42 Apr. Answer 43 Answer 44 Answer 45 Answer 46 Answer 47 Answer 48 Answer 49 Answer 50 Answer 51 Answer 52 Answer 53 Answer 54 Answer 55 Answer 56 Answer 57 Answer 58 Answer 59 Answer 60 Answer 61 Answer 62 Answer 63 Answer 64 Answer 65 Answer 66 Answer 67 Answer 68 Answer 69 Answer 70 Answer 71 Answer 72 Answer 73 Answer 74 Answer 75 Answer 76 Answer 77 Answer 78 Answer 79 Answer 80 Answer 81 Answer 82 Answer 83 Answer 84 Answer 85 Answer 86 Answer 87 Answer 88 Answer 89 Answer 90 Answer 91 Answer 92 AGBM 200 Cash Flow Problem Page 2 of 2 The Assumptions: 1. 2. 3. 4. 5. 6. 7. 8. 9. All sales are on credit. Accounts Receivable Turnover Ratio = 8 = 45 days. This means that 1/2 of the customers pay one month after the sale and the other 1/2 pays two months after the sale. Cost of Goods Sold is 70% of sales. July sales are 100. Accounts Payable Turnover Ratio = 12 = 30 days. Monthly selling and administrative expenses are 40. Beginning cash balance is 100. Minimum cash balance is never less than 50. Inventory Turnover Ratio = 12 = 30 daysStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started