Please show me how to do this with Excel or a financial calculator.

WGU prin jples financei 3 mil quiz 520d Secure ewiareisurrrrrra Question 2 of 3 Points: 0 out of 10 rue or false. In 5 years, you plan to purchase a house. You will need a down payment of S20,000. If a 5-year certificate deposit pays 10% compounded quarterly, you will have to deposit $3,055.40 at the beginning of every year to have enough for the down payment. Ha se Incorrect. You will have to deposit s3,055.40. due orcl FVs +r/4. CF +r/4 20,000 CF 1- 10/4. 20 (1+,025 $763.85 x 4 $3,055.40 Question 3 of 3 Points: 20 out of 20 ou plan on taking out a mortgage for $200,000 and must choose between a 15-year mortgage at 3.75% and a 30-year mortgage at 5.0%. The monthly 8:45 PM a