Can someone help me answer questions Q3 (a,b,c) and Q4 please!!

2004 175 $3,800 $1,695 2005 570 $2,950 $1,500 2006 1,293 $2,750 $1,183 2007 1876 $2,350 $723 2008 2,171 $2,150 $723 2009 2,600 $1,950 5723 1 Sea Horse Power Financial Summary 2 Year 3 BigBelly (small) units 4 BigBelly average price 5. BigBelly average COGS 6 2 Hippo (lante) units B Hippo average price 9 Hippo average COGS 10 Total direct sales revs 11 BigBelly license revenues 12 Hippo license revenues 13 Total gross revenues 14 Expenses 15 R&D duct development 15 Sales & Marketing 17 General and Administration 18 Total average COGS Other variable expenses/adjustments 20 EBITDA 21 Funding needs eguit debt 22 Potential acquisition value 23 27 $4,500 $3,180 $786.500 $9,450 56,660 5802,610 2R5 $3,900 53,180 $2,791 422 $45,749 $48,235 52 885,406 663 $3,400 $2,210 S5,809,618 $361,927 $339,222 56,510,767 942 $2,900 $1,710 57 158,861 $1,223,951 $1,024,997 59,387 809 1227 $2,650 $1,505 $7,920,163 $1,615,375 51,528,654 $11,054 202 1592 $2,250 $1,160 $8,664 398 $2,129,655 $2,117,487 $12.911,541 $153,745 $72.900 5244,100 $382.485 $57,590 5108210 $800.000 53,500,000 5411,441 5428,895 $363,975 $1,760,249 $60,094 15239 249 51,000,000 $4,328,110 $635,511 $761,332 $477,229 52.995,137 $45,298 $1,596,260 5706,504 $997,487 $506,842 52,966,367 $9,064 $4201,545 5914,514 $1,113,467 $539,397 53,416,715 $17,195 $5,062.913 $1,627,575 $1,245,191 $574,850 $3,731,099 526,323 55,706, 502 59,766 150 516 428,666 522.128,405 525,823,082 2004 2005 2006 2007 2008 2009 Qia. What are Seahorses fixed costs per year? Alb. What are Seahorses variable costs per year? Qic What is total cost per year? 02. What is Seashorses profit by year? Q3a. What is the projected LTV each year of a Big Belly customer given they stay a customer for 5 years? 03b. 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 cos by quantity sold is Seahorse experiencing economies of scale, diseconomies of scale or constant returns to scale? os. Is the 3 SM acquisition value in 2004 realistic? Why or why not from an economic perspective)? 06. Plot the breakeven graph. When does Seahorse 5 breakeven? How realistic is this? 3 2004 175 $3,800 $1,695 2005 570 $2,950 $1,500 2006 1,293 $2,750 $1,183 2007 1876 $2,350 $723 2008 2,171 $2,150 $723 2009 2,600 $1,950 5723 1 Sea Horse Power Financial Summary 2 Year 3 BigBelly (small) units 4 BigBelly average price 5. BigBelly average COGS 6 2 Hippo (lante) units B Hippo average price 9 Hippo average COGS 10 Total direct sales revs 11 BigBelly license revenues 12 Hippo license revenues 13 Total gross revenues 14 Expenses 15 R&D duct development 15 Sales & Marketing 17 General and Administration 18 Total average COGS Other variable expenses/adjustments 20 EBITDA 21 Funding needs eguit debt 22 Potential acquisition value 23 27 $4,500 $3,180 $786.500 $9,450 56,660 5802,610 2R5 $3,900 53,180 $2,791 422 $45,749 $48,235 52 885,406 663 $3,400 $2,210 S5,809,618 $361,927 $339,222 56,510,767 942 $2,900 $1,710 57 158,861 $1,223,951 $1,024,997 59,387 809 1227 $2,650 $1,505 $7,920,163 $1,615,375 51,528,654 $11,054 202 1592 $2,250 $1,160 $8,664 398 $2,129,655 $2,117,487 $12.911,541 $153,745 $72.900 5244,100 $382.485 $57,590 5108210 $800.000 53,500,000 5411,441 5428,895 $363,975 $1,760,249 $60,094 15239 249 51,000,000 $4,328,110 $635,511 $761,332 $477,229 52.995,137 $45,298 $1,596,260 5706,504 $997,487 $506,842 52,966,367 $9,064 $4201,545 5914,514 $1,113,467 $539,397 53,416,715 $17,195 $5,062.913 $1,627,575 $1,245,191 $574,850 $3,731,099 526,323 55,706, 502 59,766 150 516 428,666 522.128,405 525,823,082 2004 2005 2006 2007 2008 2009 Qia. What are Seahorses fixed costs per year? Alb. What are Seahorses variable costs per year? Qic What is total cost per year? 02. What is Seashorses profit by year? Q3a. What is the projected LTV each year of a Big Belly customer given they stay a customer for 5 years? 03b. 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 cos by quantity sold is Seahorse experiencing economies of scale, diseconomies of scale or constant returns to scale? os. Is the 3 SM acquisition value in 2004 realistic? Why or why not from an economic perspective)? 06. Plot the breakeven graph. When does Seahorse 5 breakeven? How realistic is this? 3