EGR120 PS#5 Data (1).xlsx - Levitt Winery Author Date Purpose To analyze market conditions for the proposed Levitt Winery Page 1 Documentation Levitt

EGR120 PS#5 Data (1).xlsx - Levitt Winery Author Date...

This preview shows page 1 - 8 out of 8 pages.

11/05/2019 7354e84a9dfd3181fe82cdd50c3d826c2d257d10.xlsx Page 1 Documentation Author Date Purpose To analyze market conditions for the proposed Levitt Winery. L evitt W inery
Image of page 1

Subscribe to view the full document.

Business Loan Request Loan Amount (PV) Annual Interest Rate Payments per Year Interest Rate per Period (RATE) Number of Years Total Payments (NPER) Monthly Payment L evitt W inery
Image of page 2
11/05/2019 7354e84a9dfd3181fe82cdd50c3d826c2d257d10.xlsx Page 3 Market Summary Market Analysis Grapes Grown by Michigan Wineries Wineries that Grow their Own Gra Grapes grown by the Wineries Yes 69 Type Wineries 12-Year Trend No 59 Frontenac 26 Unknown 27 La Crescent 20 La Crosse 7 Marechal Foch 14 Marquette 12 Seyval Blanc 2 St. Pepin 15 L evitt W inery
Image of page 3

Subscribe to view the full document.

11/05/2019 7354e84a9dfd3181fe82cdd50c3d826c2d257d10.xlsx Page 4 Michigan Wineries Bonded Wineries in Michigan Year Northwest Northeast South Total 2005 10 25 20 55 2006 12 30 26 68 2007 14 28 23 65 2008 17 28 23 68 2009 19 34 28 81 2010 18 37 32 87 2011 24 42 33 99 2012 22 39 31 92 2013 25 43 35 103 2014 23 47 39 109 2015 23 51 42 116 2016 23 53 45 121 L evitt W inery
Image of page 4
11/05/2019 7354e84a9dfd3181fe82cdd50c3d826c2d257d10.xlsx Page 5 Michigan Grapes Grapes grown by Michigan Wineries 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Frontenac 9 9 12 12 15 18 18 18 20 22 24 26 La Crescent 0 0 4 6 12 12 12 14 16 20 20 20 La Crosse 0 0 0 0 0 0 3 7 10 10 10 7 Marechal Foch 0 0 0 5 11 11 12 10 10 10 12 14 Marquette 3 7 10 14 14 14 10 8 8 10 12 12 Seyval Blanc 0 0 0 0 0 0 0 6 6 4 2 2 St. Pepin
Image of page 5

Subscribe to view the full document.

Image of page 6
Image of page 7

Subscribe to view the full document.

Image of page 8

Unformatted text preview: 3 6 8 11 14 17 17 15 15 15 L evitt W inery 11/05/2019 7354e84a9dfd3181fe82cdd50c3d826c2d257d10.xlsx Page 6 U.S. Wine Consumption Year Gallons (millions) Gallons per Capita 2005 692 2.26 2006 717 2.33 2007 745 2.39 2008 753 2.47 2009 767 2.48 2010 784 2.50 2011 800 2.54 2012 827 2.57 2013 835 2.51 2014 855 2.45 2015 895 2.46 2016 910 2.53 L evitt W inery 11/05/2019 7354e84a9dfd3181fe82cdd50c3d826c2d257d10.xlsx Page 7 U.S. Wine Sales Year Table Wine Dessert Wine Sparkling Wine Total 2005 256.2 21.9 13.0 291.1 2006 264.0 24.1 13.6 301.7 2007 272.0 26.3 13.8 312.1 2008 272.9 27.5 13.4 313.8 2009 280.2 27.2 13.8 321.2 2010 285.1 29.3 15.2 329.6 2011 299.3 30.6 17.2 347.1 2012 301.2 31.3 18.1 350.6 2013 307.8 34.3 19.5 361.6 2014 314.2 35.1 19.8 369.1 2015 321.8 39.7 21.8 383.3 2016 326.6 42.3 23.9 392.8 L evitt W inery Yearly Gross Income Year Gross Income 2015 $ (250,000) 2016 (245,000) 2017 (240,000) 2018 (175,000) 2019 (170,000) 2020 20,000 2021 200,000 2022 360,000 2023 600,000 2024 865,000 L evitt W inery...
View Full Document

  • Fall '15

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask bonus questions You can ask questions ( expire soon) You can ask questions (will expire )
Answers in as fast as 15 minutes