1. 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) January February March April May June July August Direct Cost + Indirect Cost $ (2) 40,000 105,000 287,000 299,000 225,000 188,000 140,000 68,000 1. 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) January February March April May June July August Direct Cost + Indirect Cost $ (2) 40,000 105,000 287,000 299,000 225,000 188,000 140,000 68,000