Question: Excel----- The promised cash flows of three securities are listed here. If the cash flows are risk-free and the risk free interest rate is 5%, determine the no arbitrage price of each security before the first cash flow is paid.

Security Cash flow Cash flow

Today ($) in one year ($)

A 500 500

B 0 1000

C 1000 0