Question: In 2022, Leo construction will work on a residential project that lasts 4 months. The direct costs of the residential project are shown in the


In 2022, Leo construction will work on a residential project that lasts 4 months. The direct costs of the residential project are shown in the following bar chart. Assuming $5,000 indirect cost per month, and 14.4% markup. If the retainage is 9% throughout the project, finance charge is 1% per month, and payments will be billed at the end of the month and will be received one month later. How much is the last payment the contractor is expected to receive? Question 2 15pts Fill out the cash flow table in the attached excel sheet , Please upload the finished table in the below box. \begin{tabular}{|l|l|l|l|l|l|l|} \hline End of Month & 0 & 1 & 2 & 3 & 4 & 5 \\ \hline MonthlyCost(Direct&IndirectCost) & & & & & & \\ \hline Monthly Billing & & & & & & \\ \hline Monthly Income & & & & & & \\ \hline Retainage & & & & & & \\ \hline Overdraft(beforeinterest) & & & & & & \\ \hline Interest (1\%) & & & & & & \\ \hline Overdraft(deductinterest) & & & & & & \\ \hline Overdraft(addincome) & & & & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
