Calculation questions:

$1\mathrm{.}1.$ Sandy, a manufacturing engineor, just received a year$-$end bonus of $$10,000$ that will

be invested immediately. With the expectation of earning at the rate of $8\%$ per year, Sandy

hopes to take the entire amount out in exactly $20$ years to pay for a family vacation when

the oldest daughter is due to graduate from college. Find the amount of funds that will be

avaitable in $20$ years by using $($a$)$ hand solution by applying the factor formula and tabulated

value, and $($b$)$ a spreadsheet function.