General Instructions:

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. Submit on or before December 1, 2021, 11:59PM.

Other conditions:

1. 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.
2. Consider all necessary expenses related to your company.
3. Please also provide a brief description (1 paragraph) of the company in a separate tab.

Example Template:

BADLY NEEDED :(

January February March April May $ 50,000 $35,300 $26,600 $17,900 $ June July August September December 7,200 $ 2,500 $20,800 $23,700 $ 18,600 $ 16,500 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 $ $ $ $ $ $ $ 5,000 $ 6,000 $ 6,000 $4,000 $ 4,000 $ 4,000 $5,000 $ 7,000 $ $ 5,000 $ 6,000 $ 6,000 $ 7,000 $ 7,000 $5,000 $ 6,000 $ 2,000 $2,000 $1,000 $1,000 $ 1,000 $2,000 $3,000 $3,000 $ $ $20,000 $ $ $ $ $ $ $ $10,000 $10,000 $ $ S $ $ $ $ - $ - $ $ 57,000 $48,300 $ 39,600 $28,900 $ 19,200 $ 40,500 $43,800 $39,700 $ 8,000 $ 9,000 8,000 $ 8,000 4,000 $ 7.000 $ $ $ 38,600 $ 40,500 4. Uses of Cash Payroll Rent Utilties Taxes Inventory Purchases Loan Payments Other 5. Total Uses of Cash 6. Cash Flow (Defidt) $ $ $ $ $ $ $ $ $ 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 $ 3,500 1,500 $ 1,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 $ 1,200 $ 1,200 5,000 $5,000 $5,000 $5,000 $ 5,000 $3,000 $3,000 $ 4,000 $ 5,000 $ 6,000 $ $ $ $ $ $ 400 $ 400 S 400 $ 400 500 $ 500 $ 500 $ 500 $ 500 $500 $500 $ 500 $ 500 $ 500 21,700 $21,700 $21,700 $21,700 $ 21,700 $19,700 $20,100 $21,100 $ 22,100 $ 23,100 35,300 $ 26,600 $ 17,900 $ 7,200 $2,500.00 $ 20,800 $23,700 $ 18,600 $ 16,500 $ 17,400 January February March April May $ 50,000 $35,300 $26,600 $17,900 $ June July August September December 7,200 $ 2,500 $20,800 $23,700 $ 18,600 $ 16,500 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 $ $ $ $ $ $ $ 5,000 $ 6,000 $ 6,000 $4,000 $ 4,000 $ 4,000 $5,000 $ 7,000 $ $ 5,000 $ 6,000 $ 6,000 $ 7,000 $ 7,000 $5,000 $ 6,000 $ 2,000 $2,000 $1,000 $1,000 $ 1,000 $2,000 $3,000 $3,000 $ $ $20,000 $ $ $ $ $ $ $ $10,000 $10,000 $ $ S $ $ $ $ - $ - $ $ 57,000 $48,300 $ 39,600 $28,900 $ 19,200 $ 40,500 $43,800 $39,700 $ 8,000 $ 9,000 8,000 $ 8,000 4,000 $ 7.000 $ $ $ 38,600 $ 40,500 4. Uses of Cash Payroll Rent Utilties Taxes Inventory Purchases Loan Payments Other 5. Total Uses of Cash 6. Cash Flow (Defidt) $ $ $ $ $ $ $ $ $ 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 $ 3,500 1,500 $ 1,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 $ 1,200 $ 1,200 5,000 $5,000 $5,000 $5,000 $ 5,000 $3,000 $3,000 $ 4,000 $ 5,000 $ 6,000 $ $ $ $ $ $ 400 $ 400 S 400 $ 400 500 $ 500 $ 500 $ 500 $ 500 $500 $500 $ 500 $ 500 $ 500 21,700 $21,700 $21,700 $21,700 $ 21,700 $19,700 $20,100 $21,100 $ 22,100 $ 23,100 35,300 $ 26,600 $ 17,900 $ 7,200 $2,500.00 $ 20,800 $23,700 $ 18,600 $ 16,500 $ 17,400