Maxwell Smart Points Common Size FY 12/31 STRONG Suggestion - Completely fill in Common Size numbers INCOME STATEMENT Common CSB - Common Site Basis Size Assumptions 2020 2021E 125,000,000 100.0% Revenue 1 25% 187,500,000 57,500,000 48.0% 67,500,000 54.0% G. Margins 1.0% Instructions: Fill in only the Yellow boxes (including replacing Maxwell Smart with your name). Sometimes there is a formula already in the box - sometimes not. The formulas are there as an aid to navigation. You can change them if you want - But It is not advised. 187,500,000 Revenue Cost of Goods Sold Gross Profit 100.0% 0.0% 0.0% 2.0 Show your work in the Yellow boxes for partial credit in case you do not get the correct answer. Sales and Marketing (S&M) General and Admin Research and Development Depreciation and Amortization Total Operating costs 25,000,000 12,500,000 5,000,000 5.000.000 47,500,000 20.0% 10.0% 4.0% 4.0% 38.0% S&M. 1.0% (CSB) G&A improves 1% (CSB) R&D$500,000 ($value) D&A Stable (s value) 0.0% 0.0% 0.0% 0.0% 0.0% 2.0 2.0 2.0 1.5 2.5 Operating Income 20,000,000 16.0% 0.0% 2.0 199 000 Interest Income Interest Expenso 250.000 880.000 199,000 Approx 1.01% of Avg. Cash 8% of Total Installment Debt Obligations 0.1% 0.0% 3.0 Pre Tax Income Tax (35%) Net Income 11,000,000 0.2% 0.7% 0.0% 15.5% 3.3% 12.2% 19,370,000 4067700 15,302,300 21% 0.0% 0.0% 0.0% 2.5 1.5 20 Orig Shrs Added Proceeds Bought from Mkt Net shares $ 1.39 EPS - Basic EPS - Diluted 25 15.0 11,000,000 11,000,000 Shares Outstanding 11.000.000 Shares Outstanding for Diluted 5 mil common stock warrants exercisable @ $3.75, stock price for calculations - $5.00 15.0 57.0 CASH FLOW STATEMENT Projected 2021E BALANCE SHEET 12/31/21E / Net Income 25.000 2.0 1.0 Depreciation Cash A/R (Avg Cole Period = 30 days) Inventory Days in. Hold = 45) Other Total Current Assets 12/31/20 5,000,000 10,273,973 7,089, 041 5,000,000 27,363 014 Colec period - 30 days Days Inv = 40 days 3.5 3.0 30 2.0 2.0 $1.000.000 AR Inventory Other AVP Accrued Labs from Ops 2.5 2.5 2.0 2.0 2.0 2.5 PP&E Less Accumulated Depreciation Not PP&E 50,000,000 5,000 000 45,000,000 No charge PP&E 10yr SLD 2.0 2.0 10 2.0 PP&E Other Other 5,000,000 No change 2.0 Total Assets 77,363,014 3.0 Financing 2.0 Net Cash Flow Accounts Payable Current portion of LTD Accrued Libilities Total Current Liabilities 2.5 23.0 10,000,000 2,000,000 842 486 12,842 488 | 10% ($value) No change No change 2.0 1.5 1.5 2.0 125.0 LTD 9,000,000 $1 M paid ofon 1721 2.0 Total Liabilities 21,842 466 25 Common Stock Addi PIC Retained Earings Shareholder's Equity 1,000 9,999,000 45,520,518 No change No change 1.5 1.5 2.6 55,520,548 2.5 B = 80 and up Total Equity and Liabilities 77,363,014 2.0 45.0 Average coleccion Period - Accounts Receible Average Da Saks Average Day Sales - Sales 365 Maxwell Smart Points Common Size FY 12/31 STRONG Suggestion - Completely fill in Common Size numbers INCOME STATEMENT Common CSB - Common Site Basis Size Assumptions 2020 2021E 125,000,000 100.0% Revenue 1 25% 187,500,000 57,500,000 48.0% 67,500,000 54.0% G. Margins 1.0% Instructions: Fill in only the Yellow boxes (including replacing Maxwell Smart with your name). Sometimes there is a formula already in the box - sometimes not. The formulas are there as an aid to navigation. You can change them if you want - But It is not advised. 187,500,000 Revenue Cost of Goods Sold Gross Profit 100.0% 0.0% 0.0% 2.0 Show your work in the Yellow boxes for partial credit in case you do not get the correct answer. Sales and Marketing (S&M) General and Admin Research and Development Depreciation and Amortization Total Operating costs 25,000,000 12,500,000 5,000,000 5.000.000 47,500,000 20.0% 10.0% 4.0% 4.0% 38.0% S&M. 1.0% (CSB) G&A improves 1% (CSB) R&D$500,000 ($value) D&A Stable (s value) 0.0% 0.0% 0.0% 0.0% 0.0% 2.0 2.0 2.0 1.5 2.5 Operating Income 20,000,000 16.0% 0.0% 2.0 199 000 Interest Income Interest Expenso 250.000 880.000 199,000 Approx 1.01% of Avg. Cash 8% of Total Installment Debt Obligations 0.1% 0.0% 3.0 Pre Tax Income Tax (35%) Net Income 11,000,000 0.2% 0.7% 0.0% 15.5% 3.3% 12.2% 19,370,000 4067700 15,302,300 21% 0.0% 0.0% 0.0% 2.5 1.5 20 Orig Shrs Added Proceeds Bought from Mkt Net shares $ 1.39 EPS - Basic EPS - Diluted 25 15.0 11,000,000 11,000,000 Shares Outstanding 11.000.000 Shares Outstanding for Diluted 5 mil common stock warrants exercisable @ $3.75, stock price for calculations - $5.00 15.0 57.0 CASH FLOW STATEMENT Projected 2021E BALANCE SHEET 12/31/21E / Net Income 25.000 2.0 1.0 Depreciation Cash A/R (Avg Cole Period = 30 days) Inventory Days in. Hold = 45) Other Total Current Assets 12/31/20 5,000,000 10,273,973 7,089, 041 5,000,000 27,363 014 Colec period - 30 days Days Inv = 40 days 3.5 3.0 30 2.0 2.0 $1.000.000 AR Inventory Other AVP Accrued Labs from Ops 2.5 2.5 2.0 2.0 2.0 2.5 PP&E Less Accumulated Depreciation Not PP&E 50,000,000 5,000 000 45,000,000 No charge PP&E 10yr SLD 2.0 2.0 10 2.0 PP&E Other Other 5,000,000 No change 2.0 Total Assets 77,363,014 3.0 Financing 2.0 Net Cash Flow Accounts Payable Current portion of LTD Accrued Libilities Total Current Liabilities 2.5 23.0 10,000,000 2,000,000 842 486 12,842 488 | 10% ($value) No change No change 2.0 1.5 1.5 2.0 125.0 LTD 9,000,000 $1 M paid ofon 1721 2.0 Total Liabilities 21,842 466 25 Common Stock Addi PIC Retained Earings Shareholder's Equity 1,000 9,999,000 45,520,518 No change No change 1.5 1.5 2.6 55,520,548 2.5 B = 80 and up Total Equity and Liabilities 77,363,014 2.0 45.0 Average coleccion Period - Accounts Receible Average Da Saks Average Day Sales - Sales 365