TSA Glossary Real Estate Finance Terms 1031 ExchangesAbsorption RateAbsorption BasisAdministrative ExpensesAdvertising and PromotionsAll-in-BasisAmortizationAmortization ScheduleAssessed ValueAssignable Square FeetBack of the Envelope AnalysisBad DebtBreak-Even OccupancyBridge LoansBuild to SuitCAM ChargesCap RateCap Rate CompressionCapital ExpensesCapital Gains TaxesCarried InterestCash Flow after Vacancy and ReservesCash on Cash ReturnsCash SweepsCatch-Up ProvisionClosing CostsConcessionsConstruction DebtCore InvestmentsCost ContingencyCost SegregationCredit LossCurrent RentDebt ProceedsDebt ServiceDebt Service Coverage RatioDebt YieldDefeasanceDevelopment SpreadDiscounted Cash FlowDisposition CostsDistribution WaterfallsDrawdownsDue DiligenceEconomic Vacancy RateEffective Gross IncomeEquity MultipleEquity Placement FeeEstoppel CertificateExit AssumptionsExit DateExit FeesExpense RecoveriesFixed Interest RatesFloating Interest RatesForward 12Franchise TaxGeneral Partner ClawbackGeneral VacancyGoing-in Cap RateGross LeaseGross Potential IncomeGross Profit MarginGross Sales ProceedsGross Square FeetGround LeaseHard Cost CurveHard CostsHard-Mini PermHold PeriodHoldbackHUD LoansInterest ExpenseInterest ReservesIRRIRR HurdleLand CostsLand LoanLease ExpirationsLease Up PeriodLeasing CommissionsLevered Cash FlowLoan Origination FeesLTCLTVManagement FeesMarket RentMarket Vacancy RateMezzanine DebtMilage RateMini Perm LoansNet Exit ProceedsNet Operating IncomeNet ProfitNew Sales ProceedsNew Square FootageNon-Operating ExpensesNon-Revenue UnitsOccupancyOperating DeficitOperating Expense RatioOperating ExpensesOpportunistic InvestmentsOther IncomePeak CapitalPermanent DebtPhysical Vacancy RatePreferred ReturnPre-LeasingPrepayment PenaltyProject Management FeesReal Estate DepreciationReal Estate TaxesRefinancingRenewal ProbabilityRent AbatementRank CreditRent EscalationRent RollRepairs and MaintenanceScheduled Base Rental IncomeSenior DebtSensitivity TableSOFRSoft CostsSoft Pay vs. Hard PaySoft-Mini PermSources and Uses of FundsStabilized ReturnsStep RentStructural Square FeetStructural VacancyTax AbatementsTax Increment Financing (TIF)Tenant ImprovementsTrailing 3Triple Net LeaseUnderwritingUnit MixUnlevered Cash FlowUtilitiesValue-Add InvestmentsVariable RentWagesWaterfall Promote SplitsWorking Capital ReleaseYield on Cost Excel Terms Absolute Cell ReferencesClearColor CodingCommentCONCATENATE FunctionConditional FormattingCustom FormattingEFFECTElevator ButtonsEOMONTHExcel ShortcutsFormat PainterFreeze PanesFVGridlinesHiding CellsHLOOKUPIF(AND)IF(ISERROR)INDEX/MATCHIPMTIterative CalculationsLock & HideMAXMINMIRRNested Functions NOMINALNoteNPERNPVNUMBERVALUEOFFSETPMTPMT vs. IPMTProper, Upper, LowerProtect/Lock FormulasPVROUNDROUNDUPSensitivity TablesSheet ReferencesSort DataSUMIF vs. SUMIFSSUMPRODUCTTotal Weighted AverageTransposeTRIMVLOOKUPXIRRXIRR vs. IRRYEAR