Cash Flow Envelope

Example Recall previous Example, develop the cash flow envelope and curves from January to June

The previous example was not given to us, the previous problem was filling out this table.

The previous example is the chart provided.

Cash Flow Envelope Brought forward for January is $5,000 Income: Sales forecast $10 per each unit (the client takes two months to pay his sale): Nov 1,000; Dec 1,500; Jan 1,600; Feb 900; Mar 500; Apr 1,200; May 1,300; Jun 1,400 (units) Expenses: Cost of sales: [1] Overheads are $300 per month; (2) Material $2 per each unit (supplier gives one month credit); (3) Labor $1 per each unit paid in month used); (4) Loan repayment (due to equipment procurement): February $14,000; April $16,000; May $15,000; June $2,000 Example Recall previous Example, develop the cash flow envelope and curves from January to June January February March April May June Bought $5,000 $10,100 $6,700 $20,100 $10,600 ($3,400) Forward hoome $10,000 $15,000 $16,000 $9,000 $5,000 $12,000 Total $15,000 $25,100 $22,700 $29,100 $15,600 $8,600 Available Expenses: $300 $300 $300.00 $300 $300 $300 Cash Flow Statement (3) $3,000 $1,600 $0 $4,900 $3,200 $900 $14,000 $18,400 $1,800 $500 SO $2,600 $1,000 $1,200 $16,000 $18,500 $2,400 $1,300 $15,000 $19,000 $2,600 $1,400 $2,000 $6,300 Total Expenses Closing $10,100 $6,700 $20,100 $10,000 ($3,400) $2,300 Balance Cash Flow Envelope Brought forward for January is $5,000 Income: Sales forecast $10 per each unit (the client takes two months to pay his sale): Nov 1,000; Dec 1,500; Jan 1,600; Feb 900; Mar 500; Apr 1,200; May 1,300; Jun 1,400 (units) Expenses: Cost of sales: [1] Overheads are $300 per month; (2) Material $2 per each unit (supplier gives one month credit); (3) Labor $1 per each unit paid in month used); (4) Loan repayment (due to equipment procurement): February $14,000; April $16,000; May $15,000; June $2,000 Example Recall previous Example, develop the cash flow envelope and curves from January to June January February March April May June Bought $5,000 $10,100 $6,700 $20,100 $10,600 ($3,400) Forward hoome $10,000 $15,000 $16,000 $9,000 $5,000 $12,000 Total $15,000 $25,100 $22,700 $29,100 $15,600 $8,600 Available Expenses: $300 $300 $300.00 $300 $300 $300 Cash Flow Statement (3) $3,000 $1,600 $0 $4,900 $3,200 $900 $14,000 $18,400 $1,800 $500 SO $2,600 $1,000 $1,200 $16,000 $18,500 $2,400 $1,300 $15,000 $19,000 $2,600 $1,400 $2,000 $6,300 Total Expenses Closing $10,100 $6,700 $20,100 $10,000 ($3,400) $2,300 Balance