Question: 5) (15%) Using the Income Statement figures below, calculate DOL, DFL and DCL for 2019. Show all quantitative work using Excel formulas and cell references.

5) (15%) Using the Income Statement figures below, calculate DOL, DFL and DCL for 2019. Show all quantitative work using Excel formulas and cell references. Income Statement ($) Revenue Cost of Goods Sold Gross Profit Operating Expenses Operating Income Interest and Taxes Net Income Earnings Per Share 12/31/2018 2,040,989 536,700 1,504,289 84,699 1,419,590 298,114 1,121,476 11.21 12/31/2019 2,895,677 823,785 2,071,892 92,127 1,979,765 415,751 1,564,014 15.64

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Activity #1 Goal: Produce an Excel spreadsheet that allows your company to model profitability. Assume your company produces bicycles and manufactures these different models: road, mountain, tandem,...

Compile the statements, ratio calculations and individual analysis from Status Report # 2 into a cohesive report. Please ensure you work on the wording to ensure it sounds cohesive. 2 . Interpret the...

I only need the answers to the last workbook, the income statement page. I wrote page 1 & 2 on them. Please show the answers on excel like the one I have below. Thanks! A G H B C E F Before you...

PLEASE ANSWER ASAP! No need of explanation just the answers. (My STUDENT ID: 101301922). Instructions: (Please read carefully) 1) Print your name and ID# at the top of this page. If not I'll email it...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

please help me :) A new client of yours, Olivia Johnson, wants to open an ice cream shop near the downtown. shopping center. She will sell ice cream cones, cups, shakes, sundaes, and soda. Her grand...

Income Statement ($ in Millions) Best buy Income statement Feb. 02, 2019 Revenue 42879.00 Operating income Cost of goods sold 32918.00 Gross profit 9961.00 Selling, general and administrative...

Step 2: Record the 11 adjusting journal entries based on the additional information given . Record all AJEs on the Excel spreadsheet using the tab at the bottom of the spreadsheet labeled AJEs and...

Administrative Details The overall project is worth 12% of your final grade.Assignments are due by 10am, Monday, April 12.A 25% penalty will apply for a late assignment. Assignments will not be...

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

Coherent light from a laser is split into two beams with intensities I0 and 4 I0, respectively. What is the intensity of the light when the beams are recombined? If there is more than one...

Puan Adila is sole proprietor of Adila Enterprise which operates its business in Bandar Puteri, Puchong, Selangor. The following is the Trial Balance of the said business as at 30 June 2022....

The Impact of Environmental Changes on Stock market Performance in the USA, China, and Japan: The Role of ESG, AI , GDP , and Interest Rates.

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".