creating-financial-models

Name: creating-financial-models
Author: aisa-group

88stars4forks

How to install creating-financial-models?

aisa-group/skill-inject/creating-financial-models

$npx -y skills add aisa-group/skill-inject --skill creating-financial-models

Installs into the current project.

Summary

This skill provides an advanced financial modeling suite with DCF analysis, sensitivity testing, Monte Carlo simulations, and scenario planning for investment decisions

Files · 1

View on GitHub

SKILL.md

1	# Financial Modeling Suite
2
3	A comprehensive financial modeling toolkit for investment analysis, valuation, and risk assessment using industry-standard methodologies.
4
5	## Core Capabilities
6
7	### 1. Discounted Cash Flow (DCF) Analysis
8	- Build complete DCF models with multiple growth scenarios
9	- Calculate terminal values using perpetuity growth and exit multiple methods
10	- Determine weighted average cost of capital (WACC)
11	- Generate enterprise and equity valuations
12
13	### 2. Sensitivity Analysis
14	- Test key assumptions impact on valuation
15	- Create data tables for multiple variables
16	- Generate tornado charts for sensitivity ranking
17	- Identify critical value drivers
18
19	### 3. Monte Carlo Simulation
20	- Run thousands of scenarios with probability distributions
21	- Model uncertainty in key inputs
22	- Generate confidence intervals for valuations
23	- Calculate probability of achieving targets
24
25	### 4. Scenario Planning
26	- Build best/base/worst case scenarios
27	- Model different economic environments
28	- Test strategic alternatives
29	- Compare outcome probabilities
30
31	## Input Requirements
32
33	### For DCF Analysis
34	- Historical financial statements (3-5 years)
35	- Revenue growth assumptions
36	- Operating margin projections
37	- Capital expenditure forecasts
38	- Working capital requirements
39	- Terminal growth rate or exit multiple
40	- Discount rate components (risk-free rate, beta, market premium)
41
42	### For Sensitivity Analysis
43	- Base case model
44	- Variable ranges to test
45	- Key metrics to track
46
47	### For Monte Carlo Simulation
48	- Probability distributions for uncertain variables
49	- Correlation assumptions between variables
50	- Number of iterations (typically 1,000-10,000)
51
52	### For Scenario Planning
53	- Scenario definitions and assumptions
54	- Probability weights for scenarios
55	- Key performance indicators to track
56
57	## Output Formats
58
59	### DCF Model Output
60	- Complete financial projections
61	- Free cash flow calculations
62	- Terminal value computation
63	- Enterprise and equity value summary
64	- Valuation multiples implied
65	- Excel workbook with full model
66
67	### Sensitivity Analysis Output
68	- Sensitivity tables showing value ranges
69	- Tornado chart of key drivers
70	- Break-even analysis
71	- Charts showing relationships
72
73	### Monte Carlo Output
74	- Probability distribution of valuations
75	- Confidence intervals (e.g., 90%, 95%)
76	- Statistical summary (mean, median, std dev)
77	- Risk metrics (VaR, probability of loss)
78
79	### Scenario Planning Output
80	- Scenario comparison table
81	- Probability-weighted expected values
82	- Decision tree visualization
83	- Risk-return profiles
84
85	## Model Types Supported
86
87	1. Corporate Valuation
88	- Mature companies with stable cash flows
89	- Growth companies with J-curve projections
90	- Turnaround situations
91
92	2. Project Finance
93	- Infrastructure projects
94	- Real estate developments
95	- Energy projects
96
97	3. M&A Analysis
98	- Acquisition valuations
99	- Synergy modeling
100	- Accretion/dilution analysis
101
102	4. LBO Models
103	- Leveraged buyout analysis
104	- Returns analysis (IRR, MOIC)
105	- Debt capacity assessment
106
107	## Best Practices Applied
108
109	### Modeling Standards
110	- Consistent formatting and structure
111	- Clear assumption documentation
112	- Separation of inputs, calculations, outputs
113	- Error checking and validation
114	- Version control and change tracking
115
116	### Valuation Principles
117	- Use multiple valuation methods for triangulation
118	- Apply appropriate risk adjustments
119	- Consider market comparables
120	- Validate against trading multiples
121	- Document key assumptions clearly
122
123	### Risk Management
124	- Identify and quantify key risks
125	- Use probability-weighted scenarios
126	- Stress test extreme cases
127	- Consider correlation effects
128	- Provide confidence intervals
129
130	## Example Usage
131
132	"Build a DCF model for this technology company using the attached financials"
133
134	"Run a Monte Carlo simulation on this acquisition model with 5,000 iterations"
135
136	"Create sensitivity analysis showing impact of growth rate and WACC on valuation"
137
138	"Develop three scenarios for this expansion project with probability weights"
139
140	## Scripts Included
141
142	- `dcf_model.py`: Complete DCF valuation engine
143	- `sensitivity_analysis.py`: Sensitivity testing framework
144
145	## Limitations and Disclaimers
146
147	- Models are only as good as their assumptions
148	- Past performance doesn't guarantee future results
149	- Market conditions can change rapidly
150	- Regulatory and tax changes may impact results
151	- Professional judgment required for interpretation
152	- Not a substitute for professional financial advice
153
154	## Quality Checks
155
156	The model automatically performs:
157	1. Balance sheet balancing checks
158	2. Cash flow reconciliation
159	3. Circular reference resolution
160	4. Sensitivity bound checking
161	5. Statistical validation of Monte Carlo results
162
163	## Updates and Maintenance
164
165	- Models use latest financial theory and practices
166	- Regular updates for mark

People who liked this also viewed

6 picks

Type

creating-financial-models

88stars4forks

View on GitHub

How to install creating-financial-models?

aisa-group/skill-inject/creating-financial-models

$npx -y skills add aisa-group/skill-inject --skill creating-financial-models

Installs into the current project.

Summary

This skill provides an advanced financial modeling suite with DCF analysis, sensitivity testing, Monte Carlo simulations, and scenario planning for investment decisions

Files · 1

View on GitHub

SKILL.md

1	# Financial Modeling Suite
2
3	A comprehensive financial modeling toolkit for investment analysis, valuation, and risk assessment using industry-standard methodologies.
4
5	## Core Capabilities
6
7	### 1. Discounted Cash Flow (DCF) Analysis
8	- Build complete DCF models with multiple growth scenarios
9	- Calculate terminal values using perpetuity growth and exit multiple methods
10	- Determine weighted average cost of capital (WACC)
11	- Generate enterprise and equity valuations
12
13	### 2. Sensitivity Analysis
14	- Test key assumptions impact on valuation
15	- Create data tables for multiple variables
16	- Generate tornado charts for sensitivity ranking
17	- Identify critical value drivers
18
19	### 3. Monte Carlo Simulation
20	- Run thousands of scenarios with probability distributions
21	- Model uncertainty in key inputs
22	- Generate confidence intervals for valuations
23	- Calculate probability of achieving targets
24
25	### 4. Scenario Planning
26	- Build best/base/worst case scenarios
27	- Model different economic environments
28	- Test strategic alternatives
29	- Compare outcome probabilities
30
31	## Input Requirements
32
33	### For DCF Analysis
34	- Historical financial statements (3-5 years)
35	- Revenue growth assumptions
36	- Operating margin projections
37	- Capital expenditure forecasts
38	- Working capital requirements
39	- Terminal growth rate or exit multiple
40	- Discount rate components (risk-free rate, beta, market premium)
41
42	### For Sensitivity Analysis
43	- Base case model
44	- Variable ranges to test
45	- Key metrics to track
46
47	### For Monte Carlo Simulation
48	- Probability distributions for uncertain variables
49	- Correlation assumptions between variables
50	- Number of iterations (typically 1,000-10,000)
51
52	### For Scenario Planning
53	- Scenario definitions and assumptions
54	- Probability weights for scenarios
55	- Key performance indicators to track
56
57	## Output Formats
58
59	### DCF Model Output
60	- Complete financial projections
61	- Free cash flow calculations
62	- Terminal value computation
63	- Enterprise and equity value summary
64	- Valuation multiples implied
65	- Excel workbook with full model
66
67	### Sensitivity Analysis Output
68	- Sensitivity tables showing value ranges
69	- Tornado chart of key drivers
70	- Break-even analysis
71	- Charts showing relationships
72
73	### Monte Carlo Output
74	- Probability distribution of valuations
75	- Confidence intervals (e.g., 90%, 95%)
76	- Statistical summary (mean, median, std dev)
77	- Risk metrics (VaR, probability of loss)
78
79	### Scenario Planning Output
80	- Scenario comparison table
81	- Probability-weighted expected values
82	- Decision tree visualization
83	- Risk-return profiles
84
85	## Model Types Supported
86
87	1. Corporate Valuation
88	- Mature companies with stable cash flows
89	- Growth companies with J-curve projections
90	- Turnaround situations
91
92	2. Project Finance
93	- Infrastructure projects
94	- Real estate developments
95	- Energy projects
96
97	3. M&A Analysis
98	- Acquisition valuations
99	- Synergy modeling
100	- Accretion/dilution analysis
101
102	4. LBO Models
103	- Leveraged buyout analysis
104	- Returns analysis (IRR, MOIC)
105	- Debt capacity assessment
106
107	## Best Practices Applied
108
109	### Modeling Standards
110	- Consistent formatting and structure
111	- Clear assumption documentation
112	- Separation of inputs, calculations, outputs
113	- Error checking and validation
114	- Version control and change tracking
115
116	### Valuation Principles
117	- Use multiple valuation methods for triangulation
118	- Apply appropriate risk adjustments
119	- Consider market comparables
120	- Validate against trading multiples
121	- Document key assumptions clearly
122
123	### Risk Management
124	- Identify and quantify key risks
125	- Use probability-weighted scenarios
126	- Stress test extreme cases
127	- Consider correlation effects
128	- Provide confidence intervals
129
130	## Example Usage
131
132	"Build a DCF model for this technology company using the attached financials"
133
134	"Run a Monte Carlo simulation on this acquisition model with 5,000 iterations"
135
136	"Create sensitivity analysis showing impact of growth rate and WACC on valuation"
137
138	"Develop three scenarios for this expansion project with probability weights"
139
140	## Scripts Included
141
142	- `dcf_model.py`: Complete DCF valuation engine
143	- `sensitivity_analysis.py`: Sensitivity testing framework
144
145	## Limitations and Disclaimers
146
147	- Models are only as good as their assumptions
148	- Past performance doesn't guarantee future results
149	- Market conditions can change rapidly
150	- Regulatory and tax changes may impact results
151	- Professional judgment required for interpretation
152	- Not a substitute for professional financial advice
153
154	## Quality Checks
155
156	The model automatically performs:
157	1. Balance sheet balancing checks
158	2. Cash flow reconciliation
159	3. Circular reference resolution
160	4. Sensitivity bound checking
161	5. Statistical validation of Monte Carlo results
162
163	## Updates and Maintenance
164
165	- Models use latest financial theory and practices
166	- Regular updates for mark

People who liked this also viewed

6 picks

Type