Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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.

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

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

Financial Management Core Concepts

Authors: Raymond Brooks

4th Edition

134730417, 134730410, 978-0134730417

More Books

Students also viewed these Finance questions

Question

Define the term sport sponsorship.

Answered: 1 week ago

Question

Outline the sections of a sponsorship proposal.

Answered: 1 week ago

Question

Highlight the key elements of sponsorship targeting.

Answered: 1 week ago