find the formulas

The Net Cash Flow of exercise 5 from Section 2.4 is shown in Figure 4.3.4 below. Using the in- formation provided, complete the cash budget for the whole year. Assume that the ending cash balance and the Cumulative loan for Dec. of the previous year was 10000, and 0 respectively. Assume also that the minimum cash balance, according to the company's policy, is 5000. Create your formula in January only. Copy the formula from January to February through December. 1. 22 Net Cash Flow 23 24 Cash Receipts 25 Cash Payments 26 let Cash Flow Dee Jan Feb Mar Apr MayJun Jul Aug Sep Oct lovDec oX4000 2800 2600 4600 5600 8800 18000 30000 25200 12800 54005600 9000 9000 9000 9000 9000 9000 9000 9000 9000 9000 9000 9000 000X 5000 6200 -6400-4400-3400 -200 9000 21000 16200 3800 -3600 3400 Figure 4.3.4 Answer: E F 28 Cash Budget 29 llet Cash Flow 30 Beg Cash Bal 31 Cum Cash Bal 32 Loan Dec Jan Feb M Apr May un Jul gSep Oct lov Dec 000X 5000 6200 -6400 -4400 -3400 -200 9000 21000 16200 3800 -3600 340 ! 5000 5000 5000 5 500014400306003440030800 oo5000-1200-1400 600 1600 4800 14000 26000 30600 34400 30800 27400 0 6200 6400 4400 3400 200 00 0 00 0000 00 9000 11600000 6200 12600 17000 20400 20600 116000000 0000 5000 5000 500050 5000 5000 5000 14400 30600 34400 30800 27400 33 Pay Back 34 Cum Loan 35 Ending Cash Bal Figure 4.3.5