Lease/Loan Organizer for Excel 2008

Loans & Lease Organizer will manage up to 100 lease/loan accounts into combined month end reports.

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

Each loan/lease starts with the loan/lease principal, interest rate, repayment months, salvage percent and depreciation years.

Program calculates monthly repayments, the periodic repayment of principal, interest charges, balance c/f and book value c/f.

Organizes multiple accounts using Excel tables to provide 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.

System Requirements

Requires: Excel 97 or later. Web data requires Excel 2000 or later and Windows XP/2000/2003 or later.

Order

Excel Templates - Financial Excel All Programs Complete Edition contains all our Excel templates listed in the table above: financial analysis Excel templates, business valuation, financial accounting, business planning, cash flow, lease/purchase, real estate & loan management, budgeting, business financial plan workbooks, templates and guides, 30 separate add-ins and templates for Excel.

'Complete Excel Templates 2008 Edition' - our most powerful financial product. It contains also our additional products: Excel Add-ins Collection, Complete Excel Training Bible, and 12 months full membership of our Global Business Community Network. Save a total $2,400.

If you have Excel 2007 and want to promote your business, you can purchase the spreadsheets with over 10 million sales contacts and addresses sorted in to 51 States.

You will be able to download the product immediately after ordering! Additionally, you can receive the CD.

30-day money back guarantee!

Excel templates, Spreadsheets