1 In this table, the owner pays their invoice immediately (within the same period). As such, the subcontractors are paid within the same period as well. Calculate the financial burden on the line of credit at 4% APR. Remember, you only pay interest when there is a negative cash flow. Hint: use the format in the "cash flow" tab in the excel sheet we went over in class. You will need to add additional columns for Equip, GC's and Fees and modify your formulas accordingly. Use your negative cumulative amounts to calculate your interest costs per month as we did in the "Draw Summary" tab. PAY ATTENTION TO YOUR CASH FLOW SIGNING,+ or -- Payables Receivables Invoice Month Materials Labor Equipment Subs GC's Fee Amount (less retainer) $ $ $ $ 27,900 94,700 11,300 156,060 $ $ $ $ $ $ $ 2 16,400 62,300 12,700 100,600 9,900 10,400 208,620 $ $ $ $ $ $ $ 3 30,500 47,600 14,600 153,100 6,800 13,900 229,410 $ $ $ $ $ $ $ 19,200 36,300 12.900 136,600 6,800 15,300 198,090 $ $ $ $ $ $ $ 5 16,400 16,100 10,800 122,600 4,900 13,200 158,760 $ $ $ $ $ $ $ 6 11,800 12,200 10,400 87,700 3,700 10,600 114,930 $ $ $ $ $ $ $ 7,400 10,300 9,000 77.100 3,200 7.700 99,450 $ $ $ $ $ 8 5.900 11,300 7,400 67,600 9,400 6,600 234,680 $ $ $ 9 4,400 6,200 6,300 Totals $1,400,000 3 4 $ HA 7 $ $ $ $ 1 In this table, the owner pays their invoice immediately (within the same period). As such, the subcontractors are paid within the same period as well. Calculate the financial burden on the line of credit at 4% APR. Remember, you only pay interest when there is a negative cash flow. Hint: use the format in the "cash flow" tab in the excel sheet we went over in class. You will need to add additional columns for Equip, GC's and Fees and modify your formulas accordingly. Use your negative cumulative amounts to calculate your interest costs per month as we did in the "Draw Summary" tab. PAY ATTENTION TO YOUR CASH FLOW SIGNING,+ or -- Payables Receivables Invoice Month Materials Labor Equipment Subs GC's Fee Amount (less retainer) $ $ $ $ 27,900 94,700 11,300 156,060 $ $ $ $ $ $ $ 2 16,400 62,300 12,700 100,600 9,900 10,400 208,620 $ $ $ $ $ $ $ 3 30,500 47,600 14,600 153,100 6,800 13,900 229,410 $ $ $ $ $ $ $ 19,200 36,300 12.900 136,600 6,800 15,300 198,090 $ $ $ $ $ $ $ 5 16,400 16,100 10,800 122,600 4,900 13,200 158,760 $ $ $ $ $ $ $ 6 11,800 12,200 10,400 87,700 3,700 10,600 114,930 $ $ $ $ $ $ $ 7,400 10,300 9,000 77.100 3,200 7.700 99,450 $ $ $ $ $ 8 5.900 11,300 7,400 67,600 9,400 6,600 234,680 $ $ $ 9 4,400 6,200 6,300 Totals $1,400,000 3 4 $ HA 7 $ $ $ $