show answers with formulas

Paige Monroe Company Cashbudget For the year ended December 31, 2022 Assumptions for inputs 042021 ending cash balance 5 16,000 04 2021 use of revolving line of credit $ Maximum revolving line of credit $ 20,000 Repayment of line of credit occurs in the following quarter Desire to keep cash balance of a minimum $ 15,000 2 Beginning cash balance Budgeted cash receipts Availablecih Budgeted cash disbursements Repayment of prior quarters line of credit lived Net Sallable canh Quarter 1 Quarter 2 Quarter Quarter 4 Total Vor 20221 $ $ 178,500 $ 182,070 $ 185,711 $ 169,426 $ za5,707 $ 178,500 182,070 S 185,711 $ 189,4265 735,707 5192,819 $ 196,059 $ 199,163 $ 202,714 790,975 $ $ $ 5 $ 194,319) 5 (13.909) 5 113.652) (13,10)) 155.268) Desired minimum balance N/A 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Financing Indige ofrevolving line of credit from bank $ Ending cable 50141195 02.0891510265215113.309 (55.268) What consideration an inflower oiflow is this cash budget missing that would likely be tied by a real manager pecially if a company is seeing such cash flow powth quarter-over-quarter as you see above) 25 26