Using the template and monthly cash flow (Part 1) perform a line of credit analysis using the 60-day payment cycle and retainage of 10%. The table must indicate the maximum Line of Credit.

Part 1

Part 2

Budget Activity Duration 8 11 2 3 4 6 7 9 10 1 $90,000 1 $66,000 3 2 $120,000 4 3 $140,000 5 4 $90,000 3 5 5 $125,000 6 5 $200,000 7 8 $108,000 $175,000 12 Line of Credit Analysis Cummulative Line of Credit Cumulative Costs Payments Received Month Monthly Cost Payments Month Required Received 1 2. 2 3 3 4 4 5 5 6 6 7 7 8 8 10 10 11 11 12 12 Total Contract 13 14 Retainage 15 Total Paid Budget Activity Duration 8 11 2 3 4 6 7 9 10 1 $90,000 1 $66,000 3 2 $120,000 4 3 $140,000 5 4 $90,000 3 5 5 $125,000 6 5 $200,000 7 8 $108,000 $175,000 12 Line of Credit Analysis Cummulative Line of Credit Cumulative Costs Payments Received Month Monthly Cost Payments Month Required Received 1 2. 2 3 3 4 4 5 5 6 6 7 7 8 8 10 10 11 11 12 12 Total Contract 13 14 Retainage 15 Total Paid