Question

Part B: Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known...

Part B: Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known financial writer Andrew Tobias argues that he can earn 200% per year buying wine by the case. Specifically, he assumes that he will consume one $10 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $10 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 he buys the wine and consumes the first bottle today. Do you agree with his analysis? Do you see a problem with his numbers?

Homework Answers

Answer #1
By buying by case, you can get a discount of 10%, so for 12 bottles of wine ($10 each), you'll have to pay $108, instead of $120.
This is the PV of an annuity with $10 periodic payments, 12 periods and an unknown r. So:
$108 = 10/r * (1- (1/1+r)^12))
By solving the above equation, r is calculated as 1.98% and it's per week.
So the APR is: 0.0198 * 52 = 102.77%

And then EAR can be calculated as (1+APR/52)^52 - 1 = 176.68% = 177 % Approximately

Yes, I agree with the analysis.

However, if we buy by case, we will pay less cash in total, but our payments will be much bigger ($108 vs $10). So, if we are to include the time-value concept in our calculations, why would we ignore the fact that by buying buy case, our cash outflows will be much larger than if we were to by bottle by bottle

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known financial writer...
Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known financial writer Andrew Tobias argues that he can earn 200% per year buying wine by the case. Specifically, he assumes that he will consume one $10 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $10 per week or buy a case of 12 bottles today. If he buys the case, he receives a 10 percent discount and, by doing...
A well-known financial writer argues that he can earn 148 percent per year buying wine by...
A well-known financial writer argues that he can earn 148 percent per year buying wine by the case. Specifically, he assumes that he will consume one $12 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $12 per week or buy a case of 12 bottles today. If he buys the case, he receives a 9 percent discount and, by doing so, earns the 148 percent. Assume he buys the wine and consumes the...
A well-known financial writer argues that he can earn 101 percent per year buying wine by...
A well-known financial writer argues that he can earn 101 percent per year buying wine by the case. Specifically, he assumes that he will consume one $14 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $14 per week or buy a case of 12 bottles today. If he buys the case, he receives a 7 percent discount and, by doing so, earns the 101 percent. Assume he buys the wine and consumes the...
A well-known financial writer argues that he can earn 209 percent per year buying wine by...
A well-known financial writer argues that he can earn 209 percent per year buying wine by the case. Specifically, he assumes that he will consume one $13 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $13 per week or buy a case of 12 bottles today. If he buys the case, he receives a 11 percent discount and, by doing so, earns the 209 percent. Assume he buys the wine and consumes the...
A well-known financial writer argues that he can earn an extremely high return buying wine by...
A well-known financial writer argues that he can earn an extremely high return buying wine by the case. Specifically, he assumes that he will consume one $13 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $13 per week or buy a case of 12 bottles today. If he buys the case, he receives a discount of 5 percent. Assume he buys the wine and consumes the first bottle today. What is the EAR...
Please read the article and answear about questions. Determining the Value of the Business After you...
Please read the article and answear about questions. Determining the Value of the Business After you have completed a thorough and exacting investigation, you need to analyze all the infor- mation you have gathered. This is the time to consult with your business, financial, and legal advis- ers to arrive at an estimate of the value of the business. Outside advisers are impartial and are more likely to see the bad things about the business than are you. You should...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT