Calculations

LeasePak performs many calculations, some of which depend on customization parameters established with the Portfolio update [U0212]. Calculations which are detailed in this document are:

• Lease Accrual Methods
  
  
  • Precomputed
    • Level Yield
    • Rule of 12/78ths
    • Rule of 12/78ths Half-Month Convention
      
    • Straight Line
      
    • Precomputed Simple Interest
      
      
  • Floating Simple Interest
    
    
  • Interest Bearing Loans
    
    
  • Residual
    
    
  • Operating
    • Straight Line
    • Payments
    • Variable Rate
  
  

• ITC Accrual
  
  

• Notes Payable Accrual Methods
  • Day Calculations
  • Interest Accrual
  • NP Accrual Methods: Principal and Interest (P&I)
  • NP Accrual Methods: Principal plus Interest (P+I)
  • NP Accrual Methods: Interest Only
  
  

• Late Charges
  
  
• Payoff Methods
  
  
• Initial Direct Costs/Revenues
  
  
• Net Present Value
  

• Internal Rate of Return
  • Yield
  • IRR with Residual
  • IRR without Residual
    
    
• Check Digit
  
  
  
• Miscellaneous Calculations
  • Bad Debt
  • Net Investment
  • Unearned Income
  • Capitalized Cost
  • Monthly Rental Income
  • Monthly Rental Depreciation
  • Contract Rate
  • Starting Accrued Principal

Lease Accrual Methods

• Precomputed
  • Level Yield
  • Rule of 12/78ths
  • Rule of 12/78ths Half-Month Convention
    
  • Straight Line
    
  • Precomputed Simple Interest
    
• Floating Simple Interest
  
• Interest Bearing Loans
  
• Residual
  
• Operating
  • Straight Line
  • Payments
  • Variable Rate

The term accrual refers to the process of a monthly recognition of income earned by the leasing company. LeasePak provides many methods of accruing income for the lease. The income recognition method is specified at the lease level when the lease is booked (through the New Lease update [U0101]).

There are three major accrual method types available through LeasePak:

• Precomputed
  This type includes Level or Constant Yield (FASB method), Rule of 12/78ths, Rule of 12/78ths Half Month Convention, and Straight Line. Precomputed interest leases are characterized by the use of contract receivable and unearned income General Ledger accounts. An amortization schedule of income to be earned each month can always be calculated at the start of the lease if a precomputed interest method is used.

• Simple
  This type includes Precomputed Simple, Fixed and Floating interest rates (with level or variable payments) and interest bearing loans. Simple interest leases are generally characterized by the use of the principal General Ledger account. Income can not necessarily be calculated for each month at the start of the lease.

• Operating
  This type includes the straight-line (AOSL, ROSL) payments (AOPM, ROPM), and variable rate (AOVE, ROVE) accrual methods. Operating leases are characterized by the use of the Leased Assets, Accumulated Depreciation, and Operating Income General Ledger accounts. In the straight-line method, an average monthly payment is recorded as income, while in the payments and variable rate methods income is recorded as the payment becomes due. Book depreciation on assets under operating leases is recorded in the General Ledger.

Each accrual method may have payments due in advance or in arrears. If payments are due in advance, the first payment is due on the commencement date of the lease. If payments are due in arrears, the first payment is due one period after the commencement date of the lease. Any accrual method which begins with an A (e.g., AAPR, AR78, etc.) signifies that payments are due in advance. Any accrual method which begins with an R (e.g., RAPR, RR78, etc.) signifies that payments are due in arrears.

An explanation of each of the available accrual methods follows.

Level Yield (FASB Method)

The Level Yield accrual method code list consists of:

• AAPR
• RAPR
• AADA
• RADA

The Level Yield accrual method earns income based on the calculated implicit rate or Internal Rate of Return (IRR) of the lease. The implicit rate is the discount rate that causes the present value at the inception of the lease (using the minimum lease payments and any unguaranteed residual) to be equal to the fair market value of the leased equipment. The fair market value must be reduced by any Investment Tax Credit retained by the lessor.

The implicit rate is calculated using a cash flow which includes:

• Asset acquisition cost
• Initial direct costs:

  Broker fee,
  Documentation fee or calculated amount, and
  The allowance for bad debt (if the parameterization indicates that this element should be included in initial direct costs)

• Security deposit
• Lease payments
• Residual

This cash flow is used to calculate the implicit rate, which is found via a series of complex calculations. In each calculation, the implicit rate is estimated and used to determine the net present value (NPV) of the cash flow. If the NPV is (or is very near) zero, then the estimated implicit rate is the desired rate.

For the AADA/RADA method, a file named tolerance.dat can be added to the user’s data directory which contains the number of basis points which is an allowable variance between the IRR in period 1 of the payment schedule and the IRR in the final period.

This rate is used to calculate earned income. For AAPR/RAPR accrual method, income is calculated twelve times a year. For AADA/RADA method, it is calculated daily.

• Earned income for AAPR/RAPR is calculated as follows:

  NET INVESTMENT * YIELD / 12

  If applicable, this earned income is allocated to the various income participants (lessor, vendor, investor, ITC) on a proportional basis.

• Net investment reduction is calculated as follows:

  PAYMENT AMOUNT
  - EARNED INCOME

• New net investment is calculated as follows:

  OLD NET INVESTMENT
  - NET INVESTMENT REDUCTION

The following is a sample amortization schedule using the AAPR/RAPR Level Yield accrual method (with payments due in advance and in arrears).

Rule Of 12/78ths

The Rule of 12/78ths accrual method code list consists of:

• AR78
• RR78

The Rule of 12/78ths accrual method earns income based upon a proportional method with higher earnings recognized in the earlier stages of the lease. The remaining months in the lease and the current unearned income of the lease are used to compute the monthly earned income:

EARNED INCOME = NUMBER OF REMAINING MONTHS IN LEASE
/ SUM OF THE DIGITS OF REMAINING MONTHS
* CURRENT UNEARNED RENTAL INCOME

The sum of the digits of digits "x" is a simple addition of the numbers from 1 to ‘x’. For example, the sum of the digits of 36 is calculated as follows:

1 + 2 + 3 + . . . + 35 + 36 or, in general,

1 + 2 + 3 + . . . + (x - 1) + x

A formula method for the above calculation is: x * (x + 1) / 2

In essence, a declining percentage of the total income to be earned over the life of the lease is recognized each month. A 12-month lease term, for example, would recognize 12/78ths of the total income in month 1, 11/78ths in month 2, 10/78ths in month 3, and so on. (The first period’s income calculation ration lends its name to this method.) A 36-month lease term would recognize 36/666ths of the total income in month 1, 35/666ths in month 2, 34/666ths in month 3, and so on.

Compared to the Level Yield method, the Rule of 12/78ths method earns income at a faster rate.

Note: The earned income calculation, by virtue of using the remaining months in the lease and the current unearned rental income, automatically compensates for midterm income adjustments in the lease. Midterm income adjustments result from changes in the remaining payment schedule, such as through the Payment Reschedule update [U0104], the Asset Payoff or Termination options of the Payoff update [U0103], and the Asset Add-on update [U0113].

The following is a sample amortization schedule using the Rule of 12/78ths accrual method (with payments due in advance and in arrears).

Rule Of 12/78ths Half Month Convention

The Rule of 12/78ths Half Month Convention accrual method code list consists of:

• AH78
• RH78

The Rule of 12/78ths Half Month Convention accrual method is a variation of the Rule of 12/78ths accrual method. The Half Month Convention does not earn income as fast as the regular Rule of 12/78ths method, however, it may be more representative of income earned on a calendar month basis.

The remaining months in the lease, the original term, and the original unearned income of the lease are used to compute the monthly earned income:

EARNED INCOME =
(NUMBER OF REMAINING MONTHS IN LEASE)²
/ TERM * (TERM + 1)
* ORIGINAL UNEARNED RENTAL INCOME

Compared to the Rule of 12/78ths method, the Half Month Convention method produces a smaller income accrual in the first month and larger income accruals in the succeeding months. Also, the recognition of income is spread over an additional accrual period (the lease maturity month). The remaining net investment is less than the residual in the month before maturity. A side-by-side comparison of the Rule of 12/78ths and the Rule of 12/ 78ths Half Month Convention methods follows:

It should be noted that the calculation of income each month is based upon a specific fraction of a constant original unearned income amount (where, over the life of the lease, 100% of the original unearned income is recognized as income). However, midpoint changes in the lease, such as through the Asset Add-on update [U0113], the Asset Payoff or Termination option of the Payoff update [U0103], or the Payment Reschedule update [U0104], adjust the original unearned income amount. Income accruals (continuing under the Half Month Convention) subsequent to a midpoint lease change do not smoothly amortize the remaining unearned.

Using the same information as the previous example to illustrate this point, assume an asset is added onto the lease after the 6/96 accrual, increasing the current unearned by $10.00. The following table shows the original Rule of 12/78ths Half Month Convention amortization and the amortization following the $10.00 adjustment in unearned income. Notice the fluctuation in income under the ADJUSTMENT amortization in 7/96.

NOTE: The numbers enclosed by grey area in the preceding example are for comparison purposes.

To approximate a correction for this problem, the accrual method will automatically switch from the Rule of 12/78ths Half Month Convention method to the Rule of 12/78ths method when the original unearned income amount is changed through the Asset Add-on update [U0113], the Asset Payoff or Termination options of the Payoff update [U0103], or the Payment Reschedule update [U0104].

Again using the same information as before, the following accrual will result. Notice that the income now smoothly amortizes over the remaining period.

Straight Line

The Straight Line accrual method code list consists of:

• ASTR
• RSTR

The Straight Line accrual method earns income in equal increments over the term of the lease. Each month’s earned income is calculated as follows:

EARNED INCOME = ORIGINAL UNEARNED INCOME / TERM

The following is a sample amortization schedule using the Straight Line accrual method (with payments due in advance and in arrears).

Precomputed Simple

The Precomputed Simple accrual method code list consists of:

• APX0, APX5
• RPX0, RPX5

The Precomputed Simple accrual method earns income based upon a fixed interest rate applied against the outstanding balance of the lease using a 360 or 365 day basis. The 360 day basis uses 12 equal months of 30 days. The 365 day basis uses the actual number of days in the month and a 365 day year. Under all methods, lease payments are assumed to be received on their payment due dates (therefore, there are no variations of income accrued due to the early or late receipt of the payment).

Using a 360 day basis (30 day months), income is calculated as follows:

PRINCIPAL BALANCE * INTEREST RATE / 12

Using a 365 day basis, income is calculated as follows:

PRINCIPAL BALANCE * INTEREST RATE * ACTUAL NUMBER OF DAYS IN MONTH / 365

The outstanding balance of the lease assumes that lease payments are received on their payment due dates. That is, income calculations are not based upon the day that the lease payments are actually received. Therefore, the interest to be earned each month can actually be predicted, hence the term ‘precomputed’.

The Principal Outstanding General Ledger account is used for this method. Contract Receivable and Unearned Income are not used.

The following is a sample amortization schedule using the Precomputed Simple accrual method.

Floating Simple Interest

• VT Method
• LT Method
• VL Method
• VV Method

The Floating Simple Interest accrual method code list consists of:

• RVT0, RVT5
• RLT0, RLT5
• AVL0, AVL5, AVL6
• RVL0, RVL5, RVL6
• AVV0, AVV5, AVV6, AVVE
• RVV0, RVV5, RVV6, RVVE

Floating simple interest leases may have fixed or variable payments and may be based upon a 360, 365, or actual day year. Under all methods, lease payments are assumed to be received on their payment due dates (therefore, there are no variations of income accrued due to the early or late receipt of the payment). The base interest rate may vary with any rate on the Base Rate (DRPR) file. The contract rate entered for the lease (through the Book Lease option of the New Lease update [U0101]) represents the percentage over the base rate specified (e.g., entering 2% for the lease indicates that the interest rate should be 200 basis points over the floating base rate specified for the lease).

The VT Method

There are several floating rate methods available. The following sections describe each method.

The VT method is characterized by variable payment amounts (Variable payment floaT), which consist of principal plus interest. The amount of the principal portion of the payment is specified through the lease’s payment schedule. Interest is calculated by LeasePak (in arrears). Interest is neither calculated, accrued nor billed until the due date at the end of the billing period.

This method accrues interest differently from all other methods. It does not accrue payments until their due dates (i.e., behaves as though ACCRUAL DEFERRAL DAYS is set to 31). Thus interest calculation is truly in arrears. All base rates for the period are known when interest is calculated, so no interest adjustment is ever necessary.

The interest rate is calculated by:

SUM OF (ADD-ON RATE + BASE RATE FOR EACH DAY OF THE MONTH) / 360 OR 365

Notice that if the 360 day method is used then base rate is calculated using the actual number of days in the month divided by 360, rather than assuming equal 30 day months. The interest amount, then, is calculated as follows:

INTEREST RATE * PRINCIPAL BALANCE

The Principal Outstanding General Ledger account is used for this method. Contract Receivable and Unearned Income are not used.

Step and interest-only payments may be entered for this method. Interest- only payments are entered by specifying a zero principal amount in the payment schedule.

The following is a sample amortization schedule using the VT simple interest floating rate accrual method. The actual interest rate shown in the schedule consists of the base rate plus the add-on rate.

The LT Method

This method is characterized by level (or fixed) payment amounts (Level payments floaT), which, like the VT method, consist of principal plus interest. Recall, however, that the VT method adjusts the total amount due (principal plus interest) of each payment. The LT method, in contrast, holds any variations in interest (because of fluctuations in the base rate) until the end of the lease. Midterm adjustments, however, may be made at any time to an LT lease to collect interest shortages (base rate increased) or to refund interest overages (base rate decreased).

The interest rate is calculated by LeasePak (in arrears) using the same calculation as described for the VT method. Accrual takes place on the payment due date, not before.

The amount of the fixed payment is entered into the lease’s payment schedule. This is the amount due each period. At the end of the lease, the last payment is adjusted for variations in interest. If the base rate substantially falls from the original rate, it might be possible for the lease to terminate early. This condition is automatically checked during the accrual process.

Based upon the payment schedule entered, a scheduled interest rate can be determined. The principal balance is reduced on this scheduled basis. Any adjustments because of base rate fluctuations are stored in a Principal Receivable account. Principal receivable may be positive or negative and is included in the interest calculation.

The actual interest amount, then, is calculated as follows:

INTEREST RATE * (PRINCIPAL BALANCE + PRINCIPAL RECEIVABLE)

The Principal Outstanding General Ledger account is used for this method. Contract Receivable and Unearned Income are not used.

Step and skip payments may be entered for this method.

The following is a sample amortization schedule using the LT simple interest floating rate accrual method. The actual interest rate shown in the schedule consists of the base rate plus the add-on rate.

The VL Method

This method is characterized by variable payment amounts, which consist of a level principal amount plus calculated interest (Variable payment, Level principal). The amount of the principal portion of the payment is specified through the lease’s payment schedule. The interest is calculated by LeasePak (in advance). Since income is calculated in advance using estimated base rates, an interest adjustment is automatically performed during the next period’s accrual, if required. Also, interest may be calculated based upon a 360, 365, or actual day year.

Contract Receivable and Unearned Income General Ledger accounts are used for this method. Principal Outstanding is not used. Both the contract receivable and the unearned income original amounts are estimated at the start of the lease, based upon the base rate at lease commencement (and, assuming that there are no changes to that rate throughout the lease life).

Step, skip, and interest-only payments may be entered for this method. Interest-only payments are entered by specifying a zero principal amount in the payment schedule. Skip and non-monthly payments result in the storage of the accrued but not yet due income in the Income Receivable account; this amount is used in the next period’s income calculation (i.e., it is capitalized).

The following is a sample amortization schedule using the VL simple interest floating rate accrual method. The actual interest rate shown in the schedule consists of the base rate plus the add-on rate.

The VV Method

This method is characterized by variable payment amounts, which consist of a variable principal amount plus calculated interest (Variable payment, Variable principal). The entire lease payment amount which yields the agreed upon rate is entered into the payment schedule for the lease. The interest is calculated by LeasePak (in advance). Since income is calculated in advance using estimated base rates, an interest adjustment is automatically performed during the next period’s accrual, if required. Also, income may be calculated based upon a 360, 365, actual day, or 30 day month/360 day year.

The actual lease payment is the amortized principal portion of the agreed upon (or, initial) payment schedule plus the actual interest calculated. Therefore, the lease payment entered in the payment schedule may not necessarily be the actual payment amount accrued and invoiced. The difference results from variances in the base rate.

Contract Receivable and Unearned Income General Ledger accounts are used for this method. Principal Outstanding is not used. Both the contract receivable and the unearned income original amounts are estimated at the start of the lease, based upon the base rate at lease commencement (and, assuming that there are no changes to that rate throughout the lease life).

Step, skip, and interest-only payments may be entered for this method. Interest-only payments are entered by specifying a zero principal amount in the payment schedule. Skip and non-monthly payments result in the storage of the accrued but not yet due income in the Income Receivable account; this amount is used in the next period’s income calculation (i.e., it is capitalized).

The following is a sample amortization schedule using the VV simple interest floating rate accrual method. The actual interest rate shown in the schedule consists of the base rate plus the add-on rate.

Interest Bearing Loans

• Day Calculations
• Interest Accrual
  
  
• IBL Accrual Methods: Principal plus Interest (P+I), Fixed Rate
• IBL Accrual Methods: Principal and Interest (P&I), Fixed Rate
• IBL Accrual Methods: Principal plus Interest (P+I), Floating Rate
• IBL Accrual Methods: Principal and Interest (P&I), Floating Rate
  
  
• Capitalized Daily Interest

The Interest Bearing Loan enhancement provides actual daily balance outstanding interest calculations under both fixed and floating rate methods. These methods differ from other LeasePak simple interest accrual methods in that adjustments to earned interest are made due to early or late receipt of payment.

Two repayment plans are available:

• Principal plus Interest (P+I)
  This plan calls for the periodic repayment of a specified principal amount plus accrued interest. The payment schedule consists of the principal portion of the payment only. Billing includes the scheduled principal amount, accrued interest, and previous unpaid invoices. Late payment results in increased interest which is billed on the next invoice accrued after the interest increase is calculated.

• Principal and Interest (P&I)
  This plan calls for the periodic repayment of scheduled (fixed) amounts, as stated in the promissory note. The payment schedule includes both principal and interest. Billing includes the scheduled (fixed) payment amount and previous unpaid invoices. Although the payment amount is fixed, the interest accrued is still adjusted due to early or late receipt of the payment. Therefore, under this method, the amount of the reduction of the principal balance is the variable factor. Accordingly, the final payment is the remaining unpaid principal balance plus accrued interest. It may be different from the scheduled last payment because of the variable principal reduction.

Generally, late charges need not be calculated, as additional interest is charged automatically if the payment is not made on its due date. However, some Interest Bearing Loans are written which allow the assessment of late charges.

For P&I methods, during the process of applying a payment interest is recalculated. For P+I methods, any recalculated interest amount greater than the billed interest amount is billed on the next invoice. Principal and interest payments must be applied in most delinquent due order. Payment reversals must be made in most recent due order.

Prepayments may be applied as credit memos or principal paydowns, or entered into suspense. Overpayment of interest may be applied as an interest credit and will be automatically applied the next time interest is billed. Interest credits are always applied to interest, never to principal.

Day Calculations

For each of the four IBL accrual methods (xIXx, xIFx, xAXx and xAFx), two basic day calculations are available: actual and 30-day months. Under the actual days method, all actual days elapsed are counted, including the 31st of appropriate months and the 29th of February in leap years. For example:

The actual days method may be based upon a 360, 365, or 366 day year.

Under the 30-day months method, every month is considered to have 30 days (and the total number of days in the year is always 360). No interest is charged on the 31st of any month; a payment received on the 31st is treated as if it were received on the 30th. There are always five days between the 27th of one month and the 2nd of the next month, regardless of the two months in question. There are three days from February 28 to March 1. On leap years, there are two days from February 29 to March 1.

Interest Accrual

Interest accruals are always calculated in advance of the payment due. Interest is not charged on the day a loan starts, but is charged on the day it is paid off. Accordingly, normal monthly interest accruals accrue from the previous month’s payment due day + 1 day to the current month’s payment due day. Interest adjustments are made, as necessary, when the payment is actually received or when the next accrual occurs, whichever happens first.

Since interest accruals are performed in advance, certain assumptions must be made. These assumptions are based upon projected information. For example, assume that the current date is January 1, and that the payment due February 1 is to be accrued. The accrued interest is calculated assuming that the February 1 payment will be paid on February 1. In other words, the

accrued interest is for the period January 2 through February 1, and is calculated based upon the current principal balance outstanding. If the loan is floating on a specified base rate, the interest accrued also assumes that the projected base rates for the January 2 - February 1 period will be the actual rates. If any of these assumptions do not hold true, the interest accrued (on January 1) must be adjusted.The adjustment is added to interest on the next invoice accrued after the adjustment is calculated.

If any portion of interest remains unpaid, the invoice remains open. The full amount invoiced, principal and interest, must be paid before an invoice is closed.

Note: In earlier releases of LeasePak, before version 2.1a, all interest through the effective date of the payment had to be paid before any principal could be paid. Interest adjustments were created for the interest due between the due date and the effective date of the payment. These adjustments would zero the interest on all invoices due between the oldest outstanding invoice and the effective date of the payment, whether or not the entire amount of interest was actually received.

With version 2.1a and above, interest on unpaid principal is calculated and billed the next time a new invoice accrues. Fewer adjustments to previous invoices are necessary. Also with version 2.1a, the entire amount invoiced must be paid before an invoice is closed.

If an interest credit exists, it will be applied automatically against future interest billings. Interest credits are always applied to interest, never to principal.

Fixed Rate Interest Accrual Calculation

Interest is calculated monthly in advance, during the normal accrual process. It is also calculated (or recalculated) each time the principal balance changes (e.g., payments made or reversed, mid-term changes, or payoffs/ terminations).

The interest accrual calculation for fixed rate contracts is as follows:

PRINCIPAL BALANCE * (ANNUAL RATE / DAYS IN YEAR) * DAYS

PRINCIPAL BALANCE is the current principal balance of the loan as shown in the principal balance list.

ANNUAL RATE is the interest rate stated in the loan agreement and entered as the rate during New Lease Booking.

DAYS IN YEAR is the contractual year base stated in the loan agreement and entered as part of the accrual method. It may be fixed at 360, 365, or be the actual number of days in the year (365 or 366).

DAYS is the number of days of the period from the last payment or accrual to the current date. For 30/360 accrual methods, the number of days in the month is fixed at 30. For all other methods, the actual number of days between the begin date to the end date of the accrual period should be used.

Floating Rate Interest Accrual Calculation

Interest is calculated monthly in advance, during the normal accrual process. It is also calculated (or recalculated) each time the principal balance changes (e.g., payments made or reversed, mid-term changes, or payoffs/ terminations).

The following interest accrual calculation for floating rate contracts is performed for each day in the accrual period. This repetition of the interest calculation for each day in the accrual period effectively is performing a daily interest calculation. Therefore, base rate changes during the period are automatically taken into account.

PRINCIPAL BALANCE * (BASE RATE + ADD-ON) / DAYS IN YEAR

PRINCIPAL BALANCE is the current principal balance of the loan as shown in the principal balance list.

BASE RATE is the annual rate on which the loan is floating, as stated in the loan agreement and entered during the New Lease Booking update [U0101]. Loan agreements may have different base rates.

ADD-ON is the number of basis points over or under the BASE RATE, as stated in the loan agreement and entered during the New Lease Booking

[U0101]. BASE RATE + ADD-ON represents the actual interest rate for the loan for the day. A maximum and/or minimum annual rate may be specified for each loan during the New Lease Booking [U0101].

DAYS IN YEAR is the contractual year base stated in the loan agreement and entered as part of the accrual method. It may be fixed at 360, 365, or be the actual number of days in the year (365 or 366).

Interest Bearing Loan Methods: Principal plus Interest (P+I), Fixed Rate

AIX0 Advance; actual over 360

AIX5 Advance; actual over 365

AIX6 Advance; actual over actual

AIXE Advance; 30 over 360

RIX0 Arrears; actual over 360

RIX5 Arrears; actual over 365

RIX6 Arrears; actual over actual

RIXE Arrears; 30 over 360

The scheduled principal amount of the payment only is entered into the payment schedule during New Lease Booking [U0101]. Step, skip, and zero (interest- only) payments are entered as normal. The actual amount due is the scheduled principal amount plus the calculated interest (including the effects of early or late receipt of payments due). No payment – principal or interest –is due for a skip payment.

The following is a sample amortization schedule using Principal plus Interest fixed actual/365 (AIX5) accrual method.

Outstanding Principal Balance	= $10,000
Rate	= 12% (fixed)
Payment Schedule	= 12 principal payments of $833.33(advance)
Commencement	= December 30, 1995

Date	#	Int Rate	Prin Bal	Int	Prin	Pmt Due Date	Pmt Recd Date	Intr Paid	Prin Paid	New Prin Bal
12/95			10,000.00		833.33	12/30	12/30		833.33	9,166.67
01/96	31	12%	9,166.67	93.42	833.33	01/30	01/30	93.42	833.33	8,333.34
02/96	30	12%	8,333.34	79.45	833.33	02/28	02/28	79.45	833.33	7,500.01
03/96	30	12%	7,500.01	73.97	833.33	03/30	03/31	76.44	830.86	6,669.15
04/96	30	12%	6,669.15	65.75	833.33	04/30	04/30	65.75	835.80	5,833.35
05/96	30	12%	5,833.35	57.53	833.33	05/30	05/30	57.53	833.33	5,000.02
06/96	31	12%	5,000.02	50.96	833.33	06/30	06/30	50.96	833.33	4,166.69
07/96	30	12%	4,166.69	41.10	833.33	07/30	07/30	41.10	833.33	3,333.36
08/96	31	12%	3,333.36	33.97	833.33	08/30	08/30	33.97	833.33	2,500.03
09/96	31	12%	2,500.03	25.48	833.33	09/30	09/30	25.48	833.33	1,666.70
10/96	30	12%	1,666.70	16.44	833.33	10/30	10/30	16.44	833.33	833.37
11/96	31	12%	833.37	8.49	833.33	11/30	11/30	8.49	833.33	0
				546.56	10000.00			549.03	10000.00

Interest Bearing Loan Methods: Principal and Interest (P&I), Fixed Rate

AAX0 Advance; actual over 360

AAX5 Advance; actual over 365

AAX6 Advance; actual over actual

AAXE Advance; 30 over 360

RAX0 Arrears; actual over 360

RAX5 Arrears; actual over 365

RAX6 Arrears; actual over actual

RAXE Arrears; 30 over 360

The scheduled full payment amount (principal and interest) is entered into the payment schedule for the lease during New Lease Booking [U0101]. Step and skip payments are entered as normal. No payment – principal or interest – is due for a skip payment. Interest-only payments are not allowed for this method.

The following is a sample amortization schedule using Principal and Interest fixed 30/360 (AAXE) accrual method.

Interest Bearing Loan Methods: Principal plus Interest (P+I), Floating Rate

AIF0 Advance; actual over 360

AIF5 Advance; actual over 365

AIF6 Advance; actual over actual

AIFE Advance; 30 over 360

RIF0 Arrears; actual over 360

RIF5 Arrears; actual over 365

RIF6 Arrears; actual over actual

RIFE Arrears; 30 over 360

The scheduled principal amount of the payment only is entered into the payment schedule during New Lease Booking [U0101]. Step, skip, and zero (interest- only) payments are entered as normal. The actual amount due is the scheduled

principal amount plus the calculated interest (including the effects of early or late receipt of payments due). No payment – principal or interest – is due for a skip payment.

The following is a sample amortization schedule using Principal plus Interest floating actual/actual (RIF6) accrual method.

Interest Bearing Loan Methods: Principal and Interest (P&I), Floating Rate

AAF0 Advance; actual over 360

AAF5 Advance; actual over 365

AAF6 Advance; actual over actual

AAFE Advance; 30 over 360

RAF0 Arrears; actual over 360

RAF5 Arrears; actual over 365

RAF6 Arrears; actual over actual

RAFE Arrears; 30 over 360

The scheduled full payment amount (principal and interest) is entered into the payment schedule for the lease during New Lease Booking [U0101]. Step and skip payments are entered as normal. No payment - principal or interest - is due for a skip payment. Interest-only payments are not allowed for this method.

The following is a sample amortization schedule using Principal and Interest floating actual/360 (RAF0) accrual method.

Date	#	Int Rate	Prin Bal	Int	Prin	Pmt Due Date	Pmt Recd Date	Intr Paid	Prin Paid	New Prin Bal
01/96	31	12.0	10,000.00	103.33	796.67	01/30	01/30	103.33	796.67	9,203.33
02/96	29	12.0	9,203.33	88.97	811.03	02/28	02/28	88.97	811.03	8,392.30
03/96	30	12.0	8,329.03	83.92	816.08	03/30	03/31	86.72	813.28	7,579.02
04/96	30	12.0	7,579.02	75.79	824.21	04/30	04/30	75.79	824.21	6,754.81
05/96	30	12.0	6,754.81	67.55	832.45	05/30	05/30	67.55	832.45	5,922.36
06/96	31	12.5	5,922.36	63.75	836.25	06/30	06/30	63.75	836.25	5,086.11
07/96	30	12.5	5,086.11	52.98	847.02	07/30	07/30	52.98	847.02	4,239.09
08/96	31	12.5	4,239.09	45.63	854.37	08/30	08/30	45.63	854.37	3,384.72
09/96	31	12.5	3,384.72	36.43	863.57	09/30	09/30	36.43	863.57	2,521.15
10/96	30	12.5	2,521.15	26.26	873.74	10/30	10/30	26.26	873.74	1,647.41
11/96	31	12.5	1,647.41	17.73	882.27	11/30	11/30	17.73	882.27	765.14
12/96	30	12.5	765.14	7.97	765.14	12/30	12/30	7.97	765.14	0
				670.31	10002.80			673.11	10000.00

Capitalized Daily Interest

A 1993 JULE Fund enhancement created a switch at the lease level which allows interest to be capitalized during SKIP payments. The switch appears on Book Lease or Application screens only if the accrual type indicates an interest bearing loan. If the switch is set to Y, interest which would normally accrue for a skip period is added to the principal. A principal write-up automatically occurs, effective on the due date of the skip.

Note: As a principal adjustment will be recorded effective one month in the future, no other principal changes may be posted prior to this date. This includes overpayments with a principal write-down component, but not straight payments. If a principal adjustment becomes necessary, accruals must be reversed, the adjustment made, then the loan re-accrued.

Following is a sample amortization schedule using Principal plus Interest floating Actual/365 (AIF5) accrual method. This version uses the interest only option:

The year’s payment schedule calls for 7 monthly interest-only payments and 5 skips. With the CAPITALIZE INTEREST switch set to Y, every other month a principal write-up is performed effective on the payment due date. For example, on 9/1, the 10/1 skip is accrued. Instead of holding the $53.43 and billing it on the 11/1 invoice, a principal write-up will occur and generate the following G/L transactions:

Note: The Lease Income Receivable account applies to both leases and loans; it can either represent lease income or loan interest.

The model amortization will now look like this: