Financial Analyst

Full amortization schedule with monthly payment breakdown, interest-only periods, and payoff date. Supports fixed-rate, bridge, and interest-only loan structures.

Debt sizing across CRE, private equity, or project finance. Runs every applicable constraint — DSCR, LTV, debt yield, leverage, interest coverage, or LLCR — and sizes to the binding test.

FX-adjusted P&L for cross-border transactions. Splits total return into local currency gain and currency impact — essential for international private equity and real estate deals.

Compute XIRR and MOIC from irregular cash flows with exact dates. Standard for private equity, real estate, and venture return calculations.

Fix-and-flip underwriting — models purchase, rehab, carry costs, and sale to produce net profit, ROI, annualized return, and a GO/NO-GO verdict.

Single-Family Rental (SFR) underwriting — buy-and-hold analysis with annual projections, DSCR, cap rate, CoC return, IRR, MOIC, and exit valuation over a configurable hold period.

DCF valuation with exit multiple or Gordon Growth terminal value. Returns enterprise value, equity value, implied share price, and WACC vs exit multiple sensitivity matrix.

Multifamily acquisition underwriting — supports mixed unit types, produces NOI, cap rate, DSCR, LTV, CoC return, IRR, MOIC, and annual projections with exit valuation.

Monte Carlo simulation with configurable variable distributions and custom formula. Returns P10/P50/P90 percentiles, mean, histogram, and probability of exceeding a target threshold.

Short-Term Rental (STR) underwriting — quarterly ADR and occupancy inputs yield CoC return, IRR, MOIC, NOI, and a GO/NO-GO verdict. Covers Airbnb, VRBO, and vacation rental acquisitions.

LP/GP waterfall distribution across preferred return, GP catch-up, and multiple promote tiers. Returns LP and GP splits, IRR, MOIC, and per-period cash flow allocation.

Full leveraged buyout model — sources and uses, debt schedule with cash sweep, operating model, exit, IRR and MOIC with entry/exit multiple sensitivity tables.