Sport Equipment, Inc. Forecasted Ending Cash Balance September 2020 to January 2021 Aug-20 Sep-20 Oct-20 given 230,000 240,000 185,000 Nov-20 Dec-20 Jan-21 310,000 450,000 310,000 Feb-21 270,000 Expected Sales 230,000 Cash Collections: Cash Sales Credit Sales (paid the following month) Total Collections 70.0% 30.0% 168,000 129,500 217.000 315,000 217,000 189,000 69,000 72,000 55,500 93,000 135,000 93,000 237,000 201,500 272,500 408,000 352,000 282,000 Cash Disbursements: Purchases - all cash Fixed and Admin Wages Bonuses in December and June Sales Commissions Interest on Short-term Borrowing (per Month) Total Disbursements 75% 40,000 70,000 15% 138,750 232,500 337,500 232,500 202,500 40,000 40,000 40,000 40,000 40,000 0 0 0 70,000 0 34,500 36,000 27,750 46,500 67,500 0 0 1,038 0 0 178,750 272,500 378,538 342,500 242,500 Beginning Cash Balance +Collections - Disbursemesnts 65,000 123,250 52,250 58.250 -71.000-106.038 50,000 65.500 115,500 109.500 Sport Equipment, Inc. Forecasted Ending Cash Balance September 2020 to January 2021 Aug-20 Sep-20 Oct-20 given 230,000 240,000 185,000 Nov-20 Dec-20 Jan-21 310,000 450,000 310,000 Feb-21 270,000 Expected Sales 230,000 Cash Collections: Cash Sales Credit Sales (paid the following month) Total Collections 70.0% 30.0% 168,000 129,500 217.000 315,000 217,000 189,000 69,000 72,000 55,500 93,000 135,000 93,000 237,000 201,500 272,500 408,000 352,000 282,000 Cash Disbursements: Purchases - all cash Fixed and Admin Wages Bonuses in December and June Sales Commissions Interest on Short-term Borrowing (per Month) Total Disbursements 75% 40,000 70,000 15% 138,750 232,500 337,500 232,500 202,500 40,000 40,000 40,000 40,000 40,000 0 0 0 70,000 0 34,500 36,000 27,750 46,500 67,500 0 0 1,038 0 0 178,750 272,500 378,538 342,500 242,500 Beginning Cash Balance +Collections - Disbursemesnts 65,000 123,250 52,250 58.250 -71.000-106.038 50,000 65.500 115,500 109.500