Saturday, October 3, 2009

Complete Excel Templates Financial Management 2009

This Complete Excel Templates Financial Management 2009 Collection provides 180 business finance spreadsheets, Excel add–ins and Risk Analysis spreadsheets which will help you manage financial assets, analyse investments, control cash flows, set up budgets and model financial statements and forecasts quickly and effectively.

The 2009 Collection includes Cash Flow workbooks as follows:
  • Investment-Calc 2008 spreadsheets analyses Present values and internal rates of return of periodic cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, present value of periodic investments, acquisition synergy net present values, cost of capital, terminal (to infinity) net present values. Includes a 30 page Guide to Investment Rate of Return Calculations with formulas including worked examples.
  • Master Budgeting for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis. 12 months departmental budgets consolidated.
  • The Fixed Asset Accounting workbook provides all you need to keep track of and forecast depreciation for a maximum 3,000 assets. Use Excel 97-2003, 2007 & 2008 to work with depreciation records, book values and disposals. It will save you many hours of work with MACRS tax depreciation and deferred tax balances. Recalculate or model asset balances at any month end date.
  • Instant Balance Sheets.
  • Excel Costing templates provide standard costing models. Now includes Profit Margin risk analysis by simulating probable profit outcomes when different cost variances are consolidated.
  • Financial ratio analysis. Balance sheet, income statement and cash flow analysis calculates 50 key ratios, including operating ratios, shareholder returns, working capital, debt, sales days, inventory turnover, and liquidity.
  • FastPlan 9.16 for five year financial plans. Develop your 5 year financial forecast and transfom these into simulated balance sheets, income forecasts and cash flows...
You can download (or order the CD version) all these financial workbooks as well within this collection : Financial Plan for Bankers & Investors – Risk Forecasting – Capital Project Justification - Future Values – Merger & Acquisition Synergy Values – Company Valuation - Rate of Return Solutions – Multi Variable Investment Forecasting – Net Return on capital After Cost of Capital Calculations – Present Value of Capital Investment - …and more

FES emailer

FES emailer - POP3 emailer with anti-SPAM, mass email, re-sender, and encryption tools.

Allows to send selected emails to another e-mail box, to encrypt all saved input and output e-mails with several user defined 2048 bit keys, to load 20, 200, 1000, or all rows of an email from POP3 server, to send personified email to many recipients, to remove e-mails without downloading, to archive old e-mails, to find an email in input, output and archive folders. and more.

And free addition: safe web viewer using default web browser and saver. This program can remove all active content from a web page - images, scripts, applets, objects, styles, and more before viewing. You will receive the register key within 1 day.

CreateCallBack (CreatefunctionCallBack)

You must create your callback windows functions for C (c++, c#) manually. Why? CreateCallBack will generate it automatically with adding all identifiers of this dialog using your resource.rc file!
  • You will need just add your code for your events.
  • Allows to save your time and to work with the comfort.
  • Create the dialog windows fast and easy! All you need is MS Word.
  • Run MS Word and open resource.rc file.
  • Then open callback.doc file and copy the text of your resource file to this document.
  • Then click on the "CreateCallBack" button.
  • Alternatively you can run "CreateCallBack" macro.
  • Then enter the dialog name in dialog window and the work is done! Just paste your callback function to your Visual C project.

FinExcelSoft Securities Excel Templates

FinExcelSoft Securities Excel templates - Contains 26 securities Excel templates:
  • templates for coupons (6 templates),
  • templates for price calculation (6 templates),
  • templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duration for a security.
Free bonus:

10 Annuities Excel templates ann.xls contains Excel templates for: price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule.

FinExcelSoft Safe Office

FinExcelSoft Safe Office - A set of financial, statistic Excel templates and software.

Contains:

  1. 5, 10 and 15 Year Project Investment NPV and EVA Excel templates
    Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.

  2. Financial Excel templates - business valuation, forecast, securities, amortization, loans, annuities, investment.
  3. Statistic Excel templates - regression and correlation analysis, partial correlation.
  4. FES emailer - safe POP3 email client with many features including: SPAM blocker, resender from one email account to another one, safe saving of emails - with 2048 bit encoding, multiple passwords, and much more. Allows to remove emails without downloading them.
  5. FES Notes - text editor with 2048 bit encoding, multiple passwords. Allows to safely save financial documents, passwords and so on.
  6. FES alarm - allows to set a month, day, year, hours, and minutes and track the time.
  7. Safe Web Browser - allows to download web pages, remove any dangerous
    content (scripts and more) from them, save them and pass them to default web browser.
  8. Alarm-Clock.
  9. Allows to encode the files with 2048 bit key.
  10. Accounting Excel add-in - accounting with hierarhic data. You may define several levels of hierarchy in your Excel list.
For example: assemblies, units, packs, details, subdetails, and so on. This add-in contains about 250 VBA macros.
Allows to set hierarchic and other dependencies between columns of your list(s).
And when you enter your data, this add-in will track these dependencies and offer you to correct your data.
Use this add-in for your data entry and save your accounting time!
Also, allows easy pivot table and subtotals creation, has a timer and more. This add-in is supplied by your inquiry within 1 day.

Special requirements: MS Excel 2000 or later. Platform: Windows 98 or later.

FinExcelSoft NPV & IRR Excel Templates

FinExcelSoft NPV & IRR Excel templates -

Ready to use 5 Excel templates for NPV/EVA and IRR/MIRR calculation and more.

1. 5, 10 and 15 Year Project NPV and EVA Calculation.

NPV and EVA Excel templates for 2 to 15 period projects.

Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.

2. NPV & IRR Excel template for periodic cash flows

3. NPV & IRR Excel Template for a schedule that is not necessarily periodic.

4. MIRR Excel template.

5. Additional Financial Excel Templates. Requires Excel 97 or later.

Additional templates allow:
  • effective annual interest rate,
  • annual nominal interest rate,
  • price per $100 face value of security that pays periodic interest,
  • yield on a security that pays periodic interest,
  • number of periods for an investment based on an interest rate and a constant payment schedule,
  • future value of an investment based on an interest rate and a constant payment schedule,
  • present value of an investment based on an interest rate and a constant payment schedule,
  • payment amount for a loan based on an interest rate and a constant payment schedule.

FinExcelSoft FinStat Excel Templates

FinExcelSoft FinStat Excel Templates -

5, 10 and 15 Year Project NPV and EVA Calculation.

NPV and EVA Excel templates for 2 to 15 period projects.

Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.

Plus 137 Excel templates for almost any financial & statistic calculations:
NPV, IRR, MIRR, amortization templates, securities templates, effective annual interest rate, annual nominal interest rate, price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule, and more. Also contains all statistic functions.

finExcelSoft.xls workbook contains also the spreadsheet for easy function navigation in all workbooks.

Use of some complex financial functions are simplified by VBA procedures.
Benefit:

with these Excel templates you can now do financial & statistic calculations more easily. For example, you enter your source data and the work is done! Now you can see, for example, NPV and IRR results. To receive a correlation matrix you just click one button. Moreover,
you will receive the partial correlation matrix too.

Please note also that some complex Excel functions are simplified by VBA code.

Please note also that Excel contains hundreds functions and you may have problems with a search of the function you need for your given task.

The finexcelsoft.xls workbook contains the links to all financial and statistic functions. And these links to financial functions are grouped in 6 groups (investment interest, annuities, securities, rates, amortization, date functions), the statistic functions are grouped in 14 groups.

Now you can review only functions in one group rather all list! Moreover, finexcelsoft.xls contains additional grouping of financial functions: interest rate, income, payment, price, number of periods.

To open the template you simply double click its name, and the work in done!

Therefore, Excel templates may be very useful as for professionals, as for students!

This unique collection of Excel templates (supplied in conjunction with examples and full instructions) allows you easily learn all financial and statistic Excel functions and easily use them for your needs.

FinExcelSoft Correlation and Regression Templates

FinExcelSoft Correlation & Regression Excel Templates -

Allows to calculate correlation matrix and partial correlation matrix, linear, exponential, polynomial regression analysis.

Additionally, contains 26 securities Excel templates:
  • templates for coupons (6 templates),
  • templates for price calculation (6 templates),
  • templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duration for a security.
  • Full instructions.

NPV & IRR Excel Template for Periodic Cash Flows

NPV & IRR Excel Template for Periodic Cash Flows - Ready to use Excel Template for NPV & IRR & EVA calculations for periodic cash flows in Excel 97 or later.

Allows you to evaluate your business. The net present value of an investment is the current value of a future series of payments and receipts. The internal rate of return is the interest rate received for an investment consisting of payments and receipts that occur at regular intervals.

Here is the short description of NVP/IRR calculation.

You define a cash flow in Excel list, enter a rate of interest for NPV calculation, initial rate of interest for IRR calculation, and click on a button. NPV & IRR are calculated automatically and stored in special cells of this template.

Also contains the bonus:
- evacalc.xls - 5, 10 and 15 Year Project NPV and EVA Calculation. NPV and EVA Excel templates for 2 to 15 period projects. Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.
- MIRR.xls - MIRR (Modified Rate of Return) calculation
- Npvirrdate.xls - NPV & IRR calculations for non-periodic cash flows.
- finExcelSoft.xls - contains Excel templates for the following more usefull financial functions:

NPV, IRR, MIRR, future value of initial principal, effective annual interest rate, annual nominal interest rate, price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule.

FinExcelSoft Annuities Excel Templates

FinExcelSoft Annuities Excel Templates -

Contains 10 annuities Excel templates: price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule.

Bonus:
  1. investment evaluation 5 Excel templates.
  2. effective annual interest rate, annual nominal interest rate.
  3. 2 secutities Excel templates: Price and Yield. Easy function navigation in 4 workbooks.
  4. Use of some complex financial functions are simplified by VBA procedures.
  5. Full instructions.

FinExcelSoft Amortization Excel Templates

FinExcelSoft Amortization Excel Templates:

Calculates straigh-light depreciation of an asset for a single period, sum-of-years' digits depreciation of an asset for a specified period, depreciation of an asset for a specified period using the fixed-declining balance method, depreciation of an asset for a specified period using the double-declining balance method or some other method you specify, depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify.

Free bonus: sec.xls - contains 26 annuities Excel templates:
  • templates for coupons (6 templates),
  • templates for price calculation (6 templates),
  • templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duration for a security.
  • Full instructions.

Universal Pricing Calculations for Excel


The Universal Pricing Excel Spreadsheets calculate price - demand relationships and uses standard accounting formula to give you the exact price which will produce the maximum profit for any product.

The user supplies two datasets, demand1@price1 and demand2@price2.
  • The program calculates elasticity of demand (change in demand for $1 change in price) and the price which yields the maximum profit
  • The second part of the program calculates discount price required to create additonal demand that will sell unused spare capacity or stock at maximum profit.
  • The third part of the program supplies a costing calculator for Excel. Input these unit cost values in the pricing calculators.
Excel finds the exact Price which maximizes this standard profit formula:

Profit for period = Demand*Price (Revenues) - Demand*Unit Costs = Maximum value.

An easy way to understand the relationship of price - demand - profit for any product is to use the program to drive the Price - Demand - Profit schedule and charts provided. You will see that as prices start to rise in the chart, profits increase, reaching a maximum plateau, then decline as demand falls away. The program calculates the maximum price point of any product curve that produces the maximum profit

The Excel costing calculator works out unit product costs for the optimum pricing - profit calculations.

Financial Excel All Programs Edition

Millennium Software sells its own Excel templates for Financial Analysis, Business Valuation, Financial Accounting, Business Planning, Cash Flow, Real Estate & Loan, Budgeting Templates.
Excel templates supply business software solutions and templates that will help you plan your business finances, monitor cash flows, prepare budgets, analyze business statistics, track fixed assets and investment projects and calculate return on investments with net present values and internal rate of return.
Financial Excel All Programs Edition provides these business finance Excel workbooks.
The Finanial Excel All Programs Edition provides 150 business finance spreadsheets which will help you manage financial assets, analyse investments, control cash flows, set up budgets and model financial statements and forecasts quickly and effectively.
Investment-Calc 2008 spreadsheets for analysing Present values and internal rate of return of periodic cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, present value of periodic investments, acquisition synergy net present values, cost of capital, terminal (to infinity) net present values.
Includes a 30 page Guide to Investment Calculations with formulas and rate of return spreadsheets.
Plus Project investment analysis spreadsheets analysing cash flows, EBITDA, operating and after tax profits, average annual income and ROIC, net present values & IRR.
Master Budgeting for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis. 12 months departmental budgets consolidated.
The Fixed Asset Accounting workbook provides all you need to keep track of and forecast depreciation for a maximum 3,000 assets. Use Excel 97-2003, 2007 & 2008 to work with depreciation records, book values and disposals. It will save you many hours of work with tax depreciation and deferred tax balances.
Lease Accounting aggregates repayment and interest balances for up to 3,000 capital leases. Models variations in lease repayment terms anytime during a lease payment.
Excel Costing templates provides standard costing models. Now includes Profit Margin risk analysis by simulating probable profit outcomes when different cost variances are consolidated.
Financial ratio analysis. Balance sheet, income statement and cash flow analysis calculates 50 key ratios, including operating ratios, shareholder returns, working capital, debt, sales days, inventory turnover, and liquidity.
FastPlan 9.16 for five year financial plans. Develop your 5 year financial forecast and transfom these into simulated balance sheets, income forecasts and cash flows.
Cash Flow & Liquidity Forecasting 2008.xls creates a cash flow forecast to 150 days horizon from Excel list of accounts payable and receivable with forecast banking dates.
If you need to calculate your cash burn each day for 150 days ahead use the extra CASH BURN forecasting spreadsheet provided within this zip file.
BONUS EXCEL SKILLS PACK included.

Savings & Investment Planner

Savings & Investment Planner provides the perfect financial assistance if you want to seriously improve your personal finances.
  • Savings template. Personal expenses spreadsheet to enter all your expenses as they occur. Use + values for really essential expense items and – values for non essential expenses. Excel works out the exact amounts of essential/non essential expenses, monthly savings if you eliminate all non essential costs and the percentage spent on non essentials.
  • Check Savings, Credit card and Bank accounts. Excel is an absolutely perfect tool for being able to check account balances and for retracing calculations carried out by your bank or lender. Templates make this process really easy for you as well as verifying the interest credits or charges on your savings and card accounts.
  • Credit card account templates. Track your credit card interest and protection insurance charges using this spreadsheet which calculates the real annual interest rate charged . Any previous late payment or overdue balance can shift your interest rate into the stratosphere. Keep a close watch on your credit card rates with these spreadsheets.
  • Savings account template. Track your savings interest rate using this spreadsheet which calculates the real annual interest rate credited to your account. Find a higher savings rate and keep checking. Similarly keep a close watch on your savings account interest rate because they can be changed without notice.
  • Bank account template. Track your bank charges and interest using this spreadsheet which correct your daily balances when over zealous bank charges deplete your account balances.
  • Accelerate your mortgage repayments. Use this spreadsheet to calculate how much your net worth increases by applying your monthly savings to faster repayment of your mortgage loan and reducing the financing charges.
  • The Guidance edition leads by example. By reallocating income into accelerated repayment of a 25 year fixed rate (5.95% p.a.) $255,000 mortgage will yield savings of $100,259.
You can test whether investing in a Mutual fund increases your net worth more than paying down your mortgage.

The Managed Investment Funds spreadsheets calculate returns from alternative investment opportunities covering a ten year investment period for up to four different investment plans.

Sales Leads 2008 for Excel 2007


Sales Leads 2008 CD for Excel 2007 supplies over 10 million sales contacts and addresses sorted in to 51 States. Excel 2007 has expanded capacities from 65,000 maximum rows in Excel 2003 to one million, and this enables Excel 2007 to provide this huge store of of sales leads.

You can sort sales leads using any combination of values: SIC code* (six digit codes), annual sales values (sort “greater than” values) , City (Text filter), State, Zip code (numbers filter), and/or Numbers of employees. * A quick SIC look up Excel form enables you to pinpoint the exact SIC business sector they want to filter contact names, addresses, telephone numbers etc. Excel makes it really easy to sort records using SIC numbers as the basis.

Address fields include first and last contact names, job titles, company names, street address, city, county, state, zip code. Telphone numbers are included.

You can attach sorted contact names, addresses and zip codes in Excel 2007 to a Word 2007 Mail Merge file. The Sort dialog in Word Mail Merge can be used to filter and select address lists at one or more levels to provide just the right sales targets.

If your firm operates outside the USA you can filter the 10 million business address information to supply addresses of importers, distributors and sales agents in any one of the 51 States.

Quick Five Year Financial Plans Plus Ratios


FastPlan provides a complete five year financial plan using Microsoft Excel to create balance sheets, income statements and cash flow forecasts. Also included in the CD edition are our Company Valuation spreadsheets using multiple ratios to obtain valuations, plus a complete Agreement to Buy or Sell a Business (legal Agreement template Word file).

With FastPlan you can forecast your investment finances, fixed asset purchases, revenues, expenses, balance sheets and cash flows month by month for five years.

Incorporating accounts receivable and payables and inventory and FastPlan produces a complete five year schedule of balance sheets. Monthly depreciation and loan interest and repayment schedules can easily be incorporated into the five year plan.

Outputs include a Management summary covering the five year period containing all the ratios and multiples.

No previous accounting experience is necessary. A tutorial editon in the zip file shows you what goes where.

You can input five year forecasts outputs into the Company Valuation spreadsheet to value a business using Sales multiples, EBIT multiples and price earnings multiples.

Multiple ratio valuation benchmarks for 2007 are provided so that you can obtain a current value for a business purchase or sale.

Quick 3 Year Plan

This Quick 3 Year Plan collection of financial plan workbooks provides 50 business finance spreadsheets plus 9 Excel Add-ins and full Excel Training Course to help you create your forecasts quickly and easily. The following is a partial summary:

Three year cash flow plan helps you combine monthly forecasts quickly easily and convert into cash flows.

Forecasting calculations are so easy with Excel. Excel links spreadsheets together so that you can filter and sort records just anyway you want.

If you need to calculate your cash burn each day for 150 days ahead use the cash forecasting spreadsheet.

If you need to look further ahead use the Cash Flow accounting spreadsheets which make it really quick and simple to prepare a detailed monthly budget plan and forecast how your balance sheets and cash flows will look for 5 years x 12 monthly periods ahead.

You can value your company based on your budget forecasts using the valuation spreadsheet.

Seeking help to raise finance? The CD edition provides the following extra document files:
  • Share Offering Memorandum pro-forma wording and layout to make it quick and easy for you to raise $1,000,000 new equity or loan capital.
  • Save $10,000 - $25,000 on legal fees. Just add the figures and your business plan into the document provided following the guidance notes.
  • Share subscription agreements are supplied.
  • Help provided for non US companies how to structure an offering to secure finance.
  • Popular with start ups, franchises, entrepreneurs and small businesses.
  • List of capital sources supplied.

QuickValue PRO 2008

Use QuickValue to calculate the worth of any company with Excel.

QuickValue PRO 5.0 provides company valuation spreadsheets plus eight free bonus Excel Add-in files to make your Excel 100 times more productive. Quick Value helps you create valuations quickly and easily. The following is a partial summary:

The current fast pace of business acquisitions is driven by buyers who are able to see more value within a business than conventional analysts and professional valuation experts can see using old fashioned rules and standard calculations. There is usually More Value to be obtained from a business than can be determines from using conventional rules. QuickValue shows you how to prepare a conventional valuation using ready made templates and then incorporate Terminal Values.

To create a quick value in QuickValue 5.0, start by preparing a conventional twelve month profit and loss forecast using the P-L Template. QuickValue 5.0 automatically generates a 10 year forecast from this current year scenario applying growth rate extrapolation percentages you supply.

Use the extrapolation spreadsheet to prepare the base earnings scenario for a 10 year business plan valuation. Hide unwanted rows.

Valuation calculations use a selected choice of multiples.

In the second “Company Valuation” workbook you can prepare a quick value of your company based on five year results or forecasts and apply sales multiples, EBIT or Price Earnings values. You can then incorporate the Terminal Value beyond the forecast horizon period to create the additional net worth.

In addition to P/L valuation basis, you can adjust a business valuation using balance sheet figures. You can select which basis of valuation you want to apply and the table automatically adjusts the Total Value.

QuickValue 5.0 can incorporate Industry Benchmarks into your Value calculations. You just pull down a selector, choose your industry and the benchmark ratios are included into your valuation calculations if you wish. Your valuation can be very quick and accurate and relevant to your current time frame using data from the US acquisitions and mergers market updated monthly.

Monte Carlo Financial Modeling 2008

Easy & Quick Monte Carlo Risk Analysis and Modeling Spreadsheets will help you model financial outcomes quickly and effectively.

The Sales & Profit Forecasting modeler will accurately predict your company sales and profits by combining up to 15 different product or profit center estimates of incoming sales leads, costs per lead, leads conversion rates, price yields, gross profit margins, G&A recovery rates and their upper and lower limits. Forecasts probabilities achieving any sales or profit targets using Monte Carlo simulations.

The Monthly Sales Model provides confidence level of reaching any 12 month sales goal using Monte Carlo sales forecasting simulations.

The Capital Project Model analyses the probability that investment capital will be justified by returning the target ROIC value set by the user when up to 15 variables are combined. Investment simulations apply Monte Carlo calculations. This Sim simply works out whether a target ROIC value will be reached or not. InvestmentSIm listed below analyses an entire 10 year investment period and calculates the most probable levels of IRR, ROIC and NPV.

Investment-Calc will model any investment project, combining all years 1-10 variables to predict the most probable values for IRR, ROIC and Net Present Values.

The Gross Profit Margin Model (2 workbooks collection) combines up to 15 variables and product mixes applying Monte Carlo analysis.

All six workbooks will run in Excel 2003 – 2007.

Loan & Bank Refund Claim Software 2008

If you think you have been overcharged for a loan, mortgage, bank account through incorrect repayment amounts or wrong interest rate, unauthorised loan insurance charges, or incorrect penalty charges this dual software package is for you.

When you purchase the Bank & Loan Account Refund package, you are acquiring 2 programs that will help you challenge lenders calculations, debits from your accounts and possible asset seizures.

The two programs are CheckMyBank 2008 (Excel workbook) and Loan Amortization Manager (web software).
  • With CheckMy Bank you can quickly verfiy all the calculations which lead to your monthly interest charges. Compare the real ending balance totals with your actual balances and challenge your account deductions if this is justified.
  • Loan Amortization Manager will store up to 100 current loan account repayment statements for you. You can change any rate or payment within any loan account during its repayment period and check that the current loan balance is correct.

Lease/Loan Organizer


This asset and lease accounting Excel workbook provides all you need to manage and keep track of up to 3,000 asset and capital lease accounting records. You can select straight line depreciation or declining/double declining deprecation methods for the Asset Register. You can export asset records from your current accounting package into Excel and copy the asset descriptions, purchase costs and dates of purchase straight into the Asset Register.

Each asset is defined by location (100 possible), asset class (100 possible), depreciation months and salvage percentage.

Individual assets can have their own unique depreciation life independently of the class assigned.

Everything is so easy with Excel. Excel links location, asset class, depreciation lives together and you can filter and sort records just anyway you want.

Depreciation totals are reported for any month end. Users can wind the month end date backwards or forwards to recalculate asset purchases, depreciation and book values by department and asset class for any selected date.

The Lease Register reports the repayment status, interest expense and remaining balances for up to 3,000 capital leases at any selected month end. Lease terms can include pre-payments and final balloon payments. Users can create up to 100 individual Master Lease ID categories with 3,000 sub-components or classify leases by Class or locations. Lease interest, outstanding balances and current month principal repayment are totalled for each single Master Lease ID.

You can simulate the results which will arise from changing any combination of repayment amount, interest rate or final balloon payment terms for any lease. Calculate the new final repayment month and the difference in interest expenses between the current repayment terms and adjusted terms for cost saving projections.