QUESTION 2 PLEASE!

Question 1 (10 points) In 2019, Leo construction will work on a bridge project that lasts 4 months. The direct costs of the bridge project are shown in the following bar chart. Assuming $5,000 indirect cost per month, and 12% markup. If the retainage is 10% 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. Fill out the table, and find out the peak financial requirement as well as the net profit of the project. $80,000 $80,000 B $90,000 C $50,000 D 2 N 3 4 1 2 4 5 End of Month Monthly Cost Monthly Billing Monthly Income Retainage Overdraft (before interest) Interest (1%) Overdraft (deduct interest) Overdraft Kadd income) Question 2 (10 points) For the same project in question 1, if the Leo Construction is given $50,000 advance payment, fill out the table, and find out what would be the peak financial requirement and net profit in this scenario. End of Month 0 1 2 4 5 Monthly Cost Monthly Billing Monthly Income Retainage Overdraft (before interest) Interest (1%) Overdraft (deduct interest) Overdraft (add income) Question 1 (10 points) In 2019, Leo construction will work on a bridge project that lasts 4 months. The direct costs of the bridge project are shown in the following bar chart. Assuming $5,000 indirect cost per month, and 12% markup. If the retainage is 10% 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. Fill out the table, and find out the peak financial requirement as well as the net profit of the project. $80,000 $80,000 B $90,000 C $50,000 D 2 N 3 4 1 2 4 5 End of Month Monthly Cost Monthly Billing Monthly Income Retainage Overdraft (before interest) Interest (1%) Overdraft (deduct interest) Overdraft Kadd income) Question 2 (10 points) For the same project in question 1, if the Leo Construction is given $50,000 advance payment, fill out the table, and find out what would be the peak financial requirement and net profit in this scenario. End of Month 0 1 2 4 5 Monthly Cost Monthly Billing Monthly Income Retainage Overdraft (before interest) Interest (1%) Overdraft (deduct interest) Overdraft (add income)