2007 Financial Model Casadelsol

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View 2007 Financial Model Casadelsol as PDF for free.

More details

  • Words: 773
  • Pages: 9
Drivers Total Visitors to Paso Robles Wineries Growth Rate for Total Visitors to Winery

YE08 YE09 1,000,000 1,030,000 3.00%

Total Number of Wineries in Paso Robles with Tasting Rooms

100

Average # of Winery Visits Per Visitor

3.00

Seasonality of Seasonality of Visitors as a Percentage of Total Visitors/Qtr Average Purchase per Visitor Percentage of Visitors to Purchase thru Wine Clubs, Mail and Internet Average Retail Price/Bottle

Q1 15.00% $42.54 20.00% $20

Cost of Sales Wholesale Cost of Wine/Bottle

$11.25

Selling, General and Administrative Utilities, Insurance, Supplies Dues, Licenses, Permits Maintenance and Repairs Advertising and Promotion

2.25% 0.10% 0.25% 3.00%

Salaries CEO VP of Operations Tasting Room Manager Tasting Staff Member Tasting Staff Member Tasting Staff Member Other

$133,167 $96,211 $49,519 $24,726 $24,726 $24,726

Q2 25.00%

YE10 YE11 YE12 1,060,900 1,092,727 1,125,509

Q3 35.00%

Q4 25.00%

1Q08 Revenues Tasting Room Sales CRM Sales

2Q08

3Q08

4Q08

YE08

255240 191430 63810

382860 319050 63810

510480 446670 63810

382860 319050 63810

1531440 1276200 255240

4500 1500 1064

7500 1500 1596

10500 1500 2128

7500 1500 1596

30000 6000 6384

Cost of Sales Cost of Wine (Bottle Sales) % of Revenue

143644 143644 56.28%

215466 215466 56.28%

287289 287289 56.28%

215466 215466 56.28%

861866 861866 56.28%

SG & A Utilities, Insurance, Supplies Dues, Licenses, Permits Maintenance and Repairs Advertising and Promotion Salaries

102562 5743 255 638 7657 88269

109709 8614 383 957 11486 88269

116856 11486 510 1276 15314 88269

109709 8614 383 957 11486 88269

438836 34457 1531 3829 45943 353075

9033

57685

106336

57685

230738

Cost and SG&A

246207

325175

404144

325175

1300702

First Quarter of operating costs First 2 Quarters of operating costs

246207 571382

Total Winery Visits Total CRM Visits Total Cases

EBIT

1Q09

2Q09

3Q09

4Q09

YE09

1Q10

2Q10

262897 197173 65724

394346 328622 65724

525794 460070 65724

394346 328622 65724

1577383 1314486 262897

270784 203088 67696

406176 338480 67696

4635 1545 1096

7725 1545 1644

10815 1545 2192

7725 1545 1644

30900 6180 6576

4774 1591 1129

7957 1591 1693

147954 147954 56.28%

221930 221930 56.28%

295907 295907 56.28%

221930 221930 56.28%

887722 887722 56.28%

152392 152392 56.28%

228588 228588 56.28%

102991 5915 263 657 7887 88269

110352 8873 394 986 11830 88269

117713 11830 526 1314 15774 88269

110352 8873 394 986 11830 88269

441408 35491 1577 3943 47321 353075

103433 6093 271 677 8124 88269

111015 9139 406 1015 12185 88269

11953

62063

112174

62063

248253

14959

66573

250945

332283

413621

332283

1329130

255825

339603

3Q10

4Q10

YE10

1Q11

2Q11

3Q11

4Q11

541568 473872 67696

406176 338480 67696

1624705 1353921 270784

278908 209181 69727

418361 348635 69727

557815 488088 69727

418361 348635 69727

11139 1591 2258

7957 1591 1693

31827 6365 6773

4917 1639 1163

8195 1639 1744

11474 1639 2325

8195 1639 1744

304785 304785 56.28%

228588 228588 56.28%

914354 914354 56.28%

156964 156964 56.28%

235446 235446 56.28%

313928 313928 56.28%

235446 235446 56.28%

118597 12185 542 1354 16247 88269

111015 9139 406 1015 12185 88269

444058 36556 1625 4062 48741 353075

103888 6275 279 697 8367 88269

111697 9413 418 1046 12551 88269

119506 12551 558 1395 16734 88269

111697 9413 418 1046 12551 88269

118187

66573

266293

18056

71218

124381

71218

423381

339603

1358412

260852

347143

433434

347143

YE11

1Q12

2Q12

3Q12

4Q12

YE12

1673446 1394538 278908

287275 215456 71819

430912 359094 71819

574550 502731 71819

430912 359094 71819

1723649 1436374 287275

32782 6556 6976

5065 1688 1198

8441 1688 1796

11818 1688 2395

8441 1688 1796

33765 6753 7185

941784 941784 56.28%

161673 161673 56.28%

242509 242509 56.28%

323346 323346 56.28%

242509 242509 56.28%

970038 970038 56.28%

446788 37653 1673 4184 50203 353075

104356 6464 287 718 8618 88269

112400 9696 431 1077 12927 88269

120444 12927 575 1436 17236 88269

112400 9696 431 1077 12927 88269

449599 38782 1724 4309 51709 353075

284874

21246

76003

130760

76003

304012

1388572

266029

354909

443789

354909

1419637

YE08

YE09

YE10

YE11

YE12

Total Revenue

$1,531,440

$1,577,383

$1,624,705

$1,673,446

$1,723,649

Cost of Sales

$861,866

$887,722

$914,354

$941,784

$970,038

Gross Profit % of Revenue

$669,574 43.72%

$689,661 43.72%

$710,351 43.72%

$731,662 43.72%

$753,612 43.72%

SG&A % of Revenue

$438,836 28.66%

$441,408 27.98%

$444,058 27.33%

$446,788 26.70%

$449,599 26.08%

EBIT % of Revenue

$230,738 15.07%

$248,253 15.74%

$266,293 16.39%

$284,874 17.02%

$304,012 17.64%

Valuation Inputs Investment Rate of Return (IRR) Required Capital** Term Year 5 Net Income Year 5 Price-to-Earning Ratio (PER)

30% $900,000 5 Years $304,012 20

Basic Valuation Model (No dilution) Required Future Value (Investment)

=

$3,341,637

Total Terminal Value

=

$6,080,240

Final Ownership Required by Investor

=

54.96%

** 2 QTR of operating costs + buffer and 300K for property staging

http://www.winebusiness.com/ReferenceLibrary/webarticle.cfm?dataId=45483 http://www.winebusiness.com/ReferenceLibrary/webarticle.cfm?dataId=42351 http://www.prcity.com/business/pdf/EconomicImpactReport6-2007opt.pdf http://findarticles.com/p/articles/mi_m3488/is_n3_v75/ai_15400263 http://www.sfgate.com/cgi-bin/article.cgi?file=/c/a/2007/04/27/WIG58PC2PM1.DTL

Related Documents

Financial Model
November 2019 12
Financial Model
November 2019 13
Financial Model Xyz
October 2019 20
Ind Financial Model
July 2020 2