Worksheet Templates. Friday , March 02nd , 2018 - 00:52:42 AM
Dave is a financial analyst at Extra Smart Partners (ESP), a civil engineering firm in the City of Metropolis. Daves job is to work with the civil engineers and project managers to analyze the income and costs of various government-funded infrastructure projects to support the proposal and bidding process.
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.
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%.
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.