|
|
|
|
|
|
|
|
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
|
Bond Price / Bond Yield 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
|
Payment Calculator (pmt)
|
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
|
Custodial Education Savings Account
|
Education.xlt
|
Custodial
|
|
1
|
1
|
|
Education Savings Account (ESA) |
Education.xlt
|
ESA
|
|
1
|
1
|
Family Education Funds - Allotments
|
Education.xlt
|
Family Allot
|
|
1
|
0
|
Family Education Funds - Entitlement to
Funds
|
Education.xlt
|
Family Entitlements
|
|
1
|
0
|
|
Qualified Tuition Program - Family |
Education.xlt
|
Family
|
|
1
|
1
|
|
|
|
|
|
|
|
Financial
Planning
|
|
|
|
|
|
Asset Allocation Goals
|
Portfolio.xlt
|
Allocate
|
|
1
|
incl
|
Cash Flow Projections - Annual |
CashFlow.xlt
|
Annual
|
|
1
|
1
|
Cash Flow Projections - Monthly
|
CashFlow.xlt
|
Monthly
|
|
1
|
1
|
Estate Capital Needs Analysis |
Insurance.xlt
|
Needs
|
|
1
|
incl
|
Financial Plan - Table Of Contents
|
Recommendations.xlt
|
TableOfContents
|
|
1
|
0
|
Financial Planning - Checklist
|
Recommendations.xlt
|
CheckList
|
|
1
|
0
|
Financial Planning Questionnaire (13 Pages)
|
Questionnaire.xlt
|
13 pages
|
|
11
|
0
|
Financial Planning Recommendations |
Recommendations.xlt
|
Personalized
|
|
1
|
0
|
Financial Planning Recommendations Cover
Sheet
|
Recommendations.xlt
|
Cover Sheet
|
|
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 Only
|
Funding.xlt
|
Client
|
|
Repeat
|
0
|
Funding Requirements For Retirement - Joint
|
Funding.xlt
|
Joint
|
|
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
|
Risk Tolerance Questionnaire |
Portfolio.xlt
|
Risk
|
|
1
|
incl
|
Summary of Investment Portfolio |
Portfolio.xlt
|
Summary
|
|
1
|
incl
|
|
|
|
|
|
|
|
Insurance & Estate Planning
|
|
|
|
|
|
Age Last Birthday Calculator
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Age Nearest Birthday Calculator
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Buy Term & Invest the Difference?
|
ULvsTerm.xlt
|
ULvsTerm
|
|
1
|
1
|
Buy Term & Invest the Difference Versus
Whole Life
|
ULvsTerm.xlt
|
WLvsTerm
|
|
1
|
1
|
Buy Term & Invest the Difference - with
Side Fund
|
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
|
0
|
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
|
|
Repeat
|
0
|
Leverage Investment Portfolio with
Universal Life
|
Leverage.xlt
|
Leverage&UL
|
|
1
|
incl
|
Life Expectancy Tables for Australia
|
Rates.xls
|
LE
|
|
1
|
0
|
Life Insurance Calculator
|
Calculators.xlt
|
Life
|
|
Repeat
|
0
|
Long Term Care Analysis
|
Disability.xlt
|
LTC
|
|
1
|
incl
|
Mortality Rate Tables
|
Rates.xls
|
Mortality
|
|
1
|
0
|
Pension Maximization
|
Pensions.xlt
|
Pensions Max.
|
|
Repeat
|
0
|
Prepaid Pension Maximization
|
Pensions.xlt
|
Prepaid Pension Max.
|
|
Repeat
|
0
|
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
|
|
TD versus Annuity
|
Annuity.xlt
|
TDvsAnn
|
|
1
|
1
|
TD versus Insured Annuity
|
Annuity.xlt
|
TDvsIns
|
|
1
|
1
|
|
|
|
|
|
|
|
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
|
RSAIncome.xlt
|
Transfers
|
|
1
|
incl
|
Growth of an Investment with variables
|
ReturnRt.xlt
|
Variable
|
|
1
|
incl
|
Investment Account Projections
|
Retire.xlt
|
Invest
|
|
1
|
incl
|
Late Settlement Invoice
|
Calculators.xlt
|
LateSettle
|
|
Repeat
|
0
|
Leverage Scenarios
|
Leverage.xlt
|
Scenarios
|
|
1
|
incl
|
Leverage Investment Portfolio
|
Leverage.xlt
|
Leverage
|
|
1
|
incl
|
|
Leverage 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
|
Rates of Return - 20 year Returns by asset
Class
|
Rates.xls
|
Rates of Return
|
|
1
|
1
|
Revenue Property 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
|
|
Repeat |
0
|
Summary of Investment Portfolio - Cover
Page
|
Portfolio.xlt
|
Cover Page
|
|
1
|
0
|
Summary of Other Securities
|
Portfolio.xlt
|
Other
|
|
1
|
0
|
Superannuation Retirement Account
Projections
|
Retire.xlt
|
Lump Sum Calculator
|
|
1
|
0 |
Systematic Withdrawal Plan (SWP)
|
SWIP.xlt
|
Report
|
|
1
|
1
|
|
Tax Deferred vs. Leverage Investment |
Leverage.xlt
|
IRAvsLeverage |
|
1
|
1
|
Tax Sheltered vs. Same Amount to Reduce Leverage loan
|
Leverage.xlt
|
IRAvsLoanServ
|
|
1
|
1
|
| |
|
|
|
|
|
|
Loans
|
|
|
|
|
|
Accelerated Mortgage Amortization (Quick
Pay)
|
Amortize.xlt
|
QuickPay
|
|
1
|
0
|
Accrued Interest Calculator
|
Calculators.xlt
|
DIY
|
|
Repeat
|
0
|
Day Calculator
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Debt Service Strategy
|
Loans.xlt
|
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
|
Nominal Interest Rate Calculator
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Number of Periods Calculator (n)
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Payment Calculator (pmt)
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Present Value Calculator (pv)
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Rate Calculator (i)
|
Calculators.xlt
|
Calculators
|
|
Repeat
|
0
|
Refinancing Feasibility
|
Amortize.xlt
|
Re-Finance
|
|
1
|
0
|
|
|
|
|
|
|
|
Retirement
|
|
|
|
|
|
|
Comparison of Deferred Pension to Private |
RSAIncome.xlt
|
Transfers
|
|
Repeat |
0
|
|
Deferred Tax Liability From Tax Sheltered Investments
|
RSAIncome.xlt
|
RSA Tax
|
|
1
|
1
|
Effect of Recommendations on Tax Payable |
Tax.xlt
|
Recommendations
|
|
Repeat
|
0
|
Funding Requirements For Retirement -
Client
|
Funding.xlt
|
Client
|
|
Repeat
|
0
|
Funding Requirements For Retirement - Joint |
Funding.xlt
|
Joint
|
|
Repeat
|
0
|
Individual Superannuation Fund Projections
|
Retire.xlt
|
Contributions
|
|
1
|
0
|
|
Pension Plan Calculations
|
Pensions.xlt
|
Defined Benefit
|
|
1
|
0
|
Pension Plan Projections
|
Pensions.xlt
|
Money Purchase
|
|
1
|
0
|
Pension Salary Calculations
|
Pensions.xlt
|
Earnings
|
|
1
|
0
|
Prepaid Pension Maximization
|
Pensions.xlt
|
Prepaid Pension Max.
|
|
Repeat
|
0
|
|
Projected Growth of a Tax Sheltered Vs. Open Investment |
Retire.xlt
|
RSAvsOpen |
|
1
|
0
|
Retirement Calculator
|
Calculators.xlt
|
Retire
|
|
Repeat
|
0
|
Retirement Savings Plan - Monthly
Illustration
|
RSAIncome.xlt
|
RSA-IRA
|
|
1
|
inc
|
Superannuation Retirement Account
Projections
|
Retire.xlt
|
Report
|
|
1
|
0
|
Superannuation Withdrawal Factors for
Australia
|
RSAIncome.xlt
|
Super%
|
|
1
|
0
|
Superannuation Income Illustration
|
RSAIncome.xlt
|
Income
|
|
1
|
inc
|
|
|
|
|
|
|
|
Taxation
|
|
|
|
|
|
Analysis of Annuity Income
|
Annuiy.xlt
|
Annuity
|
|
1
|
incl
|
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
|
|
Deferred Tax Liability From Tax Sheltered Investments
|
RSAIncome.xlt
|
RSA Tax
|
|
Repeat
|
0
|
Effect of Recommendations on Tax Payable |
Tax.xlt
|
Recommendations
|
|
1
|
1
|
Gross Income Requirements for Retirement
|
Tax.xlt
|
PreTaxCalc
|
|
1
|
1
|
Income Tax Payable
|
Tax.xlt
|
TaxBill
|
|
1
|
1
|
Income Tax Rates
|
Rates.xls
|
Data Entry
|
|
1
|
0
|
Income Tax Rates - Current Year
|
Rates.xls
|
Current Year
|
|
1
|
0
|
Income Tax Rates - Prior Year
|
Rates.xls
|
Prior Year
|
|
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 Annuity Income
|
Annuiy.xlt
|
Annuity
|
|
Repeat
|
0
|
Calculation of Market Value Adjustment
|
MVACalc.xlt
|
Calculate
|
|
1
|
0
|
Client Data Entry Links
|
Data.xls
|
Data Entry
|
|
1
|
0
|
Disclosure Letter
|
Recommendations.xlt
|
Disclosure
|
|
1
|
0
|
Index of Calculators
|
Calculators.xlt
|
Index
|
|
1
|
0
|
Inflation Over the Last Thirty Years (CPI)
|
Rates.xls
|
CPI
|
|
1
|
0
|
Financial Planning Spreadsheets Order Form
|
N/A
|
|
|
0
|
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
|
R
|
0 |
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
|
Division
|
|
1
|
0
|
Separation / Divorce - Income Analysis
|
Separation.xlt
|
Separate
|
|
Repeat
|
0
|
Separation / Divorce - Projected Growth of
Net Worth
|
Separation.xlt
|
Projected
|
|
1
|
inc
|
|
Software License Renewal Form
|
N/A
|
|
|
0
|
0
|
|
|
|
|
|
|
|
Menu Items
|
156
|
Reports & Charts
|
|
122
|
32
|
