incorporate following:

Expected monthly cash outflows equal 77% of the current months sales

add a row for net cash

Calculate an amount to be borrowed for the month to maintain a minimum ending cash balance of $50,000

calculate the cumulative amount borrowed (Separate row)

Utilizing a cash after borrowings subtotal (separate row), determine amount of repayments possible while still maintaining the minimum ending cash balance

Ending cash should now incorporate all the above

Excel File Edit View Insert Format Tools Data Window Help EXCEL.xlsx -freeze A Home Layout Tables Data Fill | Calibri Body) -1 1 Wrap TextGencral Good te B I U nsert Delete Format Themes Aa A3 6 Initial Sales 7 Sakks Growth 5,000,000 350,000 8 Initial Cash 9 Percentage of Sales for Cash Each Month 10 Percentage Collected the Following Month 11 Percentage Coected 2 Months Later 12 Percentage Collected 3 Months Later 13 Percentage Never Collected 14 16 17 18 Seles 19 20 Beginning Cash 21 Current Month Collections 22 Prior Months Cellections 23 Co ected 2 Months Ago 24 Ca ected 3 Months Ag 25 Total Cash Receipts 26 Mar Dec 5,050,000 ,151,505 $5,203,020 $$,255,050 5350,000, $2.350.000 S5870.000 510425.200 $15425.952 s20,476.712 s25,577,979 530,730.258 535,934061 541.189.902 $46,498.301 $51.859.784| 2000,00052.020,000 2.040,200 60,02$2,081,208 2,12,020 140 $2,144,271265,32,187,3712,2044$2,231,337 51,656,933 1,000,000$1,010,000 $1,020,100 $1,030,301 $1,040,604$1,051,010$1,061,520 $1,072,135$1,082,857 $1,093,685 5433,143 1,500,000 51,515,000 51,530,150 51,545,452 51,560,906 51,576,515 51,592.280 51,606,203 51,624,285 51,640,528 $400,000 5404,000 $408 040 $412,120 415,242 $420404 424,608 $428,854 $2,000,000 $3,520,000 $4,555,200 $$,000,752 $$,050,60 $$,101,267 $$,152,280 $$003 $s5841 $9$5361,483 $5,415,088 4,051$41,189902 27 Ending Cash 28 29 30 31 32 2.350,000 $5,870,000 1042520015425,952 20476,71225,577,979 30,730,25B 35,934 051 541,189902546498,301 551,859,784557,274,881 38 39 41 42