Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Banking And Finance Issues In Emerging Markets

Authors: William A. Barnett

1st Edition

1787564541, 9781787564541

More Books

Students also viewed these Accounting questions

Question

How do each of these methods differ?

Answered: 1 week ago

Question

highlight how to collect and record interview and diary based data;

Answered: 1 week ago

Question

clarify the relationship between research, theory and practice;

Answered: 1 week ago

Question

evaluate the quality of your data;

Answered: 1 week ago