Date And Financial Functions Syllabus

Date and Financial Functions

This course covers Date and Financial Functions and consists of 20 topics.

Date Functions Part One – This video shows how to use the YEAR, DAY, WEEKDAY, DATE, WORKDAY, and NETWORKDAYS functions to manipulate dates.
Date Functions Part Two – This video shows how to use the DATEDIF function to find years or months between two dates.
Static Time and Date – This video shows how to insert a Static Date (a date that does not change) into a spreadsheet.
Custom List – This video shows how to create a Custom List (like all NFL teams) that you can drag to Autofill.
MLK Day – This video shows how to find the date of Martin Luther King Day for a given year.
Net Present Value – This video shows how to use the NPV function to find the present value of a sequence of cash flows.
XNPV – This video shows how to use the XNPV function to find the present value of irregularly spaced cash flows.
Internal Rate of Return – This video shows how to use the IRR function to find the Internal Rate of Return of a sequence of cash flows.
Modified Internal Rate of Return and XIRR – This video shows how to use the XIRR function to find the IRR of irregularly spaced cash flows and using the MIRR function to find the Modified Internal Rate of Return.
Present Value and Future Value Functions – This video shows how to use the PV function to evaluate an annuity and the FV function to evaluate the accumulation of money for retirement.
The FVSHEDULE Function – This video shows how the FVSCHEDULE function is used to find the future value when interest rates vary over time
Mortgage Functions – This video shows how to use the PMT, IPMT, PPMT, CUMPRINC, and CUMIPMT functions to analyze loans and mortgages.
Rate and NPER Functions – This video shows how to use the RATE function to find the maximum interest rate a borrower can tolerate and using the NPER function to determine the number of periods needed to pay off a loan given the size and annual rate for the loan.
Percentage of Principle – In this video we calculate the fraction of our loan size that we pay to the bank each year.
Bond Pricing – In this video we use Excel financial functions to determine a fair price for a bond.
Annual Percentage Rate on Mortgage Loans – In this video we use Excel’s financial functions to explain the relationship between loan expenses and a loan’s APR
Excel’s Depreciation Functions – In this video we demonstrate Excel functions that make it easy to compute period by period depreciation.
Compound Interest – In this video we show how Excel’s financial functions can be used to solve problems involving compound interest.
Growing Annuities – In this video we show how to use Excel’s financial functions to value a growing annuity.
Adjustable Rate Mortgages (ARM’s) – In this video se show how Excel’s financial functions can be used to compute payments on an Adjustable Rate Mortgage.
Learn More