Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
this is table 6.2 which js to be taken as refrence for the sum.
image text in transcribed
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

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

Content Audits And Inventories A Handbook

Authors: Paula Ladenburg Land

1st Edition

1937434389, 978-1937434380

More Books

Students also viewed these Accounting questions