Civil Engineering Projects
Calculating Expenses
Now that you've projected your revenue, it's time to project your expenses for the business.
Staff costs
Your ...
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.
...
Building an Integrated Financial Statements Model
inancial statements are the mainstay of many financial models. The financial
statements ...
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 ...
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 ...
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 ...
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 ...
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 ...
Charting and Presenting Model Output
he final stage of the model building process is to present the outcome of the model. You've spent a lot of ...
Using Scenario Manager to Model Loan Calculations
Scenario Manager is grouped together with Goal Seek and Data Tables in the What-If Analysis ...
Applying Sensitivity Analysis with Data Tables
Data tables are among the more advanced and complex financial modeling tools available. Data ...
Applying Scenarios to Your Financial Model
ne of the things that makes a financial model a financial model and not a spreadsheet is that it ...
