Jun 21, 2011

Posted by admin in Finance | 0 Comments

Using Financial Functions

Using Financial Functions

We all know where we stand financially each day.  We know how much money we have in the bank and how much we owe on our credit cards.  If you have investments and an Excel program on your computer, you would use the PV function, which is for investment values, to calculate the present value of that investment.  You might also use the FV function if you wanted to calculate the future value of your investment with periodic constant payments. 

You might also use a dollar conversion function to convert a dollar price this is shown as a fraction into that of a decimal. These are just a few of the many financial functions that you will find built in on an Excel program. 

If you wanted to learn to import text files, edit menus or create macros, then you would need to install the advanced Microsoft Excel and learn how to use it.  You can find excel courses online that are for those who already have a good understanding of Excel.  Then you will be able to goal seek, to be able to reverse calculate a particular formula and many other advanced features that this program offers. 
  

Leave a Reply