Financial planning software
3 years ago
20
naviplanfinal.pdf
- CFP201NMM_Assignment1-2_MarySavona_22371.docx
naviplanfinal.pdf
Financial Analysis PREPARED FOR: PREPARED BY:
Zeeshan Vadsaria
Toronto, Ontario
Groww Financial Group Pvt Ltd
Abhi Patel
Toronto, Ontario
Groww Financial Group Pvt Ltd
Michael and Gabriella Sinoma
October 18, 2023
Table of Contents
Cover Page 1
Table of Contents 2
Obejctives 3
Plan Analysis Synopsis 4
Cash Flow Surplus/(Deficit) - Current Plan 8
What Are My Retirement Goal Options? - Current Plan 10
What Are My Education Goal Options? - Current Plan - University Education (Andre) 11
What Are My Major Purchase Goal Options? - Current Plan - Work Abroad (Joint) 12
OBJCETIVES OF MICHAEL AND GABRIELLA SIMONA
Retirement Goal:
Michael and Gabriella want them to retire when Gabriella turns 63.
However, they are willing to work till the age of 65 if necessary. They
have a goal of retiring with $80,378 per year after tax income (in today’s
dollars).
Educational Goal:
They want to fund their son Andre’s 4 years of post-secondary
education. They expect to have $17,932 (in today’s dollars) to ensure
smooth education till he completes the post-secondary education.
Major Purchase Goal:
The couple also want to fund their son’s gap year of work before the
funding for the educational purpose with a total of no more than $24,351
(in today’s dollar)
Plan Analysis Synopsis
Client Information
Michael Sinoma Gabriella Sinoma
Birth Date 1988/11/30 1989/06/21
45 Crescent Circle 45 Crescent Circle
North York, Ontario M4S 1R2 North York, Ontario M4S 1R2
Canada Canada
Citizenship Canada Canada
Family Member Information
Name Birth Date Age as of Plan Date Relationship Dependant of
Andre Sinoma 2013/12/05 9 Son Both
Advisor Information
Name Advisor Type Business Phone Cell Phone
Zeeshan Vadsaria Advisor (473) 473-4237
Abhi Patel Advisor (647) 898-2416
Plan Assumptions
Individual Assumptions Michael Sinoma Gabriella Sinoma
Retirement Date 2049/11/01 2050/06/01
Life Expectancy 90 90
Shared Assumptions
Marital Status Married
Income Tax Method Detailed Tax
Inflation Rate 3.00%
Elect to Split Pension Income Yes
Estate Assumptions
Detail Michael Gabriella
Is there a will? No Yes
Last revised? n/a 2023/10/18
Where are the wills kept? n/a
Important: The calculations or other information generated by NaviPlan® version 23.8 regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect
actual investment results, and are not guarantees of future results. These calculations are shown for illustrative purposes only because they utilize return data that may not include fees or
operating expenses, and are not available for investment. If included, fees and other operating expenses would materially reduce these calculations.
Prepared by Zeeshan Vadsaria & Abhi Patel Page 4 of 12
Address
Income Information
Regular Income Source Member Applicable Current Amount Indexed By
Salary Michael 2023/01/01 to
2049/10/31 $2,875/bi-wk 3.00%
Salary Gabriella 2023/01/01 to
2050/05/31 $3,891/bi-wk 3.00%
CPP/QPP & OAS Information
Description Michael Sinoma Gabriella Sinoma
CPP/QPP Benefits Start On 2049/12/01 2050/07/01
OAS Benefits Start On 2053/12/01 2054/07/01
OAS Deferred Benefit Bonus 0.0% 0.0%
Qualify for % of Max CPP/QPP Benefits 100% 100%
Qualify for % of OAS Benefits 100% 100%
Expense Information
Expense
Description
Member Period Applicable Current Amount Frequency Indexed By Fixed?
Regular Expenses
Housing (e.g.
utilities, repairs) Joint
2023/01/01 to
2049/10/31 $2,175 Monthly 3.00% Yes
Food Joint 2023/01/01 to
2049/10/31 $1,503 Monthly 3.00% Yes
Transportation
(e.g. gas,
insurance)
Joint 2023/01/01 to
2049/10/31 $1,153 Monthly 3.00% Yes
Entertainment
(e.g. restaurants,
movies)
Joint 2023/01/01 to
2049/10/31 $1,032 Monthly 3.00% No
Personal (e.g.
clothing, hobbies) Joint
2023/01/01 to
2049/10/31 $446 Monthly 3.00% Yes
Communications Joint 2023/01/01 to
2049/10/31 $623 Monthly 3.00% Yes
Travel Joint 2023/01/01 to
2049/10/31 $8,718 Annual 3.00% Yes
Property Taxes Joint 2023/01/01 to
2049/10/31 $6,993 Annual 3.00% Yes
University
Education Andre
2032/01/01 to
2035/12/31 $17,932 Annual 5.00% No
Retirement
Expense Joint
2049/11/01 to
2079/12/31 $6,698 Monthly 3.00% Yes
Important: The calculations or other information generated by NaviPlan® version 23.8 regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect
actual investment results, and are not guarantees of future results. These calculations are shown for illustrative purposes only because they utilize return data that may not include fees or
operating expenses, and are not available for investment. If included, fees and other operating expenses would materially reduce these calculations.
Prepared by Zeeshan Vadsaria & Abhi Patel Page 5 of 12
Expense Description Member Date to be
Incurred
Amount in Current
$
Amount to be Incurred
Lump-Sum Expenses
Car Joint 2022/04/01 $60,000 $58,252
Work Abroad Joint 2032/01/01 $24,351 $31,773
Lifestyle Asset Information
Asset Asset Type Owner Purchase Date Purchase
Amount
Market Value Value as of Current
Pre-Tax
Growth
Car
Personal
Use
Property
Joint 2022/04/01 $60,000 $40,000 2023/10/10 -10.00%
Home Principal
Residence Joint 2022/12/31 $0 $1,000,000 2023/10/10 2.00%
Portfolio Assets
Market
Value Date
Market
Value
Cost Base Int. Div. Cap.
Gains
Def.
Growth
Total
Return
Std.
Dev.
Annual
Account
Fee
Reinvest
Income?
Account Name: Chequing (Joint/Non-Registered) Goal: Emergency Fund
2023/10/10 $2,500 $2,500 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.00% Yes
Account Name: Chequing (Joint/Non-Registered) Goal: Unallocated
2023/10/10 $2,500 $2,500 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.00% Yes
Account Name: RRSP (Gabriella/Group RRSP) Goal: Retirement
2023/10/10 $125,000 $0 0.00% 1.12% 1.33% 2.51% 4.96% 14.43% 2.00% Yes
Account Name: RESP (Michael/Gabriella) Goal: Unallocated
2023/10/10 $9,000 $10,000 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.00% Yes
Account Name: TFSA (Andre/Gabriella) Goal: Work Abroad
2023/10/10 $6,000 $6,000 1.00% 0.00% 0.00% 0.00% 1.00% 0.00% 2.00% Yes
Account Name: TFSA (Michael) Goal: Retirement
2023/10/10 $15,000 $15,000 3.00% 0.00% 0.00% 0.00% 3.00% 0.00% 2.00% Yes
Account Name: TFSA (Gabriella) Goal: Retirement
2023/10/10 $15,000 $15,000 3.00% 0.00% 0.00% 0.00% 3.00% 0.00% 2.00% Yes
Note: The Portfolio Assets table includes a breakdown of the return rates by return type for your investment accounts. Interest returns are taxed as ordinary income at
the marginal tax rate. Dividends receive preferential tax treatment, while one-half the capital gains are taxed at the marginal tax rate. Income from the deferred
growth component is not subject to tax until the asset is sold and is usually taxed as a capital gain. The actual total return rates that you will receive will depend on
many factors, including inflation, type of investment, market conditions and investment performance.
Important: The calculations or other information generated by NaviPlan® version 23.8 regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect
actual investment results, and are not guarantees of future results. These calculations are shown for illustrative purposes only because they utilize return data that may not include fees or
operating expenses, and are not available for investment. If included, fees and other operating expenses would materially reduce these calculations.
Prepared by Zeeshan Vadsaria & Abhi Patel Page 6 of 12
Education Goals
University Education: Expenses
Member Start Year End Year Annual Amount (at Present) Total Projected Cost
Andre 2032 2035 $17,932 $119,901
*There are no assets allocated to this goal.
Major Purchase Goals
Member Asset Type Purchase Date Purchase Amount
(Today's $)
Projected Purchase
Amount
Joint Expense 2032/01/01 $24,351 $31,773
Work Abroad (Joint)
Account Market Value Date Value Allocated to this
Goal
Growth Rate
Assets Allocated To Work Abroad
TFSA (Andre) 2023/10/10 $6,000 1.00%
Savings Strategies
Account Saved To Applicable Amount Indexed By
RRSP - Employer Contribution 2023/01/01 to 2050/05/31 5.00% /mo n/a
RRSP - Employee Contribution 2023/01/01 to 2050/05/31 4.00% /mo n/a
Note: A percentage value in the Amount column indicates the portion of salary that is being saved. These income percentages use the salary's index rate.
Liquidation Order During Retirement
Account Account Type Owner
TFSA (Andre) TFSA Gabriella
TFSA TFSA Michael
TFSA TFSA Gabriella
RRSP Group RRSP Gabriella
Note: The assets listed above are available and will be redeemed in the order they appear to meet cash flow needs during the retirement period.
Important: The calculations or other information generated by NaviPlan® version 23.8 regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect
actual investment results, and are not guarantees of future results. These calculations are shown for illustrative purposes only because they utilize return data that may not include fees or
operating expenses, and are not available for investment. If included, fees and other operating expenses would materially reduce these calculations.
Prepared by Zeeshan Vadsaria & Abhi Patel Page 7 of 12
Current Plan
Cash Flow Surplus/(Deficit)
This report displays the total cash amount remaining after covering all expenses by projecting annual end-of-year cash
flow surplus or deficit through the duration of the analysis.
Year Age Total Inflows Total Outflows Surplus/(Deficit)
2023 35/34 $176,304 $146,982 $29,322
2024 36/35 $181,763 $151,624 $30,139
2025 37/36 $187,222 $156,379 $30,843
2026 38/37 $192,851 $161,037 $31,814
2027 39/38 $198,642 $165,834 $32,808
2028 40/39 $204,601 $170,775 $33,826
2029 41/40 $210,739 $175,865 $34,874
2030 42/41 $217,061 $181,107 $35,954
2031 43/42 $223,573 $186,506 $37,067
2032 44/43 $235,042 $250,587 ($15,546)
2033 45/44 $245,529 $228,957 $16,572
2034 46/45 $243,528 $233,294 $10,234
2035 47/46 $250,834 $240,904 $9,930
2036 48/47 $258,359 $216,031 $42,328
2037 49/48 $266,110 $222,478 $43,632
2038 50/49 $274,093 $229,118 $44,975
2039 51/50 $282,316 $235,957 $46,359
2040 52/51 $290,785 $243,002 $47,784
2041 53/52 $299,509 $250,258 $49,251
2042 54/53 $308,494 $257,731 $50,763
2043 55/54 $317,749 $265,429 $52,320
2044 56/55 $339,869 $277,542 $62,327
2045 57/56 $337,100 $281,524 $55,576
2046 58/57 $347,213 $289,935 $57,278
2047 59/58 $357,629 $298,599 $59,030
2048 60/59 $368,358 $307,673 $60,686
2049 *61/60 $357,361 $308,486 $48,874
2050 62/61* $204,850 $204,850 $0
2051 63/62 $215,762 $215,762 $0
* = year of retirement
Important: The calculations or other information generated by NaviPlan® version 23.8 regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect
actual investment results, and are not guarantees of future results. These calculations are shown for illustrative purposes only because they utilize return data that may not include fees or
operating expenses, and are not available for investment. If included, fees and other operating expenses would materially reduce these calculations.
Prepared by Zeeshan Vadsaria & Abhi Patel Page 8 of 12
Year Age Total Inflows Total Outflows Surplus/(Deficit)
2052 64/63 $222,215 $222,215 $0
2053 65/64 $223,416 $223,416 $0
2054 66/65 $224,708 $224,708 $0
2055 67/66 $231,403 $231,403 $0
2056 68/67 $238,300 $238,300 $0
2057 69/68 $228,040 $239,733 ($11,693)
2058 70/69 $133,147 $222,606 ($89,458)
2059 71/70 $137,142 $229,248 ($92,106)
2060 72/71 $141,256 $236,090 ($94,834)
2061 73/72 $145,494 $243,438 ($97,944)
2062 74/73 $149,859 $250,696 ($100,838)
2063 75/74 $154,579 $258,229 ($103,651)
2064 76/75 $163,143 $266,917 ($103,774)
2065 77/76 $169,465 $275,239 ($105,774)
2066 78/77 $174,549 $283,452 ($108,902)
2067 79/78 $179,786 $291,911 ($112,125)
2068 80/79 $185,179 $300,623 ($115,444)
2069 81/80 $190,735 $309,598 ($118,863)
2070 82/81 $196,457 $318,841 ($122,384)
2071 83/82 $202,350 $328,362 ($126,011)
2072 84/83 $208,421 $338,168 ($129,747)
2073 85/84 $214,674 $348,269 ($133,595)
2074 86/85 $221,114 $358,672 ($137,558)
2075 87/86 $227,747 $369,388 ($141,641)
2076 88/87 $234,580 $380,425 ($145,845)
2077 89/88 $241,617 $391,793 ($150,176)
2078 90/89 $251,365 $406,002 ($154,637)
2079 -/90 $3,186,339 $3,469,055 ($282,717)
* = year of retirement
Important: The calculations or other information generated by NaviPlan® version 23.8 regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect
actual investment results, and are not guarantees of future results. These calculations are shown for illustrative purposes only because they utilize return data that may not include fees or
operating expenses, and are not available for investment. If included, fees and other operating expenses would materially reduce these calculations.
Prepared by Zeeshan Vadsaria & Abhi Patel Page 9 of 12
Current Plan
What Are My Retirement Goal Options?
The graph below shows that you will start to run out of assets by age 69/68. The accumulated shortfall for retirement is
$2,779,717.00. To obtain the desired retirement income needs, the analysis suggests additional capital will be needed at
retirement age 61/60. Altering your retirement spending, saving more each month, saving a lump sum, retiring at a
different age, and increasing return by taking on more risk are all strategies that can help you reach your retirement goal.
Consider using any of these options alone, or a combination of several to reach 100% goal coverage.
2049 2052 2055 2058 2061 2064 2067 2070 2073 2076 2079
$0
$100,000
$200,000
$300,000
$400,000
CPP/QPP/OAS Other Income Asset Withdrawals Shortfall
Alter Spending OR Save Monthly OR Save a Lump Sum OR Retire In
Cover 69% ($55,459) of
expenses
Increase your monthly savings
by $2,581
Save $502,420 Michael retires in
11/2056 at age 68
Gabriella retires in 6/2057
at age 68
Important: The calculations or other information generated by NaviPlan® version 23.8 regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect
actual investment results, and are not guarantees of future results. These calculations are shown for illustrative purposes only because they utilize return data that may not include fees or
operating expenses, and are not available for investment. If included, fees and other operating expenses would materially reduce these calculations.
Prepared by Zeeshan Vadsaria & Abhi Patel Page 10 of 12
What Are My Education Goal Options? University Education (Andre) - Current Plan
The total projected cost of education for Andre is $119,901. The graph below shows that you will start to run out of
capital in 2032. Currently, you have an accumulated shortfall in the analysis of ($119,901) that may need to be covered
by student loans in the future. Selecting a less expensive education source, saving more each month, and saving a lump
sum are all strategies that can help you reach your education goals. Consider using any of these options alone or a
combination of several to reach 100% goal coverage.
2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035
($30,000)
($25,000)
($20,000)
($15,000)
($10,000)
($5,000)
$0
EOY Capital Net Withdrawals Shortfall
Alter Spending OR Save Monthly OR Save a Lump Sum
Seek education that costs $0 or less per
year.
Increase your monthly savings by $769. Save $85,697 today.
Important: The calculations or other information generated by NaviPlan® version 23.8 regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect
actual investment results, and are not guarantees of future results. These calculations are shown for illustrative purposes only because they utilize return data that may not include fees or
operating expenses, and are not available for investment. If included, fees and other operating expenses would materially reduce these calculations.
Prepared by Zeeshan Vadsaria & Abhi Patel Page 11 of 12
Work Abroad (Joint) - Current Plan
What Are My Major Purchase Goal Options?
The following options can help you achieve your major purchase goal. You can use any of these options, or a combination
of several options to reach 100% goal coverage.
2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
($25,000)
($20,000)
($15,000)
($10,000)
($5,000)
$0
$5,000
EOY Capital Net Withdrawals Shortfall
Alter Spending OR Save Monthly OR Save a Lump Sum OR Change Purchase Date
To
Cover 17%
($4,139) of expenses
Increase your monthly savings
by $261
Save $24,810 2078/12/31
Important: The calculations or other information generated by NaviPlan® version 23.8 regarding the likelihood of various investment outcomes are hypothetical in nature, do not reflect
actual investment results, and are not guarantees of future results. These calculations are shown for illustrative purposes only because they utilize return data that may not include fees or
operating expenses, and are not available for investment. If included, fees and other operating expenses would materially reduce these calculations.
Prepared by Zeeshan Vadsaria & Abhi Patel Page 12 of 12
- Essay in Firefighting - for Kim woods only
- ACCT 324 Course Projects Discussions Quizzes Midterm and Final Exam Devry
- Human Resource Help. A+++ Paper, Original Work, No Plagiarism Please. APA Format. Minimum 2-3 BODY PAGES, Intro, Abstract, Body, Conclusion, Reference Page
- hey can some one do this for $20
- chemistry quiz
- Fin
- ACC422 - INTERMEDIATE FINANCIAL ACCOUNTING II Week 1 Assignment
- Can you assist me with writing paper for politics class?
- Help with writing this Journal
- BUS 330 Week 5 DQ 2 Marketing Ethics and Children