Future Value of a Lump Sum  Deposit Investment Etc
This Excel Finance tutorial will show you how to calculate the future value of a lump sum such as a bank deposit and certain types of investments. To achieve this, you will learn how to use the future value function in Excel.
Tutorial Length (mm:ss): 
7:14 
Sign Up to View Tutorials

Downloadable Files: 
Yes 
Microsoft Office Program: 
Microsoft Office Excel 


Keywords: 
training finance excel future value fv function lump sum deposit investment 
This Excel Finance tutorial shows you how to calculate the future value of a regular annuity using a function in Excel. This allows you to see how much a series of annuity payments will be worth in the future. Also included is a brief explanation of an annuity.
Tutorial Length (mm:ss): 
5:58 
Microsoft Office Program: 
Microsoft Office Excel 


Keywords: 
training finance excel future value annuity fv function payments 
This Excel Finance tutorial shows you how to calculate the future value of an annuity due. An annuity due is similar to a regular annuity except that annuity due payments are made at the beginning of the period instead of at the end of the period. This tutorial explains how to perform these calculations using the future value function.
Tutorial Length (mm:ss): 
9:23 
Microsoft Office Program: 
Microsoft Office Excel 


Keywords: 
training finance excel future value annuity due payments end period 
This Excel Finance tutorial shows you how to calculate the present value of a series of unequal cash flows in Excel. Since the cash flows are unequal, this is not an annuity problem and, therefore, can’t be solved using the regular present value function.
Tutorial Length (mm:ss): 
2:48 
Microsoft Office Program: 
Microsoft Office Excel 


Keywords: 
training finance excel present value series unequal cash flows 
This Excel Finance tutorial shows you how to calculate the net present value of a series of cash flows or an investment. This is an introduction to net present value and so includes an explanation of the concept of net present value as well as how to setup your data to properly calculate the NPV.
Tutorial Length (mm:ss): 
6:18 
Microsoft Office Program: 
Microsoft Office Excel 


Keywords: 
training finance excel net present value npv cash flows series investment function 
This Excel Finance tutorial shows you how to determine which investment you should choose based on each investment’s net present value. In so doing, this tutorial also covers how to calculate the net present value for a series of cash flows in Excel. There is also a brief explanation of how to setup your data in order to properly calculate the net present value of an investment.
Tutorial Length (mm:ss): 
5:09 
Microsoft Office Program: 
Microsoft Office Excel 


Keywords: 
training finance excel npv net present value function investment choose series cash flow 
This Excel Finance tutorial shows you how to calculate the internal rate of return on an investment or series of cash flows. This is an overview of calculating the IRR in Excel and, therefore, also includes an overview of the internal rate of return and an explanation of how to setup your data so that you will calculate an accurate internal rate of return.
Tutorial Length (mm:ss): 
6:41 
Microsoft Office Program: 
Microsoft Office Excel 


Keywords: 
training finance excel irr internal rate of return investment cash flows function 
This Excel Finance tutorial shows you how to choose an investment based on the investment’s internal rate of return. In addition, you will learn how to calculate the internal rate of return for a series of cash flows and how to setup data to calculate the IRR.
Tutorial Length (mm:ss): 
4:37 
Microsoft Office Program: 
Microsoft Office Excel 


Keywords: 
training finance excel irr internal rate of return choose between investments function cash flow 
This Excel Finance tutorial shows you how to calculate the effective annual interest rate from a standard annual percentage rate (APR). This is an important calculation to perform since it allows you to see what the actual true yearly interest rate will be when there are compounding periods within the year.
Tutorial Length (mm:ss): 
5:37 
Microsoft Office Program: 
Microsoft Office Excel 


Keywords: 
training finance excel effective annual interest rate annual monthly calculate 
This Excel Finance tutorial shows you how to calculate the effective annual return for an interest rate that is continuously compounded. This is an interesting situation where you have to use a mathematical function and not a finance function to calculate the result.
Tutorial Length (mm:ss): 
2:15 
Microsoft Office Program: 
Microsoft Office Excel 


Keywords: 
training finance excel calculate continuous interest rate compound compounding ear eair effective annual 
This Excel Finance tutorial shows you how to get the annual percentage rate (APR) and the monthly interest rate from the effective annual interest rate using Excel. You will learn how to use the nominal function in Excel in order to get the annual percentage rate and, from there, calculate the monthly percentage rate.
Tutorial Length (mm:ss): 
3:11 
Microsoft Office Program: 
Microsoft Office Excel 


Keywords: 
training finance excel calculate apr ear eair annual percentage rate effective nominal function 