Loblaw Manufacturing Cash Budget June 2021 to October 2021 April May June 115,000 135,000 172,000 July 142,000 August 121.000 September 93,000 October 76,000 November 81,000 Collections Cash 35% 55% 10% 60.200 74,250 11,500 145,950 85,200 49,700 94.600 13,500 157,800 72.600 42,350 78,100 17,200 137,650 55,800 32,550 66,550 14,200 113.300 45,600 26,600 51.150 12.100 89,850 48,600 60% B3.000 103200 Scooth TD Total 11 Posts 12 Payment Durine Month More 15 Tallarments 16 Selection Complete the cash budget given; the collections percventages the payments percentages the interest percentages the ending cash balance for May The minimum cash balance 4096 6094 41,280 48,600 89,880 145,950 34,080 61,920 96,000 157,800 29,040 51.120 80,160 137.650 22,320 43,560 65,880 113,300 18.240 33,480 51,720 89,850 89.880 96,000 80,160 65,880 tory Payments 15 Short term interest 51,720 ER 45,000 80,000 75,000 70,000 50.000 21 Total Thisharement 30,000 Nets Cash 24 Cash Balance 25 Rod Current Borrowing 2 En Cash Balance 30,000 28 Cantive Borrowing 129 Minimum Cash balance 25,000 6.00% 0.50% 12 Monthly interest Rate 15 B F G D E Loblaw Manufacturing Cash Budget June 2021 to October 2021 April May June 115,000 135,000 172,000 July 142,000 August 121,000 September 93,000 October 76,000 November 81,000 35% 55% 10% 60,200 74,250 11,500 145,950 85,200 49,700 94,600 13,500 157,800 72,600 42,350 78,100 17,200 137,650 55,800 32,550 66,550 14,200 113,300 45,600 26,600 51,150 12,100 89,850 48,600 60% 81,000 103,200 40% 60% 41,280 48,600 89,880 145,950 A 1 2 3 4 5 Sales 6 Collections: 7 Cash 8 First Month 9 Second Month 10 Total Collections 11 Purchases 12 Payments: 13 During Month 14 Month After 15 Total Payments 16 Collections 17 Disbursements: 18 Inventory Payments 19 Short-term Interest 20 Other Payments 21 Total Disbursements 22 Beginning Cash Balance 23 Net Additions to Cash 24 Unadjusted Cash Balance 25 Add: Current Borrowing 26 Ending Cash Balance 27 28 Cumulative Borrowing 29 Minimum Cash Balance 30 31 Annual Interest Rate 32 Monthly Interest Rate 34,080 61,920 96,000 157,800 29,040 51,120 80,160 137,650 22,320 43,560 65,880 113,300 18,240 33,480 51,720 89,850 89,880 96,000 80,160 65,880 51,720 80,000 75,000 70,000 50,000 45,000 30,000 30,000 25,000 6.00% 0.50%