This is a Comprehensive Master Budget Problem. Need to do "Combined Cash Budget" for year ended.

Combined Cash Budget detail information: 1. Cash balance as of Jan 1, 2025 is expected to be $125,000 and Data's cash on hand policy requires them to have a minimum of $15,000 on hand at the end of each month. 2. Account receivable balance for Dec 31, 2024 is $110,000 and is expected to be collected in the first quarter of 2025. 3. Short-term investments are planned to be sold for $25,000 cash in the first quarter. 4. Accounts payable balance of $35,500 at Dec 31, 2024 is planned to be paid in full in the first quarter of 2025. 5. Management plans to purchase a truck in the second quarter for $50,000. 6. Income tax payments are made quarterly by Data based on the estimated annual amount. 7. Loans are repaid with interest in the earliest quarter possible in which there is a sufficient amount of cash on hand after meeting the $15,000 minimum requirement. Loans are borrowed in $1,000 increments. Combined Cash Budget detail information: 1. Cash balance as of Jan 1, 2025 is expected to be $125,000 and Data's cash on hand policy requires them to have a minimum of $15,000 on hand at the end of each month. 2. Account receivable balance for Dec 31, 2024 is $110,000 and is expected to be collected in the first quarter of 2025. 3. Short-term investments are planned to be sold for $25,000 cash in the first quarter. 4. Accounts payable balance of $35,500 at Dec 31, 2024 is planned to be paid in full in the first quarter of 2025. 5. Management plans to purchase a truck in the second quarter for $50,000. 6. Income tax payments are made quarterly by Data based on the estimated annual amount. 7. Loans are repaid with interest in the earliest quarter possible in which there is a sufficient amount of cash on hand after meeting the $15,000 minimum requirement. Loans are borrowed in $1,000 increments