Systematic Finance


Example Templates

Subject Description
Data analysis Data summary and presentation
Company consolidation and report presentation
Features Demonstration of layering Excel features and techniques
Calculator Financial calculator for TVM and discounted cash flows
Investment Simple non-tax based model
Tax based investment
Private finance initiative example
Financial Analysis Company analysis spread model
Analysis model to link to Bloomberg spreadsheets
Credit risk and Z scores
Cash flow Cash flow budget
Operating leverage
Portfolio Portfolio model
Bonds Bonds calculator
Project finance Project model
Project allocation
Complete project finance model
Depreciation Straight line, declining balance, sum of digits and US MACRS
Leasing Lease versus purchase, settlement analysis
Lease pricing and evaluation
Valuation Free cash flow valuation
Adjusted present value
Three stage dividend discount
Combined model with comparison of techniques
Shareholder value added
Mergers and acquisitions Merger model with sensitivity and charts
Optimisation Linear programming, targeting and optimisation
Decisions Bayes theorem and probability models
Risk management Futures, options, swaps and forwards
Value at risk VaR demo model
Credit VaR Credit risk model


Specimen templates for use or further development which you can purchase in the on-line store