Collate the S-Curve costs into monthly summaries and prepare a cash flow statement to determine the capital required for the job.
Expenditure Month 1 = $_____________
Month 2 = $_____________
Month 3 = $_____________
Month 4 = $_____________
Month 5 = $_____________
Month 6 = $_____________
Month 7 = $_____________
Month 8 = $_____________
Month 9 = $_____________
Month 10 = $_____________
Month 11 = $_____________
Month 12 = $_____________
Use the following information to create your cash flow statement:
•Profit and Overhead = 18%
•Defects Liability Period = Twelve (12) weeks.
•Cost of Finance = 12% per annum,
To be entered the month after any negative Cumulative Total.
Frequency of Claims = At the end of each four (4) weeks.
Period of Payment = Four [4] weeks between claim and payment.
Deposit = 5% of Contract Sum
To be included as additional income in Month 1, and then deducted from the first Progress Claim.
Initial Project Float = $ 300,000.00
To be included as additional income in Month 1, and then deducted any time after the Cumulative Total (Progress Account) is trading positive.
Bank Guarantee = Two (2) x 8% of Contract Sum
Use the template over the page to calculate your costs: