Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you fill out the green boxes You will send the invoice to owner at the end of the month; you will receive payment one
Can you fill out the green boxes
You will send the invoice to owner at the end of the month; you will receive payment one month after the invoice is sent. All previously held Retention will be released two months after the project is over both for the GC and the Sub contractor. Retention held by the owner x% of bill to owner Retention held from the sub = y% of sub amount $15,700 $16,800 8% Sub, material, equipment, and other costs are pay when paid; Labor is paid weekly 92.00% Gross Profit Margin 20% 89.00% Month Direct Costs Total Direct Costs 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) Cash Flow 1 Materials $2,000 Labor $700 Equipment $2,000 Project Overhead $2,100 Sub Contractor $3,000 $9,800 2 S7,ooo $800 $1,700 s 1 ,200 $5,000 3 $4,500 $3 ,ooo $1 ,200 $1,100 $7 ,ooo 4 $2,000 $12,00 $500 $600 $2,700 $7,000 5 6 Totals $15,500 $5,700 $5,400 $5,000 $17,700 $49,300 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 =
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started