Using the information contained in the image below, complete the Cash Flow chart for this project. Your deliverables are the following: 1) Identification of the Maximum Retainage for the Project based on the listed Commercial Terms. 2) Completing the CashFlow calculations for the remaining Months of the Project (Feb-Sept.) Upon completion, submit your file for your answer. The below Excel or pdf file may be used as your basis for submittal or you may develop your own. Cashflow Question 1-1.xlsx Cashflow Question 1.pdf Contract Value 1,034,120.00 udgeted Cost 1.004.000.00 Profit Margin Intergal Rate 7356 Commerical Termi Retainage 10% January Budgeted Com (CWT 5 45.000.00 Estimated Profit 15 1.350.00 Contract Valse 5 46.350.00 Amount Earned 15 46,350.00 ess Retainage 5 4.635.00 Total Dur 15 41.715.00 Amount Received Montivy Invoice 41715.00 Cash Balance $ 145,000.00 11.262.301 Cash Flow (4826) 501 Maximum Retainage Payments occur la per month, submitted by the 25th and projected through the end of the month On 50% Contract Valur February 92.000.00 March Apal 175.000.00 $265,000.00 5 May June 320 600 60 516468666 July August 16,000.00 September Using the information contained in the image below, complete the CashFlow chart for this project. Your deliverables are the following: 1) Identification of the Maximum Retainage for the Project based on the listed Commercial Terms. 2) Completing the CashFlow calculations for the remaining Months of the Project (Feb-Sept.) Upon completion, submit your file for your answer. The below Excel or pdf file may be used as your basis for submittal or you may develop your own. Cashflow Question 1-1.xlsx Cashflow Question 1.pdf Contract Value $1,034,120.00 Budgeted Cost 1,004,000.00 Profit Margin 3% terest Rate 7.25% Commerical Terms Retainage 10% January Budgeted Cost (BCWS) 5 $5.000.005 Estimated Profit $ 1,350.00 Contract Value S 46,350.00 Amount Earned 15 46,350.00 Less Retainage S 4635.00 Total Due B 41.715.00 Amount Received Monthly Invoice 15 41.715.00 Cash Balance S (45.000.00 interest (3.262.50% Cash Flow S 48 262.500 Maximum Retainage Payments occur is per month, submitted by the 25th and projected through the end of the month. On 50% Contract Value February March 92.000.00 $175,000.00 5 April 205,000.00 5 May June 220,000.00 5104,000.00 $ August September 87,000.00 $16,000.00 $5