Financial Modelling Frameworks & Excel Best Practices - Day 1 Analyst Survival Guide
If Finance Case Studies for Placement Interviews trained you to structure business problems, this reference guide trains you to survive the first week on a finance desk. Day 1 at Goldman Sachs, Kotak IB, or any buy-side desk, you will be expected to navigate Excel and Bloomberg at speed. This lesson gives you the shortcuts, Bloomberg commands, and fast comparable company analysis workflow that working analysts use daily.
- Financial modelling speed comes from muscle memory: edit with F2, lock references with F4, audit formulas with Ctrl + `, and move across model tabs with Ctrl + Page Up/Down.
- A clean model typically moves across Income Statement (IS), Balance Sheet (BS), Cash Flow Statement (CFS), Discounted Cash Flow (DCF), and comparable company analysis, also called comps.
- Bloomberg Terminal is the primary research tool at investment banks, asset managers, and hedge funds in India, so commands like FA, COMP, BQ, DES, NI, and BI matter from Day 1.
- Comparable company analysis uses peer multiples such as Price to Earnings (P/E), Price to Book (P/B), Enterprise Value to EBITDA (EV/EBITDA), Dividend Yield, Return on Equity (ROE), and Net Interest Margin (NIM) for banks.
- The Bloomberg comps workflow can build an Indian private banks peer table for HDFC Bank, ICICI Bank, Axis Bank, Kotak Bank, and IndusInd Bank in under 10 minutes.
- Exporting through Bloomberg Query Tool (BQ) and using the `=BDH()` formula turns a manual table into a live, auto-refreshing Excel output.
Think of Day-1 modelling as a three-layer operating system: Excel for model build and audit, Bloomberg for data and research, and a repeatable workflow for turning raw market data into a decision-ready output.
The Day-1 Analyst Operating System
Financial modelling is not only about knowing valuation theory. On an analyst desk, the immediate expectation is that you can move quickly through a workbook, check formulas without damaging links, pull source data, and present a clean output.
The source workflow points to the common model architecture: Income Statement, Balance Sheet, Cash Flow Statement, Discounted Cash Flow, and Comps. A Discounted Cash Flow model values a company using projected cash flows, while comparable company analysis benchmarks valuation multiples against peers. In practice, analysts often move between these sheets continuously, so keyboard navigation and formula hygiene are not optional.
Bloomberg adds the research layer. The terminal supplies company financials, market data, ratings, news, sector research, and Excel downloads. The strongest analysts do not treat Excel and Bloomberg as separate tools - they use Bloomberg to source and refresh data, then Excel to structure, audit, and present the model.
Excel Shortcuts for Financial Modelling
Excel shortcuts matter because financial models are linked, multi-tab, and time-sensitive. A single overwritten formula can break a forecast, while a slow analyst can lose valuable time during a live request. The following shortcuts are directly useful for DCF, comps, model audit, formatting, and presentation.
Some shortcuts are about speed, but the most important ones are about control. `F2` prevents accidental overwrites, `F4` prevents broken references, and `Ctrl + ` exposes formulas so that a model can be audited visually. For interview and placement prep, these shortcuts show that you understand how analysts actually work, not just how valuation is described in theory.
IRR means Internal Rate of Return, a return measure used in investment analysis. XNPV and XIRR are Excel functions used for net present value and internal rate of return when cash flows occur on specific dates. Named ranges are labelled cells or ranges that help analysts jump through large models using Go To.
Bloomberg Terminal Commands Analysts Should Know
Bloomberg Terminal is the primary research tool at every investment bank, asset manager, and hedge fund in India, according to the source material. The working format is simple: type the command and hit the yellow <Go> key. The skill is knowing which command answers which business question.
For example, `FA` helps pull long-run financial statements for ITC, Infosys, and HDFC Bank. `COMP` helps build peer multiple tables. `BQ` connects Bloomberg to Excel using Bloomberg formulas such as `BDH`, `BDS`, and `BDP`, allowing analysts to download and refresh data in bulk.
For acronyms used in these commands, P/E means Price to Earnings, P/B means Price to Book, EV/EBITDA means Enterprise Value to Earnings Before Interest, Tax, Depreciation and Amortisation, ROE means Return on Equity, GNPA means Gross Non-Performing Assets, EPS means Earnings Per Share, and DV01 is a rates risk measure used with swaps. In banking comps, the source specifically notes that NIM, or Net Interest Margin, is used for banks.
Fast Comps Workflow for Indian Private Banks in 5 Steps
The quickest way to connect Bloomberg and Excel is through a trading comps table. The source example sets a clear goal: build a trading comps table for Indian private banks in under 10 minutes on Bloomberg. The anchor company is HDFC Bank, and Bloomberg suggests peers including ICICI Bank, Axis Bank, Kotak Bank, and IndusInd Bank.
The result is a live, auto-updating trading comps table. The source states that this output would take 2-3 hours to build manually, which is why this workflow is a true Day-1 productivity unlock.
Worked Example: Building a Live Private Bank Comps Table
This example is valuable because it mirrors an actual analyst task: define the peer set, select sector-relevant metrics, use consensus estimates, and push the output into Excel. The nuance is that the metric set depends on the business model. For banks, the source explicitly notes using NIM, while other sectors may rely more heavily on multiples such as EV/EBITDA.
Model Hygiene and Audit Habits
Speed without control is risky in financial modelling. The source shortcuts are not random keyboard tricks; they support three hygiene goals - protecting formulas, keeping the workbook navigable, and making the output presentation-ready.
A useful interview-safe framing is: build, audit, refresh, present. Excel handles the build and audit loop. Bloomberg handles the research and refresh loop. Together, they let analysts move from source data to a client-ready or investment-ready output much faster.
Conclusion
Financial modelling frameworks and Excel best practices are Day-1 survival skills because they turn valuation knowledge into desk-ready execution. The core takeaway is simple: practise the shortcuts until they become muscle memory, learn the Bloomberg commands by use case, and apply the 5-step comps workflow until you can build a live peer table without hesitation.
The most frequent error is learning shortcuts as isolated tricks instead of connecting them to modelling tasks. That costs points because analysts are judged on whether they can build, audit, refresh, and present a reliable model under time pressure!