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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!