Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fill in the yellow cells Team [Name] Cash Flow Bid Amount $3,003,269.24 profit Month Billed Expenses for (Amount Spent) Cumulative amount spent Amount Earned Retainage

image text in transcribedFill in the yellow cells

Team [Name] Cash Flow Bid Amount $3,003,269.24 profit Month Billed Expenses for (Amount Spent) Cumulative amount spent Amount Earned Retainage Amount billed Amount received Cumulative amount received Cumulative Cash Flows to Date ($387,535.37) ($387,535.37) $44,566.57 $401,099.11 $256,551.46 $401,099.11 $401,099.11 $256,551.46 ($1,100.426.21) ($1,429,892.37) Max Capital need =largest Cumulative Cash Flows to Date value +next expenses $53,476.73 $37.888.61 $11,798.93 $340,997.48 $106,190.37 $107,090.37 $107,990.37 $340.997.48 $106,190.37 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Month 13 Month 14 ($387,535.37) ($247,875.81) ($465,015.03) ($329,466.16) ($102.599.39) ($102,599.39) ($103,599.39) ($104,599.39) ($105.599.39) ($106,599.39) ($107,599.39) ($108,599.39) ($109,599.39) ($200,000.39) Profit $445,665.68 $285,057.18 $534,767.29 $378,886.09 $117,989.30 $118.989.30 $119,989.30 $120.989.30 $125,989.30 $130,989.30 $140,989.30 $150.989.30 $160,989.30 $170,989.30 ($442,775.64) ($290.951.24) ($52,553.14) ($48,962.16) ($45,471.18) ($42,080.20) $1,138,941.14 $1,479,938.62 $1,586,128.99 $1,693,219.36 $1,801.209.73 ($1,635,091.15) ($1,738,690.54) ($1.843.289.93) ($1.948.889.32) ($2,055,488.71) $107,990.37 $108,890.37 $11.998.93 $12,098.93 $12,598.93 $13,098.93 $14,098.93 $15,098.93 $113,390.37 $117.890.37 $126,890.37 $135,890.37 $144,890.37 ($31.998.24) ($21,707.26) ($2,271,687.49) ($2,381,286.88) ($2,581,287.270) $117,890.37 $126,890.37 $135,890.37 $2,023,490.47 $2,141,380.84 $2,268,271.21 $2,404,161.58 $2,549,051.95 $22,874.70 ($32.235.32) $17,098.93 Total Please fill in the yellow shaded cells

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

Students also viewed these Accounting questions