Spreadsheet: 217359d1362052773-evenly-amortise-value-over-financial-year-months-cashflowpere
Sheet: cashflow

 | 2013-07-31 00:00:00 | 2013-08-31 00:00:00 | 2013-09-30 00:00:00 | 2013-10-31 00:00:00 | 2013-11-30 00:00:00 | 2013-12-31 00:00:00 | 2014-01-31 00:00:00 | 2014-02-28 00:00:00 | 2014-03-31 00:00:00 | 2014-04-30 00:00:00 | 2014-05-31 00:00:00 | 2014-06-30 00:00:00 | 2014-07-31 00:00:00 | 2014-08-31 00:00:00 | 2014-09-30 00:00:00 | 2014-10-31 00:00:00 | 2014-11-30 00:00:00 | 2014-12-31 00:00:00 | 2015-01-31 00:00:00 | 2015-02-28 00:00:00 | 2015-03-31 00:00:00 | 2015-04-30 00:00:00 | 2015-05-31 00:00:00
 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FY15
Total Income | 2000000
Direct Job Costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Opening Stock | -137500 | -137500 | -208000 | -160500 | -204000 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Opening WIP | -137500 | -137500 | -208000 | -160500 | -204000 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 | -137500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Subcontractors | 137500 | 208000 | 160500 | 204000 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Materials | 137500 | 208000 | 160500 | 204000 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Workshop | 137500 | 208000 | 160500 | 204000 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Hire Fees | 68750 | 104000 | 80250 | 102000 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | END
PC | 137500 | 208000 | 160500 | 204000 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Site | 68750 | 104000 | 80250 | 102000 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Incidentals | 137500 | 208000 | 160500 | 204000 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Net Stock Movement | 68750 | 104000 | 80250 | 102000 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 68750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Closing WIP | 100000 | 208000 | 160500 | 204000 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Closing Stock on Hand | 137500 | 208000 | 160500 | 204000 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 137500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Total Direct Costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END
Gross Margin ($) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | END
Gross Margin (%)