QUESTION 4: Project Accounting (40 marks) 4. Given is a table of revenue and costs for a project to be implemented. Please create a forecasted cashflow spreadsheet. Please show clearly: 4.1 4.2 4.3 4.4 4.5 the Cash In-flow, (8 marks) the Cash Outflow, (8 marks) the Net Cashflow, (8 marks) the Cumulative Cash flow. (8 marks) Analyze and state the minimum amount of money that should be advanced to the Project Team to ensure that the project team cumulative cashflow remain positive throughout the project? (it is better to show this analysis in the forecasted cash flow spreadsheet. (8 marks) Quantity Unit Rate Total Cost 6,000.00 6,000.00 Rate Total Revenue 7,500.00 7,500.00 1 1 unit 1 2 2.1 4 2.2 4 months months months months Description Cost/Revenue Mobilisation Installation Work Project Manager Engineer Supervisor General Labour Total Installation Works Materials Transportation Testing Tools Miscellaneous TOTAL Cost/Revenue 1 1 2 8 6,000.00 4,000.00 3,000.00 1,500.00 24,000.00 7,500.00 16,000.00 5,000.00 18,000.00 3,750.00 36,000.00 1,875.00 30,000.00 20,000.00 22,500.00 45,000.00 2.3 ww 2.4 2.5 12 94,000.00 117,500.00 3 15 1 4 3 sites months sites 1 8,000.00 3,000.00 1000 10,000.00 5 1 15 1 120,000.00 10,000.00 150,000.00 9,000.00 3,750.00 11,250.00 15,000.00 1,250.00 18,750.00 10,000.00 12,500.00 12,500.00 254,000.00 317,500.00 6 1 7 Terms: 1. Payment terms is 45 days after submission of Invoice. 2. Invoicing will be done at end of working month. 3. Project Manager and Engineer will start 2 weeks before the installation team and finishes 2 weeks after. 4. Total Installation works for the installation team is 3 months 5. There are 15 sites for installation. Each month can complete 5 sites