For any users in the financial, mortgage, insurance, or real estate industry, the Excel formulas PMT and IPMT are important ones to have.

Unfortunately, there isn't currently any work around to calculate amortized payments without using .