Mike is looking to build his wealth and live the Kiwi dream. He has given you $($his financial planner$)$ the following information:

$->$ In his new role he will be earning $$65,000$ per year.

$->$ He is $30$ years old and plans to retire at $65.$

$->$ Once he retires he will need $80\%$ of his income.

$->$ He wants to buy his first house in $5$ years, which should require a deposit of $$200,000.$

$->$ He is also planning to travel every year until he retires, spending todays equivalent

$$3,000$ on each trip.

$->$ He expects his investment portfolio to earn $10\%$ per annum.

$->$ General inflation should hover around $4\mathrm{.}9\%.$

$->$ He currently has $$50,000$ saved up towards his house purchase. Calculate the $1.$ Present Value of Retirement Goals Mike need to save per year $,$ until he is $65$ years old, in order to meet all his goals? $2.$ Present value of House deposit goals Mike need to save per year $,$ until he is $65$ years old, in order to meet all his goals? $3.$Present value of travel goals Mike need to save per year $,$ until he is $65$ years old, $,$ in order to meet all his goals?

Please attach:

$->$ Excel printout showing workings.