Your wealthy relative has left you $$3$ million in trust.Your wealthy relative has left you $$3$ million in trust. You will get $$1,000,000$ and the remainder

in four years. If interest rates are about $4\mathrm{.}5\%,$ what is this worth to you now? Use the Principles

of Spreadsheet Design to set up and solve this problemPROBLEM $2$

Inputs

Future value $3,000,000$

Amount received now $1,000,000$

Interest $5\%$

Years $4$

Amount received future $2,000,000$problem problem

Present value $(1,677,123)$