what is the formula?

EXERCISE 4.3 1. 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 22 Net Cash Flow 23 24 Cash Receipts 25 Cash Payments 26 Net Cash Flow Dee Jan Feb Mar Apr May Ju JllAug Sep Oet Now Dee oxx 4 2800 2600 4600 5600 8800 lam 30000 25200 12800 5400 5600 9000 9000 9000 90009000 9000 9000 9000 9000 9000 9000 9000 ooc -9 -6200-6400-4400-3400 .200 21 1620 300 , 3400 Figure 4.3.4 Answer: 28 Cash Budget Feb Mar Apr May Jun Ang Sep Oct nov Dec Dee Jan ooo . 0-6200 6400-4400-3400 .2009000 21 16200300 .3600 3400 00K100005000 5000 5000 5000 5000 5000 5000 14400 30600 34400 30800 oox50001200-1400 600 16004800 14000 26000 30600 34400 30800 27400 6200 6400 4400 3400 2000000 00O0 0 0 9000 600 0 000 6200 12600 17000 20400 20600 11600 00000 1 5000 5000 5000 5000 5000 5000 5000 14400 30600 34400 30800 27400 29 let Cash Flow 30 Beg Cash Bal 31 Cash Bal 32 Loan 33 Pay Back 34 35 Ending Cash Bal Figure 4.3.5