Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you fill out the green boxes 3:50PM Sun Feb 11 Practice 2 Project Cash Flow 2 Retention held by the owner x% of bill
Can you fill out the green boxes
3:50PM Sun Feb 11 Practice 2 Project Cash Flow 2 Retention held by the owner x% of bill to owner Retention held from the sub = y% of sub amount e @ i 23% Done 7% 93.00% 88.00% Sub, material, equipment, and other costs are pay when paid; Labor is paid weekly; PO is paid monthly before the payment is received from the owner (i.e. when the costs are incurred). Gross Profit Margin GC will send the invoice (bill or pay apps) to the owner at the end of the month; GC will receive payment from the owner at the end of the next (following) month. All previously held Retention (month 1 & 2) will be released during month 3 and then during month 5 (month 3, 4, 5) Month Direct Costs Total Direct Costs Profit &GOH (Indirect Costs) Bill To owner Money Received from Owner/GC 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 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) Materials Labor Equipment Project Overhead SubContractor 1 $3 ,ooo $5,000 $1 ,ooo $1500 $2,000 $12,500 2 $6,000 $500 $1700 $1100 $6,000 $15,300 3 $3500 $300 $200 $100 $7,000 $11,100 4 $2,000 $200 $300 $200 $2,700 $5,400 5 Totals $14,500 $8,000 $3 ,200 $2,900 $15,700 $44,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 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