Projects that involve both the construction or renovation of a structure or an alteration of part of the environment are considered part of civil engineering.
5 major civil engineering projects:
Water engineering.
Construction and management engineering.
Structural engineering.
Geotechnical engineering.
Transport engineering.
Building the Cash Flow Statement Cash is king! When running a business like this — particularly a new business — you should never ever run out of cash. You may have a business that’s highly profitable, but if you can’t pay your staff next month, then you don’t have a busi- ness. For this reason, […]
Financial Modeling in Excel Building the Cash Flow Statement Read More »
Building the Income Statement The income statement, also called the profit-and-loss (P&L) statement, shows the underlying profitability of the company — in other words, exactly how much money the business is making. This information is useful for the purposes of cal- culating taxes; it also helps the owner or manager run the business. Of all
Financial Modeling in Excel Building the Income Statement Read More »
Calculating Expenses Now that you’ve projected your revenue, it’s time to project your expenses for the business. Staff costs Your assumption for the barista’s annual salary is $50,000, so your annual pro- jection should be divided by the 12 months of the year to arrive at the monthly amount. Follow these steps: =D5*Assumptions!$B$21. The calculated
Financial Modeling in Excel Calculating Expenses Read More »
Calculating Revenue Now that you’re happy with your assumptions, you can use them to calculate the revenue of the business for the next year. Projecting sales volume You know that your base case assumption is that the cafe will sell 120 cups of coffee per day, so you need to multiply this assumption by the
Financial Modeling in Excel Calculating Revenue Read More »
Building an Integrated Financial Statements Model inancial statements are the mainstay of many financial models. The financial statements consist of three reports: Some financial models might include only a profit-and-loss statement, some might include simply a cash flow statement, but many include all three. If a financial model does contain all three, you might hear
Financial Modeling in Excel Building an Integrated Financial Statements Model Read More »
Preparing a Presentation You know your financial model best. No one is more qualified than you are to talk about your model, so you may be asked to communicate the results of the financial model as a formal presentation to the board or senior management. You need to decide how to communicate your findings in
Financial Modeling in Excel Preparing a Presentation Read More »
Dynamic Charting When you’re creating charts in financial models or reports, you should still follow best practice and try to make your models as flexible and dynamic as you can. You should always link as much as possible in your models, and this goes for charts as well. It makes sense that when you change
Financial Modeling in Excel Dynamic Charting Read More »
CHANGING A PIE CHART TO A DOUGHNUT CHART Doughnut charts are another way of displaying exactly the same information as a pie chart. To change your pie chart to a doughnut chart, follow these steps: A doughnut chart is just a pie chart with a hole in the center. This difference may not seem significant
CHANGING A PIE CHART TO A DOUGHNUT CHART Read More »
Deciding Which Type of Chart to Use When deciding how to display the output of your model, you have a lot of choices, especially in the later versions of Excel because they keep adding new charts to standard Excel. Looking back through the financial models I’ve created in the past couple of years, around 80
Deciding Which Type of Chart to Use Read More »
Conveying Your Message by Charting Scenarios As I mention in Chapter 8, the major limitation of drop-down scenarios such as the one built in the preceding section is that you can’t see multiple scenarios side- by-side. The outputs of the five-year forecast model shown in Figure 9-2 only show the cost per customer under the
Conveying Your Message by Charting Scenarios Read More »
