Building the spreadsheet that produces the numbers — the doing half of the finance cluster. Assumes the concepts are already understood (see valuation-project-economics) and that basic Excel mechanics are in place.
Needed across
What you will be able to answer
You inherit a project model from an analyst who has left, and the returns look too good. How do you find out whether to trust it?
Trace the outputs back through the calculations to the assumption cells, which only works if inputs are separated from formulas — a number typed inside a formula is the usual place a model quietly breaks. The specific things worth checking are whether NPV was applied to a range that already includes the period-zero outlay, whether the dates are irregular enough to need XNPV or XIRR instead, and whether the debt schedule's interest actually feeds the cash flow it is supposed to. Rebuilding the check rows so a failed reconciliation is visible is more reliable than reading every formula in the file.
One payment
₹99
The videos are free
Course outline
Concept 1
Concept 1 · How a model is laid out
Concept 2
After: model-structure
F4 locking a reference before the formula is dragged down a column.
Video title and channel appear once unlocked.
Concept 3
After: absolute-relative-references
Revenue, COGS and operating expense built line by line across timeline columns to a net figure.
Video title and channel appear once unlocked.
Concept 4
After: cash-flow-schedule
XIRR on dated cash flows, and the date-formatting caveat that breaks it.
Video title and channel appear once unlocked.
Concept 5
After: absolute-relative-references
XLOOKUP pulling a rate out of a separate table, including what it returns when there is no match.
Video title and channel appear once unlocked.
Concept 6
After: cash-flow-schedule
Mandatory amortisation, revolver drawdowns in a shortfall and repayments in a surplus, all feeding one cash flow.
Video title and channel appear once unlocked.
Concept 7
After: excel-finance-functions
A whole set of input assumptions switched at once rather than retyped.
Video title and channel appear once unlocked.
Concept 8
After: cash-flow-schedule
Trace Precedents and Trace Dependents following a number back to where it came from.
Video title and channel appear once unlocked.
Concept 9
After: model-structure
The colour convention that separates a typed constant from a formula from an external link.
Video title and channel appear once unlocked.
Concept 10
After: debt-schedule, scenarios-and-data-tables, error-checking
A real-estate model assembled from assumptions through operating income and expenses to NOI.
Video title and channel appear once unlocked.
6 candidates did not meet the course criteria.
Advisory on infrastructure projects, PPP structuring, urban finance, and government transaction advisory at Big-4 (Deloitte, KPMG, PwC, EY) and infra-advisory firms — often the highest-paying planning-adjacent private path. Campus-recruited at top schools. Specialisation tags: Infrastructure, Regional.
10 mapped employers
Explore path →Real-estate-focused finance and investment research at REITs, PE/RE funds, and bank/NBFC real-estate desks — where a planner's land-use/feasibility lens is an asset alongside finance skills. Direct entry is realistic mainly with deliberate finance up-skilling, CFA/RICS/valuation exposure, or specialized real-estate education. Specialisation tags: Urban, Housing, Infrastructure.
8 mapped employers
Explore path →