1. The table and graph below represent a contractor's overdraft requirements for a project. The contractor marks up their costs by 15%. The bank charges the contractor interest at a rate of 3% per month. Retainage is withheld by the owner. According to the contract, the owner is billed at the end of each month. The payment is received at the end of next month to be deposited in the bank the first of the following month. Assuming that there are no Outstanding issues, the retainage will be released one month after the completion of the project. 45,727 20,000 -14,023 14,023 1 2 - 69,100 -66,950 - 100,464 - 115,257 -117,523 -188,439 -211,415 -235,317 *Note: The lower numbers in the graph represent the [overdraft + interest] value. 1 3 5 6 2 $92,000 $75,000 $20,000 $25,000 $18,000 Direct cost Indirect cost Total cost Markup Amount billed Retainage Pay received Complete the table. Please show ALL your calculations (not sample calculation, not your excel file, but ALL your calculations!) for this questions. What rule was used for the retainage (% and time duration) in this contract? Explain what makes up the last payment in this project. Draw the Expense/Revenue curves in one figure) with 2 expense curves: one representing project cost and one representing project price. Establish the cashflow diagram for this project. Calculate the ROR for this project. 1. The table and graph below represent a contractor's overdraft requirements for a project. The contractor marks up their costs by 15%. The bank charges the contractor interest at a rate of 3% per month. Retainage is withheld by the owner. According to the contract, the owner is billed at the end of each month. The payment is received at the end of next month to be deposited in the bank the first of the following month. Assuming that there are no Outstanding issues, the retainage will be released one month after the completion of the project. 45,727 20,000 -14,023 14,023 1 2 - 69,100 -66,950 - 100,464 - 115,257 -117,523 -188,439 -211,415 -235,317 *Note: The lower numbers in the graph represent the [overdraft + interest] value. 1 3 5 6 2 $92,000 $75,000 $20,000 $25,000 $18,000 Direct cost Indirect cost Total cost Markup Amount billed Retainage Pay received Complete the table. Please show ALL your calculations (not sample calculation, not your excel file, but ALL your calculations!) for this questions. What rule was used for the retainage (% and time duration) in this contract? Explain what makes up the last payment in this project. Draw the Expense/Revenue curves in one figure) with 2 expense curves: one representing project cost and one representing project price. Establish the cashflow diagram for this project. Calculate the ROR for this project