Fle Home insert Poge Lyout formulas Data Reriew View Automate Help Sheeti B2 fx cash How forecast 17. Payrele 7) Adernisirdid Marketing: 21 Inaranit 1. Purchases (Inventory) Cost 70% of Sales - Are made based on next month's 80% Sales 2 Accounts Receivables are collected based on Sales as follows: 20% Cash, 70% in 45 days, 10% in 60 days (Assume all sales take place at the beginning of the month) 3- Accounts Payable are based on inventory purchases as follows: 20% Cash, 70% in 30 days, 10% in 45 days (Assume all purchases take place at the beginning of the month) All other expenses are also expressed as percentage of sales, please check the corresponding cell for information. Insurance Loan Payable Dividends Taxes 25 Other Expenses 20 Total Cash Out Net Monthly 4,885 $$ Allo Ner Monthly s 285$ $ $ $ 5 \begin{tabular}{|l|l|l|l|} \hline \multicolumn{1}{|l|}{ Opening Balance } \\ \hline Cosing Bank Balance & 5 & 500 & S 215 \\ \hline \end{tabular} 15 S Fle Home insert Poge Lyout formulas Data Reriew View Automate Help Sheeti B2 fx cash How forecast 17. Payrele 7) Adernisirdid Marketing: 21 Inaranit 1. Purchases (Inventory) Cost 70% of Sales - Are made based on next month's 80% Sales 2 Accounts Receivables are collected based on Sales as follows: 20% Cash, 70% in 45 days, 10% in 60 days (Assume all sales take place at the beginning of the month) 3- Accounts Payable are based on inventory purchases as follows: 20% Cash, 70% in 30 days, 10% in 45 days (Assume all purchases take place at the beginning of the month) All other expenses are also expressed as percentage of sales, please check the corresponding cell for information. Insurance Loan Payable Dividends Taxes 25 Other Expenses 20 Total Cash Out Net Monthly 4,885 $$ Allo Ner Monthly s 285$ $ $ $ 5 \begin{tabular}{|l|l|l|l|} \hline \multicolumn{1}{|l|}{ Opening Balance } \\ \hline Cosing Bank Balance & 5 & 500 & S 215 \\ \hline \end{tabular} 15 S