60. Today is 1/1/2009. For 20 years, I receive $50,000 on the first day of each year and $25,000 on the first of July each year. If I discount cash flows at 10% annually, what is the present value (rounded to the nearest thousand dollars) of these payments? Enter just the number as a positive, whole number with no dollar sign; e.g., 5000. (Note that date is in MM/DD/YYYY format.) 14. A company has revenues of $100 during Year 1. Each year their profit is 20% of revenue. Revenue is growing 15% per year. How much total profit (rounded to the nearest penny) will the company earn during Years 1-10? 66. Refer to the screenshot below, where we have total sales within different product categories. A product category is entered in cell C12. Which of the following functions will retrieve the corresponding value for sales? =LOOKUP(C12,B3:07,C, TRUE) =LOOKUP(C12,B3:07,C,FALSE) =HLOOKUP(C12,B3:07,C,TRUE) =HLOOKUP(C12,B3:07,C,FALSE) =VLOOKUP(C12,B3:07,2,TRUE) =VLOOKUP(C12,B3:07,2,FALSE) B C 1 2 3 4 Product movies candy tea soda ice cream Sales 120.00 95.00 45.00 83.00 97.00 $ $ $ $ $ 5 6 7 8 9 10 11 12 Enter product: soda Sales: 13