1. Create a cash forecasting schedule (good for 3 months) Choose your company and industry. You may wish to pattern this to an already existing company or create a new one (it can be your own dream company).
2. Please use excel spreadsheets and indicate the name of the company.
3. Other conditions:
4. Depending on the size of the company, you can start with PhP250,000 up to PhP500,000 in the first month of sales/cash inflow. Be sure to have an increase of 25% per month.
5. Consider all necessary expenses related to your company.
6. Please also provide a brief description (1 paragraph) of the company in a separate tab.

Example Template:

 

1. Operating Cash- Beginning 2. Sources of New Cash Cash Sales AR Collections Customer Deposits Bank Financing Shareholder Investment Other 3. Total Sources of Cash 4. Uses of Cash Payroll Rent Utilties Taxes Inventory Purchases Loan Payments Other 5. Total Uses of Cash 6. Cash Row (Deficit) January $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ February March April May 50,000 $35,300 $26,600 $17,900 $ 5,000 $6,000 $6,000 $4,000 $ $5,000 $6,000 $6,000 $ 2,000 $2,000 $1,000 $1,000 $ $ $ 57,000 $ $ S $48,300 . June July August September December 7,200 $2,500 $20,800 $23,700 $ 18,600 $ 16,500 $ $ $ $ S . $ $39,600 $28,900 $ 19,200 . 4,000 $4,000 $5,000 $7,000 $ 7,000 $7,000 $5,000 $6,000 $ 1.000 $2,000 $3,000 $3,000 $ $20,000 $ . $ $ $10,000 $10,000 $ $- $ $ $40,500 $43,800 $ 8,000 $ 8,000 $ 4,000 $ $ $ 9,000 8,000 7,000 $ $ $39,700 $ 38,600 $ 40,500 10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 3,500 $3,500 $3,500 $3,500 $ 3,500 $3,500 $3,500 $3,500 $ 3,500 $ 1,500 $1,500 $ 1.500 $1,500 $ 1.500 $1,500 $1,500 $1,500 $ 1,200 $1,200 $1,200 $1,200 $ 1,200 $1,200 $1,200 $ 1,200 $ 5,000 $5,000 $5,000 $5,000 $ 5,000 $3,000 $3,000 $4,000 $ $ $ $ $ $ $ 400 $ 400 $ 500 $ 500 $ 500 $ 500 $ 500 $500 $500 $500 $ 21,700 $21,700 $21,700 $21,700 $ 21,700 $19,700 $20,100 $21,100 $ 35,300 $26,600 $17,900 $ 7,200 $2,500.00 $20,800 $23,700 $18,600 $ 1,500 $ 1,200 $ 5,000 $ - 400 $ 500 $ 3,500 1.500 1,200 6,000 400 500 22,100 $ 23,100 16,500 $17,400