Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please see attached spread sheet, please answer all the questions highlighted in yellow please sue same spreadsheet so i can see the formulas. some of
please see attached spread sheet, please answer all the questions highlighted in yellow please sue same spreadsheet so i can see the formulas. some of them are answered but checked them to see if they are correct.
Problem 1 - 30 points Use the following information to complete the income statement for Company A for th Income Statement Information Revenue Gross Margin Selling General and Administrative (SG&A) Research and Development (R&D) Depreciation expense (D&A) Interest Expense Interest Income Tax Rate Securities Information Weighted Average Shares (12/31/15) A Warrants exercisable @ $2.00 B Warrants exercisable @ $3.00 Stock Price (12/31/15) Complete the following Income Statement Answers go in the yellow boxes Revenue Cost of Goods Sold Gross Profit Operating Expenses SG&A R&D D&A Operating Expenses Total Operating Income Income Expense, net Pre Tax Income Tax Net Income EPS Basic EPS Diluted Use this table (below) to help with your calculations Diluted Share Calculations Basic A warrants B warrants Total Proceeds A warrants B warrants Total Proceeds Shares repurchased Diluted shares used to calculate Diluted EPS Total Score Please Type your answers in the Yellow Boxes Do not type anything in these (Blue) boxes the income statement for Company A for the year ending December 31, 2015 (show work): $ 125,000,000 42.0% 22.0% 15.0% $ 5,000,000 $ 5,000,000 $ 2,000,000 35% of revenue of revenue 10,000,000 2,200,000 2,500,000 $ 4.25 $ 125,000,000 Points 1 1 1 1 1 5 1 1 $ 125,000,000 1 2 5 10 Total Points 60 30 Problem 2 - 10 Points Given the information below, calculate the Working Capital and Current Ratio 1 Cash and marketable securities - $2,500,000 2 Accounts Receivable (Gross) - $3,000,000 Allowance for doubtful accounts $75,000 3 Accounts Payable - $500,000 4 Accumulated Depreciation 2,000,000 6 Inventory - $4,000,000 7 Other Current Assets - $1,000,000 8 Common Stock at Par Value - $100,000 9 Current portion of long term notes - $800,000 10 Other Current Liabilities - $500,000 11 Goodwill - $10,000,000 12 Long-Term debt - $8,000,000 Answers go in the yellow boxes Working Capital Current Ratio $10,700,000 2.1:1 5 5 10 Problem 3 - 20 Points Given the following Information on ABC Corp, calculate the ratios below ABC Corp. Year end statements Balance Sheet 12/31/14 ASSETS Cash 2014 2,500,000 Accounts Payable Accounts Recievable 2,000,000 Current portion of LTD Inventory 3,000,000 Accrued Liabilities Total Current Assets 7,500,000 Total Current Liabilities Property Plant & Equipment, net 8,000,000 Long Term Debt (LTD) Other Assets 2,000,000 Shareholder's Equity Total Assets $ LIABILITIES $ 17,500,000 Income Statement FY 12/31 2015 Revenue Cost of Goods Sold Gross Profit $ 12,000,000 5,000,000 7,000,000 Selling General & Admin Research and Development Depreciation and Amortization Total Operating expenses 2,400,000 1,500,000 1,500,000 5,400,000 Operating Profit 1,600,000 Interest Income Interest Expense 100,000 700,000 Total Liabilities & Equity Pre tax Profit Tax (@35%) Net income $ 1,000,000 350,000 650,000 e ratios below Balance Sheet 12/31/15 2014 1,200,000 2015 Cash 3,500,000 Accounts Recievable 2,000,000 1,400,000 Inventory 3,000,000 3,500,000 Total Current Assets 8,500,000 9,000,000 Property Plant & Equipment, net 8,000,000 5,000,000 Other Assets 2,000,000 17,500,000 Total Assets 900,000 $ ASSETS $ 18,500,000 Answers go in the yellow boxes Current ratio 12/31/15 Accounts Receivable Turnover Total Asset Turnover Inventory Turnover Liabilities to Equity 12/31/15 Revenue to Cash Days revenue in Cash Days Inventory Return on Assets Return on Equity 2.4:1 4.0:1 1.7:1 0.6:1 2.8:1 129 219 2.4% 8.1% 2 2 2 2 2 2 2 2 2 2 20 Balance Sheet 12/31/15 LIABILITIES Accounts Payable Current portion of LTD 2015 1,400,000 900,000 Accrued Liabilities 1,200,000 Total Current Liabilities 3,500,000 Long Term Debt (LTD) 9,000,000 Shareholder's Equity 6,000,000 Total Liabilities & Equity $ 18,500,000Step 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