+ 61653- Music Com BIM STUFFM Track Question 6 1 pts 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 Month Materials Labor Equipment Subs GC's Fee 1 27,900 $ 11,300 $ Receivables Invoice Amount (less retainer) $ 156,060 $ 208,620 $ 229.410 $ 198,090 2 A $ 10.400 3 16.400 $ 30.500 $ 9.900 $ 6.800 $ 12.700 $ 14.600 $ 12.900 $ 10.800 $ 6.800 19.200 $ $ 62,300 $ 47.600 $ 36,300 $ 16,100 $ 12.200 $ 10.300 $ 11.300 $ 94.700 $ 100,600 $ 153.100 $ 136.600 $ 122.600 $ 87.700 $ 77.100 $ 67,600 5 16.400 $ 11,800 $ 7.400 $ 10,400 $ 9.000 $ 4.900 $ 3.700 $ 3.200 $ 9.400 $ 13.900 $ 15,300 $ 13,200 $ 10,600 $ 7.700 $ 6.600 $ 6,300 $ 158.760 $ 114.930 $ 99.450 S 234.680 7 $ 5.900 $ 7.400 9 $ 4.400 $ 6.200 Totals $1,400.000 C P AR NA + 61653- Music Com BIM STUFFM Track Question 6 1 pts 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 Month Materials Labor Equipment Subs GC's Fee 1 27,900 $ 11,300 $ Receivables Invoice Amount (less retainer) $ 156,060 $ 208,620 $ 229.410 $ 198,090 2 A $ 10.400 3 16.400 $ 30.500 $ 9.900 $ 6.800 $ 12.700 $ 14.600 $ 12.900 $ 10.800 $ 6.800 19.200 $ $ 62,300 $ 47.600 $ 36,300 $ 16,100 $ 12.200 $ 10.300 $ 11.300 $ 94.700 $ 100,600 $ 153.100 $ 136.600 $ 122.600 $ 87.700 $ 77.100 $ 67,600 5 16.400 $ 11,800 $ 7.400 $ 10,400 $ 9.000 $ 4.900 $ 3.700 $ 3.200 $ 9.400 $ 13.900 $ 15,300 $ 13,200 $ 10,600 $ 7.700 $ 6.600 $ 6,300 $ 158.760 $ 114.930 $ 99.450 S 234.680 7 $ 5.900 $ 7.400 9 $ 4.400 $ 6.200 Totals $1,400.000 C P AR NA