Worksheet Templates. Thursday , March 01st , 2018 - 21:57:15 PM
On the revenue side, Daves past experience with the City of Metropolis and similar projects indicate payment will come in 3 large chunks, then a revenue share of the bridge tolls for 10 years. The 3 large payments are what ESP is bidding on, and they need to cover the costs of each phase. Dave also adds a variable profit margin above costs. Using this profit margin as a variable, his goal is to estimate the lowest margin ESP can charge above its costs to ensure NPV exceeds the companys standard project bidding hurdle rate of 12%.
Next, you need to have a set of goals to work towards. There is no point is starting a budget worksheet unless you have a goal that you are striving to achieve. Without a goal sheet, any extra money you do save from your budget worksheet will have no real purpose and will be far easier to spend. Having a written set of goals helps to keep you on track.
Dave breaks out his trusty cash flow worksheet project template, which is already set up for civil engineering projects. This is his starting point which hell tweak for this project. First, he uses the quantities and types of steel, cable, cement, and other materials estimated by the engineers and multiplies those by current forward commodity prices in the market to get the approximate cost. He looks into the companys past projects to estimate a potential range of variation for the raw materials, since input prices can move substantially between proposal and building stages.
Any content, trademark/s, or other material that might be found on this site that is not this site property remains the copyright of its respective owner/s. In no way does Worksheet & Spreadsheet 2018 claim ownership or responsibility for such items, and you should seek legal consent for any use of such materials from its owner.