A contractor's expected expenses are shown in the table below. Assume that the contractor pay his/her direct expenses immediately. The contractor is using a markup of 20% com missing part of the table for months 1, 2, and 3 only. The retainage amount is 10%. will the End of Month Direet expenses/period-l-S65,000-$80,000 -$100,000 | -$105,000 Indireet expenses/period -20,000 -$20,000 30,000 540,000 -3500 Total expenses/period 85,000 100,000 $130,000 -$145,000 -$150.000 Cumulative expenses Budget value/period Retainage Amount payable -565000 570,000 15,000 s10,000 -$80,00$80,000 -S315.00| -$460.000 : -$610,000-$690.000-770,000 The contractor's bid price for an 8 months project is $1,500,000. cumulative expenses (direct + indirect) and budget values per period for the first The contractor's 3 periods are shown in the table below. The contractor is using a markup of 20%. Assume The contractor will pay his/her direct expenses immediately the following: The contractor will get a mobilization payment of 10% of the bod price and this on payment will be deducted equally from all the eight contractor payments. mobilizati The average delay between a request for payment and making the payment is one month. The summation of the interest expected for all periods- $13,462 -The bank interest rate is 12% per year. For periods 1, 2, and 3, make the necessary calculations in the table below for the payments received, cumulative payments, overdraft balance, and interest to be paid. 5 points) a. b. Calculate the net profit of the contractor for this project. (1.5 points) End of Month Cumulative expenses $80,000 S96,000 S9,600 $86,400 -$180,000 S120,000 $12,000 $108,000 $250,000 $84,000 $8,400 $75,600 (direct+ indirect) Budget value per Retainage (10%) Amount payable Payment received Cumulative payment Overdraft balance riod Interest