UNIVAX, INC. Budgeted Sales and Merchandise Purchases: Merchandise Purchases Sales Year 1: 0 Fourth quarter actual 1 Year 2: 2 First quarter estimated 3 Second quarter estimated 500,000 310,000 4 Third quarter estimated 15 Fourth quarter estimated 16 17 Additional information: 18 Percentage of sales collected in same quarter 19 Percentage of sales collected in quarter following sales 20 Percentage of sales deemed uncollectible 21 Percentage of merchandise purchases paid in same quarter 22 Percentage of merchandise purchases pain in following quarter 23 Budgeted quarterly operating expenses for Year 2 24 plus percentage of sales 25 Amount of depreciation budgeted each quarter 26 Dividends to be paid each quarter $ 300,000 $ 180,000 $ 400,000 $260,000 $ 600,000 370,000 $ 480,000 $ 240,000 33% 65% 2% 20% 80% $ 90,000 12% 20,000 $ 10,000 $ 80,000 $ 48,500 20,000 $ 18,000 10,000 $ 100,000 3.0% 27 Cash purchase of land in second quarter 28 Cash purchase of land in third quarter 29 Cash account balance at end of Year 1 30 Minimum cash balance required 31 Bank loan borrowing increments 32 Maximum loan balance allowed 33 Interest rate per quarter on bank loans 34 Current outstanding loan balance 35 UNIVAX, INC la. Schedule of expected cash collections Year 2 Quarter First Second Third Fourth Total Year 1- Fourth quarter sales: Year 2- First quarter sales: Year 2 - Second quarter sales: Year 2- Third quarter sales: Year 2-Fourth quarter sales: Total cash collections 1b. Schedule of expected cash disbursements for merchandise purchases for Year 2 Year 2 Quarter First Second Third Fourth Total Year 1- Fourth quarter purchases: Year 2 - First quarter purchases: ear 2- Second quarter purchases Year 2- Third quarter purchases: Year 2 Fourth quarter purchases: Total cash disbursements 2. Budgeted selling and administrative expenses for Yoar 2 Year 2 Quarter First Second Third Fourth Year 5 Budgeted sales 6 Variable expense rate 7 Variable expenses 8 Fixed expenses 9 Total expenses 40 Less depreciation 1 Cash disbursements 42 1 3. Cash budget for Year2 Year 2 Quarter First Second Third Fourth Year h balance, beginning collections from sales Total cash available Less disbursements Merchandise purchases Operating expenses Dividends Land Total disbursements Excess (deficiency) of receipts over disbursements Borrowings Repayments 2 Interest 8 Total financing Cash balance, ending