Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

I want to know these questions. This question is just getting answer of chart.

image text in transcribed 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 days

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

Introduction to Finance Markets, Investments and Financial Management

Authors: Ronald W. Melicher, Edgar A. Norton

16th edition

1119398282, 978-1-119-3211, 1119321115, 978-1119398288

More Books

Students also viewed these Finance questions

Question

what are the different stages of the business research process?

Answered: 1 week ago