Question

In: Finance

You have just started a new job and your employer has enrolled you in KiwiSaver. This...

You have just started a new job and your employer has enrolled you in KiwiSaver.

This is the first time you have been enrolled in KiwiSaver and you decide not to “opt out”.

You are interested in estimating how much your KiwiSaver fund could be worth when you retire.

You make the following assumptions:

• You have just turned 30 and will retire in exactly 35 years when you are 65.

• Your salary is $50,000 this year and you expect this to increase by 3% every year.

• You can choose to contribute either 3% or 8% of your salary into your KiwiSaver fund each year. https://www.kiwisaver.govt.nz/already/contributions/you/amount/

• Your employer must contribute 3% of your pay into your KiwiSaver fund each year. https://www.kiwisaver.govt.nz/already/contributions/employers/ You can ignore any tax implications and assume your account receives the full 3%. (KIWI SAVER ACC)

• You will be entitled to the annual member tax credit of $521.43 which will be credited into your KiwiSaver fund at the end of every year. https://www.kiwisaver.govt.nz/new/benefits/mtc/

• Your KiwiSaver fund will invest in a diversified portfolio of assets to earn a return on your investment. Of course, there is uncertainty around the actual annual rate of return that your fund will earn over the 35 years but you decide that 6% and 12% represent a good range of potential rates of return to conduct your analysis on.

• Regardless of the return earned, the manager of your KiwiSaver fund will charge a management fee of 1.0% at the end of each year, based on the opening balance of your fund each year.

• You will make no withdrawals or additional contributions (other than those mentioned above) to your fund until you retire in 35 years.

• For simplicity, assume that all contributions to your KiwiSaver fund are made once per year, at the end of the year. The first lot of contributions will be made in one year from today.

Construct a spreadsheet that will allow you to answer the following questions on Canvas.

How much will be in your KiwiSaver account when you retire if you contributed 8% of your salary and the fund earned 12%p.a.?

Options:

$2,942,716

$2,361,383

$1,088,765

$897,665

$1,875,698

$2,225,775

Solutions

Expert Solution

Age Opening balance Salary Self contribution Employer contribution Tax credit Management fee (1% of opening balance) Total account balance
31 0.00 50000.00 4000.00 1500.00 521.43 0.00 6021.43
32 6021.43 51500.00 4120.00 1545.00 521.43 60.21 12870.22
33 12870.22 53045.00 4243.60 1591.35 521.43 128.70 20642.32
34 20642.32 54636.35 4370.91 1639.09 521.43 206.42 29444.41
35 29444.41 56275.44 4502.04 1688.26 521.43 294.44 39395.02
36 39395.02 57963.70 4637.10 1738.91 521.43 393.95 50625.91
37 50625.91 59702.61 4776.21 1791.08 521.43 506.26 63283.47
38 63283.47 61493.69 4919.50 1844.81 521.43 632.83 77530.39
39 77530.39 63338.50 5067.08 1900.16 521.43 775.30 93547.40
40 93547.40 65238.66 5219.09 1957.16 521.43 935.47 111535.30
41 111535.30 67195.82 5375.67 2015.87 521.43 1115.35 131717.15
42 131717.15 69211.69 5536.94 2076.35 521.43 1317.17 154340.75
43 154340.75 71288.04 5703.04 2138.64 521.43 1543.41 179681.35
44 179681.35 73426.69 5874.13 2202.80 521.43 1796.81 208044.67
45 208044.67 75629.49 6050.36 2268.88 521.43 2080.45 239770.25
46 239770.25 77898.37 6231.87 2336.95 521.43 2397.70 275235.23
47 275235.23 80235.32 6418.83 2407.06 521.43 2752.35 314858.42
48 314858.42 82642.38 6611.39 2479.27 521.43 3148.58 359104.94
49 359104.94 85121.65 6809.73 2553.65 521.43 3591.05 408491.30
50 408491.30 87675.30 7014.02 2630.26 521.43 4084.91 463591.05
51 463591.05 90305.56 7224.44 2709.17 521.43 4635.91 525041.11
52 525041.11 93014.73 7441.18 2790.44 521.43 5250.41 593548.68
53 593548.68 95805.17 7664.41 2874.16 521.43 5935.49 669899.04
54 669899.04 98679.33 7894.35 2960.38 521.43 6698.99 754964.09
55 754964.09 101639.71 8131.18 3049.19 521.43 7549.64 849711.93
56 849711.93 104688.90 8375.11 3140.67 521.43 8497.12 955217.46
57 955217.46 107829.56 8626.37 3234.89 521.43 9552.17 1072674.06
58 1072674.06 111064.45 8885.16 3331.93 521.43 10726.74 1203406.72
59 1203406.72 114396.38 9151.71 3431.89 521.43 12034.07 1348886.50
60 1348886.50 117828.28 9426.26 3534.85 521.43 13488.86 1510746.55
61 1510746.55 121363.12 9709.05 3640.89 521.43 15107.47 1690800.04
62 1690800.04 125004.02 10000.32 3750.12 521.43 16908.00 1891059.92
63 1891059.92 128754.14 10300.33 3862.62 521.43 18910.60 2113760.90
64 2113760.90 132616.76 10609.34 3978.50 521.43 21137.61 2361383.87
65 2361383.87 136595.26 10927.62 4097.86 521.43 23613.84 2636683.01
From the schedule above we know that the final balance is 2,636,683
The options don't mention this number however after year 64, the account has: 2,361,383.87 is calculated. The options include the number 2,361,383

Related Solutions

You have just started a new job and your employer has enrolled you in KiwiSaver. This...
You have just started a new job and your employer has enrolled you in KiwiSaver. This is the first time you have been enrolled in KiwiSaver and you decide not to “opt out”. You are interested in estimating how much your KiwiSaver fund could be worth when you retire. You make the following assumptions: • You have just turned 30 and will retire in exactly 35 years when you are 65. • Your salary is $50,000 this year and you...
You have just started a new job and your employer has enrolled you in KiwiSaver. This...
You have just started a new job and your employer has enrolled you in KiwiSaver. This is the first time you have been enrolled in KiwiSaver and you decide not to “opt out”. You are interested in estimating how much your KiwiSaver fund could be worth when you retire. You make the following assumptions: • You have just turned 30 and will retire in exactly 35 years when you are 65. • Your salary is $50,000 this year and you...
You have just started a new job and your employer has enrolled you in KiwiSaver. This...
You have just started a new job and your employer has enrolled you in KiwiSaver. This is the first time you have been enrolled in KiwiSaver and you decide not to “opt out”. You are interested in estimating how much your KiwiSaver fund could be worth when you retire. You make the following assumptions: • You have just turned 30 and will retire in exactly 35 years when you are 65. • Your salary is $50,000 this year and you...
Task 1 You have just started a new job and your employer has enrolled you in...
Task 1 You have just started a new job and your employer has enrolled you in ANZ savings fund scheme. This is the first time you have been enrolled in the savings fund scheme of ANZ and you decide not to “opt out”. You are interested in estimating how much your savings fund could be worth when you retire. You make the following assumptions: • You have just turned 30 and will retire in exactly 35 years when you are...
You have just started a new job and are thrilled to learn that your new employer...
You have just started a new job and are thrilled to learn that your new employer offers a 401(k) retirement plan to its employees. Your annual salary is $40,000. Assume the IRS allows you to contribute up to $24,000 to your 401(k). You’ve decided to contribute 7% of your annual salary to the plan. Questions: How much more money would you need to contribute to meet the maximum allowable contribution set forth by the IRS? The company offers you a...
Today is March 30, 2018, and you have just started your new job with a financial...
Today is March 30, 2018, and you have just started your new job with a financial planning firm. In addition to studying for all your license exams, you have been asked to review a portion of a client’s stock portfolio to determine the risk/return profiles of 12 stocks in the portfolio. Unfortunately, your small firm cannot afford the expensive databases that would provide all this information with a few simple keystrokes, but that’s why they hired you. Specifically, you have...
You have just started a new job that offers a retirement savings account. You have two...
You have just started a new job that offers a retirement savings account. You have two options: You can invest 5% of your monthly wages at 2% OR You can invest 4% of your monthly wages at 4%. Both are compounded monthly. b. Assume that you will always make $45,000 annually, how much will you have saved with the better plan after 15 years? c.Assume that you will always make $45,000 annually, how much will you have saved with the...
You have just started a new job with a significant increase in salary above what you...
You have just started a new job with a significant increase in salary above what you were earning when you originally negotiated your student loan repayment. The salary increase affords you the opportunity of increasing your monthly loan payments, thereby allowing you to retire the debt sooner than originally planned. You have six years remaining in the original payback plan on a loan of $55,000, with an interest rate of 2.4% and a monthly payment of $566.74. With your new...
You are a financial planner for Kelly Roberts. Kelly has just started a new job as...
You are a financial planner for Kelly Roberts. Kelly has just started a new job as an IT programmer for the Australian government. They will pay her a salary of AUD$70,000 p.a. She expects her salary to grow at 3% p.a. each year based on previous data. Inflation in Australia is 1%. After a detailed discussion, she has decided that she will deposit 20% of her salary by automatic withdrawals: half into a TFSA; half into a taxable account. The...
Assume that you have 40 years until retirement and have just started your first job. Once...
Assume that you have 40 years until retirement and have just started your first job. Once you retire, you anticipate that you will live for 30 additional years. Assume that you will require $100,000 per year to support yourself in retirement. All investments that you make will go into and stay an account that returns 7.8% per year (however much you have at retirement will sit that account and continue to accrue interest on the remaining balance. How much will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT