The following amortization features are part of Accountant's Helpers interface:

Amortization Schedule Selection

An unlimited number of can be prepared and saved for each client.  Select any of the previously save loan amortizations by clicking on the List tab which will list all schedules for the currently selected client.

A quick loan schedule can be prepared with just the information required for the loan calculation.

 
The following options are available on the loan amortization screen:

• Loan Number - 10 character field.

• Description - 60 character field.

• Compute for Year Length - Loans can be calculated using 365, 364, or 360 days for each annual period.

• Calculate Options - Accountant’s Helper will calculate any of the following providing only one is "unknown".  Payment Amount - Interest Rate - Number of Payments - Principal Amount
  Or there is a "Manual" option where you have all of the above information, but want to generate a loan amortization schedule using Accountant’s Helper.

• Loan Start Date - This is the first day of the loan.  Interest will start accruing on this day.

• Payment Frequency - Interest can be compounded by any the following payment frequencies: Daily, Weekly, Bi-Weekly, Semi-Monthly, Monthly, Bi-Monthly, Quarterly, Semi-Annual, Annual

• First Payment Date - This is the date of the first payment.  If the first payment date does not reflect the Loan Start Date and Payment Frequency, interest will be accrued accordingly for the time between the Loan Start Date and First Payment Date.

• Principal Amount - The amount of the loan.

• Interest Rate - Interest Rate percentage to be used to calculate the loan.

• Payment Amount - The amount to be paid every period determined by the payment frequency.

• # of Payments - The total number of payments to be calculated in the loan.

• Total Interest - This is the total amount of interest paid for the full term of the loan.

• Notes - Any amount of information can be put here to be printed on the amortization schedules.

  Payment Adjustments

An infinite number of payment adjustments can be entered for each loan for any of the following reasons:

• Loan Pay-off

• Balloon Payments

• Interest Rate Changes

• Payment Amount Changes

Once the payment adjustments are entered, the program will re-calculate the number of payments and total interest paid for the loan and display this number on the Details screen.

To make a payment adjustment, just click the Add button on the Payment Adjustments screen and choose the adjustment type, date of the adjustment, and either the balloon payment amount, new payment amount, or the new interest rate.  All adjustments will only be applied on the date adjusted and all payments thereafter, until another payment adjustments is made or the end of the loan.

 Print/Preview

There are numerous report options that allow you to include just the information you want when printing loan amortization schedules.

5 Year Loan Analysis

Accountant's Helper includes a 5 Year Loan Analysis for all client loans selected.  The following will demonstrate its use:

Select the loans to print

Choose which loans to include in the 5 Year Loan analysis from a particular client by placing a check in the Print field.  Then just select the year end to print for and click Print.  An infinite number of loans can be selected.

The Ratio Analysis feature allows you to enter up to 10 years of key financial data for each client to generate up to 37 pre-defined ratios and 10 user-defined ratios.  These ratios can then be used to produce financial statements, budgets, or any other type of business prospectus. 

Select from the following ratios:

Now with Accountant's Helper Version 2.0, you can create your own User-Defined Ratios using our User-defined Ratio Wizard. Create up to 10 different ratios and customize them using your own formulas!

 Select just the ratios needed or all the ratios by checking the appropriate check box on the following screen:

This option is used to enter financial data needed to calculate the ratios that you selected.  To make data entry as easy as possible, you can print the report Ratio Data Input Worksheet.  This is a template form that can be used to write down the data that you will input using this option.  Using the worksheet to collect the data will ensure that you have all required data before attempting to enter the data.

The following screen will be displayed when you select this option.

The screen is composed of three pages.

• Balance Sheet – On this page, you will enter data that is typically found on the balance sheet.

•  Income Statement – On this page, you will enter data that is typically found on the income statement.

• Other Items – On this page, you will enter additional data that may not be found in the financial statements.

• User-Defined Data – Enter your user defined

If you did not select all ratios, you may find that some fields are disabled.  This indicates that the data is not required to calculate the ratios you selected.

Since you can store data and calculate ratios for up to ten years, the combo box at the top of the screen can be used to change from one year to the next to enter data for prior years.  If you intend to calculate ratios for prior years, you should enter data for the older years first.  The fields shown in the Prior Year Data section will be automatically filled-in based on the data entered in the prior year.  If you change the data in the Prior Year Data section that does not agree to the data entered on the prior year screen, you will be asked if you want to copy the data to the prior year.

The following reports can be printed or previewed on screen:

• Ratio Information Report - Provides a detail listing of ratios you have selected.  Information provided is ratio name, type, formula, and description.
   
• Ratio Data Input Worksheet - Used as an input form when entering financial data.  After selecting the ratios to include on the reports, you can print this worksheet and write the data that needs to be entered using the menu option Enter Ratio Data.
   
• Ratio Data Report - Includes all the data entered for the year selected. Any missing data will be indicated on this report.
   
• Ratio Detail Report - Lists the name of the ratios selected and the calculated ratio grouped by ratio type: Activity, Debt & Capital Structure, Liquidity, and Profitability, for the year selected.
   
• Ratio Yearly Comparison Report - This report will list the name of the ratios selected and the calculated ratio grouped by ratio type; Activity, Debt & Capital Structure, Liquidity, and Profitability, for each year data was entered for.