Lease Payment Period Balance
Analyze by Date: Payment Due Date
| Measure | Source and/or calculation |
|---|---|
| Discount Rate | Lease.Discount Rate |
| Interest Rate | Lease.Interest Rate |
| Lease Payment Period Balance | LeasePaymentPeriodBalance |
| Lease Payment Period Balance Count | COUNT of Period Balance for each lease key |
| Lease Term | Lease.Lease Term |
| Period Balance Base Currency Rate | Lease.Base Currency Rate |
| Period Balance Base Interest Amount | InterestAmount |
| Period Balance Base Lease Expense | LeaseExpense |
| Period Balance Base Liability Balance | LiabilityBalance |
| Period Balance Base Payment Amount | Amount |
| Period Balance Base Principal Amount | PrincipalAmount |
| Period Balance Base ROU Balance | ROUBalance |
| Period Balance Base ROU Reduction | ROUReduction |
| Period Balance Base Running Payment Amount | SUM of LeasePaymentPeriodBalance.Amount for all period for each lease key |
| Period Balance Count Payment Amount | COUNT of LeasePaymentPeriodBalance.Amount |
| Period Balance Finance Lease Cost |
IF Lease.LeaseClassification = Finance THEN ROUReduction + InterestAmount ELSE 0 Note:
IF ROUReduction <> NULL THEN ROUReduction ELSE 0.00 IF InterestAmount <> NULL THEN InterestAmount ELSE 0.00 |
| Period Balance Interest Tax Amount | InterestTaxAmount |
| Period Balance Operating Lease Cost |
IF Lease.LeaseClassification = Operating AND Lease.LongTermOperatingLease OR AdoptedLongTermOperatingLease = true THEN LeaseExpense ELSE 0 |
| Period Balance Payment Number | PaymentNumber |
| Period Balance Principal Tax Amount | PrincipalTaxAmount |
| Period Balance Remaining Base Liability Balance | MAX(LiabilityBalance) |
| Period Balance Remaining Payment Amount | PeriodBalanceRemainingPaymentAmount = SUM of LeasePaymentPeriodBalanceAmount for all periods for each lease key |
| Period Balance Remaining Payment Amounts |
Period Balance Remaining Payment Amounts = 1st period of lease: Sum Period Balance Running Payment Amount Succeeding periods = Period Balance Total Payment Amount + Lease Payment Period Balance Amount |
| Period Balance Remaining Payment Months | Period Balance Remaining Payment Months = SUM Count of Period Per Lease |
| Period Balance Running Interest Amount | SUM of InterestAmount for all period for each lease key |
| Period Balance Running Lease Expense | SUM of LeaseExpense for all period for each lease key |
| Period Balance Running Principal Amount | SUM of PrincipalAmount for all period for each lease key |
| Period Balance Running ROU Balance | SUM of ROUBalance for all period for each lease key |
| Period Balance Running ROU Reduction | SUM of ROUReduction for all period for each lease key |
| Period Balance Straight Line Amount | LeasePayment.StraightLineAmount |
| Period Balance Total Interest Amount | SUM(Interest Amount) |
| Period Balance Total Liability Balance | SUM(LiabilityBalance) |
| Period Balance Total Non Exec Payment Amount | LeasePayment.TotalNonExecPaymentAmount |
| Period Balance Total Non Exec Payment Count | LeasePayment.TotalNonExecPaymentCount |
| Period Balance Total Payment Amount | LeasePayment.TotalPaymentAmounts |
| Period Balance Total Payment Amounts | SUM(Amount) |
| Period Balance Total Principal Amount | SUM(PrincipalAmount) |
| Period Balance Total ROU Balance | SUM(ROUBalance) |
| Period Balance Total ROU Reduction | SUM(ROUReduction) |