Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show formulas used to obtain the percentage Prepare vertical analysis Operating data for Taylor Corporation are presented below. Sales revenue Cost of goods sold
Please show formulas used to obtain the percentage
Prepare vertical analysis Operating data for Taylor Corporation are presented below. Sales revenue Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income 2018 $800,000 520,000 120,000 60,000 30,000 70,000 2017 $600,000 408,000 72,000 48,000 24,000 48,000 Instructions Prepare a schedule showing a vertical analysis for 2018 and 2017. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "Show formulas in excel. FORMULAS MUST BE VISIBLE IN CELL Sales Revenue Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Income before income taxes Income tax expense Net income Taylor CORPORATION Condensed Income Statement For the Years Ended December 31 2018 Amount Percent $800,000 100%% 520,000 ? 280,000 ? 120,000 ? 60,000 ? 180,000 ? 100,000 ? 30,000 ? $70,000 ? 2017 Amount Percent $600,000 100%% 408,000 ? 192,000 ? 72,000 ? 48,000 ? 120,000 ? 72,000 ? 24,000 ? $48,000Step 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