Sunday, December 8, 2013

4 Formulas You Should Know Cold





Here is the link for the Excel spreadsheet entitled
4 Formulas You Should Know.

1) Percentage Change (% delta) = (New - Old)/ Old

2) % Markup = Old x (1 + % MrkUp)

     % Discount = Old x (1 - % Discount)

3) FV = PV x (1 + r ) ^t

4) PV = FV /(1 + r)^t

Please click on the link and complete the exercises in the example section.  Send your answers as an attached file saved as Excel4Formulas_FirstNameLastName_Date.xls to my Gmail address at rwiegs@gmail.com









Remember to ask for help if you need to solve these problems.  -R.Wiegand

No comments:

Post a Comment