Question: Please show the excel formulas for each solution. Below is the answer to the questions, I need help understanding what formulas to use in excel.

 Please show the excel formulas for each solution. Below is the

Please show the excel formulas for each solution.

Below is the answer to the questions, I need help understanding what formulas to use in excel.

answer to the questions, I need help understanding what formulas to use

Thank you so much!

Case Volume-Profit Income Statements Sales revenue Variable costs Contribution margin Fixed costs Net income $ $ S $ $ East Aviation 976,000 817,400 158,600 90,000 68,600 Mountain Adventures $ 1,000,436 $ 563,000 S 437,436 $ 200,000 $ 237,436 Here's what to do: A.) Compute the degree of operating leverage for each company. *Cell reference AND round to 3 places by using =ROUNI function. East Aviation Mountain Adventures B.) Prepare a CVP/Contribution Margin income statement assuming sales increase by 17%. Use E25 as a reference. *Absolute cell reference (S) when using cell E25 in cells D28, D29, H28, and H29. Sales increase: 1.17 Mountain Adventures East Aviation 19.89 $ Sales revenue Variable costs Contribution margin Fixed costs Net income Cest-Volume-Profit Income Statements East Aviation Sales revenue $ 976,000 Variable costs $ 817,400 Contribution margin $ 158,600 Fixed costs $ 90,000 Net income $ 68,600 Mountain Adventures $ 1,000,436 $ 563,000 $ 437,436 $ 200,000 $ 237,436 Here's what to do: A.) Compute the degree of operating leverage for each company. *Cell reference AND round to 3 places by using =ROUND function. East Aviation Mountain 2.312 1.842 B.) Prepare a CVP/Contribution Margin income statement assuming sales increase by 17%. Use E25 as a reference. *Absolute cell reference (S) when using cell E25 in cells D28, D29, H28, and H29. Sales increase: 1.17 Sales revenue Variable costs Contribution margin Fixed costs Net income $ $ $ $ $ East Aviation 1,141,920 956,358 185,562 90,000 95,562 Mountain Adventures $ 1,170,510 $ 658,710 $ 511,800 $ 200,000 $ 311,800

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 Accounting Questions!