profit Estimate Amount Bid Amount $ 2,581,287.27 $3,003,269.24 Month Billed for Expenses (Amount Spent) Cumulative amount spent Amount Earned Retainage Amount billed Amount received Cumulative amount received Cumulative Cash Flows to Date Final payment does not have retainage in it ($387,535.37) $44,566.57 ($387,535.37) ($387,535.37) ($247,875.81) $445,665.68 $285,057.18 $401.099.11 $256,551.46 $401,099.11 $401,099.11 $256,551.46 Max Capital need =largest Cumulative Cash Flows to Date value +next expenses ($465,015.03) ($329,466.16) | ($102,599.39) ($1,100,426.21) $1,429,892.37) | $534,767.29 $378,886.09 $117,989.30 $53,476.73 | $37,888.61 $11,798.93 $340,997.48 $106,190.37 ($442,775.64) ($290,951.24) ($52,553.14) $340,997.48 $106,190.37 | ($48,962.16) $1,138,941.14 $1,479,938.62 $1,586,128.99 $1,693,219.36 | $1,801,209.73 $107,090.37 $107,990.37 Profit ($1,635,091.15) ($1,738,690.54) ($1,843,289.93) ($1,948,889.32) ($2,055,488.71) ($45,471.18) $42,080.20) | ($102,599.39)| ($103,599.39) ($104,599.39)| ($105,599.39) ($106,599.39) ($107,599.39) ($108,599.39) ($109,599.39) $200,000.39) $107,990.37 $108,890.37 $118,989.30 $119,989.30 $120,989.30 $125,989.30 $130,989.30 $140,989.30 $150,989.30 $160,989.30 $170,989.30 $300,326.92 $11,998.93 $12,098.93 $12,598.93 $13,098.93 $14,098.93 $15,098.93 $113,390.37 $117,890.37 $126,890.37 $135,890.37 $144,890.37 ($31,998.24) ($21,707.26) ($2,271,687.49) ($2,381,286.88) ($2,581,287.270) $117,890.37 $126,890.37 $135,890.37 $2,023,490.47 $2,141,380.84 $2,268,271.21 $2,404,161.58 $2,549,051.95 $2,702,942.32 | | $17,098.93 $22,874.70 $32,235.32) $121,655.05 $300,326.92 $153,890.37 $300,326.92 ($2,581,287.27) Total Please fill in the yellow shaded cells Cash flow Assignment In this assignment, you are asked to develop a contractor's Cash flow. The cash flow is at the heart of any successful business, and many contractors depend on a line of credit in order to maintain sufficient working capital during project execution. This document establishes the template for measuring work progress so the contractors know the capital money amount they need to finish the project. This activity is built up so you can get the concept behind constructing contractor's Cash flow. Different contractors may have different way. This form is for the purpose of this class. You are to use this worksheet to record your responses, then enter them into the Moodle interface. This assignment is a good practice as you prepare for your project. Please use this document as a worksheet. Upload your responses directly to Moodle. You have to use SOV assignment to complete this assignment so make sure that the assignment is correct. You are required to determine the Max Capital need using the following equation Max Capital need =largest Cumulative Cash Flows to Date value +next expenses And the contractor's profit. (Profit = Cumulative amount received - Cumulative Amount Spent). Retainage = 0.1* Amount Earned Please note that the Final payment doesn't have retainage in it. You will use table below for calculation. The table is also provided in excel sheet in Moodle. profit Estimate Amount Bid Amount $ 2,581,287.27 $3,003,269.24 Month Billed for Expenses (Amount Spent) Cumulative amount spent Amount Earned Retainage Amount billed Amount received Cumulative amount received Cumulative Cash Flows to Date Final payment does not have retainage in it ($387,535.37) $44,566.57 ($387,535.37) ($387,535.37) ($247,875.81) $445,665.68 $285,057.18 $401.099.11 $256,551.46 $401,099.11 $401,099.11 $256,551.46 Max Capital need =largest Cumulative Cash Flows to Date value +next expenses ($465,015.03) ($329,466.16) | ($102,599.39) ($1,100,426.21) $1,429,892.37) | $534,767.29 $378,886.09 $117,989.30 $53,476.73 | $37,888.61 $11,798.93 $340,997.48 $106,190.37 ($442,775.64) ($290,951.24) ($52,553.14) $340,997.48 $106,190.37 | ($48,962.16) $1,138,941.14 $1,479,938.62 $1,586,128.99 $1,693,219.36 | $1,801,209.73 $107,090.37 $107,990.37 Profit ($1,635,091.15) ($1,738,690.54) ($1,843,289.93) ($1,948,889.32) ($2,055,488.71) ($45,471.18) $42,080.20) | ($102,599.39)| ($103,599.39) ($104,599.39)| ($105,599.39) ($106,599.39) ($107,599.39) ($108,599.39) ($109,599.39) $200,000.39) $107,990.37 $108,890.37 $118,989.30 $119,989.30 $120,989.30 $125,989.30 $130,989.30 $140,989.30 $150,989.30 $160,989.30 $170,989.30 $300,326.92 $11,998.93 $12,098.93 $12,598.93 $13,098.93 $14,098.93 $15,098.93 $113,390.37 $117,890.37 $126,890.37 $135,890.37 $144,890.37 ($31,998.24) ($21,707.26) ($2,271,687.49) ($2,381,286.88) ($2,581,287.270) $117,890.37 $126,890.37 $135,890.37 $2,023,490.47 $2,141,380.84 $2,268,271.21 $2,404,161.58 $2,549,051.95 $2,702,942.32 | | $17,098.93 $22,874.70 $32,235.32) $121,655.05 $300,326.92 $153,890.37 $300,326.92 ($2,581,287.27) Total Please fill in the yellow shaded cells Cash flow Assignment In this assignment, you are asked to develop a contractor's Cash flow. The cash flow is at the heart of any successful business, and many contractors depend on a line of credit in order to maintain sufficient working capital during project execution. This document establishes the template for measuring work progress so the contractors know the capital money amount they need to finish the project. This activity is built up so you can get the concept behind constructing contractor's Cash flow. Different contractors may have different way. This form is for the purpose of this class. You are to use this worksheet to record your responses, then enter them into the Moodle interface. This assignment is a good practice as you prepare for your project. Please use this document as a worksheet. Upload your responses directly to Moodle. You have to use SOV assignment to complete this assignment so make sure that the assignment is correct. You are required to determine the Max Capital need using the following equation Max Capital need =largest Cumulative Cash Flows to Date value +next expenses And the contractor's profit. (Profit = Cumulative amount received - Cumulative Amount Spent). Retainage = 0.1* Amount Earned Please note that the Final payment doesn't have retainage in it. You will use table below for calculation. The table is also provided in excel sheet in Moodle