Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Lease/Loan Organizer

EXCEL TRAINING / EXCEL DASHBOARD REPORTS

 

Organizes 100 Lease/Loan Accounts Into Combined Month end Reports

Lease/Loan Organizer for Excel

Lease/Loan Organizer 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).

Lease/Loan Organizer 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.

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 – 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.

The download zip file contains a demo/tutorial with easy instructions.

 

Lease/Loan Organizer   $99.00 Secure Payment Options

Special ! Free Choice of Complete Excel Training Course or Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

See Also: Excel Add-ins Index or, All Software



Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft