4 5 6 $2,000 $12,00 $500 $600 $2,700 $7,000 Totals $15,500 $5,700 $5,400 $5,000 $17,700 $49,300 $3,000 Retention held by the owner = x% of bill to owner 9% 91.00% Retention held from the sub = y% of sub amount 11% 89.00% Sub, material, equipment, and other costs are paid when paid; Labor is paid weekly Gross Profit Margin 18% You will send the invoice to owner at the end of the month; you will receive payment one month after the invoice is received. All previously held Retention will be released two months after the project is over. Month 1 2 3 Direct Costs Materials $2,000 $7,000 $4,500 Labor $1000 $500 $3,000 Equipment $2,000 $1,700 $1,200 Project Overhead $2,100 $1,200 $1,100 SubContractor $5,000 $7,000 Total Direct Costs $10,100 $15,400 $16,800 Profit &GOH (Indirect Costs) Bill To owner Money Received from Owner/GC (CASH IN) Money Received from the owner Retention held by the owner Retention released by the owner Total Money Received (Cash In) Payments made to suppliers, labor, and sub (CASH OUT) Paid for Materials Paid for Labor Paid to Equipment Supplier Paid to Project Overhead Paid to SubContractor Retention held from Sub Contractor Retention released to the Sub Total Payments (Cash out) Net Cash Flow at Month's end (Cash in - Cash out) Total cash generated at Month's end (after payment is received from owner) Cash Invested Cash needed for the project before payment is received from the owner Effective Cash needed for the project before payment is received from the owner Total Cash invested in the project before payment is received from the owner Month with max cash need and the amount: Total amount of cash needed for the project is = 4 5 6 $2,000 $12,00 $500 $600 $2,700 $7,000 Totals $15,500 $5,700 $5,400 $5,000 $17,700 $49,300 $3,000 Retention held by the owner = x% of bill to owner 9% 91.00% Retention held from the sub = y% of sub amount 11% 89.00% Sub, material, equipment, and other costs are paid when paid; Labor is paid weekly Gross Profit Margin 18% You will send the invoice to owner at the end of the month; you will receive payment one month after the invoice is received. All previously held Retention will be released two months after the project is over. Month 1 2 3 Direct Costs Materials $2,000 $7,000 $4,500 Labor $1000 $500 $3,000 Equipment $2,000 $1,700 $1,200 Project Overhead $2,100 $1,200 $1,100 SubContractor $5,000 $7,000 Total Direct Costs $10,100 $15,400 $16,800 Profit &GOH (Indirect Costs) Bill To owner Money Received from Owner/GC (CASH IN) Money Received from the owner Retention held by the owner Retention released by the owner Total Money Received (Cash In) Payments made to suppliers, labor, and sub (CASH OUT) Paid for Materials Paid for Labor Paid to Equipment Supplier Paid to Project Overhead Paid to SubContractor Retention held from Sub Contractor Retention released to the Sub Total Payments (Cash out) Net Cash Flow at Month's end (Cash in - Cash out) Total cash generated at Month's end (after payment is received from owner) Cash Invested Cash needed for the project before payment is received from the owner Effective Cash needed for the project before payment is received from the owner Total Cash invested in the project before payment is received from the owner Month with max cash need and the amount: Total amount of cash needed for the project is =