7 Clipboard Font Alignment Number F26 fx A C E F G H 1 VERY IMPORTANT: Before beginning, type your name in the blue cell 2 After typing your name, do not make any more changes to this cell. The yellow cells will update with a 3 unique set of numbers based on your name. Enter your answers in the blue cells. Make sure to complete both tabs. Styles 4 5 Question 1: Solve the following TVM problems using Excel formulas. You MUST use Excel formulas (FV or PV) to receive credit. 6 You can assume that all payments are made at the beginning of the period and use 0 or blank for the "type" argument in the formula. K M 8 A. Suppose you invest $10,800 today. What is the future value of the investment in 27 years, if interest at 7% is compounded annually? 9 B. Suppose you invest $ 10,800 today. What is the future value of the investment in 27 years, if interest at 7% is compounded quarterly? 10 11 C. Suppose you invest $ 540 monthly. What is the future value of the investment in 27 years, if interest at 5% is compounded monthly? 12 13 14 15 16 17 18 19 20 21 Answers: Editing N