A financial advisor recommends you a savings plan according to

which you will make a payment of $500$ every $6$ months for $5$ years and guarantees a nominal return $2\%$ per annum and compounded semi$-$annually. The $1$st payment will be made today and the last one in $4\mathrm{.}5$

years $($total of $10$ payments$).$ You will receive the savings amount in $5$ years from today.

Calculate:

i$)$ How much money will you receive at the end of $5$ years?

ii$)$ If you were given the option to deposit a lump sum today, what amount would you have to deposit so that at the end of $10$ years you would receive the same amount as in question i$.$ Without making any other interim deposits?

$**$Please show workings also in an excel file.