You have been asked to build a simple bond valuation model in Excel. Which of the following statements about bond valuation is incorrect? Select one: The bond value is the sum of the present values of each cash flow discounted at the yield. All future should be included in the relevant time periods, both coupons and redemption amount The bond value can be calculated as follows: =PRICE(settlement date, maturity date, yield, coupon rate, redemption amount, payment frequency) The bond value can be calculated as follows: =PV(rate, number of periods, present value, future value) with the present value being input as a negative number The bond value can be calculated as follows: =NPV(rate, cashflows)