1) Which Excel function is used to directly calculate the annual return for the bond shown below?

Annual coupon	10.0
Number of years to maturity	7.0
Price	90.0
Par value	100.0

Select one:

A) YIELD

B) IRR

C) NPV

D) RATE

2) Which Excel function would you use to calculate the value of the cash flows below, at the end of year 5?

Investment made each year	100.0
Number of years	5.0
Compounding rate	8.0%

Select one:

A) FV

B) NPV

C) PV

D) RATE

Please answer both.