Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Investor's ROI Investor's ROI: What percentage of the company are you selling? What is the estimate of what the investor's stake will be worth in

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Investor's ROI Investor's ROI: What percentage of the company are you selling? What is the estimate of what the investor's stake will be worth in 5 years? What is the specific exit strategy to get the investor that ROI? - For your slide: Show what the investment could turn into at the end of year five and discuss their exit strategy and provide support for it. Bevy Buddy Balance Sheet At December 31, 2026 At December 31, 2027 2028 September October November December Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Assets: Current Assets ash S 2,992,236 S 3,231,570 $ 3,473,625 $ 3,718,414 $ 4,355,884 5 5,045,894 5 5,760,559 $ 6,500,323 $ 7,153,745 $ 7,861,446 5 8,594,759 $ 9 9,354,120 $ 11,929,239 Accounts Receivable 137,612 138,410 139,221 140,032 141,659 144,138 146,658 149,225 151,837 154,494 157,198 159,948 166,78 Inventory 17,317 17,417 17,519 17,621 20,790 21,154 21,524 21,901 25,404 25,849 26.301 26,761 35,038 Other Current Assets Total Current Assets $ 3,147,165 $ 3,387,397 $ 3,630,365 $ 3,876,067 $ 4,518,333 $ 5,211,186 $ 5,928,741 $ 6,671,449 $ 7,330,986 $ 8,041,789 $ 8,778,258 $ 9,540,829 $ 12,131,057 Non-Current Assets Property, Plant, & Equipment S 281,229 281,229 S 281,229 S 281,229 S 310,329 S 310,329 5 310,329 S 310,329 S 339,429 5 339,429 5 339,429 S 339,429 S 368,529 Accumulated Depreciation 69 847 74.534 79.221 83.908 99 424 114.940 130,456 145,972 162.943 179.914 196.885 213,856 287,562 Net PP&E S 211,382 $ 206,695 $ 202,008 S 197,321 S 210,905 195,389 S 179,873 164,357 S 176,486 $ 159,515 5 142,544 125,573 S 80.967 Intangible Assets S 271,880 5 271,880 5 271,880 5 271,880 S 271,880 5 271,880 5 271,880 5 271,880 S 271,880 5 271,880 S 271,880 S 271,880 S 271,880 Accumulated Amortization 36.256 38,522 40.788 43.054 49.851 56.648 63.445 70.242 77.039 83.836 90.633 97.430 124,61 Net Intangible Assets S 235,624 S 233,358 S 231,092 S 228,826 S 222,029 S 215,232 5 208,435 5 201,638 S 194,841 S 188,044 $ 181,247 5 174,450 S 147,262 Total Non-Current Assets $ 447,006 $ 440,053 $ 433,100 $ 426,147 $ 432,934 $ 410,621 $ 388,308 $ 365,995 $ 371,327 $ 347,559 $ 323,791 $ 300,023 $ 228,229 Total Assets $ 3,594.171 $ 3,827,450 $ 4,063,465 $ 4,302,214 $ 4,951,267 $ 5,621,807 $ 6,317,049 $ 7,037,444 $ 7,702,313 $ 8389,348 $ 9,102,049 $ 9,840,852 $ 12,359,286 Liabilities: Current Liabilities Accounts Payable S 17,317 $ 17,417 $ 17,519 5 17,621 S 20,790 S 21,154 5 21,524 $ 21,901 S 25,404 S 25,849 S 26,301 S 26,761 S 35,038 Other Current Liabilities Total Current Liabilities 17,317 $ 17,417 $ 17,519 $ 17,621 $ 20,790 $ 21,154 $ 21,524 $ 21,901 $ 25,404 $ 25,849 $ 26,301 $ 26,761 $ 35,038 Non-Current Liabilities Other Long Term Liabilities S $ S S S $ S Total Liabilties $ 17,317 $ 17,417 $ 17,519 $ 17,621 $ 20,790 $ 21,154 $ 21,524 $ 21,901 $ 25,404 $ 25,849 $ 26,301 $ 26,761 $ 35,038 Owners' Equity Founders' Investment S 300,000 S 300,000 S 300.000 S 300,000 S 300.000 S 300.000 S 300,000 S 300,000 S 300.000 S 300,000 S 300.000 S 300.000 S 300,000 Angel Investor's Investment 2,000,000 2,000,000 2,000,000 2.000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 Retained Earnings 1,276,854 1,510,033 1,745,946 1.984,593 2,630,477 3.300,653 3.995.525 4,715,543 5.376.909 6,063.499 6,775,748 7,514,091 10,024,248 Total Owners' Equity $ 3,576,854 $ 3,810,033 $ 4,045,946 $ 4,284,593 $ 4,930,477 $ 5,600,653 $ 6,295,525 $ 7,015,543 $ 7,676,909 $ 8,363,499 $ 9,075,748 $ 9,814,091 $ 12,324,248 Total Liabilties & Owners' Equity $ 3,594,171 $ 3,827,450 $ 4,063,465 $ 4,302,214 $ 4,951,267 $ 5.621,807 $ 6,317,049 $ 7,037,444 $ 7,702,313 $ 8,389,348 $ 9,102,049 $ 9,840,852 $ 12,359,286Company Name Valuation Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Horizon Value Year 5 Initial Cash Outlay $ (509,009) Operating Cash Flow $ (789,131) $ 2,760,654 $ 2,811,008 $ 2,882,897 $ 2,604,219 Capital Expenditures $ (44,100) (29,100) $ (29,100) $ (29,100) Payments to Shareholders Free Cash Flow $ (509,009) $ (789,131) $ 2,716,554 $ 2,781,908 $ 2,853,797 $ 2,575,119 7,725,358 Discounted Free Cash Flows $ (509,009) $ (563,665) $ 1,385,997 $ 1,013,815 $ 742,867 $ 478,803 1,436,410 NPV $ 3,985,218 Dilution 50.1855% Discount Rate (CAPM, WACC) 40.0% Estimated Long Term Industry Growth Rate 5.0%Bevy Buddy Cash Flow Statement Ca For the Year ended December 31, 2024 For the Yea Operations January February March April May June July August September October November December Total January February March April May June Net Income $ (1,000,000) $ (43,334) $ (43,334) $ (177,144) $ (181,144) $ 122,716 $ 117,716 $ 122,716 $ 122,716 $ 257,036 $ (702,056) $ 209,405 $ 212,001 $ 214,595 $ 217,191 $ 219,832 $ 222,475 Depreciation Expense 3,952 3,952 3,952 3,952 3,952 3,952 3,952 27,664 4,687 4,687 4,687 4,687 4,687 4,687 Amortization Expense 2,266 2,266 2,266 2,266 2,266 2,266 2,266 15,862 2,266 2,266 2,26 2,266 2,266 2,266 Inc/Dec) in A/R (89,359) (41,242) (130,601) (756 (770) (770 (770) (784) (783) (Inc/Dec) in Inventory (11,115) (5,130) (16,245) 285 (97) (97) (96) (99) (98) (Inc/Dec) in A/P 11,115 5,130 16.245 285 97 97 97 98 Net Cash Flow from Operations $ (1,000,000) $ $ $ (43,334) $ (43,334) $ (170,926) $ (174,926) $ 39,575 $ 123,934 $ 128,934 $ 128,934 $ 222,012 $ (789,131) $ 215,602 $ 218,184 $ 220,778 $ 223,375 $ 226,001 $ 228,645 Investing Activities Cash Paid for Fixed Assets $ $ $ (237,129) $ $ $ (237,129) $ (44,100) $ $ Cash Paid for Intangible Assets (271,880) (271,880 Net Cash Flow from Investing $ $ (509,009) $ $ S - $ (509,009) $ (44,100) $ $ S Financing Activities Cash from Founders $ 300,000 $ $ $ $ 300,000 $ $ Cash from Angel Investor 2,000,000 2,000,000 $ $ Dividends to Shareholders Net Cash Flow from Financing $ 2,300,000 $ S $ $ $ S $ $ $ 2,300,000 $ $ S S S Net Change in Cash $ 1,300,000 $ $ (43,334) $ (43,334) $ (679,935) $ (174,926) $ 39,575 $ 123,934 $ 128,934 $ 128,934 $ 222,012 $ 1,001,860 $ 171,502 $ 218,184 $ 220,778 $ 223,375 $ 2 226,001 $ 228,645 Beginning Cash Balance 1,300,000 1,300,000 1,300,000 1,256,666 1,213,332 533,397 358,471 398,046 521,980 650,914 779,848 1,001,860 1,173,362 1,391,546 1,612,324 1,835,699 2,061,700 Ending Cash Balance $ 1,300,000 $1,300,000 $ 1,300,000 $ 1,256,666 $ 1,213,332 $ 533,397 $ 358,471 $ 398,046 $ 521,980 $ 650,914 $ 779,848 $ 1,001,860 $ 1,001,860 $ 1,173,362 $ 1,391,546 $ 1,612,324 $ 1,835,699 $ 2,061,700 $ 2,290,345 Minimum Cash Reserve 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 Do we fall below the minimum? NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NOBevy Buddy Bevy Buddy sh Flow Statement Cash Flow Statement r ended December 31, 2025 For the Year ended December 31, 2026 For the Year ended December 31, 2027 2028 Operations July August September October November December Total Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Total Net Income $ 225,116 $ 227,803 $ 230,491 $ 233,179 $ 235,913 $ 238,647 $ 2,686,649 $ 645,884 $ 670,176 $ 694,872 $ 720,017 $ 2,730,950 661,367 $ 686,590 $ 712,249 $ 738,343 $ 2,798,548 $ 2,510,157 Depreciation Expense 4,687 4,687 4,687 4,687 4.687 4,687 56.244 15,516 15,516 15,516 15,516 52,064 16,971 16,971 16,971 16,971 67.884 73,706 Amortization Expense 2.266 2,266 2.26 2,266 2.266 2.266 27,192 6,797 6,797 6,797 6,797 27,188 6,797 6,797 6,797 6,797 27,188 27,188 Inc/Dec) in A/R 784 (797) 797) (798) (811) 811) (9,431) (1,627) (2,479 (2,520) (2,567) 9,193) (2,612) (2,657) (2,704) (2,750) (10,723) (6,832 Inc/Dec) in Inventory (99) (100) (101) (100) (102) (102) (1,376) (3,169) (364) (370) (377) 4,280 (3,503) (445) (452) (460) (4,860) 8,27 Inc/Dec) in A/P 100 100 100 102 102 1,376 3,169 364 370 377 4,280 3,503 445 452 460 4,860 8,277 Net Cash Flow from Operations S 231,285 $ 233,960 $ 236,646 $ 239,335 $ 242,055 $ 244,789 $ 2,760,654 $ 666,570 $ 690,010 $ 714,665 $ 739,763 $ 2,811,008 $ 682,523 $ 707,701 $ 733,313 $ 759,361 $ 2,882,897 $ 2,604,21 Investing Activities Cash Paid for Fixed Assets is $ (44,100) $ (29,100) $ $ (29,100) $ (29,100) $ $ (29,100) $ (29,100 Cash Paid for Intangible Assets Net Cash Flow from Investing $ $ S (44,100) $ (29,100) $ IS (29,100) $ (29,100) $ S S $ (29,100) $ (29,100 Financing Activities Cash from Founders $ $ $ Cash from Angel Investor $ S $ Dividends to Shareholders Net Cash Flow from Financing S $ $ S S $ S $ S $ $ S S Net Change in Cash S 231,285 $ 233,960 $ 236,646 $ 239,335 $ 242,055 $ 244,789 $ 2,716,554 $ 637,470 $ 690,010 $ 714,665 $ 739,763 $ 2,781,908 $ 653,423 $ 707,701 $ 733,313 $ 759,361 $ 2,853,797 $ 2,575,119 Beginning Cash Balance 2,290,345 2,521,629 2,755,589 2,992,236 3,231,570 3,473,625 1,001,860 3,718,414 4,355,884 5,045,894 5,760,559 3,718,414 6,500,323 7,153,745 7,861,446 8,594,759 6,500,323 9,354,120 Ending Cash Balance $ 2,521,629 $ 2,755,589 $ 2,992,236 $ 3,231,570 $ 3,473,625 $ 3,718,414 $ 3,718,414 $ 4,355,884 $ 5,045,894 $ 5,760,559 $ 6,500,323 $ 6,500,323 $ 7,153,745 $ 7,861,446 $ 8,594,759 $ 9,354,120 $ 9,354,120 $ 11,929,239 Minimum Cash Reserve $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 Do we fall below the minimum? NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NOBevy Buddy Bevy Buddy Income Statement Income Statement For the Year ended December 31,2024 For the Year ended December 31,2025 Revenue January February March April May June July August September October November December Total January February March April May June July August September October November Bevy Buddy S S S $ 357,435 $ 357,435 $ 357,435 $ 357,435 $ 522,405 $ 1,952,145 $ 525,429 $ 528,509 $ 531,588 $ 534,668 $ 537,802 $ 540,937 $ 544,071 $ 547,260 $ 550,450 $ 553,639 $ 556,884 Total Revenue S S $ 357,435 $ 357,435 $ 357,435 $ 357,435 $ 522,405 $ 1,952,145 $ 525,429 $ 528,509 $ 531,588 $ 534,668 $ 537,802 $ 540,937 $ 544,071 $ 547,260 $ 550,450 $ 553,639 $ 556,884 Cost of Goods Sold Bevy Buddy utilities S 40,950 S 40,950 $ 40,950 $ 40,950 $ 59,850 $ 2 223,650 $ 60,899 5 61,256 $ 61,613 $ 61,970 $ 62,333 S 62,696 S 63,059 S 63,429 S 63,799 S 64,168 S 64,544 Manufacturing 14,625 14,625 14,625 14,625 21,375 79,875 21,750 21,877 22,005 22,132 22,262 22,391 22,521 22,653 22,785 22,917 23.052 Direct Cost #3 Direct Cost #4 Total COGS S 55,575 $ 55,575 $ 55,575 $ 55,575 81,225 $ 303,525 $ 82,649 $ 83,133 $ 83,618 $ 84,102 $ 84,595 $ 85,087 85,580 $ 86,082 86,584 87,085 $ 87,596 Total Gross Margin S $ $ $ $ 301,860 $ 301,860 $ 301,860 $ 301,860 $ 441,180 $ 1,648,620 $ 442,780 $ 445,376 $ 447,970 $ 450,566 $ 453,207 $ 455,850 $ 458,491 $ 461,178 $ 463,866 $ 466,554 $ 469,288 Administrative: Start up Expenses $ 1,000,000 s - s - s S S - - $ 1,000,000 s S - S Lease/property taxes/insurance 1,980 1,980 1.980 1,980 1,980 1,980 1,980 13,860 1,988 1,988 1,988 1,988 1,988 1,988 1,988 1,988 1,988 1,988 1,988 Office Supplies 500 500 50 500 50 50 50 3,500 502 50 502 502 502 502 502 502 502 502 502 Office/support Staff 16,000 16,000 16,000 16,000 16,000 16,000 16,000 112,000 16,067 16,067 16,067 16,067 16,067 16,067 16,067 16,067 16,067 16,067 16,067 Executive Salaries 37.500 37,500 37,500 37,500 37,500 37,50 37,500 37,500 37,500 37,500 37.500 Website/App Design and Maintenace 6,200 6,200 6,200 6,200 6,200 6,200 6,200 43,400 6.226 6,226 6.226 6,226 6,226 6,226 6,226 6,226 6,226 6,226 6,226 Outsourcing Expense Depreciation Expense 3,952 3,952 3,952 3,952 3,952 3,952 3,952 27,664 4.687 4,687 4,68 4.687 4.687 4,687 4,687 4.687 4,687 4,687 4,687 Amortization Expense 2,266 2,266 2,266 2.266 2,26 2.266 2.266 15,862 2.266 2,26 2,26 2,26 2,26 2,26 2,26 2,26 2,26 2,26 2,266 Payroll Tax Expense 5.670 6.670 6.670 6.670 6.670 6.670 6.670 46.690 16.976 16.976 16.976 16.976 16.976 16,976 16.976 16.976 16.976 16.976 16,97 Office Equipment 325 325 325 325 325 325 325 2.275 326 326 326 326 326 326 326 326 326 326 326 hardware/software Maintenance 417 417 417 417 417 417 417 2.919 418 418 418 418 418 418 418 418 418 418 418 Lega 4.000 2,000 2,000 2.000 2.000 2,000 14.00 2,008 2,008 2,008 2,008 2,008 2,008 2,008 2,008 2,008 2,008 2,008 Accounting 5,000 5,000 10,000 5.000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Selling: Public relations 8,000 8,000 8,000 8,000 8,000 8,000 8,000 56,00 8,033 8.033 8.033 8.033 8.033 8,03 8,033 8.033 8,033 8,033 8,033 Tradeshows 12,500 12,500 12,500 12,50 12,500 12,50 12,500 87,50 12,552 12,552 12,552 12,552 12,552 12,552 12,552 12,552 12,552 12,552 12,552 Air Time 11,667 11,667 11,667 11,667 1,667 11,667 11,667 81,669 11,715 11,715 11,715 11,715 11,715 11,715 11,715 11,715 11,715 11,715 11,715 Social Ads 10,000 10,000 10,000 10,000 10,000 10,000 10,000 70,000 10,042 10,042 10,042 10.042 10,042 10.042 10,042 10.042 10,042 10,042 10,042 Salespersons Salaries 8,33. 3,333 8.333 8,333 8,333 8,333 8,333 58,331 8,368 8,368 8,368 8,368 8,368 8,368 8,368 8,368 8,368 8,368 8,368 Launch Events 12,500 12,500 12,50 12,500 12,500 12,50 12,500 12,500 12,500 112,500 12,552 12,552 12,552 12,552 12,552 12,552 12,552 12,552 12,552 12,552 12,552 Consultant-Sales 14,16 14,167 14,167 14,167 14,167 14,167 14,167 14,167 14,167 127,503 14,226 14,226 14,226 14,226 14,226 14,226 14,226 14,226 14,226 14,226 14,226 Pop-Up Shops 16,66 16.667 16,66 16,667 16.66' 16,667 16.667 16.667 16.667 150,003 16,736 16.73 16,736 16,736 16,736 16.73 16.736 16,736 16,736 16,736 16,736 Google Ads 20,000 20,000 20,000 20,000 20,00 20,000 20,000 140,000 20,083 20,083 20,083 20,083 20,08 20,08 20,083 20,083 20,083 20,083 20,083 Paid media 25,000 25,000 25,000 25.000 25.000 25,000 25.000 175,000 25,104 25.104 25,104 25,104 25.104 25.104 25.104 25,104 25.104 25,104 25,104 Total Selling & Adminstrative Expenses $ 1,000,000 $ $ 43,334 $ 43,334 $ 177,144 $ 181,144 $ 179,144 $ 184,144 $ 179,144 $ 179,144 $ 184,144 $ 2,350,676 $ 233,375 $ 233,375 $ 233,375 $ 233,375 $ 233,375 $ 233,375 $ 233,375 $ 233,375 $ 233,375 $ 233,375 $ 233,375 Earnings/(Loss) Before Taxes $ (1,000,000) $ $ (43,334) $ (43,334) $ (177,144) $ (181,144) $ 122,716 $ 117,716 $ 122,716 $ 122,716 $ 257,036 $ (702,056) $ 209,405 $ 212,001 $ 214,595 $ 217,191 $ 219,832 $ 222,475 $ 225,116 $ 227,803 $ 230,491 $ 233,179 $ 235,913Bevy Buddy Income Statement For the Year ended December 31,2026 For the Year ended December 31,2027 2028 Revenue December Total Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Total Bevy Buddy $ 560,128 $ 6,511,366 $ 1,699,906 $ 1,729,655 $ 1,759,900 $ 1,790,694 $ 6,980,156 $ 1,822,039 $ 1,853,933 $ 1,886,377 $ 1,919,371 $ 7,481,719 $ 8,005.444 Total Revenue $ 560,128 $ 6,511,366 $ 1,699,906 $ 1,729,655 $ 1,759,900 $ 1,790,694 $ 6,980,156 $ 1,822,039 $ 1,853,933 $ 1,886,377 $ 1,919,371 $ 7,481,719 $ 8,005,444 Cost of Goods Sold Bevy Buddy utilities S 64,920 $ 754,686 $ 229,788 $ 233,809 $ 237,898 $ 242,060 $ 943,555 $ 280,779 $ 285,694 $ 290,694 $ 295,778 $ 1,152,945 $ 1,549,037 Manufacturing 23,186 269.531 82.067 83,503 84.963 86.450 336.983 100,278 102,034 103,819 105,635 411,766 553,227 Direct Cost #3 Direct Cost #4 Total COGS S 88,106 $ 1,024,217 $ 311,855 $ 317,312 $ 322,861 $ 328,510 $ 1,280,538 $ 381,057 $ 387,728 $ 394,513 $ 401,413 $ 1,564,711 $ 2,102,264 Total Gross Margin $ 472,021 $ 5,487,149 $ 1,388,051 $ 1,412,343 $ 1,437,039 $ 1,462,184 $ 5,699,618 $ 1,440,982 $ 1,466,205 $ 1,491,864 $ 1,517,958 $ 5,917,008 $ 5,903,180 Administrative: Start up Expenses S S S S $ S Lease property taxes/insurance 1.988 23,856 6,315 6,315 5,315 6,31 25,260 6,631 6,631 6,631 6,631 26,524 28,880 Office Supplies 502 6,024 1.595 1,595 1,595 1.595 6,380 1,674 1,674 1,674 1.674 6.696 7,293 Office/support Staff 16,067 192.804 51.030 51.030 51,030 51,030 204.120 53.582 53.582 53.582 53.582 214,328 233.377 Executive Salaries 37,500 450,000 119,602 119,602 119,602 119,602 78,408 125,582 125,582 125,582 125,58 502,328 546.978 Website/App Design and Maintenace 6,226 74,712 19,774 19,774 19,774 19,774 79.096 20,763 20.763 20,763 20,763 83,052 90,434 Outsourcing Expens Depreciation Expense 4.687 56.244 15,516 15,516 15,516 15,516 62,064 16,971 16,971 16.971 16,971 67,884 73,706 Amortization Expense 2,266 27,192 6,797 6.797 6,797 6.797 27,18 6,797 6.79 6,797 6,797 27,188 27,188 Payroll Tax Expense 16,976 203, 712 54,055 54,055 54,055 54,055 216,220 56,758 56,758 56,758 56,758 227,032 247,212 Office Equipment 326 3,912 1,037 1,037 1,037 1,037 1, 148 1,088 1,088 1,088 1,088 4.352 4,740 hardware software Maintenance 418 5.016 1.329 1.329 1,329 1.329 5,316 1.395 1,395 1.395 1.395 5.580 6,078 Legal 2,008 24,096 6,379 6,379 6,379 6,379 25,516 6,698 6,698 6,698 6,698 26,792 29,172 Accounting 5,000 60,000 15,947 15,947 15,947 15,947 63,788 16,744 16,744 16,744 16,744 66,976 72,930 Selling: Public relations 8,033 96,396 25,515 25,515 25,515 25,515 102,060 26,791 26,791 26,791 26,791 107,164 116,689 Tradeshows 12,552 150,624 39,867 39,867 39,867 39,867 159,468 41,861 41,861 41,861 41,861 167,444 182,326 Air Time 11,715 140.580 37.209 37.209 37.209 37.209 148,836 39,070 39.070 39.070 39.070 156.280 170,171 Social Ads 10.042 120,504 31,894 31,894 31.894 31,894 127,576 33,488 33,488 33.488 33,488 133,952 145,861 Salespersons Salaries 8,368 100,416 26,578 26,578 26,578 26,578 106,312 27,907 27,907 27,907 27,907 111,628 121,551 Launch Events 12,552 150,624 39,867 39,867 39,867 39,867 159,468 41,861 41,861 41,861 41,861 167,444 182,326 Consultant-Sales 14,226 170, 712 45,183 45,183 45,183 45,183 180,732 47,442 47,442 47.442 47,442 189,768 206,636 Pop-Up Shops 16,736 200,832 53,156 53,156 53,156 53,156 212,624 55,814 55,814 55,814 55,814 223,256 243,101 Google Ads 20.083 240.996 63.788 63,788 63.788 63,788 255.15 66.977 66.977 66.977 66.977 267.908 291,722 Paid media 25.104 301.248 79.734 79.734 79 734 79.734 318.936 13.721 83.721 83,721 83.721 334.884 364.652 Total Selling & Adminstrative Expenses $ 233,375 $ 2,800,500 $ 742,167 $ 742,167 $ 742,167 $ 742,167 $ 2,968,668 779,615 $ 779,615 $ 779,615 $ 779,615 $ 3,118,460 $ 3,393,023 Earnings/(Loss) Before Taxes 238,647 $ 2,686,649 $ 645,884 $ 670,176 $ 694,872 $ 720,017 $ 2,730,950 $ 661,367 $ 686,590 $ 712,149 $ 738,343 $ 2,798,548 $ 2,510,157Bevy Buddy Bevy Buddy Statement of Retained Earnings Statement of Retained Earnings For the Year ended December 31, 2024 For the Year ended December 31, 2025 January February March April May June July August September October November December January February March April May June July August September October November Beginning Retained Earnings $ $ (1,000,000) $ (1,000,000) S (1,000,000) S (1,043,334) 5 (1,086,668) 5 (1,263,812) $ (1,444,956) $ (1,322,240) $ (1,204,524) 5 (1,081,808) 5 (959,092) 5 (702,056) 5 (492,651) 5 (280,650) S (66,054) $ 151,136 5 370,969 $ 593,443 S 818,359 $ 1,046,363 $ 1,276,854 $ 1,510,033 Net Income/(Loss) $ (1,000,000) S S (43,334) $ (43,334) 5 (177,144) 5 (181,144) S 122,716 s 117,716 $ 122,716 $ 122,716 $ 257,036 $ 209,405 S 212,001 $ 214,595 $ 217,191 $ 219,832 $ 222,475 $ 225,116 $ 227,803 230,491 $ 233,179 S 235,913 Dividends S S S Ending Retained Earnings $ (1,000,000) 5 (1,000,000) 5 (1,000,000) 5 (1,043,334) $ (1,086,668) $ (1,263,812) 5 (1,444,956) 5 (1,322,240) $ (1.204.524) $ (1,081,808) (939,092) 5 (702,056) 5 (492.651) 5 (280.650) S (66.054) $ 151,136 $ 370,969 $ 593,443 $ 818,559 $ 1,046.363 S 1,276,854 $ 1.510.033 1,745,946Bevy Buddy Statement of Retained Earnings For the Year ended December 31, 2026 For the Year ended December 31, 2027 2028 December Quarter 1 Quarter 2 Quarter 3 Quarter 4 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total $ 1,745,946 $ 1,984,593 $ 2,630,477 $ 3,300,653 $ 3,995,525 $ 4,715,543 $ 5,376,909 $ 6,063,499 $ 6,775,748 $ 7,514,091 S 238.647 $ 645.884 5 670,176 $ 694.872 $ 720.017 $ 661.367 $ 686.590 $ 712.249 $ 738.343 $ 2.510,157 S S S S $ 1,984.593 $ 2,630.477 $ 3.300.653 $ 3,995.525 $ 4,715.543 $ 5.376.909 $ 6.063.499 $ 6,775,748 $ 7.514,091 $ 10.024.248Bevy Buddy Bevy Buddy Balance Sheet Balance Sheet At December 31, 2024 At December 31, 2025 January February March April May June July August September October November December January February March April May June July August Assets: Current Assets Cash $ 1,300,000 5 1,300,000 $ 1,300,000 $ 1,256,666 $ 1,213,332 $ 533,397 5 358,471 $ 398,046 S 521,980 S 650,914 S 779,848 $ 1,001,860 $ 1,173,362 $ 1,391,546 5 1,612,324 $ 1,835,699 $ 2,061,700 $ 2,290,345 $ 2,521,629 S 2,755,589 Accounts Receivable 89.359 89 359 89.359 89.359 130.601 131,357 132,127 132.89 133,667 134.451 135.234 136.018 136,81: Inventory 11,115 11,115 11,115 11,115 16,245 16,530 16,627 16,724 16,820 16.919 17,017 17,116 17,216 Other Current Assets Total Current Assets $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,256,666 $ 1,213,332 $ 533,397 $ 358,471 $ 498,520 $ 622,454 $ 751,388 $ 880,322 $ 1,148,706 $ 1,321,249 $ 1,540,300 $ 1,761,945 $ 1,986,186 $ 2,213,070 $ 2,442,596 $ 2,674,763 $ 2,909,620 Non-Current Assets Property, Plant, & Equipment S 'S 237,129 5 237,129 $ 237,129 $ 237,129 $ 237,129 $ 237,129 $ 237,129 $ 281,229 $ 281,229 $ 281,229 $ 281,229 $ 281,229 $ 281,229 S 281,229 $ 281,229 Accumulated Depreciation 3,95 7,904 11,856 15,808 19,760 23,712 27,66 32,351 37,038 41,725 46,412 51,099 55,786 60.473 65,16 Net PP&E 233,177 $ 229,225 S 225,273 S 221,321 S 217,369 S 213,417 $ 209,465 $ 248,878 S 244,191 $ 239,504 S 234,817 $ 230,130 S 225,443 S 220,756 S 216,069 Intangible Assets S 271,880 $ 271,880 $ 271,880 $ 271,880 S 271,880 S 271,880 S 271,880 $ 271,880 $ 271,880 5 271,880 $ 271,880 $ 271,880 S 271,880 271,880 S 271,880 Accumulated Amortization 2,266 4,532 6,798 9.064 11,330 13,596 15,862 18,128 20.394 22,660 24.926 27,192 29,458 31,724 33,990 Net Intangible Assets 269,614 S 267,348 S 265,082 S 262,816 S 260,550 S 258,284 $ 256,018 s 253,752 S 251,486 $ 249,220 S 246,954 $ 244,688 S 242,422 S 240,156 $ 237,890 Total Non-Current Assets $ 502,791 $ 496,573 $ 490,355 $ 484,137 $ 477,919 $ 471,701 $ 465,483 $ 502,630 $ 495,677 $ 488,724 $ 481,771 $ 474,818 $ 467,865 $ 460,912 $ 453,959 Total Assets $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,256,666 $ 1,213,332 $ 1,036,188 $ 855,044 $ 988,875 $ 1,106,591 $ 1,229,307 $ 1,352,023 $ 1,614,189 $ 1,823,879 $ 2,035,977 $ 2,250,669 $ 2,467,957 $ 2,687,888 $ 2,910,461 $ 3,135,675 $ 3,363,579 Liabilities: Current Liabilities Accounts Payable S S S 11,115 $ 11,115 $ 11,115 $ 11,115 $ 16,245 $ 16,530 $ 16,627 $ 16,724 $ 16,820 $ 16,919 $ 17,017 S 17,116 $ 17,216 Other Current Liabilities Total Current Liabilities $ $ 11,115 $ 11,115 $ 11,115 $ 11,115 $ 16,245 $ 16,530 $ 16,627 $ 16,724 $ 16,820 $ 16,919 $ 17,017 $ 17,116 $ 17,216 Non-Current Liabilities Other Long Term Liabilities S S S S S S S S Total Liabilties $ S S $ $ 11,115 $ 11,115 $ 11,115 $ 11,115 $ 16,245 $ 16,530 $ 16,627 $ 16,724 $ 16,820 $ 16,919 $ 17,017 $ 17,116 $ 17,216 Owners' Equity Founders' Investment S 300,000 S 300,000 $ 300,000 S 300,000 S 300,000 S 300,000 S 300,000 S 300,000 S 300,000 S 300,000 S 300,000 S 300,000 S 300,000 S 300,000 300,000 S 300,000 S 300,000 S 300,000 S 300,000 S 300,000 Angel Investor's Investment 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 Retained Earnings (1,000,000) (1,000,000) (1,000,000) (1,043,334) (1,086,668) (1,263,812) (1,444,956) (1,322,240) (1,204,524) (1,081,808) (959,092) (702,056) (492,651) (280,650) (66,054) 151,136 370,969 593,443 818,559 1,046,363 Total Owners' Equity $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,256,666 $ 1,213,332 $ 1,036,188 $ 855,044 $ 977,760 $ 1,095,476 $ 1,218,192 $ 1,340,908 $ 1,597,944 $ 1,807,349 $ 2,019,350 $ 2,233,946 $ 2,451,136 $ 2,670,969 $ 2,893,443 $ 3,118,559 $ 3,346,363 Total Liabilties & Owners' Equity $ 1,300,000 $ 1,300,000 $ 1,300,000 $ 1,256,666 $ 1,213,332 $ 1,036,188 $ 855,044 $ 988,875 $ 1,106,591 $ 1,229,307 $ 1,352,023 $ 1,614,189 $ 1,823,879 $ 2,035,977 $ 2,250,669 $ 2,467,957 $ 2,687,888 $ 2,910,461 $ 3,135,675 $ 3,363,579

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Accounting An Integrated Approach

Authors: Penne Ainsworth, Dan Deines

5th Edition

0073527009, 9780073527000

More Books

Students also viewed these Accounting questions

Question

What is the purpose of depreciation?

Answered: 1 week ago

Question

Date decision to be made (if known)

Answered: 1 week ago