1. Alternatively, how much will be the minimum borrowing for the second quarter necessary to satisfy the $50,000 minimum cash required balance?2. Alternatively, how much will be the Maximum loan pay-off amount for the third quarter necessary to satisfy the $50,000 minimum cash required balance?3. Alternatively, how much will be the minimum borrowing for the fourth quarter necessary to satisfy the $50,000 minimum cash required balance?4. Based on the Excel Cash Budget you prepared with all green cells on, what is the loan balance at the end of fourth quarter?

Carefully study the following cash budget and determine the amount to be borrowed or repaid during each quarter, so that the company never ends a quarter with less than $50,000 cash on hand, and always repays as much debt as possible. There is no debt as of the beginning of the rst quarter, and interest costs are assumed not signicant in this analysis. Use the pick lists associated with the boxed areas near the bottom of the spreadsheet to determine the right amounts to borrow and repay each quarter. Correct choices will result in Cash budge_t Beginning cash Customer receipts Available cash Less: disbursements Direct materials Direct labor Factory overhead SGSLA Other expense and tax Equipment purchases Total disbursements Cash surplus (decit) Financing: Planned borrowing Planned repayment Ending cash balance 10,000 140,000 28,000 14,000 13,500 31,000 11,000 19 3,500 52,500 5_2,500 the boxed areas turning green. 52,500 160,000 212,500 30,000 16,000 14,000 31,000 12,000 250m 353,000 140,500 5_9,500 59,500 200,000 259,500 41,000 20,000 15,000 33,000 13,000 122,000 137,500 @500 First Second Third Fourth Quarter Quarter Quarter Quarter 62,500 250,000 31 2,500 48,000 25,000 _ 17,000 33,000 _ 15,000 225,000 _ 363,000 -50,500 3,500