2. Notes Payable Worksheet Months: Sales Cash and Accounts Receivable Collections: Cash: 10% immediately Accounts Receivables: 87% within 30 days Total Cash Collections from Sales, Interest Income (+) or Expense (-). Net Revenues Expenses or COGS: 80% of Sales Paid Immediately 40% Accounts Payable: 30 days: 60% Taxes Payables Wages Payables Administrative Expenses: 10% of COGS, Total Expenses_ Net Income Begin. Cash and Marketable Securities Ending Cash and MS Balance_ -Minimum Operating Cash (MOC) Excess Funds (+).036/12 Needed Funds (-).06/12 Oct. $400,000 Incomplete 20,000 Incomplete_ Incomplete 60,000 40,000 150,000 Nov. 410,000 30,000 Dec. 420,000 35,000 Jan. 300,000 55,000 10,000 2. Notes Payable Worksheet Months: Sales Cash and Accounts Receivable Collections: Cash: 10% immediately Accounts Receivables: 87% within 30 days Total Cash Collections from Sales, Interest Income (+) or Expense (-). Net Revenues Expenses or COGS: 80% of Sales Paid Immediately 40% Accounts Payable: 30 days: 60% Taxes Payables Wages Payables Administrative Expenses: 10% of COGS, Total Expenses_ Net Income Begin. Cash and Marketable Securities Ending Cash and MS Balance_ -Minimum Operating Cash (MOC) Excess Funds (+).036/12 Needed Funds (-).06/12 Oct. $400,000 Incomplete 20,000 Incomplete_ Incomplete 60,000 40,000 150,000 Nov. 410,000 30,000 Dec. 420,000 35,000 Jan. 300,000 55,000 10,000