Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

I need to find this answers. you need to mention the equation too

image text in transcribed 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 up

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_2

Step: 3

blur-text-image_3

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

International Financial Reporting A Practical Guide

Authors: Alan Melville

6th edition

1292200743, 1292200766, 9781292200767, 978-1292200743

More Books

Students also viewed these Finance questions