The accountant for Jean's Dress Shop prepared the following cash budget. Jean's desires to maintain a cash

balance of $$10,000$ at the end of each month. Funds are assumed to be borrowed and repaid on the last day of

each month. Interest is charged at the rate of $1$ percent per month.

Required

a$.$ Complete the cash budget by filling in the missing amounts.

Note: Use the cells from the given information to complete this question. Any shortages or repayments should be

indicated with a minus sign.

b$.$ & c$.$ Determine the amount of net cash flows from both operating and financing activities Jean's will report on

the third quarter pro forma statement of cash flows.

Note: Use the cells from the given information to complete this question. Using the image please provide the correct excel code to solve all the yellow boxes.