Directions: Using the financial functions of Excel and/or the formulas for TVM, solve each of the problems. Show all work by writing it out OR through the Excel functions you use to calcuate the answer in your cell. Enter answers into each colored cell.

You have $100,000 that you want to invest in a one year Certificate of Deposit (CD) with a 2.78% annual interest rate. What will be the value of that CD in a year?

PV= 100000

r/YR= 3%

n= 1

formula: FV= PV (1+r)^n= ?

#3 - Your company has chosen to take on two projects. The first is for three years and pays $1,560,000 annually. The second is for four years and pays $2,000,000 annually. The interest rate for both is 5.5%. What is the Future Value of this portfolio? What is the present value of this portfolio