Using Excel to Calculate Dilutive Earnings Per Share PROBLEM Oakridge Corporation has provided the information that follows related to its calculation of earnings per share for 2023. Its common shares and bonds were outstanding during the entire year. Net income Common shares outstanding Face value of convertible bonds Shares into which bonds can be converted Face rate of the bonds Tax rate $ 400,000 100,000 900,000 15,000 10% 25% the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Calculate Oakridge's 2023 basic and diluted earnings per share. For simplicity, ignore the IFRS requirement to record the debt and equity components of the bonds separately. Basic earnings per share Potential increase in diluted EPS numerator Potential increase in diluted EPS denominator Test of antidilutive bonds Diluted earnings per share
Using Excel to Calculate Dilutive Earnings Per Share PROBLEM Oakridge Corporation has provided the information that follows related to its calculation of earnings per share for 2023. Its common shares and bonds were outstanding during the entire year. Net income Common shares outstanding Face value of convertible bonds Shares into which bonds can be converted Face rate of the bonds Tax rate $ 400,000 100,000 900,000 15,000 10% 25% the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Calculate Oakridge's 2023 basic and diluted earnings per share. For simplicity, ignore the IFRS requirement to record the debt and equity components of the bonds separately. Basic earnings per share Potential increase in diluted EPS numerator Potential increase in diluted EPS denominator Test of antidilutive bonds Diluted earnings per share
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 54E: Rebert Inc. showed the following balances for last year: Reberts net income for last year was...
Related questions
Question
![Using Excel to Calculate Dilutive Earnings Per Share
PROBLEM
Oakridge Corporation has provided the information that
follows related to its calculation of earnings per share for
2023. Its common shares and bonds were outstanding during
the entire year.
Net income
Common shares outstanding
Face value of convertible bonds
Shares into which bonds can be converted
Face rate of the bonds
Tax rate
$ 400,000
100,000
900,000
15,000
10%
25%](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe156e5f2-9c38-4ccf-b9ab-31d76292d136%2F240542fb-f7cc-4a7b-af81-c3621fd0be90%2Fn5ze1ma_processed.png&w=3840&q=75)
Transcribed Image Text:Using Excel to Calculate Dilutive Earnings Per Share
PROBLEM
Oakridge Corporation has provided the information that
follows related to its calculation of earnings per share for
2023. Its common shares and bonds were outstanding during
the entire year.
Net income
Common shares outstanding
Face value of convertible bonds
Shares into which bonds can be converted
Face rate of the bonds
Tax rate
$ 400,000
100,000
900,000
15,000
10%
25%
![the required mathematical formulas or functions with cell references to the
Problem area or work area as indicated.
Calculate Oakridge's 2023 basic and diluted earnings per share. For
simplicity, ignore the IFRS requirement to record the debt and equity
components of the bonds separately.
Basic earnings per share
Potential increase in diluted EPS numerator
Potential increase in diluted EPS denominator
Test of antidilutive bonds
Diluted earnings per share](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe156e5f2-9c38-4ccf-b9ab-31d76292d136%2F240542fb-f7cc-4a7b-af81-c3621fd0be90%2Fmmqrzeh_processed.png&w=3840&q=75)
Transcribed Image Text:the required mathematical formulas or functions with cell references to the
Problem area or work area as indicated.
Calculate Oakridge's 2023 basic and diluted earnings per share. For
simplicity, ignore the IFRS requirement to record the debt and equity
components of the bonds separately.
Basic earnings per share
Potential increase in diluted EPS numerator
Potential increase in diluted EPS denominator
Test of antidilutive bonds
Diluted earnings per share
AI-Generated Solution
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
![Cornerstones of Financial Accounting](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
![Financial Accounting: The Impact on Decision Make…](https://www.bartleby.com/isbn_cover_images/9781305654174/9781305654174_smallCoverImage.gif)
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
![Cornerstones of Financial Accounting](https://www.bartleby.com/isbn_cover_images/9781337690881/9781337690881_smallCoverImage.gif)
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
![Financial Accounting: The Impact on Decision Make…](https://www.bartleby.com/isbn_cover_images/9781305654174/9781305654174_smallCoverImage.gif)
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
![Intermediate Accounting: Reporting And Analysis](https://www.bartleby.com/isbn_cover_images/9781337788281/9781337788281_smallCoverImage.jpg)
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
![Pfin (with Mindtap, 1 Term Printed Access Card) (…](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning