Select Page

Category: Truth Tips

Truth Tip All Calculators

All calculators: to switch from positive to negative numbers or vice-versa, highlight the numbers to change in one column and right click, select change sign.  To put the same # or formula in multiple cells, enter the # or formula in the top cell, highlight the cells you want filled starting w/ that top one, select ALT  + DOWN ARROW    or right click and select “fill down”.   Anywhere there are cells underlined in blue inside the spreadsheets you can enter numbers or formulas in place of what is there,

How do I figure out if I can get ahead by earning 6% if I have an 8% cost?

How do I figure out if I can get ahead by earning 6% if I have an 8% loan? At first glance, the answer is obvious, you don’t get ahead.  However, sometimes we get confused and think that since an account (say at 6%) has an increasing balance while a loan (say at 8%) has a decreasing balance, we might be able to get ahead.  Let’s look at it to see the whole truth of the matter. Take a \$100,000 account earning 6% over 20 years.  Future Value: \$320,714.

Truth Tip All Calculators

Financial calculators: switch from annual to monthly mode or any other mode and it will ask you if you want to adjust the existing amounts to match.    Pushing the “TOP” button: causes the calculator to stay on top of anything you are doing.  Double clicking on any of the labels for the inputs in the calculator brings up that (other) financial calculator.