Model Star – Financial Modeling ExcellenceCLICK IMAGE TO VISIT SITEI never knew if the model was doing what it should. Whenever I had to update the model, I had a feeling of dread. Could we really be making important business decisions on the basis of a model nobody really understood?

After Model Star everything changed. I took the inputs from the old model and built a new model from scratch in one afternoon.

                                                                                                      – Daniel Madson

Quick Access Toolbar ★ Navigation and Selection ★ Hyperlinks ★ Fill and Sum data ★ Paste Special ★ Skip Blanks ★ Autofill ★ Conditional Formatting ★ The Developer Tab ★ Formatting Macros ★ The Personal Workbook ★ Deactivate F1 Help ★ Worksheet Setup ★ Print Setup ★ Group Sheets ★ One Formula per Row ★ Dynamic Titles ★ Calculation Blocks ★ Corkscrew Balance Calculation ★ Log Sheet Macro ★ Formula Editing ★ Function Wizard ★ Absolute ★ Relative and Mixed References ★ Copying Formulas with Original Referencing ★ Date Functions ★ Quick Charts ★ Trace Precedents and Dependents ★ Control [ ★ Circular Code ★ Subtraction Calculations ★ The Income Statement ★ Retained Earnings Corkscrew ★ Dividend Calculation ★ The Balance Sheet ★ Balance Sheet Check ★ The Cash Flow Statement ★ Avoid Cash Circularities ★ Changing the Timeline ★ Create Charts ★ Adjust Default Chart Type ★ Financial Modelling Chart Tips ★ Profit KPIs ★ Free Cash Flow ★ (FCF) ★ Payback Period ★ Discounting ★ Weighted Average Cost of Capital (WACC) ★ Net Present Value ★ XNPV ★ XIRR ★ Gearing ★ Liquidity Ratios ★ Benchmarks in the Demonstration Model ★ Debt Service Cover Ratio (DSCR) ★ SUMIF ★ COUNTIF ★ INDEX and MATCH ★ Loan Life Cover Ratio (LLCR) ★ Inputs in the Executive Summary ★ Terminal Value ★ Flags and Masks ★ Counters ★ Partial Period Factor/Fraction ★ Inflation Factors ★ Year Fractions ★ Capital Expenditure ★ Operations ★ Depreciation and Amortisation ★ Allocating Assets ★ Disposing Assets ★ Tax ★ Finance ★ Iteration Macro ★ Amortising Loan Repayment ★ Equal Instalments Loan Repayment ★ Manual Loan Repayment ★ Bullet Loan Repayment ★ Debt Service Reserve Account ★ Maintenance Reserve Account ★ Charting Input Data ★ Protection ★ Switches ★ Form Controls ★ Key Dates ★ Capital Expenditure Inputs ★ Data Tables ★ Scenario Selection Table ★ Full Scenario Input Sheet ★ Expected Value ★ Cash Reconciliation ★ Retained Earnings Reconciliation… Read more…