Solve in Excel questions 14 and 15 of corporate finance.

c H A PTE R 5 Discounted Cash Flow Valuation 14. Calculating EAR. First National Bank charges 10.1 percent compounded monthly on its business loans. First United Bank charges 10.3 percent compounded semiannually. As a potential borrower, which bank would you go to for a new loan? 15. Calculating APR. Vandermark Credit Corp. wants to earn an effective annual return on its consumer loans of 14.2 percent per year. The bank uses daily compounding on its loans. What interest rate is the bank required by law to report to potential borrowers? Explain why this rate is misleading to an uninformed borrower. 16. Calculating Future Values. What is the future value of $1,345 in 16 years assuming an interest rate of 8.4 percent compounded semiannually? 17. Calculating Future Values. Bucher Credit Bank is offering 4.7 percent compounded daily on its savings accounts. If you deposit $3,650 today, how