Pleese only on excel

Formative $1$ week $2$

Find the solutions for the below exercises using Excel, at the end of the assessment you have to present the Excel sheet

Financial functions:

$=$ PMT $($rate; nper; pv; fv; type$)$

$=$ FV $($rate; nper; PMT; pv; type$)$

$=$ NPER $($rate; PMT; pv; fv; type$)$

$=$ RATE $($nper; PMT; pv; fv; type$)$

$=$ PV $($rate; nper; PMT; fv; type$)$

Exercise$1$:

We place $10,000$ Euros at an annual rate of $8\mathrm{.}25\%$ for $10$ years. What is the acquired value after $10$ years?

You buy a coffee shop by paying $10$ annuities of $60,000$ Euros paid at the beginning of the year, the first payment being made on the date of acquisition. Knowing that the interest rate is $7\%$ what is the purchase price.

We borrow a sum repayable in $15$ installments of $10,000$ Euros each paid at the end of the period. The interest rate being at $12\%$ what is the loan amount?

Exercise $2$:

Bank A offers certificates of deposits at annual rates of $6\%.$ Bank B offers a product that pays monthly coupons at an annual rate of $5\mathrm{.}75\%.$

Which product do you prefer, knowing that you want to invest your money over two years without withdrawing it$?$

Exercise $3$:

After $7$ years, the cost for each study year will be $40,000$ USD.

How much will we have to invest today at an annual rate of $10\%$ to get the $40,000$ USD?

If you only have $$15,000$ to invest, what should the rate be to reach $$40,000?$

Exercise $4$:

For how long must a sum be deposited in an account paying $14\%$ compound interest in order to double in value?

Exercise $5$:

At the end of each quarter, a $50-$yearoldwoman puts $$3000$ in a retirement account that pays $5\%$ interest compounded quarterly. When she reaches $60,$ she withdraws the entire amount and places it in a mutual fund that pays $6\mathrm{.}9\%$ interest compounded monthly. From then on she deposits $$300$ in the mutual fund at the end of each month. Howmuch is in the account when she reaches age $65?$

Exercise $6$:

Mateo sells some land in Malta. She will be paid a lump sum of $$60,000$ in $7$ years. Until then, the buyer pays $8\%$ simple interest quarterly.

Find the amount of each quarterly interest payment on the $$60,000.$

The buyer sets up a sinking fund so that enough money will be present to pay off the $$60,000.$ The buyer will make semiannual payments into the sinking fund; the account pays $6\%$ compounded semiannually. Find the amount of each payment into the fund.

Formative $1$ week $2$

Find the solutions for the below exercises using Excel, at the end of the assessment you have to present the Excel sheet

Financial functions:

$=$ PMT $($rate; nper; pv; fv; type$)$

$=$ FV $($rate; nper; PMT; pv; type$)$

$=$ NPER $($rate; PMT; pv; fv; type$)$

$=$ RATE $($nper; PMT; pv; fv; type$)$

$=$ PV $($rate; nper; PMT; fv; type$)$

Exercise$1$:

We place $10,000$ Euros at an annual rate of $8\mathrm{.}25\%$ for $10$ years. What is the acquired value after $10$ years?

You buy a coffee shop by paying $10$ annuities of $60,000$ Euros paid at the beginning of the year, the first payment being made on the date of acquisition. Knowing that the interest rate is $7\%$ what is the purchase price.

We borrow a sum repayable in $15$ installments of $10,000$ Euros each paid at the end of the period. The interest rate being at $12\%$ what is the loan amount?

Exercise $2$:

Bank A offers certificates of deposits at annual rates of $6\%.$ Bank B offers a product that pays monthly coupons at an annual rate of $5\mathrm{.}75\%.$

Which product do you prefer, knowing that you want to invest your money over two years without withdrawing it$?$

Exercise $3$:

After $7$ years, the cost for each study year will be $40,000$ USD.

How much will we have to invest today at an annual rate of $10\%$ to get the $40,000$ USD?

If you only have $$15,000$ to invest, what should the rate be to reach $$40,000?$