David Rowell: Attempt 1 Question 7 (20 points) For someone who has $100,000 today and wants to save it for 20 years, would a 4% Certificate of Deposit that compounds annually be a better deal than a 3.90% Certificate of Deposit that compounds quarterly? Why? Name the type of the problem Show excel inputs Solve problem: A. State the value of of the CD with annual compounding B. State the value of the CD with quarterly compounding C. State the CD that you would choose to invest in