BE3.13 (LO3) Excel Smolinski Company is considering an investment that will return a lump sum of $500,000 five years from now. What amount should Smolinski Company pay for this investment in order to earn a 4% return? Show calculations using all four methods: (a) formula, (b) factor Table PV.1, (c) financial calculator, and (d) Excel function PV. BE3.14 (LO 3) Excel If Kerry Dahl invests $3,152 now, she will receive $10,000 at the end of 15 years. What annual rate of interest will Kerry earn on her investment? Round your answer to the nearest whole number. Show calculations using any of three methods: (a) factor Table PV.1, (b) a financial calculator, or (C) Excel function PV. BE3.20 (LO 3) Excel Caledonian Company receives a six-year, $50,000 note that bears interest at 8% (paid annually) from a customer at a time when the market interest rate is 6%. What is the present value of the note received by Caledonian? Show calculations using (a) factor Tables PV.1 and PV.2, (b) a financial calculator, or (C) Excel function PV