Azsaturndx

/** 
 * Cumulative Interest
 * (SQL Server) 
 * AzsaturnDx (2022) - No copyright at all
 *
 * Returns the cumulative interest paid on a loan between @start and @end periods.
 *
 * @Rate FLOAT - Required. The interest rate.
 * @Periods INT - Required. The total number of payment periods.
 * @Value INT - Required. The present value.

Azsaturndx

/** 
 * Reloads a dataView every periodically
 * (Code onTime) 
 * AzsaturnDx (2020) - No copyright at all
 *
 * Reload data from the contextDataview
 *
 * Implementation:
 * 1.- Copy this to a file.
 * 2.- Copy this file to (...)/app/js/

Azsaturndx

System.Net.ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12;

Azsaturndx

/** 
 * Hide Roles controls
 * (Code onTime) 
 * AzsaturnDx (2020) - No copyright at all
 *
 * Hides all role-based controls from user.
 *
 */

// Expressed in milliseconds

Azsaturndx

/** 
 * Prevent user session closing
 * (Code onTime) 
 * AzsaturnDx (2020) - No copyright at all
 *
 * Prevents the user from logging out by constantly refreshing userToken (re-logging-in according to: daf.js)
 *
 * REQUIRES: Your COT project must have the Account Manager enabled.
 */

Azsaturndx

/** 
 * Principal Payment
 * (SQL Server) 
 * AzsaturnDx (2020) - No copyright at all
 *
 * Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
 *
 * @Rate FLOAT - Required. The interest rate per period.
 * @Period INT - Required. Specifies the period and must be in the range 1 to nper.
 * @Periods INT - Required. The total number of payment periods in an annuity.

Azsaturndx

/** 
 * Effective Annual Interest Rate
 * (SQL Server) 
 * AzsaturnDx (2020) - No copyright at all
 *
 * Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
 *
 * @Rate FLOAT - Required. The nominal interest rate.
 * @Periods INT - Required. The number of compounding periods per year.
 * @return FLOAT Effective Annual Interest Rate.

Azsaturndx

Financial Functions

This is a list of Financial Functions that i've developed in the past years. You can use them to do amortization schedule calculations and so. Please make good use of them, you can do whatever you like, there's no copyright.

• Interest Payment (IPMT).
• Future Value (FV).
• Payment (PMT).
• Effective Annual Interest Rate (EFFECT).

Azsaturndx

/** 
 * Interest Payment
 * (SQL Server) 
 * AzsaturnDx (2020) - No copyright at all
 *
 * Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
 *
 * @Rate FLOAT - Required. The interest rate per period.
 * @Period INT - Required. Specifies the period and must be in the range 1 to nper.
 * @Periods INT - Required. The total number of payment periods in an annuity.

Azsaturndx

/** 
 * Future Value (FV)
 * (SQL Server)
 * AzsaturnDx (2020) - No copyright at all
 *
 * Calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment.
 *
 * @Rate FLOAT - Required. The interest rate for the loan.
 * @Periods INT - Required. The total number of payments for the loan.
 * @Payment FLOAT - Required. The payment made each period; it cannot change over the life of the annuity.