Zixu

Rate $33
Response 1h

$33/h

See Finance tutors

Unfortunately, this tutor is unavailable

Finance

Real Estate Finance: Cap rates, pro formas, DCF, IRR, development cashflows, Excel 101

Finance

Lesson location

- online

About Zixu

I teach real estate finance by moving systematically from first principles to clean, auditable models. I hold a Master of Science in Real Estate Development from Columbia University and a Bachelor of Commerce in Finance and Economics from the University of Toronto. Professionally, I have worked across underwriting, asset management, and development, where I have built pro formas, sized debt, and presented countless investment memoranda. I also serve as co-founder of PropTory, a platform that uses blockchain technology to modernize real-estate transactions and expand access worldwide. My instruction is practical and outcomes-oriented: I clarify core concepts—such as the relationship between capitalization rates and discount rates, and the distinction between unlevered and levered returns—and translate them into Excel models that students can explain confidently in interviews or apply directly to live transactions. I am patient, structured, and direct. Each session concludes with a tangible learning outcome and a clear plan for next steps. I welcome students, career switchers, junior analysts, and investors who want to improve their current understanding of the subjects.

About the lesson

What you’ll master:

1. Core concepts → models: Time value of money, cap rate vs. discount rate, unlevered vs. levered returns → 5-line DCF → full pro-forma with sensitivities.

2. Loans: DSCR/LTV sizing, interest-only vs. amortizing, covenants, refinance math, debt-yield & proceeds waterfalls.

3. Acquisitions: Rent roll normalization, NOI build, T-12 to forward NOI, cap-rate/exit assumptions, value-add plan, IRR/EM hurdles.

4. Development: Sources & uses, draw schedule, interest carry, contingency, lease-up/absorption, stabilization and exit.

Tracks (pick one or mix):

1. Foundations → Modeling (4 lessons)
L1: Cap rate value; build an unlevered DCF; pitfalls (units, annualization).
L2: Full pro-forma (revenues, opex, reserves); simple sensitivity.
L3: Add debt (DSCR/LTV sizing, IO vs. amortizing); levered IRR.
L4: Present a one-page investment memo (assumptions, risks, decision).

2. Loans Deep-Dive (3–4 lessons)
Term sheet anatomy; lender’s view (DSCR, DY, LTV).
Proceeds sizing & refinance underwriting; covenant cases.
Sensitivities (rates, NOI shocks); default and breakeven math.

3. Acquisitions Underwriting (4–5 lessons)
T-12 clean-up, rent roll checks, market vs. in-place.
Value-add plan (CapEx, loss-to-lease, mark-to-market).
Exit cap / hold-period logic; returns & risk commentary.

4. Development Pro-Forma (5–6 lessons)
Land deal & soft/hard cost map; sources/uses.
Draw schedule + monthly interest carry.
Lease-up/absorption model; stabilization test.
Exits (sell vs. refi) & sensitivity dashboard.

Real Estate Finance: Cap rates, pro formas, DCF, IRR, development cashflows, Excel 101

Lesson location

About Zixu

About the lesson

Rates

Rate

Pack rates

online

Other tutors in Finance

Syed

Arbaz

Krishak

Adrienne

Abeer

Andy

Vikrant

Naje

Zammad

Usman

Christian

Konrad

Samuel

Maria

Elena

Yehuda

Frank

Zach

Max

Habib

Real Estate Finance: Cap rates, pro formas, DCF, IRR, development cashflows, Excel 101

Lesson location

About Zixu

About the lesson

Rates

Rate

Pack rates

online

Other tutors in Finance

Syed

Arbaz

Krishak

Adrienne

Abeer

Andy

Vikrant

Naje

Zammad

Usman

Christian

Konrad

Samuel

Maria

Elena

Yehuda

Frank

Zach

Max

Habib

Share

Verified teacher profile

levels

All languages in which the lesson is available

Review

Évaluations

Recommendations

free lessons

Report this posting