Question: 5. Complete the overdraft calculation table on the next page (6 pts) and answer the following questions based on the following assumptions: Project lasts two

 5. Complete the overdraft calculation table on the next page (6

5. Complete the overdraft calculation table on the next page (6 pts) and answer the following questions based on the following assumptions: Project lasts two months with retainage paid during month 4 Payment for Month 1 is received at the start of month 3 Payment for month 2 is received at the start of month 4 What is the percent markup? (2 pts) What is the percent of retainage? (2 pts) What is the total amount of this contract? (2pts) What is the maximum amount of money borrowed? (2pts) What is the total interest paid? (2 pts) Page 3 of 4 What is final markup on this project (2 pts) NOTE: If you leave a cell blank in the table, I will assume you do not know what belongs there! Month 3 Month 4 Description Direct Cost Month 1 $ 80,000 Month 2 $ 60,000 Indirect Cost $ 10,000 $ 10,000 Subtotal of Costs $ 90,000 $ 70,000 Markup $ 18,000 XXXXX Total Billed Retainage withheld $ 4,200 Payment Received Total Costs to Date (not including Interest) Total Amount Billed to date Total Amount Received to date Overdraft at end of month Interest on overdraft balance (1.0% per month) $0 $ 102,600 $192,000 Total Amount Financed

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!