Financial planning software

profileAbhiptl
  • 3 years ago
  • 20
files (2)

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