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...

See similar textbooks

Similar questions

are given the following information about Jordan plc:Financial position statement at January 2017£000 £000Non-current assets 1,511Current assets 672Total assets 2,183Equity financeOrdinary shares (50p) 200Reserves 150Non-current liabilities7% preference shares 3009% bonds (redeemable after 8 years) 6509% bank notes 560Current liabilities 323Total liabilities 2183You are also given the following information:• Yield on Treasury bills 7%• Jordan plc equity beta 1.21• Equity risk premium 9.1%• Current ex-div ordinary share price £2.35• Current ex-div preference share price 66p• Current ex-interest bond price £105• Corporate tax rate 30%Required:(a). calculate the company’s weighted average cost of capital (WACC) using market weightings.(b). critically discuss whether you consider that companies, by integrating a sensible level of gearinginto their capital structure, can minimise their weighted average cost of capital.
Santiago Enterprises has the following potentially dilutive securities that it has issued prior to the current fiscal year. SANTIAGO ENTERPRISES POTENTIALLY DILUTIVE SECURITIES FOR CALCULATING DILUTED EARNINGS PER SHARE AT BEGINNING OF CURRENT FISCAL YEAR Long Term Debt: Bonds Payable, 8%, issued in denominations of $1,000 at par, each bond is convertible into 15 shares of common stock 1,000,000 Stockholders' Equity: Preferred Stock, $25 par value, 5% annual dividend rate, cumulative and nonparticipating, each share is convertible into 2.5 shares of common stock 1,000,000 Stock Options Outstanding, 100,000 options, $15 option exercise price The company's average stock price for the year is $25 and the price at the end of the fiscal year is $21. The company's average tax rate for the year is 30%. REQUIRED: Calculate the per share effects for each of these potentially dilutive securities that would be used to calculate the company's diluted earnings per share for the year. Round your…
Complete the table. (Round earnings per share to 2 decimal places, e.g. $2.66.) Income before interest and taxes Interest expense from bonds Income before income taxes Income tax expense (40%) Net income Outstanding shares Earnings per share $ $ Issue Stock $1,584,000 $ $ Issue Bonds $1,584,000 140800 528,000
The following table presents information for Golden Fleece Financial. Long-term debt outstanding Current yield to maturity on debt Number of shares of common stock Price per share Book value per share Expected rate of return on stock Cost of capital $470,000 % $ $ 9.00% Calculate the company cost of capital. (Ignore taxes. Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) 18,500 67 42 18.00%
2. The balance sheet for Putnam Corporation at the end of the current year include the following: Page 7 of 9 ManEco-01 FINANCIAL STATEMENT ANALYIS Bonds payable, 6% 6% Preferred stock, P100 par. Common stock, P10 par Income before income taxes was P950,000 and income tax expense for the current year amounted to P285,000. Cash dividends paid on common stock were P200,000, and the common stock was selling for P40 per share at the end of the year. There were no ownership changes during the year. Instructions Determine each of the following: (a) times Interest earned. (b) earnings per share for common stock. (c) price-earnings ratio. P5,000,000 1,000,000 2,000,000
II. The following is a comparative balance sheet of ABC Co. for December 31, 2022 and 2021: Cash and cash equivalents Accounts receivable Inventories Investment in bonds at amortized cost Equipment Accumulated depreciation Total Assets Accounts payable Bonds payable, due 2025 Ordinary stock, P20 par Share premium Retained earnings Total Liabilities and Equity Additional information: . 2022 250,000 327,600 822,000 0 . 2,400,000 (700,000) 3,099,600 359,000 0 1,800,000 280,000 660,600 3,099,600 2021 220,000 356,000 780,000 200,000 2,040,000 (760,000) 2,836,000 • Net income for 2022, P545,600. Depreciation reported on income statement, P140,000. Fully depreciated equipment, no salvage value, was scrapped. Equipment was purchased for P560,000. Bonds of P400,000 were retired at their face value. 281,000 400,000 1,600,000 200,000 355,000 2,836,000 10,000 shares of ordinary stock were issued for cash of P28 per share. Cash dividends declared and paid, P240,000 Investment in bonds with carrying…
SW Company provides the Equity & Liability information below for analysis. SW Company had net income of $424,100 in 2023 and $373,500 in 2022. Equity and Liabilities. Share capital-common (141,800 shares issued) Retained earnings (Note 1) Accrued liabilities. Notes payable (current) Accounts payable Total equity and liabilities Return on equity 2022 Book value per share Note 1: Cash dividends were paid at the rate of $1 per share in 2022 and $2 per share in 2023. Required: 1. Calculate the return on common share equity for 2022 and 2023. (Assume total equity was $1,618,900 at December 31, 2021.) (Round your answers to 1 decimal place.) 2023 2022 2023 2022 $1,228,500 $1,228,500 274,500 6,600 56, 600 171,900 $1,797,000 $1,738,100 2023 429,500 8,500 2. Calculate the book value per shares for 2022 and 2023. (Round your answers to 2 decimal places.) 69,700 60,800
Assume the following data for Cable Corporation and Multi-Media Incorporated. Multi-Media Incorporated Cable Corporation $ 39,800 352,000 409,000 $ 190,000 2,170,000 966,000 234,000 545,000 175,000 421,000 Net income Sales Total assets Total debt Stockholders' equity a. 1. Compute return on stockholders' equity for both firms. Note: Input your answers as a percent rounded to 2 decimal places. Cable Corporation Multi-Media, Incorporated 2. Which firm has the higher return? Return on Stockholders' Equity % %
1. The PowerPoint Corporation has two classes of share capital outstanding: 9% (dividend rate), P20 par, Preference and P70 par, Ordinary. During the fiscal year ending December 31, 2012, the company had the equity transactions in chronological order as reflected in the table below. Dividends were paid at the end of the fiscal year on the ordinary share at P1.20 per share and on the preference at the preference rate. Profit for the year was P850,000. How much should be the amount of Preference Share Capital to be shown on the December 31, 2012 statement of financial position? No. of shares Price per share Issue of preference share 10,000 P28 Issue of ordinary share 35,000 70 Reacquisition and retirement of preference 2,000 30 Purchase of treasury ordinary share 5,000 80 Share split 2-for-1 Reissue of treasury ordinary share. 5,000 52 Balances of the accounts in the shareholders' equity section of the December 31, 2011 statement of financial position were: Preference Share Capital,…
1. The PowerPoint Corporation has two classes of share capital outstanding: 9% (dividend rate), P20 par, Preference and P70 par, Ordinary. During the fiscal year ending December 31, 2012, the company had the equity transactions in chronological order as reflected in the table below. Dividends were paid at the end of the fiscal year on the ordinary share at P1.20 per share and on the preference at the preference rate. Profit for the year was P850,000. No. of shares Price per share Issue of preference share 10,000 P28 Issue of ordinary share 35,000 70 Reacquisition and retirement of preference 2,000 30 Purchase of treasury ordinary share 5,000 80 Share split 2-for-1 Reissue of treasury ordinary share. 5,000 52 Balances of the accounts in the shareholders' equity section of the December 31, 2011 statement of financial position were: Preference Share Capital, 50,000 shares P1,000,000 Ordinary Share Capital, 100,000 shares 7,000,000 Share Premium - Preference 400,000 Share Premium-Ordinary…
Current assets Net Fixed assets Total assets Accounts payable and accurals. Short term debt Long term debt Preferred Stock (10,000 shares) Common Stock (50,000 shares) Retained earnings Total common equity Total liabilities and equity $2,000 3,000 $5,000 $900 100 1,100 250 1,300 1,350 $2,650 $5,000 Sunrise's earnings per share last year were $3.20. The common stock sells for $52.00, last year's dividend (D.)was $2.25, and a flotation cost of 10% would be required to sell new common stock. Security analysts are projecting that the common dividend will grow at an annual rate of 8.8%. Sunrise's preferred stock pays a dividend of $2.90 per share, and its preferred stock sells for $25.00 per share. The firm's before-tax cost of debt is 12%, and its marginal tax rate is 25%. The firm's currently outstanding 10% annual coupon rate, long-term debt sells at par value. The market risk premium is 5.2%, the risk- free rate is 5.5%, and Sunrise's beta is 1.526. The firm's total debt, which is the…
Current assets Net Fixed assets Total assets Accounts payable and accurals. Short term debt Long term debt Preferred Stock (10,000 shares) Common Stock (50,000 shares) Retained earnings Total common equity Total liabilities and equity $2,000 3,000 $5,000 $900 100 1,100 250 1,300 1,350 $2,650 $5,000 Sunrise's earnings per share last year were $3.20. The common stock sells for $52.00, last year's dividend (D.)was $2.25, and a flotation cost of 10% would be required to sell new common stock. Security analysts are projecting that the common dividend will grow at an annual rate of 8.8%. Sunrise's preferred stock pays a dividend of $2.90 per share, and its preferred stock sells for $25.00 per share. The firm's before-tax of debt is 12%, and its marginal tax rate is 25%. The firm's currently outstanding 10% annual coupon rate, long-term debt sells at par value. The market risk premium is 5.2%, the risk- free rate is 5.5%, and Sunrise's beta is 1.526. The firm's total debt, which is the sum of…