PPMT Function
The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a trying to determine is the principle of a …
Functions
Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.
NPER Function
The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods of a loan are based on …
CUMPRINC Function
The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an excellent tool to quickly understand your …
YEARFRAC Function
The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax: =YEARFRAC(start_date, end_date, [basis]) Arguments: start_date – The start date. end_date …
YEAR Function
The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out the year from a date or …
WORKDAY.INTL Function
Workday.intl Function