This is Video 1 of the full build-out series of an Excel Based Financial & Retirement Planning Calculator and Income Projector.
00:00 Pre-Retirement Financial Planning
00:31 Calculate Current Net Worth (Step 1)
00:55 Calculate After Tax Cash Flow (Steps 2 - 4)
02:07 When Do You Want To Retire (Step 5)
02:48 Project Income & Net Worth to Retirement Year (Steps 6 - 7)
04:44 Inflation, Emergency Fund, Income Taxes & Other Factors
05:59 Define Goal Year & Residual Value
06:53 Income Planning After Retirement
07:30 Retirement Changes to Income & Expenses
08:50 Command Center (Dashboard) for the Financial Planner
09:46 Detail Analysis Assets, Debts, Income, Net Worth
11:52 Non Tax Advantaged Investment Accounts
12:29 Pre-tax Investment Accounts - 401(k) & IRA
13:10 Health Savings Accounts - HSA & FSA
13:46 Real Property & Personal Property
15:20 Debts, Loans, Liabilities, Credit Cards, Debt in Arrears
17:25 Interest, Dividends, Market Return, ROR, Capital Gain
21:48 Income Rate of Return (Percentage Yield)
23:43 Market Rate of Return (Percentage Yield)
24:21 Determine Your Net Worth at December 31
27:19 Interest & Dividend Yield x Beginning Account Balance
29:34 Asset Appreciation vs Asset Depreciation
31:10 Capital Gain Calculations
36:49 Selling Assets Fees & Disposal Costs
38:07 Free Cash Flow Allocation to Net Worth
40:32 Assets Increasing & Liabilities Decreasing
41:37 HSA Distributions are not Taxable if used for Medical
43:47 Reallocation of Assets, Liabilities, and Net Worth
#retirementplanning #retirementstrategy #financialplanning
コメント