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 problem. Please use excel to solve it