Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance A Contemporary Application Of Theory To Policy

Authors: David N. Hyman

5th Edition

0030113172, 978-0030113178

More Books

Students also viewed these Finance questions