Question

Time Value of Money In solving these problems please use Excel formulas of the time value of money valuation including : Present Value / PV, Future Value / FV, interest Rate / Rate, Number of periods / NPER First National Bank TIME VALUE OF MONEY ANALYSIS You have applied for a job with a local bank. As part of its evaluation process, you must take an examination on time value of money analysis covering the following questions: 1. Draw time lines for (1) a $100 lump sum cash flow at the end of Year 2; (2) an ordinary annuity of $100 per year for 3 years; and (3) an uneven cash flow stream of −$50, $100, $75, and $50 at the end of Years 0 through 3. 1. What’s the future value of $100 after 3 years if it earns 4%, annual compounding? 2. What’s the present value of $100 to be received in 3 years if the interest rate is 4%, annual compounding? 2. What annual interest rate would cause $100 to grow to $119.10 in 3 years? 3. If a company’s sales are growing at a rate of 10% annually, how long will it take sales to double? 4. What’s the difference between an ordinary annuity and an annuity due? What type of annuity is shown here? How would you change it to the other type of annuity? 1. What is the future value of a 3-year, $100 ordinary annuity if the annual interest rate is 4%? 2. What is its present value? 3. What would the future and present values be if it was an annuity due? 5. A 5-year $100 ordinary annuity has an annual interest rate of 4%. 1. What is its present value? 2. What would the present value be if it was a 10-year annuity? 3. What would the present value be if it was a 25-year annuity? 4. What would the present value be if this was a perpetuity? 6. A 20-year-old student wants to save $5 a day for her retirement. Every day she places $5 in a drawer. At the end of each year, she invests the accumulated savings ($1,825) in a brokerage account with an expected annual return of 8%. 1. If she keeps saving in this manner, how much will she have accumulated at age 65? 2. If a 40-year-old investor began saving in this manner, how much would he have at age 65? 3. How much would the 40-year-old investor have to save each year to accumulate the same amount at 65 as the 20-year-old investor? 7. What is the present value of the following uneven cash flow stream? The annual interest rate is 4%.

Answer 1

I will be answering first 4 parts of this question.
QUESTIOa lfiak 3 3. 3

FV 아千100 to be deceeded M. 3.feaHtely 는.) (パ 88.90 3 3

mpany Sale oN. doubl sala ou long uitta oot a by υ시정 into olation udil double at ky, annual sabe