Penaki

Clean rent rolls, verified T-12s and expense spike alerts.

Standardize every unit in the rent roll, annualize T-1, T-3, T-6 and T-12 statements, verify stated NOI and flag unusual monthly expense jumps.

NOI trend

12 months

Annual NOI

$2.40M

Occupancy

94%

Rent per sf

$1.92

Month 8 looks unusualFlagged

Every unit configured and checked for errors.

Standardize floor plans, occupancy, charge codes, renovation status and AMI tiers, and flag missing square footage or zero-rent units.

  • Five-step wizard for floor plans, charges, renovations and AMI
  • Rent efficiency and lease expiration charts
  • Exception alerts for missing SF or $0 rents
  • Editable grid with undo, redo and Excel export

Rent roll · Summary & Details

240 units · 5-step setup complete

Floor planSizeUnitsOccupiedIn-place
Studio450 sf2496%$1,180
1 bed / 1 bath680 sf9695%$1,450
2 bed / 1 bath860 sf4093%$1,690
2 bed / 2 bath980 sf4894%$1,850
3 bed / 2 bath1,200 sf3290%$2,250
Floor Plans · Occupancy · Charges · Renovations · AMIAvg $1,640

Trailing 1, 3, 6 and 12-month T-12 verification.

Annualize revenue and expenses across T-1, T-3, T-6 and T-12 periods and check calculated NOI against the document's stated NOI.

  • T-1, T-3, T-6 and T-12 annualized summary
  • Calculated NOI checked against stated NOI
  • Monthly income, expense and NOI trend chart
  • Mapped to a standard chart of accounts

T-12 operating statement

T-1 · T-3 · T-6 · T-12

T-12 NOI

$2.40M

Expense ratio

42.1%

Doc NOI check

Matched

Rental income$4.20M
Other income$0.31M
Payroll$0.42M
Repairs and maintenanceSpike · Oct$0.24M
Utilities$0.28M
Real estate taxes$0.56M
Property insurance2 spike months$0.21M

Monthly expense spikes flagged automatically.

Months running 20% or more above a category's average are flagged in the T-12 grid and carried onto the model's expense tab.

  • Standard chart of accounts mapping
  • Months 20%+ above average flagged automatically
  • Spike alerts shown next to Year 1 expense assumptions
  • Inline cell editing with instant recalculation

Unusual figures, by month

Trailing 12

Rental income
Other income
Payroll
Repairs
Utilities
Insurance
4 months flagged across 3 linesSeasonal swings ignored

Included with every deal

  1. Standard COA

    Every deal maps to the same categories for clean comparisons.

  2. Quick setup wizard

    Configure floor plans, charges and renovation tiers in minutes.

  3. Inline editing

    Edit any unit or T-12 cell with full undo and redo history.

  4. Excel exports

    Download the cleaned rent roll or T-12 to Excel anytime.