💰 Financial Functions
Function used to calculate loan payments
PMT or Payment
Total cost of the loan includes loan amount plus this
Interest
Type of schedule showing principal and interest per year
Amortization
THIS Excel tool lets you quickly copy a formula or create a series by dragging a small square.
Fill Handle
Area you select to control what prints
Print Area
Argument in PMT that means total number of periods
nper
This represents how much you pay monthly
Monthly Payment
Function used to find loan balance in amortization
PV or Present Value
Title row for the data table
Column Titles
Feature to repeat titles on each printed page
Print Titles
This argument in PMT represents the loan amount
pv
Interest rate divided by this gives monthly rate
12
Chart added to show yearly payments visually
Line Chart
Used to make important rates stand out visually
Conditional Formatting
Prevents edits to a worksheet
Protect Sheet
Multiply this by 12 to get monthly periods
Term
Cost you borrow from a lender
Loan Amount
Amount left on loan after certain years
Remaining Balance
THIS Excel feature lets you assign a custom label to a cell or range for easier formulas.
Temporarily hides a tab
Hide Worksheet
Used to calculate the value of investments in the future.
FV or Future Value
This defines how long a loan lasts
Term
Condition used to stop calculations in later years
IF Function
Uses two changing variables to compare outputs
Two-Variable Table
Found under Formulas tab to trace errors
Error Checking Tool