B24 fx Payables period (days): E 13 With these projection, we can summarize Fun Toys' projected...

Transcribed Image Text:

B24 fx Payables period (days): E 13 With these projection, we can summarize Fun Toys' projected cash collection as: 14 15 16 Beginning receivables 17 Sales 18 Cash collections 19 Ending receivables 20 Q1 Q2 Q4 H M R Next, we need to consider cash disbursements. The cash disbursements will be in the form of payment of accounts payable, wages, taxes, and 21 other expenses, capital expenditures, and long-term financing expenses. We have the following information concerning these disbursements: 22 23 purchase is 60% of the next quart 24 Payables period (days): 60% 90 25 Wages, taxes, and other: 20% 26 Interest and dividends: 27 Capital expenditure (Q2) $ 20,000,000 $100,000,000 28 29 With the payables period shown, we can calculate the payments for the purchases made in the current quarter as: 30 31 32 33 Purchases paid in the current quarter: Purchases paid in the next quarter: 34 So, the cash disbursement projections are: Q1 Q2 Q3 Q4 35 36 37 Payment of accounts 38 Wages, taxes, and other 39 Capital expenditures 40 Interest and dividends 41 42 Total cash disbursements 43 The total cash inflows for Fun Toys is projected to be: 44 45 46 Total cash collections 47 Total cash disbursements 48 Net cash inflow 49 Q1 Q2 Q3 Q4 image (1).png 50 To calculate the cash balance each quarter for Fun Toys, we need to know the beginning cash balance and minimum cash balance, which are: 50 To calculate the cash balance each quarter for Fun Toys, we need to know the beginning cash balance and minimum cash balance, which are: 51 52 53 54 Beginning cash balance: $ 20,000,000 Minimum cash balance: $ 10,000,000 55 Finally, we can calculate the cash balance each quarter for Fun Toys, which is: 56 57 58 Beginning cash balance 59 Net cash inflow 50 Ending cash balance 51 52 Minimum cash balance Cumulative surplus (deficit) 53 54 Q1 Q2 Q3 Q4 B24 fx Payables period (days): E 13 With these projection, we can summarize Fun Toys' projected cash collection as: 14 15 16 Beginning receivables 17 Sales 18 Cash collections 19 Ending receivables 20 Q1 Q2 Q4 H M R Next, we need to consider cash disbursements. The cash disbursements will be in the form of payment of accounts payable, wages, taxes, and 21 other expenses, capital expenditures, and long-term financing expenses. We have the following information concerning these disbursements: 22 23 purchase is 60% of the next quart 24 Payables period (days): 60% 90 25 Wages, taxes, and other: 20% 26 Interest and dividends: 27 Capital expenditure (Q2) $ 20,000,000 $100,000,000 28 29 With the payables period shown, we can calculate the payments for the purchases made in the current quarter as: 30 31 32 33 Purchases paid in the current quarter: Purchases paid in the next quarter: 34 So, the cash disbursement projections are: Q1 Q2 Q3 Q4 35 36 37 Payment of accounts 38 Wages, taxes, and other 39 Capital expenditures 40 Interest and dividends 41 42 Total cash disbursements 43 The total cash inflows for Fun Toys is projected to be: 44 45 46 Total cash collections 47 Total cash disbursements 48 Net cash inflow 49 Q1 Q2 Q3 Q4 image (1).png 50 To calculate the cash balance each quarter for Fun Toys, we need to know the beginning cash balance and minimum cash balance, which are: 50 To calculate the cash balance each quarter for Fun Toys, we need to know the beginning cash balance and minimum cash balance, which are: 51 52 53 54 Beginning cash balance: $ 20,000,000 Minimum cash balance: $ 10,000,000 55 Finally, we can calculate the cash balance each quarter for Fun Toys, which is: 56 57 58 Beginning cash balance 59 Net cash inflow 50 Ending cash balance 51 52 Minimum cash balance Cumulative surplus (deficit) 53 54 Q1 Q2 Q3 Q4