Skip to content (Press Enter)
  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Macrordinary

Macrordinary

  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Home>Blog>formulas>financial formulas

Category: financial formulas

Updated on June 12, 2022June 12, 2022/ Brent Allen

BYROW() in Excel: A Marginal Tax Schedule Example

The BYROW() function allows calculations to be done on a row by row basis. This allows for new functions to be created that are similar to the SUMPRODUCT() function, but are much more customizable. In this example, we will be …

Read More
Updated on March 12, 2022March 12, 2022/ Brent Allen

LAMBDA() in Excel – Generating an Amortization Schedule

LAMBDA() in Excel – Generating an Amortization Schedule

Use the LAMBDA() function to create a loan amortization schedule!

Read More
Updated on November 27, 2019October 20, 2019/ Brent Allen

Creating a Basic Loan Amortization Schedule Without Code

Creating a Basic Loan Amortization Schedule Without Code

An amortization schedule contains details with respect to a loan, including the following: The principal amount of the loan. The interest on the loan (typically reflected in annual terms). The length of the loan (typically reflected in years; except in …

Read More
Updated on November 4, 2019October 11, 2019/ Brent Allen

Using PMT() to calculate installments

One of the most commonly used financial functions is the payment function – the PMT() function. This formula replicates the mathematical equation below: Instead of using the mathematical equation, the Excel formula uses a much simpler list of arguments. =PMT(interest …

Read More

Recent Posts

  • Non-Unique List in Excel: Showing Only Duplicates
  • BYROW() in Excel: A Marginal Tax Schedule Example
  • Unique Values from 2 Lists in Excel – Multiple Methods
  • LAMBDA() in Excel – Generating an Amortization Schedule
  • LET Function in Excel: A Name Parsing Example

Categories

  • dashboards
  • excel
  • financial formulas
  • formulas
  • M
  • office script
  • pivot tables
  • power apps
  • power bi
  • power pivot
  • power platform
  • power query
  • scripts
  • VBA
Copyright © 2025 Macrordinary. Software Company | Developed By Rara Theme. Powered by WordPress.