PROJECTED CASHFLOW Prepare a cash-flow on a monthly basis, based on the following project transactions: Jan 5, 2014 ABC Builders invested P100,000 to finance their future project Jan 20, 2014 Received 20% down-payment for the Ph1,800,000 project estimated to be completed within 6months starting February 1, 2014. Jan 25, 2014 Mobilized project and spent Ph15,000.00 as mobilization cost. Jan 25, 2014 Purchased materials and issued post-dated-check to supplier worth Ph180,000 dated Feb 25, 2014 Feb 5, 2014 Purchased construction equipment worth Ph200,000. Paid 30% down-payment, and the remaining balance payable in seven (7) equal monthly payment without interest starting March 5, 2014 and ends Sept 5, 2014. Feb 02, 2014 Treat clients for dinner for Ph15,000 charge as representation in Project Overhead cost. Feb 6, 2014 Purchased materials worth P230,000 and issued PDC dated March 6, 2013. Feb 28, 2014 Paid salaries of direct labor for Ph60,000. March 8, 2014 Purchased materials worth P160,000 and issued PDC dated April 8, 2013. March 15, 2014 Received first monthly progress billing of Ph200,000. March 30, 2014 Paid salaries of direct labor for Ph70,000. April 5,2014 Purchased materials worth P170,300 and issued PDC dated May 5, 2013. April 15, 2014 Received second progress billing of Ph300,000.00 April 28, 2014 Paid salaries of direct labor for Ph80,000 May 10,2014 Purchased materials worth P160,700 and issued PDC dated June 10, 2013. May 15, 2014 Received third progress billing of issued PDC dated May 5, 2013. April 15, 2014 Received second progress billing of Ph 300,000.00 April 28, 2014 Paid salaries of direct labor for Ph80,000 May 10,2014 Purchased materials worth P160,700 and issued PDC dated June 10, 2013. May 15, 2014 Received third progress billing of Ph330,000.00 May 28, 2014 Paid salaries of direct labor for Ph70,000. June 10,2014 Purchased materials worth P90,000 and issued PDC dated July 10, 2013. June 15, 2014 Received fourth progress billing of Ph360,000.00 June 28, 2014 Paid salaries of direct labor for Ph65,000 July 8, 2014 Purchased materials worth P80,000 and issued PDC dated Aug 8, 2013. July 15, 2014 Received fifth progress billing of Ph310,000.00 July 28, 2014 Paid salaries of direct labor for Ph40,000. July 30, 2014 Demobilized project and spent P8,000.00 as demobilization cost. August 15, 2014 Received final payment of Ph300,000.00. September 30, 2014 Release of retention after issuing guarantee bond and paid insurance premium equivalent to 3% of the retention money. Other cash-flow information: Down-payment to be recouped from progress billings - Project overhead cost at Ph20,000.00 per month during the project duration. - Loans to be paid on a lump sum amount at the end of the project with fix 1% interest rate on the loan amount per month. - Progress billing is subject to 10% retention and to be release after issuance of guarantee bond equivalent to 3% of the retention money - Minimum monthly cash ending balance of 10,000.00 Prepare Cashflow, Income Statement and Balance Sheet for the period ending July 30, 2014