Mastering Financial Modelling - ReadMe
---------------------------------------
This disk contains all the files used in 'Mastering Financial
Modelling'. These are in an Excel 97 format.
Install using the SETUP command as below to install and create
program groups and icons
System Requirements
-------------------
This section summarises the requirements for using the
Application.
1. IBM-compatible personal computer with an 804086 or
higher processor.
2. Hard disk with 20Mb of free space
3. Microsoft Mouse or other compatible pointing device
4. EGA, VGA or compatible display (VGA or higher is
recommended)
5. 32 MB of random access memory.
6. Windows 95 or later.
7. Excel 97 or later.
Installation
------------
1. Insert the CD into your CD-ROM Drive
2. Select the Start button in the bottom left of your screen.
3. Select Run.
4. Write in the space provided: D:\SetUp.exe - then click
on OK. D is your CD-ROM drive: if this is not correct
for your machine then change the letter accordingly.
5. The Application will now install itself. Follow the
instructions on screen to select a destination directory.
6. If you are prompted, then restart Windows.
Accessing your New Applications
-------------------------------
You will see that a program group has been created for you.
The Application will also now appear under Programmes on
the Start Menu.
To access your new application, simply double-click on the
icons in the program group.
Name Key Features
------------------------------------------------------------------------------------------------------------------------------------
Simple_Model Basic investment model - full of errors
Calculator Financial calculator showing interface
Features Simple model with features layered on
Dynamic_Graph Demo of a dynamic graph
Features_Application Completed application incorporating all the features
Investment_Model Layered model to show design and features
PPP_1 Basic templates
PPP_2 Completed cash flows
PPP_3 Formatting, functions, comments, validation, printing
PPP_4 Combo boxes
PPP_5 Scenarios, data tables, documentation, protecting
PPP_6 Final model
Financial_Analysis Credit analysis
Dynamic_Graph_Ratios
Cash_Flow_Statement Calculation of cash flow
Financial_Analysis
Forecast_Trend Forecasts, trends, exponential smoothing,Seasonal decomposition
Financial_Analysis Forecasted statements and analysis
Financial_Analysis Forecasted statements and analysis
Cash_Flow Basic cash flow budget
Cash_Flow_Budget Cash flow budget with actual and variance sheets
Leverage Leverage and operating leverage
Portfolio Portfolio theory
Portfolio CAPM, Growth Model, WACC
Bonds Bond pricing, yield, duration, convexity, portfolio results
Project_Model NPV model
Project_Allocation Allocation using Solver
Project_Model Risk techniques
Depreciation SL. SYD, DB and MACRS methods
Leasing Rentals, lease v. purchase, classification, accounting
Valuation Accounts, Dividends, Market and Free Cash Flow Valuation
Optimisation_LP Linear programming
Optimisation_Margin Linear programming plus data table
Optimisation_Pensions Optimising pension contributions
Decisions Bayer Theorum probabilities model
Risk_Management Forwards, Swaps, FOREX, Futures, Options
Modelling_Checklist Check lists for future use




雷达卡


京公网安备 11010802022788号







