3 pages plus excel calculations needed

For this assignment you will take on the role of Sadie (or Saul) McDollar who has been hired by Wacky Wines to assist with the evaluation of two expansion options. The first option is to open a new store in LA and the second option is to open a new store in Miami. Your job is to evaluate these two options and make a recommendation to the owners of Wacky Wines regarding which investment option should be pursued.

 In order to complete the analysis use the information below and the two sets of provided pro forma financial statements (LA and Miami). Your memo should clearly state your recommendation regarding where Wacky Wines should open its next store. You must justify your decision using capital budgeting techniques (payback, discounted payback, NPV, IRR, and MIRR)

Expansion Information: Having been successful at prior expansions, Wacky Wines is hoping to expand again. This time, Wacky Wines is looking to expand by either opening a store in LA or Miami. From prior experience, Wacky Wines learned that it is difficult to expand into two new markets at the same time, and hence decided to only pursue one location at this time. The expansion in either location will be financed via a $500,000 loan. The proceeds will be used to purchase the necessary real estate, inventory, and supplies to open the store. In other words, the initial investment is $500,000 for either location.

The owners of Wacky Wines plan to sell all stores in 2030 and retire to the Bahamas. It is expected that the LA store will sell for $1.5 million while the Miami store will sell for $3 million in 2030.

Please use Wacky Wines weighted average cost of capital of 12% as the discount rate.

 

Key assumptions used to construct the pro forma statement projections:

 

  1. 1)  Wacky Wines receives the $500,000 loan and uses the loan proceeds to purchase retail

    space, inventory, furniture and fixtures, signage, etc. The 30 year loan has a fixed

    interest rate of 5%.

  2. 2)  For Miami, Wacky Wines’ sales are assumed to grow slowly (only 2% annually) for the

    first several years. This is due Zika concerns causing a decline in tourism and wealthy residence moving out of Miami. However, once Zika is eradicated, sales growth is expected to increase to 20% per year and remain high.

  3. 3)  For LA, Wacky Wines’ sales are assumed to grow at a constant rate of 10% per year.
  4. 4)  The gross profit margin is assumed to be 5% lower in Miami since consumers in LA are

    willing to pay higher prices for the same wines.

     The owners of Wacky Wines are extremely well versed in finance. Hence, do not dedicate a great deal of space to explaining simple finance concepts in your write-up. However, the owners are looking for advanced analysis with evidence of critical thinking. The owners always appreciate well written memos that make appropriate use of correct grammar and spelling.

    They are also very busy therefore memos written in a concise manner are better received.

    However, if you have just one page of analysis, it will not be graded and you will earn a zero.

     The course website will only allow you to submit one document in Microsoft word format. Thus, you will need to embed your excel tables and graphs in your word document before uploading your write-up to the course website.

    Extra Credit Opportunity: I will grade the assignments. Then I will go back through the assignments and award an additional 5 points (essentially half a letter grade) to any memo that properly references and discusses at least tworelevant Harvard Business Review articles and/or Wall Street Journal articles. For reference formatting requirements refer to: http://www.oxfordjournals.org/our_journals/ajae/for_authors/guide.pdf
Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more