HOME << Back to Excel Add-ins << Back to finance software << Back To Categories

AtFinCalc $150.00 Payment Problems?

 AtFinCalc Technical Details

Installing your license key

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

You can install the license key you received with your purchase by using the Atereon License Manager. The license manager can be found on the "Start Menu" under "Programs | Atereon" as "Register Atereon Software".

In the license manager, select "AtFinCalc" as your application and enter your license key.

Using the Library

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

How to use the AtFinCalc.dll library.

Visual Basic

Step 1: Add a reference to the AtFinCalc.dll

1. Open your project
2. On the menu, select Project | References
3. Put a check next to "Atereon FinCalc 1.0 Library"
4. Click "Ok"

Step 2: Create an Object

AtFinCalc Objects can now be created using a Dim statement, either referencing the library or not.

Dim mLoan as New Loan

dim mAnn1 as New GrowingAnnuity

dim mAnn2 as New PayingAnnuity

dim mDep as New Deposit

dim mFlowItem as CashFlow

dim mFlows as CashFlows

or

dim mLoan as new AtFinCalc.Loan

dim mAnn1 as new AtFinCalc.GrowingAnnuity

dim mAnn2 as new AtFinCalc.PayingAnnuity

dim mDep as new AtFinCalc.Deposit

dim mFlowItem as AtFinCalc.CashFlow

dim mFlows as AtFinCalc.CashFlows

Visual C++

The AtFinCalc.dll objects can be added to a Visual C++ project using the #import directive in a header file. The AtFinCalc objects can be created using the compiler generated SmartPointers and their "CreateInstance" methods.

The #import directive creates a header file "AtFinCalc.tlh" that can be added to your project to get Class View references for the AtFinCalc objects.

Don't forget to call CoInitialize(NULL) to set up COM.

All "optional" parameters should be passed in as 0 or 0.0 to use their default values.

#include "stdafx.h"

#include <comdef.h>

#import "c:\libraries\AtFinCalc\AtFinCalc.dll" no_namespace



int main(int argc, char* argv[])

{

  CoInitialize(NULL);



  ILoanPtr m_loan;

  m_loan.CreateInstance("AtFinCalc.Loan");

  m_loan->Amount = 1000.0;

  m_loan->Periods = 24;

  m_loan->Rate = 0.10 / 12.0;

  printf("%.2f\n", m_loan->CalcPayment(0, 0, 0));



  CoUninitialize();

  return 0;

}

ASP - Active Server Pages

In ASP use the Server.CreateObject function to create AtFinCalc.dll objects.

dim mLoan

set mLoan = Server.CreateObject("AtFinCalc.Loan")

VB Script

In VB Script use the CreateObject function to create AtFinCalc.dll objects.

dim mLoan

set mLoan = CreateObject("AtFinCalc.Loan")

Redistributing the library as part of your product 

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Note:
Redistributing the AtFinCalc library requires a client licenses for each target workstation, a single-server license for each network server (including, but not limited to web servers), or a redistribution agreement for the product with Atereon, Inc.

Using Windows Installer

The AtFinCalc distribution includes a Windows Installer Merge Module (MSM) file that can be included in your own project. This is the preferred method of redistributing the library.

1. AtFinCalc.MSM

Other installation toolkits

If you want to create an install manually, you need to include the following:

1. AtFinCalc.dll
2. AtLicense.dll

Both files need to be registered. The standard location for these files is "Program Files\Common Files\Atereon".

In order to install your license you will need to use the Atereon License manager or the code below. In the code below, replace the license key with the license key you received with your purchase. If a license is not installed the evaluation license will expire after 30 days, and your application will no longer function.

dim atfincalc as new AtFinCalcLib

call atfincalc.SetLicense("1234-5678-1234-5678")

CashFlows Object

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

The CashFlows Object is a Collection of CashFlow Objects. The contained CashFlow Objects can be referenced by index (flows(i))or using the iterator methods (For Each flow in mFlows).

CashFlow Object

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

This object contains a single entry in a cash flow table (the CashFlows Collection Object). Each item in a CashFlows Collection is a CashFlow object.

Not all properties have values in every cash flow. For example, a CashFlows collection created by a Loan Object has no Contribution or Distribution properties.

Properties

Methods

None

Example

Problem:

What does the cash flow table for a mortgage look like.

Dim mort as New Loan

dim flows as CashFlows

dim i as long

mort.Amount = 100000

mort.Periods = 360 ' 30 Years

mort.Rate = .0725/12 ' 7.25%

set flows = mort.CalcCashFlows

for i = 0 to flows.Count - 1

  ' Do processing

  principle = flows(i).Balance  ' Starting Principle

  interest = flows(i).Interest  ' Interest Paid

  payment = flows(i).Payment  ' Payment Amount

  ' flows(i).Payment  = flows(i).Interest + flows(i).Principle

next i



' Or do it this way

dim flow as CashFlow

for each flow in flows

  ' Do processing

  principle = flow.Balance  ' Starting Principle

  interest = flow.Interest  ' Interest Paid

  payment = flow.Payment    ' Payment Amount

  ' flow.Payment  = flow.Interest + flow.Principle

next flow

Deposit Object

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

This object is used for calculations on Deposit accounts -- accounts that have an initial deposit and receives interest at a fixed rate over a period of time. This includes financial instruments such as savings accounts and certificates of deposit.

You can combine the calculations of a Deposit Object with the calculations of a GrowingAnnuity Object to perform calculations for an annuity that has an initial value and is also receiving regular contributions. See the GrowingAnnuity Object example for an example.

Properties

Methods

For each function, you can either set the properties in advance or pass them in as parameters.

Example

Problem:

What will a $1000 18 month CD at 6% be worth when it matures?

dim dep as new Deposit

dim value as Double

dep.PresentValue = 1000

dep.Periods = 18

dep.Rate = .06/12

value = dep.CalcFutureValue

And what APY is that?

dim apy as Double

dep.Periods = 12

apy = dep.Yield

GrowingAnnuity Object

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

This object is used for calculations on annuities that are paying no distributions, but are receiving regular contributions.

You can combine the calculations of a GrowingAnnuity Object with the calculations of a Deposit Object to calculate values for an annuity that already has principle. Use the Deposit Object for the current principle and the GrowiungAnnuity Object for the contributions. See the example below.

Properties

Methods

Except for CalcCashFlows Function, you can either set the Properties in advance or pass them in as parameters to the function call.

Example

Problem:

My annuity currently has $10000 in it. What will its value be in 10 years with a quarterly contribution of $2500 at a 9% rate of return.

dim growAn as New GrowingAnnuity

dim dep as New Deposit

dim value as Double

growAn.Periods = 10 * 4

growAn.Rate = .09 / 4

growAn.Contribution = 2500

dep.Periods = 10 * 4

dep.Rate = .09 / 4

dep.PresentValue = 10000

value = dep.CalcFutureValue() + growAn.CalcEndingValue()

Loan Object

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

This object is used for calculations on loans (amortization schedules) with fixed interest rates over a fixed period of time. For example a fixed-rate mortgage, an adjustable rate mortgage during its initial fixed-rate period, a balloon mortgage before the balloon payment is due, or an installment loan.

If you calculate a Payment amount, the amount of the final payment will probably be different from every other Payment, this is reflected in the CashFlows Collection generated. If you calculate another parameter using a Payment amount, such as Amount or Rate, the calculation assumes that all payments (including the final payment) will be equal. The resulting side-effect is that an Amount calculated from a Payment can be slightly different from an identical Payment calculated from another Amount.

For example, the calculated Payment for a $1000.00 loan at 10% over 12 periods, is $87.92 per period. The same Payment is also calculated for a $1000.10 loan and a $1000.05 loan. The Amount calculated from a $87.92 payment is always $1000.05.

Properties

Methods

Except for CalcCashFlows Function, you can either set the Properties in advance or pass them as function call parameters.

Example

Problem:

What payment is required for a $100,000 mortgage over 15 years at 7.25%.

Dim mort as New Loan

dim payment as Double

dim orig as Double

orig = 100000

mort.Amount = orig

mort.Periods = 15 * 12

mort.Rate = .0725 / 12

payment = mort.CalcPayment

If the payments are all equal, what would the original Amount be?

dim amt as Double

' Now work backwards

amt = mort.CalcAmount

' amt ≠ orig

PayingAnnuity Object

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

This object is used for calculations on Annuities that are paying distributions. The PayingAnnuity Object can be used to calculate the principle required for an annuity to last a given period, the rate of return required to guarantee an payments, the periods an annuity will last or the payment available from an annuity.

You can combine the calculations of PayingAnnuity Object with the calculations of a GrowingAnnuity Object to determine the contributions required to create an annuity that will last for a given period. See the example below.

Properties

Methods

Except for the CalcCashFlows Function, you can either set the properties in advance or pass them as parameters. to the function calls.

Example

Problem:

What initial principle will be required for a 20 year annuity at 10% that has monthly payments of $1000?

Dim payAn as New PayingAnnuity

dim principleRequired as Double

payAn.Rate = 0.10 / 12

payAn.Distribution = 1000

payAn.Periods = 20 * 12

principleRequired = payAn.CalcStart ingValue

How much will I need to contribute each month if I have 15 years before retirement?

Dim growAn as New GrowingAnnuity

dim monthlyDeposit as Double

growAn.EndingValue = principleRequired

growAn.Periods = 15 * 12

growAn.Rate = 0.10 / 12

monthlyDeposit = growAn.CalcContribution