Question

In: Finance

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 $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 discount of 7 percent. Assume he buys the wine and consumes the first bottle today.
  
What is the EAR of purchasing wine by the case with this discount?

Solutions

Expert Solution

Answer : Calculation of EAR :

Calculation Cost of Purchasing Case = (12 bottles * $14) * (1 - 0.07)

= 156.24

Now taking this as present value we will calculate Rate using Rate function of Excel :

=RATE(nper,pmt,pv,fv,type)

where nper is the nuber of periods i.e 12

pmt is the periodic payment i.e 14

pv is calculated above i.e -156.24

fv is the future value i.e 0

type is 1 as he buys the wine and consumes the first bottle today.

=RATE(12,14,-156.24,0,1)

Rate will be 1.3479% or 0.013479

EAR = (1 + Rate)^52 - 1

= (1 + 0.013479)^52 - 1

= 2.006153249 - 1

= 1.006153249 or 100.62%


Related Solutions

A well-known financial writer argues that he can earn 81 percent per year buying wine by...
A well-known financial writer argues that he can earn 81 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 6 percent discount and, by doing so, earns the 81 percent. Assume he buys the wine and consumes the...
How can I solve this using the HP 10bii financial calculator? A well-known financial writer argues...
How can I solve this using the HP 10bii financial calculator? 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 $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 discount of 8 percent. Assume he buys the...
Gary Vaynerchuck is a well known Marketer. He can be controversial. Review Gary's Facebook, LinkedIn, Newsfeeds...
Gary Vaynerchuck is a well known Marketer. He can be controversial. Review Gary's Facebook, LinkedIn, Newsfeeds and if You have Amazon Prime Follow The Leader: Gary Vaynerchuck. The Follow The Leader Series is a Great series just to view. 1. What are the key factors in Gary's success? 2. What can we learn as marketers from Gary? 3. What is Gary's philosophy of doing business? 4. What does Gary need to change? 5. What can you apply to direct marketing...
ECONOMICS question one, write at least 2 pages (a) James is a well-known wine farmer from...
ECONOMICS question one, write at least 2 pages (a) James is a well-known wine farmer from Italy who interacts with other members of the wine farmers association to agree on where to supply their farm wine. Each farming season, he gathers his fellow farmers to discuss on the best wine pricing model. As a student of Principles of Economics, assess the above scenario to discuss the above somewhat behavioral economics. (b) Brian is a wheat farmer who sells a bushel...
Case Study: Orpheus Financial Advisors Orpheus was an extremely successful, and very well respected financial advisory...
Case Study: Orpheus Financial Advisors Orpheus was an extremely successful, and very well respected financial advisory firm with offices throughout the United States. Orpheus had a reputation for well-trained advisors and was known to be very selective in terms of the investment managers they would recommend to their clients. As a result, Orpheus clients tended to stay with the investment choices they were recommended for an average of ten years. The average for other platform managers was less than five...
Your friend argues real GDP per capita is a poor measure of economic well-being. He says...
Your friend argues real GDP per capita is a poor measure of economic well-being. He says the statistic fails to consider factors such as pollution and leisure. Provide a counter argument that defends the use of real GDP per capita as a welfare measure.
Which of the following statements is true? A. Extremely high savings rate can be counterproductive for...
Which of the following statements is true? A. Extremely high savings rate can be counterproductive for an economy in short term. B. The greater the savings rate in an economy, the slower is the rate of capital accumulation. C. For positive growth, consumption in an economy should always be less than savings. D. The greater the consumption expenditure in an economy, the faster is capital accumulation.
Payday Loans.  As you saw, the interest rates on these loans can be extremely high and are...
Payday Loans.  As you saw, the interest rates on these loans can be extremely high and are even called predatory by some. Do you think such high interest loans are ethical? Why or why not?
It is well known that most IPOs have extraordinary return on the first day of trading...
It is well known that most IPOs have extraordinary return on the first day of trading but under perform the general market in the next 5 years. Why do issuers intentionally under price their shares at beginning? And why do you think IPOs under perform in the long term?
The medical, social and financial costs of obesity are well known. So is the fact that...
The medical, social and financial costs of obesity are well known. So is the fact that eating less and moving more will promote weight loss. However, these conventional methods do not always work. When they fail, is surgery a good weight-loss option?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT