vondravl

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.

	/**
	* 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.

	class Software {
	[string]$Name
	[string]$Id
	[string]$Version
	[string]$AvailableVersion
	}

	$upgradeResult = winget upgrade \| Out-String

	$lines = $upgradeResult.Split([Environment]::NewLine)

	// *******************
	// Contributors:
	// - Andrew Smith (@AndrewSouthpaw)
	// - Shaun Mosley (@Shaunm44)

	// *******************
	// This setup will allow you to synchronize personal events from one calendar (the "secondary calendar")
	// to another calendar, e.g. work (the "primary calendar"), but obfuscate the details. Then your coworkers
	// know when you're busy but don't get to see the personal details.
	//

	javascript: Promise.all([import('https://unpkg.com/turndown@6.0.0?module'), import('https://unpkg.com/@tehshrike/readability@0.2.0'), ]).then(async ([{
	default: Turndown
	}, {
	default: Readability
	}]) => {

	/* Optional vault name */
	const vault = "";

	/* Optional folder name such as "Clippings/" */

	/**
	* 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.

	/**
	* 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.

	/**
	* 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.

	/**
	* 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.

	/**
	* Payment (PMT)
	* (SQL Server)
	* AzsaturnDx (2020) - No copyright at all
	*
	* Calculates the payment for a loan based on constant payments and a constant interest rate.
	*
	* @Rate FLOAT - Required. The interest rate for the loan.
	* @Periods INT - Required. The total number of payments for the loan.
	* @Present FLOAT - Required. The present value, or the total amount that a series of future payments is worth now; also known as the principal.