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
Month	Materials	Labor	Equipment	Subs	GC's	Fee		Invoice Amount (less retainer)
1		$ 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
4	$ 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	$ 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

What happens when we front-end-load our project? Calculate the financial burden on a line of credit at 5% given the following conditions: Payment terms are still 30 days, pay-when-paid with subs, current with labor and GC's, 30 days with materials, equipment, and fees.

Please These question have two parts! I could not understand!