Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to find this answers. you need to mention the equation too Maxwell Smart STRONG Suggestion Completely fill in Common Size numbers INCOME STATEMENT
I need to find this answers. you need to mention the equation too
Maxwell Smart STRONG Suggestion Completely fill in Common Size numbers INCOME STATEMENT Common Size FY 12/31 2015 130,000,000 58,500,000 71,500,000 100.0% 45.0% 55.0% Sales and Marketing (S&M) General and Admin Research and Development Depreciation and Amortization Total Operating Costs 26,000,000 13,000,000 5,000,000 5,000,000 49,000,000 20.0% 10.0% 3.8% 3.8% 37.7% Operating Income 22,500,000 17.3% 250,000 880,000 0.2% 0.7% 0.0% 16.8% 5.9% 10.9% Revenue Cost of Goods Sold Gross Profit Interest Income Interest Expense Pre Tax Income Tax (35%) Net Income EPS - Basic EPS - Diluted 21,870,000 7,654,500 14,215,500 $ Assumptions Revenue 20% G. Margins 1.0% S&M 1.0% (CSB) G&A improves 0.5% (CSB) R&D $500,000 D&A Stable ($ value) Approx 4.0% of Avg. Cash 7% of Total Debt Obligations Same rate as previous year 1.42 Shares Outstanding 10,000,000 Shares Outstanding for Diluted 5 mil common stock warrants exercisable @ $4.50, stock price for calculations = $5 BALANCE SHEET Cash A/R (Avg Collec Period = 30 days) Inventory (Days Inv. Held = 45) Other Total Current Assets 12/31/15 5,000,000 10,684,932 7,212,329 5,000,000 27,897,260 PP&E Less Accumulated Depreciation Net PP&E 50,000,000 5,000,000 45,000,000 Other 5,000,000 Collec period = 25 days Days Inv = 45 days $1,000,000 No change PP&E 10 yr SLD No change Total Assets 77,897,260 Accounts Payable Current portion of LTD Accrued Liabilities Total Current Liabilities 10,000,000 2,000,000 1,376,712 13,376,712 LTD 9,000,000 Total Liabilities 22,376,712 Common Stock Addl PIC Retained Earnings 1,000 9,999,000 45,520,548 Shareholder's Equity 55,520,548 Total Equity and Liabilities 77,897,260 Average collection Period = Accounts Receiable Average Daily Sales Average Daily Sales = Sales 365 Days Inventory Held = Inventory Average Daily Cost of Sales Average Daily Sales = Cost of Goods Sold 365 10% ($ value) No change No change $1 Mil paid off on 1/1/15 No change No change T CSB = Common Size Basis Points Instructions: Common Size 2016E 156,000,000 715,000 156,000,000 715,000 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. 100.0% 0.0% 0.0% 2.5 2.5 0.0% 0.0% 0.0% 0.0% 0.0% 2.5 2.5 2.5 2.5 2.5 0.0% 2.5 0.5% 0.0% 3.0 To help with calculating Diluted Share 2.5 Orig Shrs Added Proceeds Bought from Mkt Net shares 0.0% 0.0% 0.0% 2.5 2.5 2.5 10.0 10,000,000 10,000,000 10.0 53.0 CASH FLOW STATEMENT 2016E 12/31/16E 3.0 3.0 3.0 2.5 2.5 2.5 3.0 1.0 2.5 Net Income Depreciation A/R Inventory Other A/P Accrued Liabs Total Cash flow from Ops PP&E Other 3.0 Financing 2.5 2.5 2.5 2.5 Net Cash Flow 2.5 2.5 2.5 2.5 3.0 B = 80 and up 3.0 3.0 55.0 - w boxes (including mart with your name). a formula already in the . The formulas are there on. You can change them s not advised. with calculating Diluted Shares 10,000,000 FLOW STATEMENT 2.0 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 2.5 27.0 135.0 B = 80 and upStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started