Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you show me in excel on to lay out and reference each answer thank you Leverage Problem 9 10 11 12 13 14 15
can you show me in excel on to lay out and reference each answer thank you
Leverage Problem 9 10 11 12 13 14 15 16 17 18 19 20 You have been asked to assist Green Gadget Inc. by completing various analyses to help them better assess their business and financial risks, specifically with regards to its operating and financial leverage. In order to assist you in your analysis, the CFO has provided you with the below information regarding Green Gadget You have decided to prepare the following information for your analysis: 1. Prepare an Analytical Income Statement for Green Gadget Inc. 2. Compute the following for Green Gadget: a. Price per unit (at current output) b. Variable cost per unit (at current output) C. Breakeven units d. Breakeven sales dollars 3. Calculate Green Gadget's Degree of Financial Leverage (DFL) 4. Calculate Green Gadget's Degree of Combined Leverage (DCL) 5. If Green Gadget's sales decrease by 20%, what percentage would EBIT decrease by? 6. If Green Gadget's sales increase by 15%, what percentage would Net Income increase by? 52,000 $21,000,000 Given: Output Level Total Assets Total Asset Tumover Operating Return on Assets (OROA) DOL Interest Expense Tax Rate 22 21 24 25 26 40 35% 2.5 $2.100,000 26% 20 29 Step 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