AutoSave File Home Insert Page Layout Formulas Data Review View PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edi A6 A B D E F 1 Use the below information and complete a cash forecast for the next three months. 2 You collect 50% of credit sales in the month they occur and 50% in the next month. 3 You pay 50% of the accounts payable balance in the month it is shown and 50% in 4 the next month. The starting cash for a month is the same as the ending cash of the 5 prior month. 6 7 Jan Feb March 8 Starting Cash $ 5,000 9 10 Cash Sales $ 60,000 $40,000 $20,000 11 Credit Sales $ 70,000 $30,000 $ 40,000 12 13 Accounts Payable $ 20,000 $50,000 $ 70,000 14 Payroll $ 20,000 $30,000 $25,000 15 Rent $ 20,000 $20,000 $ 20,000 16 17 Ending Cash 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35