Calculate Value of Savings or Retirement Plan in Excel using the Future Value Function – FV() This video illustrates the power of the future value function (FV) when calculating potential savings or retirement plans. Download savings calculator and retirement templates in excel. Instructions can be found here.
Read more »
Forecasting
Using Excel FV functions to calculator your savings or retirement plan
Cash Flow Forecasting
Cash Flow Forecasting Forecasting cash flows is very important, as many businesses have failed due to lack of cash flow rather than lack of profit! Cash flow forecasting is absolutely essential while planning short or long-term funding requirements of any business.
Read more »
How to Use Balanced Scorecard to Develop Key Performance Indicators
How to Use Balanced Scorecard to Develop Key Performance Indicators Balanced Scorecard was first proposed by Dr. Kaplan and Norton in 1992 and has since evolved into a strategic planning tool. Many big corporations around the world have adopted the Balanced Scorecard in its full scale operation. Incidentally, Strategy Map is one of the...
Read more »
Time Value Formulas in Microsoft Excel – Part II
Time Value Formulas in Microsoft Excel – Part II In the first article, I discussed the PV and FV functions in Excel for calculating the time value of money. In this article, I will discuss the NPV and IRR functions in Excel.
Read more »
Time Value Formulas in Microsoft Excel – Part I
Time Value Formulas in Microsoft Excel – Part I Excel offers a few simple formulas for determining the value of projects over time. I
Read more »