Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 answer to the questions, I need help understanding what formulas to use in excel.
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,800Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started