1 Seahorse Powes Financial Summary D 3 1 Year BigBelly small units Bigltelly average price BigBelly average COGS 2004 175 $3,800 $1.095 2005 570 $2,950 $1.500 2006 1,293 $2,750 $1,183 2007 1,870 $2.350 5723 2008 2,171 $2,150 $723 2009 2.600 $1,950 $723 27 $4.500 $3,180 5786,500 $9,450 56.660 $802.510 285 $3,900 $3180 $2.791.422 $45,749 $48,235 $2,85 406 663 $3,400 $2,210 55,809.618 $161.927 $339,222 56510.767 942 $2.900 $1,710 $7.138.861 $1,223,951 $1,024,992 $9.387 NO2 1227 52,650 $1,505 $7.920,16 $1,615,375 $1,528,664 $11064,709 1592 $2,250 $1,160 $8,664,398 $2.129,655 $2,117,487 $12,011,841 Hippo (large) units Hippo average price Hippo average COGS Total direct sales revs BigBelly license revenues Hippo license tevenues Total gross revenues Expenses: RXO, Product development Sales & marketing General and Administration Total average COGS Other variable expenses/adjustments EBITDA Funding needs (equity/ debt) Potentialition value $153,745 $12.900 $244.100 $382485 $57.90 ISLOVO $800,000 $3.500.000 $411,441 $478.895 $363.975 $1,760,249 560,094 5635,511 $761,372 $477.229 $2.995,137 $45,298 $1,500,260 $706,504 $997,487 5506,842 $2,966 367 $9.064 $0 201,145 $914,514 $1,113,467 $539,397 $3,416,715 $17,196 $5.062.013 $1,627576 $1.245.191 5574850 $3,731,000 $26,323 $5706,102 $1,000,000 548 110 $9.70.150 $16,428,666 $22.128,40% 525.8230 2004 2005 2006 2002 2008 2009 al Q3a. What is the projected LTV each year of a 'Big Belly' customer given they stay a customer for 5 years? Q3b. Based on what you found, write an explanation what this means for CPA? Q3c. How can BigBelly improve the LTV of a customer? 04. Plot the average COGs by quantity sold. Is Seahorse experiencing economies of scale, diseconomies of scale or constant returns to scale? 1 Seahorse Powes Financial Summary D 3 1 Year BigBelly small units Bigltelly average price BigBelly average COGS 2004 175 $3,800 $1.095 2005 570 $2,950 $1.500 2006 1,293 $2,750 $1,183 2007 1,870 $2.350 5723 2008 2,171 $2,150 $723 2009 2.600 $1,950 $723 27 $4.500 $3,180 5786,500 $9,450 56.660 $802.510 285 $3,900 $3180 $2.791.422 $45,749 $48,235 $2,85 406 663 $3,400 $2,210 55,809.618 $161.927 $339,222 56510.767 942 $2.900 $1,710 $7.138.861 $1,223,951 $1,024,992 $9.387 NO2 1227 52,650 $1,505 $7.920,16 $1,615,375 $1,528,664 $11064,709 1592 $2,250 $1,160 $8,664,398 $2.129,655 $2,117,487 $12,011,841 Hippo (large) units Hippo average price Hippo average COGS Total direct sales revs BigBelly license revenues Hippo license tevenues Total gross revenues Expenses: RXO, Product development Sales & marketing General and Administration Total average COGS Other variable expenses/adjustments EBITDA Funding needs (equity/ debt) Potentialition value $153,745 $12.900 $244.100 $382485 $57.90 ISLOVO $800,000 $3.500.000 $411,441 $478.895 $363.975 $1,760,249 560,094 5635,511 $761,372 $477.229 $2.995,137 $45,298 $1,500,260 $706,504 $997,487 5506,842 $2,966 367 $9.064 $0 201,145 $914,514 $1,113,467 $539,397 $3,416,715 $17,196 $5.062.013 $1,627576 $1.245.191 5574850 $3,731,000 $26,323 $5706,102 $1,000,000 548 110 $9.70.150 $16,428,666 $22.128,40% 525.8230 2004 2005 2006 2002 2008 2009 al Q3a. What is the projected LTV each year of a 'Big Belly' customer given they stay a customer for 5 years? Q3b. Based on what you found, write an explanation what this means for CPA? Q3c. How can BigBelly improve the LTV of a customer? 04. Plot the average COGs by quantity sold. Is Seahorse experiencing economies of scale, diseconomies of scale or constant returns to scale