Rework the budget by using your suggested minimum cash balance ($60,000). Also include any interest from borrowing and investing.

Need help with the cash budget part - please include formulas.

  

Transcribed Image Text:

Collections Worksheet Sales Collections Cash 30-days 60-days Rate of Credit Sales Collected Total Cash Collections Disbursements Worksheet Purchases Payments Salaries Interest Other expenses Taxes New Computer Total Cash Disbursements Net Cash Flows NOV 750,000 825,000 Rate 30% 40% 30% 98% DEC 75% JAN 350,000 300,000 648,900 JAN FEB 0 335,500 FEB MAR 0 APR 298,000 250,000 400,000 500,000 105,000 90,000 75,000 120,000 150,000 157,500 180,000 187,500 210,000 323,400 137,200 117,600 98,000 156,800 196,000 205,800 235,200 220,500 242,550 102,900 88,200 73,500 117,600 147,000 154,350 176,400 469,750 295,500 306,200 380,300 471,100 MAR APR MAY 225,000 187,500 300,000 375,000 393,750 450,000 262,500 225,000 187,500 300,000 375,000 393,750 60,000 60,000 60,000 60,000 60,000 60,000 4,000 4,000 4,000 4,000 4,000 4,000 9,000 9,000 9,000 9,000 9,000 145,000 25,000 9,000 145,000 0 0 405,500 373,000 313,400 171,750 (110,000) (66,800) MAY JUN 0 448,000 JUL 525,000 600,000 625,000 700,000 JUN JUL AUG 532,800 577,050 631,400 0 468,750 525,000 450,000 468,750 60,000 60,000 4,000 4,000 9,000 9,000 636,750 523,000 (67,700) (165,650) 9,800 AUG SEP 0 35,300 SEP OCT 217,500 240.000 270,000 245,000 274,400 284,200 313,600 183,750 205,800 213,150 725,000 800,000 (111,600) NOV OCT 675,650 730,000 796,750 543,750 600,000 675,000 525,000 543,750 600,000 60,000 60,000 60,000 4,000 4,000 4,000 9,000 9,000 9,000 145,000 0 0 NOV 541,750 743,000 616,750 673,000 58,900 DEC 0 900,000 DEC 300,000 675,000 60,000 4,000 9,000 145,000 0 893,000 57,000 (96,250) Collections Worksheet Sales Collections Cash 30-days 60-days Rate of Credit Sales Collected Total Cash Collections Disbursements Worksheet Purchases Payments Salaries Interest Other expenses Taxes New Computer Total Cash Disbursements Net Cash Flows NOV 750,000 825,000 Rate 30% 40% 30% 98% DEC 75% JAN 350,000 300,000 648,900 JAN FEB 0 335,500 FEB MAR 0 APR 298,000 250,000 400,000 500,000 105,000 90,000 75,000 120,000 150,000 157,500 180,000 187,500 210,000 323,400 137,200 117,600 98,000 156,800 196,000 205,800 235,200 220,500 242,550 102,900 88,200 73,500 117,600 147,000 154,350 176,400 469,750 295,500 306,200 380,300 471,100 MAR APR MAY 225,000 187,500 300,000 375,000 393,750 450,000 262,500 225,000 187,500 300,000 375,000 393,750 60,000 60,000 60,000 60,000 60,000 60,000 4,000 4,000 4,000 4,000 4,000 4,000 9,000 9,000 9,000 9,000 9,000 145,000 25,000 9,000 145,000 0 0 405,500 373,000 313,400 171,750 (110,000) (66,800) MAY JUN 0 448,000 JUL 525,000 600,000 625,000 700,000 JUN JUL AUG 532,800 577,050 631,400 0 468,750 525,000 450,000 468,750 60,000 60,000 4,000 4,000 9,000 9,000 636,750 523,000 (67,700) (165,650) 9,800 AUG SEP 0 35,300 SEP OCT 217,500 240.000 270,000 245,000 274,400 284,200 313,600 183,750 205,800 213,150 725,000 800,000 (111,600) NOV OCT 675,650 730,000 796,750 543,750 600,000 675,000 525,000 543,750 600,000 60,000 60,000 60,000 4,000 4,000 4,000 9,000 9,000 9,000 145,000 0 0 NOV 541,750 743,000 616,750 673,000 58,900 DEC 0 900,000 DEC 300,000 675,000 60,000 4,000 9,000 145,000 0 893,000 57,000 (96,250)

Answer rating: 100% (QA)

To rework the budget and incorporate the suggested minimum cash balance of 60000 as well as interest from borrowing and investing we can start by calc... View the full answer