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.

Use function IF to resolve wrong responses. - Instructions: 26% of your score. Function: IF; Cell reference. Use the IF function with cell references to the Problem area and to this work area. In the respective function fields, set the output to display either Antidilutive or Dilutive.

-Instructions: 26% of your score. Function: IF; Cell reference. Use the IF function with cell references to the Problem area and to this work area. In the respective function fields, set the output to display either the calculated EPS or if antidilutive, then the amount of basic EPS.

Function: IF; Formula: Subtract, Multiply, Divide, Add; Cell Referencing 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. \begin{tabular}{lr} Net income & $400,000 \\ Common shares outstanding & 100,000 \\ Face value of convertible bonds & 900,000 \\ Shares into which bonds can be converted & 15,000 \\ Face rate of the bonds & 10% \\ Tax rate & 25% \end{tabular} Student Work Area Required: Provide input into cells shaded in yellow in this template. Input 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 \begin{tabular}{|lr|} \hline$ & 4.00 \\ \hline$ & \\ \hline$ & \\ \hline$ & 15,000 \\ \hline \end{tabular} Antidilutive Test of antidilutive bonds Diluted earnings per share