01. Functions & Interest (9:08)
Access Financial Funtions
Functions Covered Today:
PV, FV
RATE, NPER
PMT, PPMT, IPMT
Functions NOT Covered:
NPV, DDB, IRR, MIRR
SLN, SYD
Simple v. Compound Interest Rates
APR Annual Percentage Rate

02. Loan Calculator (18:08)
Calculate Mortgage Payments
PMT Function
Amount of Loan
Number of Periods
Interest Rate
Monthly Payment
Total Amount Paid
Total Interest Paid
Rounding Issues
Extra Payment at End of Loan

03. Investment Calculator (7:37)
Calculate Future Value of Investment
Amount of Investment
APR Annual Percentage Rate
Number of Years to Invest
Extra Payments
Future Value
FV Function

04. Interest Rate Calculator (11:30)
What was my rate of return ROI
Intial Investment Amount
Amount of Return
Number of Years to Invest
What was my Interest Rate
RATE Function
Why sometimes divide by 12
Annual vs. Monthly Compounding

05. Millionaire Calculator (9:30)
How long until I'm a millionaire
Initial Deposit Amount
Monthly Payment Amount
Goal Amount
Interest Rate
Calculate Number of Months
Convert to Whole Years
INT Function
NPER FUnction

06. Initial Deposit Calculator (7:06)
College fund calculator
How much deposit to hit goal return
Current Balance Amount
Interest Rate
Years to have account open
Extra annual payments
PV Function

07. House Value Calculator (5:55)
Monthly payment you can afford
Interest rate from bank
How many years for your mortgage
Calculate house you can afford
PV Function

08. Loan Amortization (22:47)
How Amortization Works
Interest and Principal Portions
Build LoanF Form
Create AmortT Table for Periods
Build AmortF Subform
Link Child and Master Fields
Calculate Interest Paid
IPMT Function
Calcaulte Principal Paid
PPMT Function
Rounding Issues
IIF Function to Hide Errors