The Motley Fool Discussion Boards
Investing/Strategies / Bonds & Fixed Income Investments
|Subject: Re: OT; Learning Excel||Date: 11/9/2002 2:14 PM|
|Author: iamdb||Number: 5141 of 35992|
I have the previous model iMac running OS 10 and the latest Microsoft Office suite. I find EXCEL indispensible for financial planning. I enjoy building and testing spreadsheets. Once you get into it, I suspect you'll find it a satisfying challenge and dream up all sorts of spreadsheets to cover various aspects of your life from tracking your physical weight and BMI to your financial weight and NAV. I created a table that predicts growth of income from various sources, growth of total income, and growth of portfolio value over the next 40 years, given a number of parameters I provide like expected return, expected CPI, rate of draw, and so forth. It's intersting and instructive to vary the parameters and observe the changes in expected values. Another table tracks our asset allocation and shows what needs to be sold or bought to maintain the balance we want. I think the combination of Quicken and EXCEL is unbeatible.
Wish I had your new iMac with its wide display -- perfect for spreadsheets.
Incidently, at the time I left the high-tech world in 1992, the techies used Sun or Silicon Graphic workstations and Macs (Symbolics LISP machines had largely gone away by then). Only secretaries and clerical personnel used PCs
|Copyright 1996-2017 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us|