Check my work 1. Annual cash inflows from two competing investment opportunities are given below. Each investment opportunity will require the same initial investment Compute the present value of the cash inflows for each investment using a 19% discount rate (Hint Use Microsoft Excel to calculate the discount factor(s)) (Round discount factor(s) to 3 decimal places, intermediate and final answers to the nearest dollar amount.) Investment Year 1 2 3 4 X $ 4,000 7.000 10,000 13,000 $13,000 10,000 7.000 4,000 $34,000 534,000 Present value of cash flows Y 2. At the end of four years, when you graduate from college your parents have promised to give you a used car that will cost $11,000 (Hint Use Microsoft Excel to calculate the discount factor(s).) a. What lump sum must they invest now to have the $11,000 at the end of four years if they can invest money at 5%? (Do not round your intermediate calculations. Round your PV factor to 3 decimal places and round your final answer to the nearest whole dollar) Presente . What lump sum must they invest now to have the $11.000 at the end of four years if they can invest money at 11%? (Do not round your intermediate calculations. Round your PV factor to 3 decimal places and round your final answer to the nearest whole dollar) Presenta Check my work 3. Joanne has just won the grand prize on a popular quiz show. She has a choice between (a) receiving $255,000 immediately and (b) receiving $31.000 per year at the end of the year for eight years, plus a lump sum of $105.000 at the end of the eight-year period. If Joanne can get a return of 9% on her investments, which option would you recommend that she accept? (Hint Use Microsoft Excel to calculate the discount factor(s).) Option a Option b 4. You have just learned that you are a beneficiary in the will of your late Uncle Sam. The executor of her estate has given you three options as to how you may receive your inheritance: a. You may receive $105,000 immediately b. You may receive $158,000 at the end of five years, c. You may receive $25,000 at the end of each year for five years (a total of $125.000) 4. You have just learned that you are a beneficiary in the will of your late Uncle Sam. The executor of her estate has given you three options as to how you may receive your inheritance: a. You may receive $105,000 immediately b. You may receive $158,000 at the end of five years. c. You may receive $25.000 at the end of each year for five years (a total of $125,000). If you can invest money at a 11% return, which option would you prefer? (Hint Use Microsoft Excel to calculate the discount factor(s)) Option a Option b Option