This course is especially beneficial to accountants, financial managers, and analysts. We explore: » determining monthly payments for a loan» creating an amortization table for a mortgage» computing present and future value for a series of payments or amounts» calculating internal rate of return for cash flows» calculating the number of months to pay off […] Prerequisite: Excel Level 1
This course is especially beneficial to accountants, financial managers, and analysts. We explore:
» determining monthly payments for a loan
» creating an amortization table for a mortgage
» computing present and future value for a series of payments or amounts
» calculating internal rate of return for cash flows
» calculating the number of months to pay off a loan
» calculating imputed interest rate
» building a 1- or 2-dimensional What-If table for financial terms such as payments, present value, etc.
Also, if you’re connected to the audit profession, Audit Data Analytics may be of particular value. ADAs can enhance the traditional sampling techniques used in audit examinations.
