Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

You have been asked by your 60 year old uncle Quentin to help him assess a new venture. It is Friday night, and he needs the work finished by Sunday in preparation for an early Monday morning meeting, so you know that he will not be able to give you any more information than he already has (and you will be unable to contact him over the weekend), and therefore you may need to rely on your own assumptions and estimates for some of the analysis.


Quentin lives in Chicago and recently took early retirement (from a company he joined 35 years ago), and left the company with a lump sum payment of $450,000. 
Surprisingly, rather than being depressed by his new state of independence, he is excitedly contemplating a new career as a retailer of a range of flavoured gourmet coffee beans. He is confident that she can set up a business to import coffee from Vietnam and sell it in the USA. His wife, who he met at business school, is pleased with his passion for this possible new venture, but concerned that it might turn into a financial disaster. She has suggested that he develop a financial plan to evaluate the venture and its viability.

After a couple of hours with Uncle Quentin you have assembled the following information from him:
- Vietnam Coffee (VC, owned by a college friend) is prepared to give him exclusive rights to sell their products in the USA for a five year period in exchange for an upfront payment;

- The coffees retail in Vietnam for an average of VND 80,000 per kilogramme (VND = Vietnamese Dong);

- VC would sell products to Quentin at a 30% discount to the price in Vietnam;

- VC would ship to Quentin on receipt of payment for each order;

- Quentin has found out that air freight from Vietnam to the USA via air courier would average VND 60,000 per kg and that the time from him placing an order to receiving the goods in Chicago would be one week;

- Quentin plans to order from Vietnam every four weeks and intends to maintain a minimum stock of four weeks worth of sales to ensure that he will always be able to have sufficient inventory on hand;

- He will buy a special refrigerator at a cost of $9,000 to be able to keep the coffee in good condition, and has found a small industrial room that he can rent nearby at a rental of $300 per month (payable monthly in advance, plus an initial three month deposit);


- Quentin intends to sell by internet only, and has found a designer to set up his website at a cost of $3,500;
- He has already spent $6,000 on a market study that told him that once established, demand will be about 600 kg a month, although in the first year sales would start at only 100 kg in the first month before building up slowly to the full level at the end of the first year;
- The above study assumed a selling price of $13.00 per kg;


- Packaging and shipping to the customer within the USA would cost $1.50 per kg for which Quentin would not charge extra;
- All sales would be by credit card, with the credit card company taking a 1% per sale fee and remitting the monthly net balance to Quentin three days after the month end; 
- He believes that one person could run the operation and hopes to do so himself,
paying himself $3,000 per month;
- The study also examined the potential for a deal to supply a small supermarket chain with ground coffee at a price of $12.50 per kg, and concluded that sales at that price could be in addition to the coffee beans, and would represent an extra 30% on top of
the bean volume;
- Based on the study Quentin is confident that he could achieve the sales of ground coffee, but it would need him to use special and better packaging, which would add $3 per kg. This would also require him to purchase special grinding and packaging equipment at a cost of $1,500. If he did this he would need to hire an assistant just to work on ground coffee at a monthly cost of $2,000;


- If necessary, Quentin believes that he could borrow up to $100,000 at 8% p.a.;
- Quentin's marginal tax rate on investment or earned income is 30%, payable one
year in arrears.
Quentin believes that he could invest his redundancy lump sum at 5% per annum and therefore suggests that you use 5% as the after tax discount rate for a discounted cash flow analysis.

Quentin has asked you to prepare an analysis to help him with his decision, making clear any assumptions that you make; 


(excluding the content of exhibits, headings, etc), should include:
- A summary of all assumptions and estimates that you have made for your analysis,
including justifications where appropriate;
- Monthly cash flow in the first year of operation;
- Annual cash flow thereafter;
- A DCF analysis;
- Any sensitivity analysis that you think would be helpful;
- The amount which Quentin could offer VC as an upfront fee for the exclusive rights for the five year period which would leave him no better or worse off than if he did not undertake the venture;
- Conclusions and recommendations.
Quentin has explained that he is going to be out of town for a wedding so will be unable to provide any assistance at all, but as he pointed out before leaving "you business school students have it a lot easier now than we did in our day, with
computers and the internet to help".

---------------------------

Solution file contains the MS word document with having complete analysis part in total 2139 Words count, it includes the references and Excel file which keeps all calculations and computations.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91269710
  • Price:- $60

Priced at Now at $60, Verified Solution

Have any Question?


Related Questions in Basic Finance

A firm issues 100000000 of bond priced at 99 percent and

A firm issues $100,000,000 of bond priced at 99 percent and carrying a coupon rate of 12%. Calculate: a) The number of bond actually issued. b) the price paid by the investors for each bond c) the dollar coupon to be pai ...

A compare and contrast primary valuation alternatives

A) Compare and contrast primary valuation alternatives: historical costs (purchase price less accumulated depreciation), fair value (market price), and the mixed attributed measurement model. In your opinion which one re ...

What is the yield to maturity ytm on a 5-year 1000 bond

What is the yield to maturity (YTM) on a 5-year, $1,000 bond that pays annual payments of $100 that has a current value of $1,112? (rounded to 2-digits)

Finance for decision-making assignment questions -must

FINANCE FOR DECISION-MAKING ASSIGNMENT QUESTIONS - Must answer ALL parts of SIX (6) questions. Question 1 - The Australian government wants to raise more money to finance its public expenditure programs. It can issue tre ...

A new piece of equipment is purchased for 15000 the

A new piece of equipment is purchased for $15,000. The expected lifetime of the asset is five years. Which depreciation method depreciates exactly 3,000 each year? It would be Straight-line, Modified Accelerated Cost Rec ...

Suppose the interest rate is 39 anbsphavingnbsp500nbsptoday

Suppose the interest rate is 3.9 % a.  Having $500 today is equivalent to having what amount in one? year? b.  Having $ 500 in one year is equivalent to having what amount? today? c.  Which would you? prefer, $500 in one ...

The pretzel factory has net sales of 841300 and cost of

the pretzel factory has net sales of 841,300 and . cost of 698500. the depreciation expense is 28400 and the interest paid is 8400. The firms marginal tax rate is 35 percent what is the firms operating cash flow?

You have an opportunity to invest 2500 today and receive

You have an opportunity to invest $2,500 today and receive $3,000 in three years. What would be the return on your investment if you accepted this opportunity?  (Round answer to 2 decimal places, e.g. 52.75.)  Return on ...

A perpetual bond sells for 885 and pays a semiannual coupon

A perpetual bond sells for $885 and pays a semiannual coupon in the amount of $34. What is the annualized yield for the bond?

Question - comparing aprs james sprater of grand junction

Question - Comparing APRs James Sprater of Grand Junction, Colorado, has been shopping for a loan to buy a used car. He wants to borrow $18,000 for four or five years. James' credit union offers a declining-balance loan ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As