Retail Investor .org

	      

SPREADSHEETS REFERENCED IN THIS SITE

Here is a list of all the individual spreadsheets talked about on separate pages elsewhere. They were all created with Microsoft Excel97 software. A few have been downloaded from elsewhere on the web, in case a direct link gets broken. Their authors are credited. You can open the files with other spreadsheet software but they are not so robust. They will probably have problems creating the graphs and will be missing the financial functions.

A great many use the advanced financial functions reflecting the time-value-of-money equations talked about on the Rate of Return page. If your Excel97 is not generating the numbers correctly it may be because you have not enabled the Analysis Toolbar (>>Tools>>Add-Ins).

You are correctly concerned about the integrity of the files you download. It involves trust that my machine is clean. Macros are the possible problem because they are automated processes. I USE NO MACROS. Microsoft claims that Excel files saved with the extension .xlsx will NOT include macros. I have included copies of the files using that extension. Regardless, protect yourself by setting an option to open all downloaded files in 'Protected View'. Click File > Options. Click Trust Center > Trust Center Settings > Protected View.

Description.xls.xlsxLink to Discussion
Benefits of Tax Deferral - ViewWhy Bother Making Your Own Decisions?
Company Financial AnalysisGather Facts
Track Portfolio Monthly - ViewKeep Track
Track Yearly Wealth - View Keep Track
Schedule 3 "Capital Gains" for Tax Return - View Keep Track
Chart market returns when sorted by Dividend Yield - View Understand Equity
Compare returns from Dividend vs Growth Portfolios - View Understand Equity
Predict Bond Price Changes - View Bond Pricing
How Long Will Pension Last - ViewGot Enough To Retire?
How Much of My Salary Must I Save - ViewGot Enough To Retire?
Calculate Safe Withdrawal Rate - ViewGot Enough To Retire?
Convert Flat pay to Indexed Math Annuity - ViewGot Enough To Retire?
Drawdown RRSP first or last? - ViewNitty-Gritty of RRSP
Deconstruct Benefits of RRSP - ViewNitty-Gritty of RRSP
Invest in RRSP or Outside? - ViewNitty-Gritty of RRSP
Calc Net Present Value of RRSP cost to Taxpayer Nitty-Gritty of RRSP
US Securities Better in RRSP or Taxable or TFSA? - ViewRRSP Decisions
Save in Which Account - RRSP or TFSA? - RRSP Decisions
Save in Which Account - RRSP or RESP? - RRSP Decisions
Delay Claiming the RRSP's Tax Deduction when Expecting your Tax Bracket to Rise? - RRSP Decisions
Choose between Immediate Pay vs Deferred, or Delay purchase of Life Annuity - ViewAnnuity
2000 Mortality Table for Prescribed Annuities Annuity
1971 Mortality Table for Prescribed Annuities - View Annuity
Taxable Income for Prescribed and Non-Prescribed Life Annuities - View Annuity
Tax Burden on Income, Capital Gains, Dividends - View Capital Gains Taxed at Half Rate - False
Call Options Decision Metrics - ViewSo You Think You Understand Options ?
The Portion of Returns Coming From Dividends - View Reinvested Dividends Account for 97% of Returns .. FALSE
RateReset Preferred Share Yield - View Preferred Shares
Preferred Share Yield-to-Call - View Preferred Shares
Calculate a Stock's Beta - View Risks
Calculate Bond Duration - ViewRisks
Present Value of Growing Perpetuity (dividends) - ViewBig Picture Strategy
Calc Return Earned by Real Estate - View Real Estate
Return From PayingDown Mortgage - ViewReal Estate
Compare Mortgages with differnt Fees using APR - View Real Estate
Canadian Monthly Mortgage Amorization - ViewReal Estate
Canadian Weekly Mortgage Amortization - View Real Estate
Canadian Bi-weekly Mortgage Amortization - View Real Estate
Total Returns of stocks with Different Yields - ViewEvaluating Growth
Graphs and TimeSeries Financial and Economic DataMany
Market Data from ShillerNone
Bond Yields - ViewNone