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

$1)$ How much will we have to invest today at an annual rate of $10\%$ to get the $40,000$ USD? $2)$ If you only have $ $15,000$ to invest, what should the rate be to reach $ $40,000?$