Question: Complete both tables Table 2: AgBiz Estimated Cash Inflows (Jan. - Apr.) Mar Item Sales Apr Jan $12,000 Feb $10,000 Cash Sales (S) S1.000 $2,000

 Complete both tables Table 2: AgBiz Estimated Cash Inflows (Jan. -

Complete both tables
Apr.) Mar Item Sales Apr Jan $12,000 Feb $10,000 Cash Sales (S)

Table 2: AgBiz Estimated Cash Inflows (Jan. - Apr.) Mar Item Sales Apr Jan $12,000 Feb $10,000 Cash Sales (S) S1.000 $2,000 $4,000 $5,000 Account Receivable (2 month old) Account Receivable (3 month old) Total Cash Inflows $2.000 $2.000 S1,000 Assumptions: 1. Sales are 1/4 cash, and 3/4 credits. 2. Account Receivable ratio is 4. Feb Table 3: Pro-Forma Cash Flow Budget Item Jan Mar Apr Initial Cash Balance S2,000 $2.000 $2,000 $2,000 Cash Inflow Total cash available Cash Outflow Net Cash Need Borrowings End Cash Balance $1.000 $1.000 $1.000 $2.000 Cumulative borrowings (Hint: These three tables are consistent. You are able to get cash inflow from table 2 and cash outflow from table 3) Based on the above Pro-Forma Cash Flow Budget, answer the following two questions: (1) Does the business need to borrow money? If yes, how much money needs to be borrowed

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!