Intermediate Learning had prepared the following sales budget, schedule of budgeted cash receipts, and cash budget for 2025 mick the icon to view the original budgets.) Intermediate Leaming decided to revise ts valen budget to show fourth quarter sales of 050 tablets due to the expectation of increased holiday sales Click the icon to view the revised sales budget) Requirement 1. Revise the schedule of budgeted cash receipts to include the increase in fourth quarter sales and the change in the timing of customer re Schule of Cash Receipts from Customers First Second Third Fourth Quarter Quarter Quarter Quarter Total Total sales 247500 247500 880000 467500 1842500 First Second Third Fourth Quarter Quarter Quarter Quarter Total Cash Receipts from Customers Accounts Receivable balance, December 31, 2024 20000 ist Cash sales 99000 1 eet sales collected in 1st 44550 Istot -- Credits collected in 2nd or tutt-Creta collected in 3rd 2nd - Credits collected in 2nd go End-Crottescotected in 3d Credits collected in that Cash sa -Credit sales colected in bed do Credit Score in the Enter my umber in the edit fields and then continue to the next question Suppose a change in the receipt of cash from sales on account is as follows: (Click the icon to view the revised receipt of cash information) Read the requirements ales customer receipts (If an input field is not used in the table, leave the input field empty, do not enter a zero. Round your answers to the nearest dollar) 1 Requirements - X 1. Revise the schedule of budgeted cash receipts to include the increase in fourth quarter sales and the change in the timing of customer receipts 2. How will the changes in cash receipts affect the cash budget? Print Done First Second Third Fourth Quarter Quarter Quarter Total Quarter Deipts from Customers: Recolvable balance December 31, 2024 20000 -Cash sales 99000 Credit sales collected in 1st to 44550 -Credit sales collected in 2nd qtr -Credit sales collected in 3rd qr -Cash salos Credits to collected in 2nd tr. Our Credit sales collected in 3rd gr -Credit sales collected in that -Cash sales Q-Creditsoles collected in 3rd que dr-Credit sales collected in that th Or-Cash salos matr-Credit les collected in that 163550 Total cash receipts from customers Requirement 2. How will the changes in cash receipts affect the cash budget Intermediate Learning will need to borrow funds because of the in cash receipts. This will result in of interest expenso a Enter any number in the edit hields and ti less o the next question more uit in of interest expense and in net income for the year a decrease an increase Original Budgets Total sales $ 247,500 $ 247,500 $ 880,000 $ 440,000 $ 1,815,000 First Second Third Fourth Quarter Quarter Quarter Quarter Total $ 20.000 99,000 44,550 $ 103,950 99,000 Cash Receipts from Customers: Accounts Receivable balance, December 31, 2024 1st Qur-Cash sales (40%) ist Qur-Credit sales (60%), 30% collected in 1st qtr. 1st Qtr-Credit sales (60%), 70% collected in 2nd qtr 2nd Qtr --Cash sales (40%) 2nd Qur-Credit sales (60%), 30% collected in 2nd to 2nd at Credit sales (60%), 70% collected in 3rd qr 3rd Qui ---Cash sales (40%) 3rd Qtr-Credit sales (60%) 30% collected in 3rd qtr. 3rd Qu ---Credit sales (60%). 70% collected in 4th qtr. 4th QtrCash sales (40%) Ath Qu. -Credit salos (60%), 30% collected in 4th qtr Total cash receipts from customers 44550 $ 103,950 352.000 158.400 $369,600 176,000 79 200 614,350 $ 624,800 $ 1.650.200 $ 163,550 $ 247.500 5 Accounts Receivable balance, December 31, 2025: 4th Qtr - Credit salas (60%) 70% collected in 1st qtr of 2026 S 184,800 Intermediate Leaming Print Done Original Budgets - Intermediate Learning Cash Budget For the Year Ended December 31, 2025 First Second Third Quarter Quarter Quarter Fourth Quarter Total $ 40,000 $ 163,550 40.3955 247,500 40,4405 614,350 40,795$ 40,000 624,800 1.650,200 203,550 287,895 654,790 665,595 1,690,200 Beginning cash balance Cash receipts Cash available Cash payments Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes 90.000 90.000 90.000 54,830 90,000 245,850 170,830 3,800 9,600 32.525 25,275 67750 1,500 0 8,200 30 775 67 750 1,500 2,400 240,650 7,000 29,275 71 600 1,500 1.680 360,000 712,160 28.600 117 850 287,500 6,000 10.200 1,522310 80,400 1.500 6,120 Interest expense 243.155 371,455 465,995 441,705 (39,605) (40,000) (83,560) (40,000) 180.795 (40,000) Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash exconn (dociency) Financing Borrowing 223,890 (40,000) 183,890 167.890 (40.000) (79,605) (123.560) 148,795 127 890 80.000 124.000 0 204.000 Print Done 243.155 371 455 465,995 441,705 1,522 310 (39,605) (40.000) (79,605) (83,560) (40,000) 188,795 (40,000) 223.890 (40,000) 167 890 (40,000) (123,560) 148,795 183,890 127.890 Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deuclency) Financing Borrowing Principal repayments Total offects of financing Ending cash balance 80,000 0 124.000 0 0 (148,000) (148,000) 204,000 (204,000) 80,000 124,000 0 (56,000) (56,000) 167,890 0 $ 40,395 $ 40,4405 40.795$ 167 890 Print Done - More Info * Requirements 1. Revise the schedule of budgeted cash receipts to include the increase in fourth quarter sales and the change in the timing of customer receipts 2. How win the changes in cash receipts affect the cash budget? 30% in the quarter of the sale 35% in quarter after the sale 33% two quarters after the sale 2% never collected Print Done Print Done Intermediate Learning had prepared the following sales budget, schedule of budgeted cash receipts, and cash budget for 2025 Click the icon to view the original budgets) Intermediate Leaming decided to revise its sales budget to show fourth quarter sales of 850 tablets due to the expectation of increased holiday sales (Click the icon to view the revised sales budget.) Question Help Suppose a change in the receipt of cash from sales on account is as follows: Click the icon to view the revised receipt of cash information) Read the requirements Requirement 1. Revise the schedule of budgeted cash receipts to include the increase in fourth quarter sales and the change in the timing of customer receipts (If an input field is not used in the table, leave the input field empty, do not enter a zoro Round your answers to the nearest dollar) Schdule of Cash Receipts from Customers First Second Third Fourth Quarter Quarter Quarter Quarter Total 247500 247500 Total sales 880000 467500 1842500 First Second Third Fourth Quarter Quarter Quarter Quarter Total 20000 99000 44550 Cash Receipts from Customers: Accounts Receivable balance, December 31, 2024 1st Cash salos 1st QuCredit sales collected in 1tr 1st Qur-Credit sales collected in 2nd qtr 1st QtrCredit sales collected in 3rd at 2nd -Cash sales 2nd Credit salon collected in 2nd tr 2nd Our Credit sales collected in and a 2nd Crodit sales collected in the 3rd Qui-Cash sales Enter any number in the edit hields and then continue to the next question 7 20000 accounts Receivable balance, December 31 2024 st Qtr-Cash sales 99000 44550 ist Qur-Credit sales collected in 1st qtr 1st Qtr --Credit sales collected in 2nd qtr 1st Qu-Credit sales collected in 3rd qtr 2nd @t-Cash sales 2nd Or-Credit sales collected in 2nd at 2nd Q.-Credit sales collected in 3rd qtr 2nd Qtr --Credit sales callocled in that 3rd Qur-Cash sales 3rd QtrCredit sales collected in 3rd te 3rd Ou --Credit sales collected in that Ath Or Cash sales 4th Or-Credit sales collected in 4th qu. Total cash receipts from customers 163550 Requirement 2. How will the changes in cash recoipts affect the cash budget? Intermediate Learning will need to borrow funds because of the In net income for the year In cash receipts. This will result in of interest expense and Enter any number in the edit Melds and then continue to the next question ared the following sales budget, schedule of sh budget for 2025 original budgets) Suppose a change in the receipt of cash from sales (Click the icon to view the revised receipt of cas Read the requirements to revise its sales budget to show fourth quarter expectation of increased holiday sales, revised sales budget.) UTS: De - Requirements din 1. Revise the schedule of budgeled cash receipts to include the increase in fourth quarter sales and the change in the timing of customer receipts 2. How will the changes in cash receipts affect the cash budget? ed in Led in Print Done sed in ted in the More Info - ced in 3rd qur red in 4th qtr ted in 4th qur 30% in the quarter of the sale 35% in quarter after the sale 33% two quarters after the sale 2% never collected tomers e changes in cash receipts eed to borrow fund Print Done result in of in for the year dit fields and then continue to the next question D Original Budgets Intermediate Learning Sales Budget For the Year Ended December 31, 2025 First Second Third Quarter Quarter Quarter Fourth Quarter Total Budgeted tablets to be sold 450 550 $ 450 550 $ 1,600 550 $ 800 550 $ 3,300 550 $ Sales price per unit 247,500 $ 247,500 $ 880,000 $ 440,000 $ 1,815,000 Total sales Schdule of Cash Receipts from Customers First Second Quarter Third Quarter Fourth Quarter Quarter Total Total sales S 247,500 $ 247,500 $ 880,000 $ 440,000 $ 1,815,000 First Second Third Fourth Quarter Quarter Quarter Quarter Total $ Cash Receipts from Customers: Accounts Receivable balance December 31, 2024 1st Qtr-Cash sales (40%) 1st Qtr-Credit salos (60%), 30% collected in 1st qtr 1st Qur-Credit sales (60%), 70% collected in 2nd qr 2nd Qur-Cash sales (40%) 2nd Otr-Credit sales (60%) 3056.collected in 2nd at 20,000 99,000 44,550 $ 103,950 99,000 44.550 Print Done - Onginal Budgets Schdule of Cash Receipts from Customers Total sales First Second Third Fourth Quarter Quarter Quarter Quarter Total $ 247,500 $ 247,500 $ 880,000 $ 440,000 $ 1,815,000 First Second Third Fourth Quarter Quarter Quarter Quarter Total 20,000 99 000 44,550 $ 103,950 99,000 Cash Receipts from Customers: Accounts Receivable balance. December 31, 2024 1st Qur-Cash sales (40%) 1st Qui --Credit sales (60%), 30% collected in 1st qtr. 1st Qt-Credit sales (60%), 70% collected in 2nd qtr. 2nd Qur Cash sales (40%) 2nd Qir-Credit sales (60%), 30% collected in 2nd qtr. 2nd Qur. --Credit sales (60%), 70% collected in 3rd que 3rd Qur-Cash sales (40%) 3rd Qur-Credit sales (60%), 30% collected in 3rd qr 3rd Qt-Credit sales (60%), 70% collected in 4th qu. 4th Qt-Cash sales (40%) 4th Qtr --Credit sales (60%), 30% collected in 4th gr. 44,550 $ 103,950 352,000 158,400 $ 369,600 176,000 79,200 614,350 $ 624,800 $ 1.650,200 $ 163,550 $ 247 500 $ Total cash receipts from customers Print Done Original Budgets Accounts Receivable balance, December 31, 2025: 4th QtCredit sales (60%), 70% collected in 1st qtr of 2026 $ 184,800 Intermediate Leaming Cash Budget For the Year Ended December 31, 2025 First Second Third Quarter Quarter Quarter $ 40.000 $ 40,395$ 40,440 $ 163,550 247,500 614,350 Fourth Quarter Total 40,795 $ 624,800 40,000 1,650,200 203,550 287,895 654,790 665,595 1,690,200 90.000 Beginning cash balance Cash receipts Cash available Cash payments Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes 54,830 3,800 25,275 67.750 1,500 0 90,000 170,830 8,200 30,775 67,750 1,500 2.400 90,000 245,850 9,600 32,525 80 400 1,500 6,120 90,000 240,650 7.000 29 275 71,600 1,500 1.680 360,000 712,160 28,600 117,850 287,500 6,000 10,200 Interest expenso 243.155 371.455 465,995 441 705 1,522,310 Total cash payments Ending cash balance before financing Minimum cash balance desired (39,605) (40,000) (83,560) (40,000) 188,795 (40,000) 223,890 (40,000) 167 890 (40,000) riginal Budgets Quarter Total Quarter Quarter Quarter 40,795 $ 624,800 $ eginning cash balance 40,000 $ 163,550 40,395 $ 247.500 40,440$ 614,350 40,000 1,650,200 287,895 203,550 654,790 665,595 1,690,200 Cash receipts Cash available Sash payments Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes 90,000 54830 3,800 25,275 90,000 170,830 8,200 30,775 67 750 1,500 2.400 371,455 90,000 245,850 9,600 32,525 80,400 1,500 6,120 90,000 240,650 7,000 29,275 71,600 1,500 1,680 360,000 712,160 28,600 117,850 287,500 6,000 10,200 67,750 1.500 0 243.155 465,995 441.705 1,522 310 (39,605) (40,000) (83,560) (40,000) 188,795 (40,000) 223.890 (40,000) 167 890 (40,000) Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (de ciency) Financing Borrowing Principal ropayments Total effects of financing (79,605) (123,660) 148.795 183,890 127,890 80.000 0 124.000 0 204,000 (204,000) 0 (148,000) (148 000) 40,795$ 80 000 0 (56,000) (56,000) 167,890 0 124,000 40,440 $ 40,395 $ Ending cash balance 167 890 Intermediate Learning had prepared the following sales budget, schedule of budgeted cash receipts, and cash budget for 2025 mick the icon to view the original budgets.) Intermediate Leaming decided to revise ts valen budget to show fourth quarter sales of 050 tablets due to the expectation of increased holiday sales Click the icon to view the revised sales budget) Requirement 1. Revise the schedule of budgeted cash receipts to include the increase in fourth quarter sales and the change in the timing of customer re Schule of Cash Receipts from Customers First Second Third Fourth Quarter Quarter Quarter Quarter Total Total sales 247500 247500 880000 467500 1842500 First Second Third Fourth Quarter Quarter Quarter Quarter Total Cash Receipts from Customers Accounts Receivable balance, December 31, 2024 20000 ist Cash sales 99000 1 eet sales collected in 1st 44550 Istot -- Credits collected in 2nd or tutt-Creta collected in 3rd 2nd - Credits collected in 2nd go End-Crottescotected in 3d Credits collected in that Cash sa -Credit sales colected in bed do Credit Score in the Enter my umber in the edit fields and then continue to the next question Suppose a change in the receipt of cash from sales on account is as follows: (Click the icon to view the revised receipt of cash information) Read the requirements ales customer receipts (If an input field is not used in the table, leave the input field empty, do not enter a zero. Round your answers to the nearest dollar) 1 Requirements - X 1. Revise the schedule of budgeted cash receipts to include the increase in fourth quarter sales and the change in the timing of customer receipts 2. How will the changes in cash receipts affect the cash budget? Print Done First Second Third Fourth Quarter Quarter Quarter Total Quarter Deipts from Customers: Recolvable balance December 31, 2024 20000 -Cash sales 99000 Credit sales collected in 1st to 44550 -Credit sales collected in 2nd qtr -Credit sales collected in 3rd qr -Cash salos Credits to collected in 2nd tr. Our Credit sales collected in 3rd gr -Credit sales collected in that -Cash sales Q-Creditsoles collected in 3rd que dr-Credit sales collected in that th Or-Cash salos matr-Credit les collected in that 163550 Total cash receipts from customers Requirement 2. How will the changes in cash receipts affect the cash budget Intermediate Learning will need to borrow funds because of the in cash receipts. This will result in of interest expenso a Enter any number in the edit hields and ti less o the next question more uit in of interest expense and in net income for the year a decrease an increase Original Budgets Total sales $ 247,500 $ 247,500 $ 880,000 $ 440,000 $ 1,815,000 First Second Third Fourth Quarter Quarter Quarter Quarter Total $ 20.000 99,000 44,550 $ 103,950 99,000 Cash Receipts from Customers: Accounts Receivable balance, December 31, 2024 1st Qur-Cash sales (40%) ist Qur-Credit sales (60%), 30% collected in 1st qtr. 1st Qtr-Credit sales (60%), 70% collected in 2nd qtr 2nd Qtr --Cash sales (40%) 2nd Qur-Credit sales (60%), 30% collected in 2nd to 2nd at Credit sales (60%), 70% collected in 3rd qr 3rd Qui ---Cash sales (40%) 3rd Qtr-Credit sales (60%) 30% collected in 3rd qtr. 3rd Qu ---Credit sales (60%). 70% collected in 4th qtr. 4th QtrCash sales (40%) Ath Qu. -Credit salos (60%), 30% collected in 4th qtr Total cash receipts from customers 44550 $ 103,950 352.000 158.400 $369,600 176,000 79 200 614,350 $ 624,800 $ 1.650.200 $ 163,550 $ 247.500 5 Accounts Receivable balance, December 31, 2025: 4th Qtr - Credit salas (60%) 70% collected in 1st qtr of 2026 S 184,800 Intermediate Leaming Print Done Original Budgets - Intermediate Learning Cash Budget For the Year Ended December 31, 2025 First Second Third Quarter Quarter Quarter Fourth Quarter Total $ 40,000 $ 163,550 40.3955 247,500 40,4405 614,350 40,795$ 40,000 624,800 1.650,200 203,550 287,895 654,790 665,595 1,690,200 Beginning cash balance Cash receipts Cash available Cash payments Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes 90.000 90.000 90.000 54,830 90,000 245,850 170,830 3,800 9,600 32.525 25,275 67750 1,500 0 8,200 30 775 67 750 1,500 2,400 240,650 7,000 29,275 71 600 1,500 1.680 360,000 712,160 28.600 117 850 287,500 6,000 10.200 1,522310 80,400 1.500 6,120 Interest expense 243.155 371,455 465,995 441,705 (39,605) (40,000) (83,560) (40,000) 180.795 (40,000) Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash exconn (dociency) Financing Borrowing 223,890 (40,000) 183,890 167.890 (40.000) (79,605) (123.560) 148,795 127 890 80.000 124.000 0 204.000 Print Done 243.155 371 455 465,995 441,705 1,522 310 (39,605) (40.000) (79,605) (83,560) (40,000) 188,795 (40,000) 223.890 (40,000) 167 890 (40,000) (123,560) 148,795 183,890 127.890 Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deuclency) Financing Borrowing Principal repayments Total offects of financing Ending cash balance 80,000 0 124.000 0 0 (148,000) (148,000) 204,000 (204,000) 80,000 124,000 0 (56,000) (56,000) 167,890 0 $ 40,395 $ 40,4405 40.795$ 167 890 Print Done - More Info * Requirements 1. Revise the schedule of budgeted cash receipts to include the increase in fourth quarter sales and the change in the timing of customer receipts 2. How win the changes in cash receipts affect the cash budget? 30% in the quarter of the sale 35% in quarter after the sale 33% two quarters after the sale 2% never collected Print Done Print Done Intermediate Learning had prepared the following sales budget, schedule of budgeted cash receipts, and cash budget for 2025 Click the icon to view the original budgets) Intermediate Leaming decided to revise its sales budget to show fourth quarter sales of 850 tablets due to the expectation of increased holiday sales (Click the icon to view the revised sales budget.) Question Help Suppose a change in the receipt of cash from sales on account is as follows: Click the icon to view the revised receipt of cash information) Read the requirements Requirement 1. Revise the schedule of budgeted cash receipts to include the increase in fourth quarter sales and the change in the timing of customer receipts (If an input field is not used in the table, leave the input field empty, do not enter a zoro Round your answers to the nearest dollar) Schdule of Cash Receipts from Customers First Second Third Fourth Quarter Quarter Quarter Quarter Total 247500 247500 Total sales 880000 467500 1842500 First Second Third Fourth Quarter Quarter Quarter Quarter Total 20000 99000 44550 Cash Receipts from Customers: Accounts Receivable balance, December 31, 2024 1st Cash salos 1st QuCredit sales collected in 1tr 1st Qur-Credit sales collected in 2nd qtr 1st QtrCredit sales collected in 3rd at 2nd -Cash sales 2nd Credit salon collected in 2nd tr 2nd Our Credit sales collected in and a 2nd Crodit sales collected in the 3rd Qui-Cash sales Enter any number in the edit hields and then continue to the next question 7 20000 accounts Receivable balance, December 31 2024 st Qtr-Cash sales 99000 44550 ist Qur-Credit sales collected in 1st qtr 1st Qtr --Credit sales collected in 2nd qtr 1st Qu-Credit sales collected in 3rd qtr 2nd @t-Cash sales 2nd Or-Credit sales collected in 2nd at 2nd Q.-Credit sales collected in 3rd qtr 2nd Qtr --Credit sales callocled in that 3rd Qur-Cash sales 3rd QtrCredit sales collected in 3rd te 3rd Ou --Credit sales collected in that Ath Or Cash sales 4th Or-Credit sales collected in 4th qu. Total cash receipts from customers 163550 Requirement 2. How will the changes in cash recoipts affect the cash budget? Intermediate Learning will need to borrow funds because of the In net income for the year In cash receipts. This will result in of interest expense and Enter any number in the edit Melds and then continue to the next question ared the following sales budget, schedule of sh budget for 2025 original budgets) Suppose a change in the receipt of cash from sales (Click the icon to view the revised receipt of cas Read the requirements to revise its sales budget to show fourth quarter expectation of increased holiday sales, revised sales budget.) UTS: De - Requirements din 1. Revise the schedule of budgeled cash receipts to include the increase in fourth quarter sales and the change in the timing of customer receipts 2. How will the changes in cash receipts affect the cash budget? ed in Led in Print Done sed in ted in the More Info - ced in 3rd qur red in 4th qtr ted in 4th qur 30% in the quarter of the sale 35% in quarter after the sale 33% two quarters after the sale 2% never collected tomers e changes in cash receipts eed to borrow fund Print Done result in of in for the year dit fields and then continue to the next question D Original Budgets Intermediate Learning Sales Budget For the Year Ended December 31, 2025 First Second Third Quarter Quarter Quarter Fourth Quarter Total Budgeted tablets to be sold 450 550 $ 450 550 $ 1,600 550 $ 800 550 $ 3,300 550 $ Sales price per unit 247,500 $ 247,500 $ 880,000 $ 440,000 $ 1,815,000 Total sales Schdule of Cash Receipts from Customers First Second Quarter Third Quarter Fourth Quarter Quarter Total Total sales S 247,500 $ 247,500 $ 880,000 $ 440,000 $ 1,815,000 First Second Third Fourth Quarter Quarter Quarter Quarter Total $ Cash Receipts from Customers: Accounts Receivable balance December 31, 2024 1st Qtr-Cash sales (40%) 1st Qtr-Credit salos (60%), 30% collected in 1st qtr 1st Qur-Credit sales (60%), 70% collected in 2nd qr 2nd Qur-Cash sales (40%) 2nd Otr-Credit sales (60%) 3056.collected in 2nd at 20,000 99,000 44,550 $ 103,950 99,000 44.550 Print Done - Onginal Budgets Schdule of Cash Receipts from Customers Total sales First Second Third Fourth Quarter Quarter Quarter Quarter Total $ 247,500 $ 247,500 $ 880,000 $ 440,000 $ 1,815,000 First Second Third Fourth Quarter Quarter Quarter Quarter Total 20,000 99 000 44,550 $ 103,950 99,000 Cash Receipts from Customers: Accounts Receivable balance. December 31, 2024 1st Qur-Cash sales (40%) 1st Qui --Credit sales (60%), 30% collected in 1st qtr. 1st Qt-Credit sales (60%), 70% collected in 2nd qtr. 2nd Qur Cash sales (40%) 2nd Qir-Credit sales (60%), 30% collected in 2nd qtr. 2nd Qur. --Credit sales (60%), 70% collected in 3rd que 3rd Qur-Cash sales (40%) 3rd Qur-Credit sales (60%), 30% collected in 3rd qr 3rd Qt-Credit sales (60%), 70% collected in 4th qu. 4th Qt-Cash sales (40%) 4th Qtr --Credit sales (60%), 30% collected in 4th gr. 44,550 $ 103,950 352,000 158,400 $ 369,600 176,000 79,200 614,350 $ 624,800 $ 1.650,200 $ 163,550 $ 247 500 $ Total cash receipts from customers Print Done Original Budgets Accounts Receivable balance, December 31, 2025: 4th QtCredit sales (60%), 70% collected in 1st qtr of 2026 $ 184,800 Intermediate Leaming Cash Budget For the Year Ended December 31, 2025 First Second Third Quarter Quarter Quarter $ 40.000 $ 40,395$ 40,440 $ 163,550 247,500 614,350 Fourth Quarter Total 40,795 $ 624,800 40,000 1,650,200 203,550 287,895 654,790 665,595 1,690,200 90.000 Beginning cash balance Cash receipts Cash available Cash payments Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes 54,830 3,800 25,275 67.750 1,500 0 90,000 170,830 8,200 30,775 67,750 1,500 2.400 90,000 245,850 9,600 32,525 80 400 1,500 6,120 90,000 240,650 7.000 29 275 71,600 1,500 1.680 360,000 712,160 28,600 117,850 287,500 6,000 10,200 Interest expenso 243.155 371.455 465,995 441 705 1,522,310 Total cash payments Ending cash balance before financing Minimum cash balance desired (39,605) (40,000) (83,560) (40,000) 188,795 (40,000) 223,890 (40,000) 167 890 (40,000) riginal Budgets Quarter Total Quarter Quarter Quarter 40,795 $ 624,800 $ eginning cash balance 40,000 $ 163,550 40,395 $ 247.500 40,440$ 614,350 40,000 1,650,200 287,895 203,550 654,790 665,595 1,690,200 Cash receipts Cash available Sash payments Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes 90,000 54830 3,800 25,275 90,000 170,830 8,200 30,775 67 750 1,500 2.400 371,455 90,000 245,850 9,600 32,525 80,400 1,500 6,120 90,000 240,650 7,000 29,275 71,600 1,500 1,680 360,000 712,160 28,600 117,850 287,500 6,000 10,200 67,750 1.500 0 243.155 465,995 441.705 1,522 310 (39,605) (40,000) (83,560) (40,000) 188,795 (40,000) 223.890 (40,000) 167 890 (40,000) Interest expense Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (de ciency) Financing Borrowing Principal ropayments Total effects of financing (79,605) (123,660) 148.795 183,890 127,890 80.000 0 124.000 0 204,000 (204,000) 0 (148,000) (148 000) 40,795$ 80 000 0 (56,000) (56,000) 167,890 0 124,000 40,440 $ 40,395 $ Ending cash balance 167 890
