|
Financial Planning Spreadsheets ©
|
Professional Version
|
|
Menu Descriptions For Version 2008.4
|
|
30-Sept-2008
|
|
Calculators
|
File Name
|
Worksheet
|
N/R
|
Reports
|
Chart
|
Accrued Interest Calculator
|
Calculators.xlt
|
DIY
|
|
1
|
0
|
Age Last Birthday Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Age Nearest Birthday Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Analysis of Drawing Canada
Pension Benefits Early
|
Calculators.xlt
|
EarlyCPP
|
|
1
|
0
|
Annuity Calculator (pmt)
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Bond Price / Bond Yield
Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
C.P.P. Rate Cal. / Cost of
Waiting Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Day Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Depreciation Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Effective Interest Rate
Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
End Date Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Future Value Calculator (fv)
|
Calculators.xlt
|
Calculators
|
|
1
|
0
|
Income Tax Estimator
|
Calculators.xlt
|
Tax
|
|
1
|
0
|
Internal Rate of Return (IRR)
|
Calculators.xlt
|
IRR-NPV
|
|
1
|
0
|
Late Settlement Invoice
|
Calculators.xlt
|
LateSettle
|
|
1
|
0
|
Life Insurance Calculator
|
Calculators.xlt
|
Life
|
|
1
|
0
|
Net Present Value (NPV)
Calculator
|
Calculators.xlt
|
IRR-NPV
|
|
0
|
0
|
Nominal Interest Rate
Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Number of Periods (n)
Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Present Value Calculator (pv)
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Rate Calculator (i)
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Retirement Calculator
|
Calculators.xlt
|
Retire
|
|
1
|
incl
|
Tax Free Rate Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
Taxable Equivalent Rate
Calculator
|
Calculators.xlt
|
Calculators
|
|
0
|
0
|
|
|
|
|
|
|
|
Education
|
|
|
|
|
|
College Cost Estimator
|
Education.xlt
|
Tuition
|
|
1
|
1
|
Family Education Funds -
Allotments
|
Education.xlt
|
Family Allotments
|
|
1
|
0
|
Family Education Funds -
Entitlement to Funds
|
Education.xlt
|
Family Entitlements
|
|
1
|
0
|
Registered Education Savings
Plan - Family Plan
|
Education.xlt
|
Family
|
|
1
|
1
|
Registered Education Savings Plan (RESP) |
Education.xlt
|
RESP
|
|
1
|
1
|
Trust Fund for Education
Savings
|
Education.xlt
|
ITF
|
|
1
|
1
|
|
|
|
|
|
|
|
Financial
Planning
|
|
|
|
|
|
Analysis of Drawing Canada
Pension Early
|
Calculators.xlt
|
EarlyCPP
|
|
Repeat
|
0
|
Analysis of Tax Liabilities For Clearance
of Estate
|
Insurance.xlt
|
Estate
|
|
1
|
incl
|
Asset Allocation Goals |
Portfolio.xlt
|
Allocate
|
|
1
|
incl
|
Cash Flow Projections |
CashFlow.xlt
|
Annual
|
|
1
|
1
|
Cash Flow Projections - Monthly
|
CashFlow.xlt
|
Monthly
|
|
1
|
1
|
Checklist for a Comprehensive
Financial Plan
|
Recommendations.xlt
|
CheckList
|
|
1
|
0
|
Cost of Waiting for CPP
Calculator
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Estate Capital Needs Analysis |
Insurance.xlt
|
Needs
|
|
Repeat
|
0
|
Financial Planning
Questionnaire
|
Questionnaire.xlt
|
11 pages
|
|
11
|
0
|
Financial Planning Recommendations |
Recommendations.xlt
|
Personalized
|
|
1
|
0
|
Financial Planning
Recommendations Cover
|
Recommendations.xlt
|
Cover
|
|
1
|
0
|
Financial Planning
Recommendations Narrative
|
Recommendations.xlt
|
Narrative
|
|
1
|
0
|
Financial Planning
Recommendations Worksheet
|
Recommendations.xlt
|
Basic
|
|
1
|
0
|
Funding Requirements For
Retirement – Client
|
Funding.xlt
|
Client
|
R
|
Repeat |
0
|
Funding Requirements For
Retirement - Joint
|
Funding.xlt
|
Joint
|
R
|
Repeat |
0
|
Net Worth Statement |
NetWorth.xlt
|
Report
|
|
1
|
1
|
Pension Maximization
|
Pensions.xlt
|
Pension Max
|
|
1
|
incl
|
Prepaid Pension Maximization
|
Pensions.xlt
|
Prepaid Pension Max.
|
|
1
|
incl
|
Registered Education Savings Plan (RESP) |
Education.xlt
|
RESP
|
|
Repeat |
0
|
Risk Tolerance Questionnaire |
Portfolio.xlt
|
Risk
|
|
1
|
incl
|
Summary of Investment Portfolio |
Portfolio.xlt
|
Summary
|
|
Repeat
|
0
|
Table Of Contents
|
Recommendations.xlt
|
TableOfContents
|
|
1
|
0
|
|
|
|
|
|
|
|
Insurance & Estate Planning
|
|
|
|
|
|
Age Last Birthday Calculator
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Age Nearest Birthday Calculator
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Analysis of Tax Liabilities For
Clearance of Estate
|
Insurance.xlt
|
Estate
|
|
Repeat
|
0
|
Buy Term & Invest the
Difference vs. UL
|
ULvsTerm.xlt
|
ULvsTerm
|
|
1
|
1
|
Buy Term & Invest the
Difference vs. Whole Life
|
ULvsTerm.xlt
|
WLvsTerm
|
|
1
|
1
|
Buy Term & Invest the
Difference - with side fund deposit
|
ULvsTerm.xlt
|
ULvsTermSF
|
|
1
|
1
|
Charitable Legacy Investment
Plan
|
Gifts.xlt
|
Legacy
|
|
1
|
0
|
Comparison of Charitable Gift
as Cash vs. Gifting Security
|
Gifts.xlt
|
Security
|
|
1
|
incl
|
Comparison of Term Insurance
Plans
|
Insurance.xlt
|
TermCompare
|
|
1
|
1
|
Critical Illness - Needs
Analysis
|
Disability.xlt
|
Critical
|
|
1
|
incl
|
Disability Needs Analysis
|
Disability.xlt
|
Report
|
|
1
|
1
|
Estate Capital Needs Analysis |
Insurance.xlt
|
Needs
|
|
1
|
1
|
|
G.I.C. versus Annuity
|
Annuity.xlt
|
GICvsAnn
|
|
1
|
1
|
G.I.C. versus Insured Annuity
|
Annuity.xlt
|
GICvsInsur
|
|
1
|
1
|
Leveraged Investment Portfolio
with Universal Life
|
Leverage.xlt
|
Leverage&UL
|
|
1
|
incl
|
Life Insurance Calculator
|
Calculators.xlt
|
Life
|
|
Repeat
|
0
|
Long Term Care Analysis
|
Disability.xlt
|
LTC
|
|
1
|
incl
|
Pension Maximization
Illustration
|
Pensions.xlt
|
PensionsMax
|
|
Repeat
|
0
|
Prepaid Pension Maximization
|
Pensions.xlt
|
Prepaid Pension Max.
|
|
Repeat
|
incl
|
Rate of Return on Life
Insurance
|
Insurance.xlt
|
IRR
|
|
1
|
0
|
Summary of Deemed Disposition
of Securities
|
Insurance.xlt
|
Deemed
|
|
1
|
0
|
Taxable Capital Gain from
Deemed Disposition
|
Insurance.xlt
|
Summary
|
|
1
|
0
|
|
|
|
|
|
|
|
Investments
|
|
|
|
|
|
Analysis of Investment
Portfolio & Income Tax
|
Portfolio.xlt
|
Analysis
|
|
1
|
1
|
Calendar of Income from
Systematic Withdrawal Plans
|
SWIP.xlt
|
Calendar
|
|
1
|
0
|
Comparison of Deferred Pension
to Private Managed
|
LIF.xlt
|
LIRALIF
|
|
1
|
incl
|
Late Settlement Invoice
|
Calculators.xlt
|
LateSettle
|
|
Repeat
|
0
|
Leverage Scenarios
|
Leverage.xlt
|
Scenarios
|
|
1 |
incl
|
Leveraged Investment Portfolio
|
Leverage.xlt
|
Leverage
|
|
1 |
incl
|
|
Leveraged Investment Portfolio with Universal Life
|
Leverage.xlt
|
Leverage&UL
|
|
Repeat
|
0
|
No Money Down - Retirement Plan
(Leverage)
|
Leverage.xlt
|
Retirement
|
|
1 |
incl
|
Projected Growth of an
Investment
|
ReturnRt.xlt
|
Growth
|
|
1
|
incl
|
Projected Growth of an
Investment with variables
|
ReturnRt.xlt
|
Variable
|
|
1
|
incl
|
RRSP Investment with Mortgage Pay Down |
RRSP.xlt
|
RRSP&Mtg
|
|
1 |
0
|
R.R.S.P. vs. Leverage
Investment
|
Leverage.xlt
|
RRSPvsLeverage
|
|
1 |
1
|
|
R. R. S. P. vs. Mortgage Pay Down |
RRSP.xlt
|
RRSPvsMtg
|
|
1 |
0
|
|
R.R.S.P. vs. Same Amount to Reduce Leverage Loan
|
Leverage.xlt
|
RRSPvsLoanServ
|
|
1 |
1
|
Rates of Return - 20 year
Returns by asset Class
|
Rates.xls
|
Rates of Return
|
|
1
|
1
|
Revenue Property Investment
Analysis
|
Analysis.xlt
|
Real Estate
|
|
1
|
0
|
Summary of Distributions and
Tax Analysis
|
Analysis.xlt
|
R.O.I.
|
|
1
|
1
|
Summary of Guaranteed
Investments
|
Portfolio.xlt
|
Guaranteed
|
|
1
|
0
|
Summary of Insurance Contracts
|
Portfolio.xlt
|
Insurance
|
|
1
|
0
|
Summary of Investment Fund
Holdings
|
Portfolio.xlt
|
Funds
|
|
1
|
0
|
Summary of Investment Portfolio |
Portfolio.xlt
|
Summary
|
|
1
|
incl
|
Summary of Investment Portfolio
- Cover Page
|
Portfolio.xlt
|
Cover Page
|
|
1
|
0
|
Summary of Other Securities
|
Portfolio.xlt
|
Other
|
|
1
|
0
|
Systematic Withdrawal Plan
(SWP)
|
SWIP.xlt
|
Report
|
|
1
|
1
|
|
|
|
|
|
|
|
Loans
|
|
|
|
|
|
Accelerated Mortgage
Amortization (Quick Pay)
|
Amortize.xlt
|
QuickPay
|
|
1
|
0
|
Accrued Interest Calculator
|
Calculators.xlt
|
DIY
|
|
Repeat
|
0
|
Annuity Calculator (pmt)
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Day Calculator
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Debt Service Strategy
|
Loans.xl
|
DebtService
|
|
1
|
0
|
Effective Interest Rate
Calculator
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
End Date Calculator
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Future Value Calculator (fv)
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Gross Debt Service Ratio /
Total Debt Service Ratio
|
Amortize.xlt
|
DSR
|
|
1
|
0
|
Lease versus Purchase Analysis
|
Loans.xlt
|
BuyVsLease
|
|
1
|
0
|
Loan Schedule
|
Loans.xlt
|
Report
|
|
1
|
1
|
Mortgage Amortization Schedule
|
Amortize.xlt
|
Report
|
|
1
|
1
|
Mortgage Pay Down And R.R.S.P.
|
RRSP.xlt
|
RRSP&Mtg
|
|
Repeat |
0
|
Mortgage Pay Down vs. R.R.S.P.
|
RRSP.xlt
|
RRSPvsMtg
|
|
Repeat |
0
|
Nominal Interest Rate
Calculator
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Number of Periods Calculator
(n)
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Present Value Calculator (pv)
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Refinancing Feasibility
|
Amortize.xlt
|
Re-Finance
|
|
1
|
0
|
Return Rate Calculator (i)
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
|
|
|
|
|
|
|
Retirement
|
|
|
|
|
|
Comparison of Deferred Pension
to Private
|
LIF.xlt
|
LIRALIF
|
|
Repeat
|
0
|
|
Defined Benefit Pension Plan Calculations
|
Pensions.xlt
|
Defined Benefit
|
|
1
|
0
|
Effect of Recommendations on Tax Payable |
Tax.xlt
|
Recommendations
|
|
Repeat
|
0
|
Funding Requirements For
Retirement - Client
|
Funding.xlt
|
Client
|
|
1 |
1
|
Funding Requirements For Retirement - Joint |
Funding.xlt
|
Joint
|
|
1 |
1
|
Life Income Fund Illustration
(LIF)
|
LIF.xlt
|
L.I.F.
|
|
1
|
inc
|
Life Income Fund Rules (LIF
& LRIF)
|
LIF.xlt
|
LIFRules
|
|
1
|
1
|
Locked In Retirement Account
(L.I.R.A.)
|
LIF.xlt
|
LIRA
|
|
1
|
0
|
Locked Retirement Income Fund
Illustration (LRIF)
|
LIF.xlt
|
L.R.I.F.
|
|
1
|
1
|
Money Purchase Pension Plan
|
Pensions.xlt
|
Money Purchase
|
|
1
|
0
|
Old Age Security (OAS) Clawback
Planning
|
RRSP.xlt
|
Clawback
|
|
Repeat |
0
|
P.R.I.F. (Saskatchewan
Illustration)
|
RRIF.xlt
|
Sask
|
|
1
|
inc
|
Pension Salary Calculations
|
Pensions.xlt
|
Earnings
|
|
1
|
0
|
Prepaid Pension Maximization
|
Pensions.xlt
|
Prepaid Pension Max.
|
|
Repeat
|
0
|
Projected Growth of a R.R.S.P.
Investment
|
RRSP.xlt
|
RRSP
|
|
1 |
incl
|
Projected Growth of an R.R.S.P.
vs. Open Investment
|
RRSP.xlt
|
RRSPvsOpen
|
|
1 |
0
|
Registered Retirement Income
Fund (RRIF)
|
RRIF.xlt
|
Income
|
|
1
|
incl
|
RRIF - Tax Liability
|
RRIF.xlt
|
RRIFTax
|
|
1
|
1
|
RRIF - Minimum Rates
|
RRIF.xlt
|
RRIF%
|
R
|
1
|
0
|
Registered Retirement Plan -
(RRSP-RRIF)
|
RRIF.xlt
|
RRSP-RRIF
|
|
1 |
1
|
Retirement Calculator
|
Calculators.xlt
|
Retire
|
|
Repeat
|
0
|
RRSP Accumulation / Retirement
Projector
|
RRSP.xlt
|
Report
|
|
1
|
1
|
|
|
|
|
|
|
|
Taxation
|
|
|
|
|
|
Average Cost Per Share for Tax
Purposes
|
ACB.xlt
|
ACB
|
|
1
|
1
|
Average Cost Per Share for Tax
Purposes - Long Form
|
ACB.xlt
|
ACBLongForm
|
|
1
|
0
|
Analysis of Prescribed Annuity
Income
|
Annuiy.xlt
|
Prescribed
|
|
1
|
incl
|
Effect of Recommendations on Tax Payable |
Tax.xlt
|
Recommendations
|
|
1
|
1
|
Income Tax Rates - Current Year
|
Rates.xls
|
Current Year
|
R
|
1 |
0
|
Gross Income Requirements for
Retirement
|
Tax.xlt
|
PreTaxCalc
|
|
1
|
1
|
Income Tax Payable
|
Tax.xlt
|
TaxBill
|
|
1
|
1
|
Income Tax Rates & Income
Security Program Rates
|
Rates.xls
|
Data Entry
|
R
|
1 |
0
|
Income Tax Rates - Prior Year
|
Rates.xls
|
Prior Year
|
|
1 |
0
|
Marginal Tax Rates - All
Canadian Provinces
|
Rates.xls
|
Marginal Rates
|
|
1
|
0
|
Old Age Security (OAS) Clawback
Planning
|
RRSP.xlt
|
Clawback
|
|
1 |
1
|
Provincial Income Tax Rates -
Provinces & Territories
|
Rates.xls
|
Provinces
|
|
1 |
0
|
R.R.I.F. Deferred Tax Liability
|
RRIF.xlt
|
RRIFTax
|
|
Repeat
|
0
|
R.R.S.P. Contribution Analysis
|
RRSP.xlt
|
Room
|
|
1
|
0
|
Record of Average Cost Per
Share
|
ACB.xlt
|
ACPSCalc
|
|
1
|
1
|
Record of Investment Cost Base
- Blank Form for clients
|
ACB.xlt
|
ACPSform
|
|
1
|
0
|
Separation / Divorce - Income
Analysis
|
Separation.xlt
|
Separate
|
|
1
|
0
|
Summary of Realized Gains for
the Year
|
ACB.xlt
|
Realized
|
|
1
|
0
|
|
|
|
|
|
|
|
Other Reports & Forms
|
|
|
|
|
|
Analysis of Market Value
Adjustments
|
MVACalc.xlt
|
Report
|
|
1
|
1
|
Analysis of Prescribed Annuity
Income
|
Annuiy.xlt
|
Prescribed
|
|
Repeat
|
0 |
Calculation of Market Value
Adjustment
|
MVACalc.xlt
|
Calculate
|
|
1
|
0
|
Canada Child Tax Benefit &
Supplement
|
Separation.xlt
|
ChildTaxBenefit
|
|
1
|
0
|
Client Data Entry Links
|
Data.xls
|
Data Entry
|
|
1
|
0
|
Financial Planning Spreadsheets
Order Form
|
N/A
|
|
|
0
|
0
|
GST/HST Credit Calculations
|
Separation.xlt
|
GSTCredit
|
|
1
|
0
|
Index of Caclulators
|
Calculators.xlt
|
Index
|
|
1
|
0
|
Inflation Over the Last Thirty
Years (CPI)
|
Rates.xls
|
CPI
|
|
1
|
0
|
Disclosure Letter
|
Recommendations.xlt
|
Disclosure
|
|
1
|
0
|
Letter of Engagement
|
Recommendations.xlt
|
EngagementLetter
|
|
1
|
0
|
No Fee Letter of Engagement
|
Recommendations.xlt
|
NoFeeEngagement
|
|
1
|
0
|
Owners Manual
|
FPSManual.pdf
|
n/a
|
|
0
|
0
|
Provincial Child Benefit Plans
|
Separation.xlt
|
ProvincialBenefit
|
|
1
|
0
|
Registered User Change/Transfer
Form
|
RegisteredUser.xls
|
Change Form
|
|
1
|
0
|
Registered User Name etc. for
Reports
|
RegisteredUser.xls
|
Licensee
|
|
1
|
0
|
Separation / Divorce - Division
of Assets
|
Separation.xlt
|
Valuation
|
|
1
|
0
|
Separation / Divorce - Income
Analysis
|
Separation.xlt
|
Separate
|
|
Repeat
|
0
|
Separation / Divorce -
Projected Growth of Networth
|
Separation.xlt
|
Projected
|
|
1
|
inc
|
|
Upgrade & Updates Subscription Form
|
N/A
|
|
|
0
|
0
|
|
|
|
|
|
|
|
Menu Items
|
177
|
Reports & Charts
|
|
124
|
37
|
