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:

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Chic Chic Ltd is a company in meat industry that deals with slaughtering and selling deboned chicken Below is a schedule of a forecasted cash flow for ... View the full answer