Financial Modeling

Building a Parametric Excel Spreadsheet (from scratch) for Easy Scenario Analysis

So, what is a parametric spreadsheet?

Valid question. In comparison to a static/base case/deterministic spreadsheet, a parametric spreadsheet is set up in such a way that key parameters and assumptions can be changed without invalidating the underlying calculations. So if you've found that your project is delayed by a year or that CAPEX is higher than anticipated -- you can incorporate these changes into your spreadsheet without breaking everything and instantly see how they affect value.

How the DPL Software Stacks Up Against Other Decision Tree Software Tools

As a market leader in decision analytic tools, we confidently stand by our claim that DPL is the most powerful, full featured application for decision tree and influence diagram modeling on the market today. DPL offers a dedicated, standalone graphical modeling interface for performing decision and risk analyses, Monte Carlo simulation, and Real Option valuation. The tool's flexibility and intuitiveness allow you to model the characteristics specific to your decisions with a precision unmatched by our competitors.

DPL Fed Rate Hike Promotion: Buy DPL now or Buy DPL later?

After much ado the Federal Reserve decided to maintain interest rates at their current levels this past Wednesday -- which wasn't much of a surprise to most. The Syncopation team saw an opportunity to drum up the drama surrounding the Fed's upcoming November meeting by offering potentially huge savings on DPL licenses, with the amount of savings depending on the outcome of the FOMC's Nov 2 meeting. As a bonus, we're also providing a quick lesson on the value of imperfect information through our promotion. Read on for all the details.

Setting up your Excel Cash Flow Spreadsheet for Easy Scenario Analysis

We often find ourselves helping people start a DPL analysis from an Excel spreadsheet, but in many cases the difficult modeling is in the spreadsheet itself. In this post I'm going to provide you with a few simple tips for preparing your spreadsheet in a way that makes setting up and running a scenario analysis a breeze.

Subscribe to Financial Modeling