Question Help - Specialized Learning had prepared the following budget, schedule of budgeted cathets, and cash but for Suppose a change in the map of cash from our follow 2025 Ok the loon to the red coch information) (Click the icon to view the original buts) Read the Specialized Learning decided to sales budget to show fourth querweg 160 tablets due to the expectation of increased day (Click the icon to view the ed al bupat Requirement 1. Arvise the schedule of butted and receipts to dude the increase in fourth quarters and the change in the timing of stoner recipe. Of an input fold is rotuned in the table, we prout felt www.da netorte ar Round your answer to the dollar) Behdule of Cash Receipts from Customers First Second Thin Fourth Quarter Quarter Quarter Quarter Total Total First Second Third Fourth Quarter Quarter Quarter Quarter Total Cash Receipts from Customers Account Receive December 2024 Tot-Casse -Credit si colected in and om Credits collected indet End Enter any number in the fields and then continue to the next question Q Suppone a change in the recept of cash from sales is as follow Click the icon to view the red receipt of cath information) Read the requirements Specialized Learning had prepared the following a budget schedule of budgeted cash receipts, and cash budget for 2025 (Click the loon to view the original budgets) Specialized Learning decided to revise its sales budget to show fourth quarter of 650 tablets due to the expectation of increased holiday sales (Click the icon to view the revised a budget stredie elected in the Moto-Credits cocoding To Credits beded in And Q-Cash and Credit les cated in and on And Out Credit sales cocher -Credit les collected in the 3rd Cash Ser Credit scorected in and Ord Crude a collected in the Cash sales htCredit ses collected in Totulah cipts from customers Requirement 2. How will the changes in cash receipts affect the cash budget? Specinted Learning will need to borrow funds because of the Y net income for the year in cash. This will result in of interest expens und Enter any number in the edit fields and then continue to the next question More Info Specialized Learning Sales Budget For the Year Ended December 31, 2025 First Second Third Quarter Quarter Quarter 550 350 1,600 5 550||$ 550||$ 550 $ 40% in the quarter of the sale 30% in quarter after the sale 28% two quarters after the sale 2% never collected Fourth Quarter 650 5505 Total Budgeted tablets to be sold Sales price per unit 3,150 550 Print Done Total sales 5 302,500 5 192.500 5 880.000 $ 367.500||$ 1,732,500 Print Done ann swing i Original Budgets X gets. ales bud Specialized Learning Sales Budget For the Year Ended December 31, 2025 First Second Third Quarter Quarter Quarter Fourth Quarter Total Budgeted tablets to be sold Sales price per unit 550 550 $ 350 550 $ 1,600 550 S 500 550 3,000 550 S S Total sales 302,500 $ 192,500 S 880,000 S pec 275,000 $1,650,000 S Schule of Cash Receipts from Customers are Second Third Fourth First Quarter Quarter Quarter Quarter Total Total sales s 880.000 $275,000 $1,650,000 302,500 $ 192,500 $ First Second Third Fourth Quarter Quarter Quarter Quarter Total Cash Receipts from Customers: Accounts Receivable balance, December 31, 2024 1st Qtr-Cash sales (20%) $ 22.000 Pr 60,500 end Print Done 7 of 7 (3 complete) Howing Original Budgets gets. salos es bud Specialized Learning Cash Budget For the Year Ended December 31, 2025 First Second Third Quarter Quarter Quarter Fourth Quarter Total $ 38,000 $ 179,300 35,575 $ 245,300 35,680 $ 550.000 35,525 $ 565,400 38,000 1,540,000 217,300 280.875 585,680 600,925 1,578,000 Spec S 40,000 40,000 ear E 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 33,280 172,440 40,000 139,320 33,280 14,080 88,320 40,000 146,880 38,400 100,300 58,625 3,000 990 99,740 97,640 59,725 3,000 0 550 550 160,000 491,920 174,080 403,440 243,300 12,000 6.180 105,760 65,500 3,000 3,135 59,450 3,000 2,055 500 Interest expense 247,725 388,195 478,155 376,845 1,490,920 Pr Total cash payments Ending cash balance before financing (107,320) 107,525 224,080 (30,425) 87,080 then a Print Done Original Budgets - 217,300 280,875 585,680 600,925 1,578,000 40,000 160,000 40,000 33,280 40,000 172,440 40,000 139,320 146,880 Cash availabla Cash payments: Capital expenditures Purchases of direct materials Direct labor Manufacturing overhead Selling and administrative expenses Income taxes 38,400 88,320 14,080 97,640 59,725 491,920 174,080 403,440 243,300 33,280 99,740 59,450 105,760 100,300 58,625 3,000 990 3,000 0 65,500 3,000 3,135 3,000 2,055 12,000 6,180 Interest expense 247,725 388,195 478,155 376,845 1,490,920 (30,425) (35,000) (107,320) (35,000) 107 525 (35,000) 224,080 (35,000) 87,080 (35,000) (65.425) (142,320) 72,525 189,080 52.080 Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (de clency) Financing: Borrowing Principal repayments Total effects of financing 66,000 0 143,000 0 0 (72,000) 0 (137.000) (137,000) 209,000 (209,000) 66,000 143,000 (72,000) 35,525 $ $ 35,575$ 35,680||$ 87,080 87,080 Ending cash balance Print Done