Lease/Loan Organizer 2006 for Excel

Time saving Excel add-in organizes up to 100 lease/loan accounts into combined month end reports.

Calculates and combines current period payments of principal and interest, provides outstanding balances, months remaining, payments remaining and asset book values (S/L or DDB depreciation).

Starting information includes the loan/lease principal, interest rate, repayment months, salvage percent and depreciation years.

Program calculates the monthly repayment, and at each month end the periodic repayment of principal, interest charges, balance c/f and book value c/f.

Consolidates all leases/loans into one overall month end summary report.

Organizes multiple accounts using Excel tables that provides quick and easy look up/drill down any lease/loan account and report current balances. Transforms all accounts into yearly principal and interest payments schedules based on daily interest to a maximum 20 year repayment period.

Includes lease or loan repayment amortization schedules that accrues interest on the daily balance method for a maximum of up to 7,755 days A– over 21 years, with daily accruals of interest/360 days/365 days/366 days.

Each account is created by entering the draw down date, repayment months, principal amount, annual interest rate, depreciation years and residual asset salvage value percent. The program creates the year by year repayment of principal and interest expense schedule for each account whether created in the past or anticipated in the future.

lease_note_organizer.jpg (267308 bytes)

 

Order

Additional Information: Lease/Loan Organizer 2006 for Excel

30-day money-back guarantee!

Buy Online

buy.gif (540 bytes)

$125.00

More Millennium Software

Business & Finance

Material Resources Planning Systems    Accounting  Amortization   Business    Business Plan Automation   Finance 

  Info Managers   Inventory Systems  Bar Code Fonts   Legal    Planners/Schedulers   Presentation Tools

  Project Management   Internet Marketing

Management Systems (  

Contact  Management    Document   Management   Sales Management

Real Estate   Vehicles   Venture Capital

Business Using Mail, Phone, or Email

Publishing     Gem Management    Rental   Repair   Travel  )

  Software for MS Excel (Accounting    Analysis     Budgeting     Calculators    Cars      Charting     Checks      Converters      E-Books     Finance     Forecasting    Employment      Inventory        Investment        Management    Marketing   Planners       Project Management      Quality Control    Schedulers )

Business Software

MS Excel Add-ins, Spreadsheets, Templates

Copyright © Millennium Software All Rights Reserved