Financial Analyst
Financial modelling questions
107 questions on Financial modelling for financial analysts, easiest first.
Easy 33
- Reading a revenue varianceeasy
- Break-even volumeeasy
- Reading a cost varianceeasy
- Spotting a variable costeasy
- Totals by region and montheasy
- Locking a cell referenceeasy
- When to use Goal Seekeasy
- Margin of safetyeasy
- Where net income goes nexteasy
- The balance check roweasy
- Adding back depreciationeasy
- Blue and black cellseasy
- A rate typed into a formulaeasy
- Yearly straight-line depreciationeasy
- Receivables went upeasy
- Where capex appearseasy
- Working out gross margineasy
- What EBITDA leaves outeasy
- Sensitivity or scenario analysiseasy
- Repaying loan principaleasy
- GST in the sales figureeasy
- DSO from receivables and revenueeasy
- Building revenue from driverseasy
- What zero-based budgeting iseasy
- Contribution margin ratioeasy
- Cost that jumps in blockseasy
- Annual run-rate of a subscription baseeasy
- Monthly customer churneasy
- Mixing lakh and croreeasy
- How long the cash lastseasy
- Where assumptions should liveeasy
- Budget or forecasteasy
- Checking where a number comes fromeasy
Medium 43
- Retained earnings roll-forwardmedium
- XLOOKUP default behaviourmedium
- Sales needed for a target profitmedium
- Flexing the budget for volumemedium
- Splitting price and volumemedium
- Two-way lookup in a gridmedium
- Using an Excel data tablemedium
- What a 12-month rolling forecast coversmedium
- Markup versus marginmedium
- Forecasting receivablesmedium
- Inventory from inventory daysmedium
- Days of cash tied upmedium
- Cash impact of working capitalmedium
- Depreciation up by ₹10medium
- Rolling the debt schedulemedium
- How much revolver to drawmedium
- PP&E roll-forwardmedium
- Using brought-forward lossesmedium
- Effective rate under 115BAAmedium
- UAE corporate tax on profitmedium
- Weighted average selling pricemedium
- Lookup broke after a new columnmedium
- Model recalculates very slowlymedium
- Switching between scenariosmedium
- Building a monthly timelinemedium
- Wrapping formulas in IFERRORmedium
- Share-based pay in cash flowmedium
- Rent with yearly escalationmedium
- Spreading an annual budgetmedium
- Lifetime value versus acquisition costmedium
- Months to recover CACmedium
- Retention of the starting ARR basemedium
- Splitting a mixed costmedium
- Close the loss-making branchmedium
- Make or buy a componentmedium
- Demand above plant capacitymedium
- Reading a P10 resultmedium
- A plug that forces balancemedium
- Cross-footing a summary tablemedium
- Revenue from one cohortmedium
- A downside that is too kindmedium
- Missing bar in an EBITDA bridgemedium
- Revenue up, profit downmedium
Hard 31
- Operating leverage and EBIThard
- Probability-weighted scenarioshard
- Reading a tornado charthard
- Fixed costs rise, break-even moveshard
- Handling an interest circularityhard
- IRR with irregular dateshard
- Monthly rate from an annual ratehard
- Annual plan billed in Octoberhard
- Out of balance by twice a figurehard
- Gain on selling a machinehard
- Profitable but short of cashhard
- Sizing a cash sweephard
- Revenue for a marketplacehard
- Adjusting EBITDA for one-offshard
- Every cost as a percent of saleshard
- Staff cost with mid-year hireshard
- Rolling months up to yearshard
- Capitalising development costshard
- Receivables in a seasonal businesshard
- Tax depreciation faster than bookhard
- Raising the bad debt provisionhard
- Break-even with two productshard
- Headroom on a DSCR covenanthard
- Volume needed after a price cuthard
- Accepting a low-price orderhard
- Simulation with independent inputshard
- Calculating a mix variancehard
- How much EBITDA becomes cashhard
- Annual churn from monthly churnhard
- Effect of a 2% price risehard
- Drawing power on a cash credit linehard