Part B

Part C, using Excel functions (such as RATE).

(20 pts) A financial writer argues that he can effectively earn 177 percent per year buying wine by the case. Specifically, he assumes that he will consume one $100 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $100 per week or buy a case of 12 bottles today. If he buys the case, he receives a 10 percent discount and, by doing so, earns the 177 percent. Assume for now that the price is expected to be constant, that he buys the wine and consumes the first bottle today, and that there are 52 weeks in a year. 1 1. 9 3 Do you agree with his analysis? Why or why not? Someone argues that the percentage return he earns is not real because he would consume all the wine. What could the financial writer do to realize the percentage return in terms of money? Suppose starting from the next week, the price of the wine per bottle is expected to appreciate by 1% per week. Assume the writer can still enjoy the 10% discount for buying a case now. How much percentage return will he earn now? 2 a. b. c