1% 40% 1 Assumptions of Problem 13.6-12 Month Cash Flow Budget 2 Initial Sales - $5,000,000 3 Monthly Sales Growth 1% = 4 % Monthly Cash Sales = 5 % Collected Following Month = 30% 6 x Collected Two months 20% 7 % Collected Three Months = 9 % Never Collected = 9 Initial Cash Balances = $350,000 10 Cash Outflows as current month sales 11 Desired ending cash balance each month $50,000 12 Loan repayment is calculated as the excess of cash available over desired ending balance, but never more than the arnount of the loan. 77% January February March April May June July August September October November December Beginning Cash Balance Sales 40% Cash Sales 30% Collected Following Month = 20% Collected Two Months = 8% Collected Three Months - 77% Cash Outflows as current month sales = Cash Balance beforeloan Desired ending cash balance each month Amount borrowed Cash after loan Cumulative loan Loan repayment Ending Cash $8,447,245 31 Instruction: 32 Please complet part ato e Please use Excel formula to complet P13.6 for example January $5 million x 1.01% is February $5.05 Please try your best of part f) but I will not deduct point for not completing part 1) Points deducted for not using Excel formula to complete P13.6