Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Laiterie de Coaticook in the Eastern Townships of Quebec produces several types of cheddar cheese. It markets this cheese in four varieties: aged 2

The Laiterie de Coaticook in the Eastern Townships of Quebec produces several types of cheddar cheese. It markets this cheese in four varieties: aged 2 months, 9 months, 15 months, and 2 years. At the producer's store, 2 kg of each variety sell for the following prices: $ 8.50, $ 10.50 comma $ 11.25, and $ 12.00, respectively. Consider the cheese maker's decision whether to continue to age a particular2-kg block of cheese. At 2 months, he can either sell the cheese immediately or let it age further. If he sells it now, he will receive $ 8.50 immediately. If he ages the cheese, he must give up the $ 8.50 today to receive a higher amount in the future.
What is the IRR(expressed in percent per month) of the investment of giving up $ 85.00 today by choosing to store 20 kg of cheese that is currently 2 months old and instead selling 10 kg of this cheese when it has aged 9 months, 6 kg when it has aged 15 months, and the remaining 4 kg when it has aged 2 years?
Please show detail of the formula use and excel spreadsheet on how to guess the interest rate

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Credit Derivatives Handbook Global Perspectives Innovations And Market Drivers

Authors: Greg Gregoriou, Paul Ali

1st Edition

0071549528, 978-0071549523

More Books

Students also viewed these Finance questions

Question

6. Does your speech have a clear and logical structure?

Answered: 1 week ago