How do i solce for Net additions to cash and cummulative borrwing?
A 1 Please complete the yellow highlighted parts. Please show the formulas if the number or figures are not provided in the problem Loblaw Manufacturing 3 Cash Budget 4 June 2021 to October 2021 5 April May June July August September October November 327,031 6 Sales 383,906 483,125 403,812 344,093 254,468 216,125 235, 343 7 Collections Cash 20% 96,625 80.762 68,819 52,894 43,225 9 First Month 65% 249.539 314,031 51,614 223,660 171,904 10 Second Month 1594 49,055 57,586 72.469 60,572 51,614 11 Total Collections 395,219 452.380 192.901 337, 126 266,743 12 Purchases 3596 265,719 222,097 189,251 145,452 118,869 129,439 13 Payments 14 During Month 40% 106,288 88,899 75,700 58,183 47,548 15 Month After 159 431 159,431 133.258 113,551 87,274 16 Total Payments 265.719 248,270 208.958 171,734 134,822 17 Collections 395.219 452,380 192,901 337 126 266,743 15 Disbursements 19 Inventory Payments 265,719 248.270 208,958 171,734 134,822 Sheets interpretation 031 H 1 Please complete the yellow highlighted parts. Please show the formalas if the number or figures are not provided in the problem Loblaw Manufacturing Cash Budget June 2021 to October 2021 5 April May June July August September October November 1 Disbursements 19 Inventory Payments 265,719 248.270 208.958 171.734 134,822 20 Short-term Interest 21 Other Payments 227.500 21331 199662 145.188 127.750 22 Total Disbursements 493,219 461,551 408,020 316,922 262,572 23 Betoning Cash Balance 30.000 24 Net Additions to Cash 25 Unadjusted Cash Balance 30,000 26 Add Current Borrowing 27 Ending Cash Balance 30,000 28 20 Camlative Borrowing 30 Minimum Cash Balance 25,000 Discount for Paying in Same Month 2.00% Sheet interpretation e w A 1 Please complete the yellow highlighted parts. Please show the formulas if the number or figures are not provided in the problem Loblaw Manufacturing 3 Cash Budget 4 June 2021 to October 2021 5 April May June July August September October November 327,031 6 Sales 383,906 483,125 403,812 344,093 254,468 216,125 235, 343 7 Collections Cash 20% 96,625 80.762 68,819 52,894 43,225 9 First Month 65% 249.539 314,031 51,614 223,660 171,904 10 Second Month 1594 49,055 57,586 72.469 60,572 51,614 11 Total Collections 395,219 452.380 192.901 337, 126 266,743 12 Purchases 3596 265,719 222,097 189,251 145,452 118,869 129,439 13 Payments 14 During Month 40% 106,288 88,899 75,700 58,183 47,548 15 Month After 159 431 159,431 133.258 113,551 87,274 16 Total Payments 265.719 248,270 208.958 171,734 134,822 17 Collections 395.219 452,380 192,901 337 126 266,743 15 Disbursements 19 Inventory Payments 265,719 248.270 208,958 171,734 134,822 Sheets interpretation 031 H 1 Please complete the yellow highlighted parts. Please show the formalas if the number or figures are not provided in the problem Loblaw Manufacturing Cash Budget June 2021 to October 2021 5 April May June July August September October November 1 Disbursements 19 Inventory Payments 265,719 248.270 208.958 171.734 134,822 20 Short-term Interest 21 Other Payments 227.500 21331 199662 145.188 127.750 22 Total Disbursements 493,219 461,551 408,020 316,922 262,572 23 Betoning Cash Balance 30.000 24 Net Additions to Cash 25 Unadjusted Cash Balance 30,000 26 Add Current Borrowing 27 Ending Cash Balance 30,000 28 20 Camlative Borrowing 30 Minimum Cash Balance 25,000 Discount for Paying in Same Month 2.00% Sheet interpretation e w
