Sabine N Konig. Worksheet Templates. December 13th , 2017.
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.
Carefully select a film that, while it entertains, supports the #2: Precede the movie with an introduction. This will place the film in proper context and provide helpful background #3: Give the students a film study worksheet to read before prior to starting the film with the instruction that they will be asked to answer the questions after the movie is completed. The worksheet focuses student attention on those aspects of the movie that related to the subjects being covered in #4: Show the movie and allow several 3 - 5 minute breaks for students to make #5: Upon completion of the film, engage the students in a discussion which uses the interest generated by the movie to stress facts or explore concepts necessary to meet curriculum #6: Assign homework which, also uses the interest generated by the film to stress facts or explore concepts necessary to meet curriculum standards.
In the last step of his cash flow worksheet, Dave sums the expenses and revenues for each year and all 5 scenarios. He charts these out in graphs with a horizontal line for minimum acceptable return. ESP has access to public project funding at a 6% interest rate, to which he adds 3% for additional risk factors, for a 9% discount rate. Finally, he discounts the net returns per year under all scenarios at 9%, and calculates an NPV for each revenue path. This gives him 5 project values at 5 different revenue assumptions based on his variable markup. At least 3 of these NPVs must exceed the companys 12% hurdle rate in his cash flow worksheet for the bid to viable.
Next, he enters his labor costs into the cash flow worksheet broken down by engineering, iron workers, marine services, etc. He includes an estimates of hiring employees or subcontracting the work, and benefits, insurance, and other costs. These expenses are timed out according to the project phase. He adds costs of fees, permits, training, additional studies, delays, etc. to the plan.
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.