Please use the appropriate financial formulas for your calculations. No credit for answers not supported by the appropriate formula. 1) You are proposing that your company purchase new equipment that will generate additional revenues for the firm. After extensive analysis you determine that the cash flows generated will be as follows: Year 1 $234,881, Year 2 $556,901, Year 3 $847,038, Year 4 $389,466, and Year 5 $101,753. Your firm uses a 15% discount rate for the evaluation of capital project. What is the present value of the future cash flows? (Use the NPV formula to solve this problem) 2) You borrow $15,000 at 5% interest to finance the purchase of a used car. You must pay back the loan in equal annual installments in four years. Create the loan amortization table. The top of page 178 of the text has an excellent example. Note, the first step is to calculate your annual payment using the PMT financial formula in Excel. 3) Started today you deposit $100 for each of the next 28 years into an account paying 4%. What is the future value of your account? Also calculate the value if interest rate is 7% and 10%. 4) You go to Melvindale Bank because you heard they have good interest rates on deposits. You meet with the bank manager and she says they have two account options. Option A pays 8% interest compounded annually. Option B pays 7.85% compounded daily. You plan to deposit $15,000 today for five years. How much would you have in five years if you selected option A? How much would you have if you selected option B? 5) You owe $13,000 in credit card debt, The interest charge is 1.5% monthly. You want to pay off this credit card in five years and you plan to make the first payment today. How much do you need to pay each month to pay off your credit card in five years? (See Chapter 6, page 178. You do not need to create the table shown, just determine the monthly payment). 6) Your friend owes you $2,000 and plans to repay you in two annual payments of $1,000. Assuming a 10% discount rate calculate the present value of the loan repayments if they are received a) as an ordinary annuity and b) as an annuity due