AutoSave C - Lab 4 Assignment/2) (1) - Compatibility Mode - Excel Search claudia thomson CT File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments X out . AutoSum Arial 10 - A A == 89 Wrap Text General AR ME F Pesto la copy BIU Insert Delete format A Sensitivity $ %, 8 Merge Center Paste Format Painter Clipboard Conditional format as Cell Formatting Table Styles Styles Clear Sort & Find & Filter Select Eding Analyze Data Analysis Font Alignment Number Cels Sersity N 0 R S 1 15 Al CMAT Inc. has forecasted its total cash receipts and total cash disbursement from July to December. The company's ending cash balance DE IF G H J K M 1 CMAT Inc. has forecasted its total cash receipts and total cash disbursement from July to December. The company's ending cash balance 2 in June is $15 thousand. Il has no exisling deblal the end of June. The company's minimum cash requirement is $15 thousand 3 For simplicity let's assume that the company will excess cash in the cash account when there is no exising debt to pay off 4 Complete ACMET'S cash budgetfor July, August September October November and December 5 6 Assumptions 7 8 Ending cash balance at the end of June 15 9 Minimum cash requirement 10 Cumulative borrowing at the end of June 0 11 12 Cash budget 13 June July August September October November December 14 Total cash receipts $305.97 $414.65 $500.09 $567.75 5622.41 $650.23 15 Total cash disbursement $316.75 $435 00 $563 D0 $548.75 S597 41 $60500 16 Net cash flow 17 Beginning cash balance 18 Ending cash balance (before borrowing) 19 Surplus (deficit) 20 Borrowing (repayment) 21 Ending cash belance (aller borrowing) 22 Cumulative Borrowing 23 24 28 27 28 30 31 cashbudget + IH 1009 Type here to search O ! TL ENG 4:44 PM 1/03/2021