Question

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 first bottle today. |

Calculate the EAR. |

Answer #1

**SEE THE IMAGE. ANY DOUBTS,
FEEL FREE TO ASK. THUMBS UP PLEASE**

**AS NOTHING WAS MENTIONED,
EXCEL IS USED.**

**NEED HELP WITH FINANCIAL
CALCULATOR, LET ME KNOW**

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 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 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...

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...

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,...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 1 minute ago

asked 3 minutes ago

asked 4 minutes ago

asked 8 minutes ago

asked 9 minutes ago

asked 9 minutes ago

asked 10 minutes ago

asked 10 minutes ago

asked 10 minutes ago

asked 10 minutes ago

asked 11 minutes ago

asked 11 minutes ago