On January $1,$ Quotor, Inc. issued a $10-$year monthly bond with a face value of $$1,955,000$ that pays $6\mathrm{.}0\%$ interest. On the date of issue,Victoria deposits $$4,500$ in a bank account that pays $8\mathrm{.}1\%$ interest compounded monthly. In $14$ years, how much does she have in this

account?

Time Value of Money $($TVM$)$ Framework

What Excel function and arguments to that function would you use to compute this value?

$=$ function$($ rate $,$ nper, pmt $,[$PV$],[$type$])$

What is the compounding factor that would be used to compute the growth of the principal after one year? $1\mathrm{.}084$

the market for similar bonds was $8\mathrm{.}0\%.$ How much was Quotor able to raise from issuing this bond?

For numerical entries, please

do NOT enter commas

do NOT enter the dollar symbol: $

DO enter the percent symbol when it is needed: $\%$

enter dollar amounts to the nearest cent, for example: $12345\mathrm{.}67$

Cash Flow Diagram

Please complete the TVM Framework table to compute the amount that Quotor was able to raise by issuing this bond.

Time Value of Money $($TVM$)$ Framework

What Excel function and arguments to that function would you use to compute this value?

$=$function$($ rate $,$ nper, pmt $,[$FV$],[$type$])$

$,$