the last slide is the one that needs to be filled out
Posted: Sun May 08, 2022 10:06 am
the last slide is the one that needs to be filled out
Chapter 18 Question 5 Input Area 5 Beginning AR . Collection period o Collection period c Collection period 265 45 30 30 APP F 35% 01 Q2 03 04 Sales $ 620 5 070 $ 020 $ 5 730 Output Area 04 a 01 03 620 04 10 670 110 5 BEAR scoll from our Totalcat Cell 110 335 645 $ $ 45 day collection period 01 Beginning receivables $ 265.00 $ Sales 620.00 Cash collections 575.00) Ending receivables 3 310.00 $ 02 310.00 670.00 (645.00) 335.00 03 335.00 520.00 (645.00 310.00 04 310.00 730.00 1675.00) 366.00 $ $ b $ $ 60 day collection period Beginning receivables $ 265.00 $ Sales 620.00 Cash collections (471.67) Ending receivables $ 41333 $ 413.33 670.00 (636.67) 446 67 446.67 620.00 (653.33) 413 33 413.33 730.00 (656.67) 486.67 $ 5 $ 5 30 day collection period Beginning receivables $ 255.00 $ Sales 620.00 Cash collections (678.33) Ending receivables 5 206.67 $ 208.67 670.00 (653.33) 223.33 223.33 620.00 (636.67) 206.67 206,67 730.00 (693.33) 243.33 $ $
Chapter 18 Question Input Area Projected sales increase Orders (of sales) Jo. Payables period c Payables period 15% 30% 90 60 01 1.210 03 Sales 5 $ 02 1,330 5 04 1.400 Outour Area Beg Av Pats made our traders Totalt 01 02 os 04 01 $ 1210 $ 1.330 $ 1.170 5 14695 1332 202 24 214 292 333 117 145 133.15 375 38 30 411.15 Q3 438.00 04 417.45 S Jo. The payable period is zoro since payment is made immediately, Payment in each period 0.30 times next period sales 01 02 Payment of accounts $ 399.00 5 351.00 $ b. If the payables period is 90 days Payment of accounts 5 363.00 5 399.00 $ 351.00 $ 438.00 le the payables period is Payment of account 60 days 375.00 - $ 5 431.15 383.00 - 5 380,00 - 5
Chapter 18 Question 11 Input Area: Uncollected credit sales Collected in the month of the sale Collected in the following month Previous month credit sales Previous month credit purchases Beginning cash $ $ $ 5% 35% 60% 459,000 248,400 342,000 April 486,000 $ 240,100 May 549,000 $ 288,100 June 586,800 286,200 Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment purchases 62,700 17,600 127.800 86,800 17,600 148,400 95,100 17,600 Output Area: Sales collections = .35 times current month sales + .60 times previous month sales. April 342,000 $ May 331,000 $ June 321,850 445,500 787,500 $ $ 483,750 814,750 $ 534,780 856,630 Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements Purchases Wages, taxes, and expenses Interest Equipment purchases Total cash disbursements Ending cash balance 248,400 $ 62,700 17,600 127,800 456,500 331,000 $ 240,100 $ 86,800 17,600 148,400 492,900 *321,850 $ 288,100 95,100 17,600 $ 400,800 455,830
Sales (st quarter of next year) AR Collection period of purchases for next Sales Suppliers paid of sales for expenses Interest and dividendo Outlay in seconda Beginning cash balance Minimum balance in millions) Borrowing rate Invested securities Beginning short-term borrowing 175 53 45 45% 36 30% 15 45 36 20 3% $ $ $ Q1 02 03 04 Sales in milliona) $ 180$ 145 $ 100 % Output Aroa 45-day collection period means sales collections 12 current sales +1/2 oldes 36-day payables period means payables = 35 current orders - 2/5 old orders Q1: Cash flow 12.05 02. Cash flow $ (28.40) Q3: Cash flow $ Q4. Cash flow $ 37.15 02 03 $ Beginning cash balance Net cash inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit) Cash Balance Q1 36.00 5 12.05 48.065 20.00) 28.05 S 46.065 (25.40 19.655 (2000) 10.35) $ 5 04 21.55 37.15 68.70 120.00) 3870 1965 5 1.90 21.05 3 (20.091 1.55$ $
Chapter 18 NAME: Keafer Manufacturing Working Capital Management Input Area: Input Data (Do not change (These are different from Textbook intonic Come on here Beginning cash balance Outlay in third Q Targot cash balance 105.800 305,000 95.000 01 795.000 $ Last years' sales $ 02 844,000 $ Q3 914,000 $ 04 783.000 7.90% 50 Days 3273000100 Growth rate in sales Collection period Beg AR Percent uncollectible of purchases for next sales Suppliers paid X of sales for expenses Interest and dividends 44% 30 Days 23% 32.000 5 Output Area:
Output Ams: Sales next year Sales following year Quarterly cash flow of 02 03 04 Collections from previous Quarter Collections from Ourrent quarter sales Payments to suppliers for previous quarter Payments to suppliers for current quarter Expenses Dividends and interest Outlay Not cash flow Cash Balance 01 Q2 03 04 Beginning cash balance Net cash inlow Ending cash balance Minimum cash balance Cumulative surplus defic
- The Last Slide Is The One That Needs To Be Filled Out 1 (33.52 KiB) Viewed 32 times
- The Last Slide Is The One That Needs To Be Filled Out 2 (27.77 KiB) Viewed 32 times
- The Last Slide Is The One That Needs To Be Filled Out 3 (66.58 KiB) Viewed 32 times
- The Last Slide Is The One That Needs To Be Filled Out 4 (30.43 KiB) Viewed 32 times
- The Last Slide Is The One That Needs To Be Filled Out 5 (27.52 KiB) Viewed 32 times
- The Last Slide Is The One That Needs To Be Filled Out 6 (31.08 KiB) Viewed 32 times
Chapter 18 Question Input Area Projected sales increase Orders (of sales) Jo. Payables period c Payables period 15% 30% 90 60 01 1.210 03 Sales 5 $ 02 1,330 5 04 1.400 Outour Area Beg Av Pats made our traders Totalt 01 02 os 04 01 $ 1210 $ 1.330 $ 1.170 5 14695 1332 202 24 214 292 333 117 145 133.15 375 38 30 411.15 Q3 438.00 04 417.45 S Jo. The payable period is zoro since payment is made immediately, Payment in each period 0.30 times next period sales 01 02 Payment of accounts $ 399.00 5 351.00 $ b. If the payables period is 90 days Payment of accounts 5 363.00 5 399.00 $ 351.00 $ 438.00 le the payables period is Payment of account 60 days 375.00 - $ 5 431.15 383.00 - 5 380,00 - 5
Chapter 18 Question 11 Input Area: Uncollected credit sales Collected in the month of the sale Collected in the following month Previous month credit sales Previous month credit purchases Beginning cash $ $ $ 5% 35% 60% 459,000 248,400 342,000 April 486,000 $ 240,100 May 549,000 $ 288,100 June 586,800 286,200 Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment purchases 62,700 17,600 127.800 86,800 17,600 148,400 95,100 17,600 Output Area: Sales collections = .35 times current month sales + .60 times previous month sales. April 342,000 $ May 331,000 $ June 321,850 445,500 787,500 $ $ 483,750 814,750 $ 534,780 856,630 Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements Purchases Wages, taxes, and expenses Interest Equipment purchases Total cash disbursements Ending cash balance 248,400 $ 62,700 17,600 127,800 456,500 331,000 $ 240,100 $ 86,800 17,600 148,400 492,900 *321,850 $ 288,100 95,100 17,600 $ 400,800 455,830
Sales (st quarter of next year) AR Collection period of purchases for next Sales Suppliers paid of sales for expenses Interest and dividendo Outlay in seconda Beginning cash balance Minimum balance in millions) Borrowing rate Invested securities Beginning short-term borrowing 175 53 45 45% 36 30% 15 45 36 20 3% $ $ $ Q1 02 03 04 Sales in milliona) $ 180$ 145 $ 100 % Output Aroa 45-day collection period means sales collections 12 current sales +1/2 oldes 36-day payables period means payables = 35 current orders - 2/5 old orders Q1: Cash flow 12.05 02. Cash flow $ (28.40) Q3: Cash flow $ Q4. Cash flow $ 37.15 02 03 $ Beginning cash balance Net cash inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit) Cash Balance Q1 36.00 5 12.05 48.065 20.00) 28.05 S 46.065 (25.40 19.655 (2000) 10.35) $ 5 04 21.55 37.15 68.70 120.00) 3870 1965 5 1.90 21.05 3 (20.091 1.55$ $
Chapter 18 NAME: Keafer Manufacturing Working Capital Management Input Area: Input Data (Do not change (These are different from Textbook intonic Come on here Beginning cash balance Outlay in third Q Targot cash balance 105.800 305,000 95.000 01 795.000 $ Last years' sales $ 02 844,000 $ Q3 914,000 $ 04 783.000 7.90% 50 Days 3273000100 Growth rate in sales Collection period Beg AR Percent uncollectible of purchases for next sales Suppliers paid X of sales for expenses Interest and dividends 44% 30 Days 23% 32.000 5 Output Area:
Output Ams: Sales next year Sales following year Quarterly cash flow of 02 03 04 Collections from previous Quarter Collections from Ourrent quarter sales Payments to suppliers for previous quarter Payments to suppliers for current quarter Expenses Dividends and interest Outlay Not cash flow Cash Balance 01 Q2 03 04 Beginning cash balance Net cash inlow Ending cash balance Minimum cash balance Cumulative surplus defic