Real Estate Financial Modeling Analyst

Build financial models that institutional investors rely on.

At Kleinbrook Young LLC, we build bespoke financial models for US private equity firms, developers, debt funds, and family offices. These aren't template models—they're built from the ground up to support real investment decisions on multimillion- and billion-dollar commercial real estate transactions.

We're looking for an experienced Real Estate Financial Modeling Analyst who enjoys solving complex problems, takes pride in building clean, accurate models, and wants to work alongside a high-performing team.

If you can build sophisticated Excel models from scratch and want your work to have a direct impact on institutional real estate investments, we'd love to hear from you.

---

What You'll Do

• Build institutional-quality financial models from a blank workbook
• Model acquisitions, developments, and value-add investments across:

• Multifamily
• Affordable Housing (LIHTC)
• Retail
• Industrial
• Data Centers
• Mixed-Use Developments
• Build JV equity waterfalls, construction debt draws, capitalized interest, refinancing scenarios, and sensitivity analyses
• Audit and improve existing client models
• Follow our documented modeling standards to ensure consistency and quality
• Respond quickly as deal assumptions evolve during active transactions

---

What We're Looking For

Technical Skills

• Expert-level Microsoft Excel
• Able to build monthly cash flow models and multi-tier IRR waterfalls from scratch
• Strong understanding of:

• Levered & Unlevered IRR
• Equity Multiple
• Yield on Cost
• Cap Rate
• DSCR
• Debt Yield
• Loan-to-Cost (LTC)

Experience

• Minimum 2 years in one or more of the following:

• Commercial Real Estate Financial Modeling
• Real Estate Investment or Acquisitions
• Investment Banking
• Private Equity
• Valuation or Transaction Advisory
• Big 4 Real Estate Advisory

Other Requirements

• Excellent written English
• Available for at least 4 hours of overlap with US Central Time (late evening/overnight in the Philippines)
• Reliable internet connection and power backup

We'll teach you our modeling standards and workflows.

We won't teach Excel or real estate finance fundamentals.

---

Why Join Kleinbrook Young?

• Work on real institutional transactions—not practice exercises
• Competitive compensation based on technical ability
• Paid technical assessment
• Paid monthly, on time
• 13th Month Pay
• Paid Time Off
• Performance review after 90 days
• Opportunity to become a senior team member and help train future analysts

---

How to Apply

Applications that do not include every item below will not be considered.

send an email to ----------

Subject

Modeling Analyst — [Your Name]

Include the following:

1. Resume

---

2. Answer These Five Questions

Q1. Total development cost is $60,000,000. Stabilized NOI is $4,200,000. What is the yield on cost? (Answer as a percentage to one decimal.)

Q2. Market cap rate for that asset is 5.25%. What is the development spread, in basis points?

Q3. An investor puts in $10,000,000 of equity and receives $18,000,000 back over the hold. What is the equity multiple? (Answer as a multiple to two decimals.)

Q4. NOI is $4,200,000. Annual debt service is $3,000,000. What is the DSCR? (Two decimals.)

Q5. Your construction interest calculation depends on the loan balance, and the loan balance depends on the construction interest. Excel returns a circular reference error. Name the one Excel setting you enable to resolve it.

---

3. Short Written Response

In 150 words or fewer, using the deal from Q1 and Q2:

The sponsor asks, "Does this deal work?"

What three additional pieces of information would you need before answering?

---

4. 90-Second Video

Share a Loom or similar screen recording showing a financial model you've built.

Please:

• Remove confidential information
• Walk through one calculation you're particularly proud of
• Explain your thinking

Professional production quality isn't important—we're interested in how you approach modeling.

---

5. Availability

Include one sentence confirming your availability for at least 4 hours of overlap with US Central Time.

---

Hiring Process

1. Application Review
2. Paid Technical Assessment (4–6 hours, paid at the full role rate whether or not an offer is made)
3. Live Screen Share (we'll modify assumptions and observe your modeling process)
4. Offer