Can the following please be worked out with excel calculations as well as formula calculations- i am struggling to know which formula to use

As the lucky winner of the 30 million lottery, Sam can take the prize money either as: Option 1: $ 1 million per annum for 30 years (first payment is made today) Option 2: $15 million paid today. If interest rate is 8% p.a., which option does Sam prefer?

Philip invests $17,200 at an interest rate of 2.5 percent per quarter. How much is the investment worth in 2 years?

What is the effective annual interest rate corresponding to 12 percent per annum compounding monthly?

Starting with his next monthly salary payment, Harry intends to save $200 each month. If the interest rate is 6 percent per annum, how much will Harry have in 2 years?

A company draws a $1million in 120-day Bank Accepted Bill (BAB). Current interest rate is 8% p.a. What is the market price of this BAB today?

For the past 10 years, the growth rate in Rankine Ltd.s dividend per share has been 10 percent per annum and is expected to be maintained indefinitely. The latest dividend, 90 cents per share, was paid yesterday. What is the fair value of Rankines common share? Assume the required rate of return on Rankines common share is 15 percent per annum.

Thanj you!!!