Question: Using the data below, calculate the monthly cashflow and create the cumulative revenue/expenditure curves similar to the in-class example. Perform all calculations using spreadsheet software.
Using the data below, calculate the monthly cashflow and create the cumulative revenue/expenditure curves similar to the in-class example. Perform all calculations using spreadsheet software. Annual interest rate = 6% Retainage = 10% from 0 to 50% complete; 5% from 50.01 to 99.9% complete Markup (overbilling rate) = 8% Monthly payment arrives 2 weeks after end of month. Month (1) Direct Cost + Indirect Cost $ (2) January 40,000 February 105,000 March 287,000 April 299,000 May 225,000 June 188,000 July 140,000 August 68,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
