50.1K

Verified Solution

Link Copied!

this is table 6.2 which js to be taken as refrence for the sum.

1.3.2 Please build a spreadsheet similar to Table 6.2 to compute the maximum overdraft for a project with the following characteristics: Construction Schedule and Monthly Percent Executed: Philadelphia University MCM-604 Table 6.2. Comprehensive Cash Flow Analysis Example 1) Gencral Project Information 4) Menthly Cosis and Disburecmens Monthly Costs: Monthly Immediafe Expenditures: Monthly Ixpenditures af I month credit: Total Monbly Exposures 5) Monthly Net Cash Flow and Cash Pasition Net Cash Flow: Cash Position (Overdraft): \begin{tabular}{|r|r|r|r|r|r|r|} \hline$252,000 & $672,000 & $519,000 & $82,000 & $721,000 & $540,000 & $300,000 \\ \hline$252,000 & $924,000 & $1,443,000 & $1,361,000 & $640,000 & $100,000 & $200,000 \\ \hline \end{tabular} 6) Most nesative net cash flow and maximum overdrafl Most negative net cash flow: Most negative cash positios (Max OD) $672,000 $1,443,000 1.3.2 Please build a spreadsheet similar to Table 6.2 to compute the maximum overdraft for a project with the following characteristics: Construction Schedule and Monthly Percent Executed: Philadelphia University MCM-604 Table 6.2. Comprehensive Cash Flow Analysis Example 1) Gencral Project Information 4) Menthly Cosis and Disburecmens Monthly Costs: Monthly Immediafe Expenditures: Monthly Ixpenditures af I month credit: Total Monbly Exposures 5) Monthly Net Cash Flow and Cash Pasition Net Cash Flow: Cash Position (Overdraft): \begin{tabular}{|r|r|r|r|r|r|r|} \hline$252,000 & $672,000 & $519,000 & $82,000 & $721,000 & $540,000 & $300,000 \\ \hline$252,000 & $924,000 & $1,443,000 & $1,361,000 & $640,000 & $100,000 & $200,000 \\ \hline \end{tabular} 6) Most nesative net cash flow and maximum overdrafl Most negative net cash flow: Most negative cash positios (Max OD) $672,000 $1,443,000

Answer & Explanation Solved by verified expert

See Answer