+1 862 207 3288 Assignment Instructions
The profitability of a Small business depends a lot on cash generation. This weekís assignment is to build an excel template to estimate flow of cash for the next 12 months. The attached excel has details of business transactions. You are expected to use the transaction data to build a cash flow statement in Exce
Category Description
Accts. Rec. Collections 100% of previous months non cash sales
Advertising 2% of monthly sales
Bank Service Charges Monthly charge of $150; 1% for Loan Processing fee;
Beginning Cash Balance $10,000
Capital Purchases No capital purchases for this year
Cash Sales 60% of monthly sales
Credit Card Fees 14% APR on an outstanding balance of $50,000
Health Insurance 10% of Payroll
Insurance $500 per month
Interest 7% per annum
Inventory Purchases 10% of Monthly Sales
Loan Proceeds One Time Inflow of $50,000
Miscellaneous 1% of Monthly Sales
Office $2500 per annum
Owner’s Draw Average $2000 per month
Payroll $5,000
Payroll Taxes 10% of Payroll
Professional Fees $4000 per annum
Rent or Lease $30,000 per annum
Subscriptions & Dues $1000 per annum
Taxes & Licenses 15% of Profit
Total Monthly Sales Average of $20,000 per month
Utilities & Telephone Average of $500 per month
TAKE ADVANTAGE OF OUR PROMOTIONAL DISCOUNT DISPLAYED ON THE WEBSITE AND GET A DISCOUNT FOR YOUR PAPER NOW!
