Question: Assignment: You are analyzing a construction project with a five-month duration. On the last day of each month you may bill the owner for the

Assignment: You are analyzing a construction project with a five-month duration. On the last day of each month you may bill the owner for the work completed during the month. The owner will pay the monthly bills 15 days after they are received. The owner will withhold \10 retention. Final payment is expected one month after completion of the project and includes payment of all accumulated retention. You will pay material suppliers in full when you receive payment from the owner. You will pay subcontractors when you receive payment from the owner. You will withhold \10 from the subcontractor's payment. You pay for self-performed labor on a weekly basis. The project's monthly costs and billings are shown below. Formatting The format of your Excel file should match the layout included in the video and powerpoint. Be sure to identify: - Your cash flow before payment - Total cash before payment - Your cash flow at the end of the month - Your total cash at the end of the month - Your peak need for cash Submission: Your submission must be in Excel, with all formulas included. Submit your completed spreadsheet with this assignment. Make sure it includes the minimum items listed above
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
