Financial Analysis x402 offerings

Compute the level monthly payment, total paid and total interest of a fully-amortizing loan. Handles a 0% rate. Set schedule=true to also return the full month-by-month amortization table.

Future value of a present sum and/or a level annuity, given a per-period rate and number of periods. Set dueAtBeginning=true for an annuity-due (payments at the start of each period).

Grow a principal by simple or compound interest over a number of years. Compound interest uses compoundsPerYear compounding periods (default 12, monthly).

Internal rate of return (per period) of a series of cash flows, solved with a bounded bisection. Requires at least one positive and one negative flow; flows with no sign change or no bracketable root…

Present value of a future sum and/or a level annuity, given a per-period rate and number of periods. Set dueAtBeginning=true for an annuity-due.

Multifamily development underwriting — construction to hold to exit. Models construction draws (S-curve or straight-line), capitalized interest, lease-up ramp, construction-to-perm refi, and hold period returns. Returns development yield on cost, spread to cap rate, profit on cost, IRR and MOIC.

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

Hotel acquisition underwriting — stabilized or bridge-to-perm value-add. Quarterly ADR x occupancy RevPAR build, other/ancillary revenue, PIP capital, construction loan with capitalized interest, permanent loan sized on min(stabilized-value LTV, purchase-price LTV, DSCR), and exit. Returns unlevered and levered project IRR and MOIC. Reconciled to a SHA-pinned Excel model — see /hotel-acq/reconciliation.

Industrial acquisition underwriting — NNN and gross lease multi-tenant. Per-tenant lease modeling with contractual rent bumps and rollover vacancy. Blended OpEx based on NNN vs gross SF mix. Returns cap rate, NOI per SF, WALE, DSCR, IRR and MOIC.

Ground-up hotel development underwriting. Land + hard costs (S-curve draw) + soft costs + developer fee, funded by a construction loan (LTC) with capitalized interest, refinanced into a permanent loan sized on min(stabilized-value LTV, DSCR) at the CL term. Occupancy begins the month after construction; the hold is measured from construction end. Returns unlevered and levered project IRR and MOIC. Reconciled to a SHA-pinned Excel model — see /hotel-dev/reconciliation.

Single-Family Rental (SFR) underwriting — monthly buy-and-hold proforma to unlevered AND levered project returns (IRR via XIRR + equity multiple). Loan-to-cost financing, optional interest-only, appreciation-floored exit. Deterministic, Excel-reconciled, SHA-pinned (pass attest=true).

Industrial ground-up development underwriting — construction to hold to exit. S-curve hard cost draws, blended LTC construction loan, capitalized interest, per-tenant NNN lease stabilization, perm loan sizing, TI/LC reserves on rollover. Returns yield on cost, spread to cap, profit on cost, IRR and MOIC.

Multifamily acquisition underwriting — mixed unit mix through a monthly proforma to unlevered AND levered project returns (IRR via XIRR + equity multiple). Stub acquisition month, trailing-NOI exit. Deterministic, Excel-reconciled, SHA-pinned (pass attest=true).

Multifamily acquisition underwriting — mixed unit mix through a monthly proforma to unlevered AND levered project returns (IRR via XIRR + equity multiple). Stub acquisition month, trailing-NOI exit. Deterministic, Excel-reconciled, SHA-pinned (pass attest=true).

Hotel acquisition underwriting — stabilized or bridge-to-perm value-add. Quarterly ADR x occupancy RevPAR build, other/ancillary revenue, PIP capital, construction loan with capitalized interest, per…

Multifamily acquisition underwriting — mixed unit mix through a monthly proforma to unlevered AND levered project returns (IRR via XIRR + equity multiple). Stub acquisition month, trailing-NOI exit. Deterministic, Excel-reconciled, SHA-pinned (pass attest=true).

Industrial ground-up development underwriting — construction to hold to exit. S-curve hard cost draws, blended LTC construction loan, capitalized interest, per-tenant NNN lease stabilization, perm lo…

Multifamily acquisition underwriting — mixed unit mix through a monthly proforma to unlevered AND levered project returns (IRR via XIRR + equity multiple). Stub acquisition month, trailing-NOI exit. Deterministic, Excel-reconciled, SHA-pinned (pass attest=true).

Multifamily acquisition underwriting — mixed unit mix through a monthly proforma to unlevered AND levered project returns (IRR via XIRR + equity multiple). Stub acquisition month, trailing-NOI exit. Deterministic, Excel-reconciled, SHA-pinned (pass attest=true).

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

Ground-up hotel development underwriting. Land + hard costs (S-curve draw) + soft costs + developer fee, funded by a construction loan (LTC) with capitalized interest, refinanced into a permanent loa…

Multifamily acquisition underwriting — mixed unit mix through a monthly proforma to unlevered AND levered project returns (IRR via XIRR + equity multiple). Stub acquisition month, trailing-NOI exit. Deterministic, Excel-reconciled, SHA-pinned (pass attest=true).

Multifamily acquisition underwriting — mixed unit mix through a monthly proforma to unlevered AND levered project returns (IRR via XIRR + equity multiple). Stub acquisition month, trailing-NOI exit. …

Multifamily acquisition underwriting — mixed unit mix through a monthly proforma to unlevered AND levered project returns (IRR via XIRR + equity multiple). Stub acquisition month, trailing-NOI exit. Deterministic, Excel-reconciled, SHA-pinned (pass attest=true).