19. Adding a Data Table
Adding a Data Table to complement our Retirement Calculator gives us the ability to look at a broader view of the calculations based around the number of years you expect to be employed.
In examining the comparisons, you can see that at around 10 years of employment, there is a break even point - that is, the Return on the Investment is about the same as the Actual Investment. After that the return on an investment grows unimaginably!
You can do this type of analysis quickly and simply only through the use of a spreadsheet. These techniques give you the tools to answer financial questions easily!
Materials Covered: Project 7 - Using Macros and Visual Basic for Applications (VBA) with Excel, pp. EX 539-548
In examining the comparisons, you can see that at around 10 years of employment, there is a break even point - that is, the Return on the Investment is about the same as the Actual Investment. After that the return on an investment grows unimaginably!
You can do this type of analysis quickly and simply only through the use of a spreadsheet. These techniques give you the tools to answer financial questions easily!
Materials Covered: Project 7 - Using Macros and Visual Basic for Applications (VBA) with Excel, pp. EX 539-548
posted by hj at 9:04 AM
<< Home