Using Excel to Calculate Dilutive Earnings Per SharePROBLEMOakridge Corporation has provided the information thatfollows related to its calculation of earnings per share for2023. Its common shares and bonds were outstanding duringthe entire year.Net incomeCommon shares outstandingFace value of convertible bondsShares into which bonds can be convertedFace rate of the bondsTax rate$ 400,000100,000900,00015,00010%25% the required mathematical formulas or functions with cell references to theProblem area or work area as indicated.Calculate Oakridge's 2023 basic and diluted earnings per share. Forsimplicity, ignore the IFRS requirement to record the debt and equitycomponents of the bonds separately.Basic earnings per sharePotential increase in diluted EPS numeratorPotential increase in diluted EPS denominatorTest of antidilutive bondsDiluted earnings per share

The objective of the question is to calculate the basic and diluted earnings per share (EPS) for…

Answered: Using Excel to Calculate Dilutive…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Five Measures of Solvency or Profitability The balance sheet for Bearing Industries Inc. at the end of the current fiscal year indicated the following: Bonds payable, 7% $1,400,000 320,000 Preferred $5 stock, $100 par Common stock, $12 par 600,000 Income before income tax was $254,800, and income taxes were $38,800, for the current year. Cash dividends paid on common stock during the current year totaled $30,000. The common stock was selling for $40 per share at the end of the year. Determine each of the following. Round answers to one decimal place, except for dollar amounts which should be rounded to the nearest whole cent. Use the rounded answers for subsequent requirements, if required. a. Times interest earned ratio b. Earnings per share on common stock c. Price-earnings ratio d. Dividends per share of common stock e. Dividend yield $ $ times %
Accounts Payable Notes Payable Long Term Debt Common Stock Retained Earnings Total Liabilities & Equity $ 275,000 $ 315,000 $ 495,000 $ 925,000 $2,450,000 $4,460,000 Pre-Tax Cost of Debt: Intermediate Debt: 4.5% Long Term Debt: 6.5% Tax Rate: 21% Return on Equity: 11% Dividends per share: $0.20 Earnings per share: $0.90 C/S market price: $55 C/S outstanding: 80000 shares This company uses intermediate debt, long-term debt and common equity to finance its operations. With the information presented above: a. Calculate the firm's debt ratio (book value and market value based) b. Calculate the firm's WACC c. Calculate the new firm's WACC if the firm issued 150,000 new common stock at a flotation cost of $1.20 per share. The new issuance generates $4.5 million.
Carla Vista Corporation had net income of $42,000 for the year ended December 31, 2023, and weighted average number of common shares outstanding of 10,000. The following information is provided regarding the capital structure: 1. 2. (a1) (a2) 8% convertible debt, 210 bonds each convertible into 43 common shares. The bonds were outstanding for the entire year. The income tax rate is 35%. The bonds were issued at par ($1,150 per bond). No bonds were converted during the year. 3% convertible, cumulative $100 preferred shares, 1,000 shares issued and outstanding. Each preferred share is convertible into 2 common shares. The preferred shares were issued at par and were outstanding the entire year. No shares were converted during the year. Calculate the basic earnings per share for 2023. (Round answer to 2 decimal places, e.g. 15.25.) Basic earnings per share eTextbook and Media
Want answer with calculation
The balance sheet of QUIGGE and get the end of the current fiscal year indicated the following bonds payable 8% $1 million preferred $10 stock $100 par 117,000 common stock $13 par 1,026,675 income before and come tax expense was $200,000 in income taxes for $30,350 for the current year cash dividends paid common stock during the current. Your total is $do 47,285 common stock with selling for $20 per share at the end of the year determine each of the following round answers to one decimal place, except for dollar amounts, which should be rounded to the nearest whole cent a. Times interest earned ratio. b. Earnings per share in common stock. c. Price earnings ratio. d. Dividends per share of common stock. e. Dividend yield.
Balance sheet and income statement data indicate the following: Bonds payable, 10% (due in two years) Preferred 5% stock, $100 par (no change during year) Common stock, $50 par (no change during year) Income before income tax for year Income tax for year Common dividends paid Preferred dividends paid Interest expense Based on the data presented, what is the times interest earned ratio? Round your answer to two decimal places. 2.46 3.07 0.41 5.07 $868,000 263,400 2,167,800 353,540 81,447 108,390 13,170 86,800
please answer part d,e
Amy Dyken, controller at Shamrock Pharmaceutical Industries, a public company, is currently preparing the calculation for basic and diluted earnings per share and the related disclosure for Shamrock’s financial statements. Below is selected financial information for the fiscal year ended June 30, 2020. Long-term debt Notes payable, 10% $990,000 9% convertible bonds payable 5,040,000 10% bonds payable 6,080,000 Total long-term debt $12,110,000 Shareholders’ equity Preferred stock, 5% cumulative, $50 par value, 104,000 shares authorized, 26,000 shares issued and outstanding $1,300,000 Common stock, $1 par, 10,000,000 shares authorized, 1,000,000 shares issued and outstanding 1,000,000 Additional paid-in capital 3,990,000 Retained earnings 6,090,000 Total shareholders’ equity $12,380,000 The following transactions have also occurred at Shamrock. 1. Options were granted on July 1, 2019, to purchase 180,000 shares at $15…
A7 please help.......
Trina's Trikes, Inc. reported a debt-to-equity ratio of 1.81 times at the end of 2018. If the firm's total debt at year-end was $9.00 million, how much equity does Trina's Trikes have? A. $16.29 million B. $1.81 million C. $9.00 million D. $4.97 million
Questions: 1. Price-earnings ratio 2. Dividend payout ratio 3. Dividend yield ratio
A2 please help......

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS