Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part D. INCOME STATEMENT ANALYSIS (TREND-HORIZONTAL) Another useful technique is called horizontal analysis (or trend analysis). Basically you compare the same line item of an

image text in transcribed

Part D. INCOME STATEMENT ANALYSIS (TREND-HORIZONTAL) Another useful technique is called horizontal analysis (or trend analysis). Basically you compare the same line item of an income statement and compute % changes across time. Again, there are various approaches. You can choose a base year and show all other years -Compute % change in net sales as (current sales prior year salesyprior year sales -Compute % change in net income as (current net income prior year net income)/prior year net income s a% of that base. Alternatively, you can compute the change from the prior year- and that is what you will do below for just two lines of the income statement. Round all of the computations too 3 decimal places. Show all If there is a decline in income, use a negative sign for your final answer. f these as a percentage.(i.e. if your answer .3475 round then format it as 34.8 (OWL has the % sign so do not add that). I have done a comparison of the prior year the year before that in the right hand column. GPS Current Year Prior Year 281/15797-1.8 % 15516-15797 Change in net sales % Change in net income 244/920 -26.5 % % AEO Current Year Prior Year 88017/3521848 2.5 % Change in net sales 2.6% 212449-218138 Change in net income Part D. INCOME STATEMENT ANALYSIS (TREND-HORIZONTAL) Another useful technique is called horizontal analysis (or trend analysis). Basically you compare the same line item of an income statement and compute % changes across time. Again, there are various approaches. You can choose a base year and show all other years -Compute % change in net sales as (current sales prior year salesyprior year sales -Compute % change in net income as (current net income prior year net income)/prior year net income s a% of that base. Alternatively, you can compute the change from the prior year- and that is what you will do below for just two lines of the income statement. Round all of the computations too 3 decimal places. Show all If there is a decline in income, use a negative sign for your final answer. f these as a percentage.(i.e. if your answer .3475 round then format it as 34.8 (OWL has the % sign so do not add that). I have done a comparison of the prior year the year before that in the right hand column. GPS Current Year Prior Year 281/15797-1.8 % 15516-15797 Change in net sales % Change in net income 244/920 -26.5 % % AEO Current Year Prior Year 88017/3521848 2.5 % Change in net sales 2.6% 212449-218138 Change in net income

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

Information Technology Control And Audit

Authors: Sandra Senft, Frederick Gallegos, Aleksandra Davis

4th Edition

1439893209, 978-1439893203

More Books

Students also viewed these Accounting questions