for tve schedule of values, develop unbalanced bid to increase present valur of project assuming interest rate of .667% per month.

PV of Bal. Bid PV of Unbal. Bid Gain or (Loss) Balanced Bid Unbalanced Bid Month of Present Value No. Description Amount Amount Payment (PV) of $1 1 Site Prep S 200 000 2 2 Lot A Grading S 550,000 5 3 Retainage Wall $ 1,540,000 8 4 Lot B Grading S 580,000 11 5 Utilities S 780,000 12 6 Landscaping S 350.000 14 Total: $4,000,000 ona Unbalanced Total: Complete the table shown above (also available on Canvas). Be sure to show the Gain (or Loss) for each individual item. Also, the unbalanced cost must still appear moderately reasonable to the average client. What was the Total Gain that you achieved (in dollar $)? Enter your answer here Which equals to what percentage (%) of the contract value? Enter your answer here Repeat the first problem, except now use an interest rate of i= 3% per month (Use the attached excel sheet on canvas to submit you work) Please select file(s) Select file(s) Save Answer Q13.4 1 Point When the interest rate was 3%. What was the Total Gain that you achieved (in dollar $)? Enter your answer here Which equals to what percentage (%) of the contract value? Enter your answer here PV of Bal. Bid PV of Unbal. Bid Gain or (Loss) Balanced Bid Unbalanced Bid Month of Present Value No. Description Amount Amount Payment (PV) of $1 1 Site Prep S 200 000 2 2 Lot A Grading S 550,000 5 3 Retainage Wall $ 1,540,000 8 4 Lot B Grading S 580,000 11 5 Utilities S 780,000 12 6 Landscaping S 350.000 14 Total: $4,000,000 ona Unbalanced Total: Complete the table shown above (also available on Canvas). Be sure to show the Gain (or Loss) for each individual item. Also, the unbalanced cost must still appear moderately reasonable to the average client. What was the Total Gain that you achieved (in dollar $)? Enter your answer here Which equals to what percentage (%) of the contract value? Enter your answer here Repeat the first problem, except now use an interest rate of i= 3% per month (Use the attached excel sheet on canvas to submit you work) Please select file(s) Select file(s) Save Answer Q13.4 1 Point When the interest rate was 3%. What was the Total Gain that you achieved (in dollar $)? Enter your answer here Which equals to what percentage (%) of the contract value? Enter your answer here