Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Common Size Financial Statement Analysis Using Exce Completing this activity will help you learn 1. create Excel formulas using call references 2, create acute
Common Size Financial Statement Analysis Using Exce Completing this activity will help you learn 1. create Excel formulas using call references 2, create acute cet references to perform calculations efficiently and correctly 3. apply conditional formatting to highlight cells based on criteria that you specify Case scenario: You are working at a small business that has been mostly stable. You want to analyze the financial statements of the past five years to examine the trends ever time and compare the percentages of income statement Items retative to overall sales. You als want to highlight cells according to whether the calculated ratio increases or decreases more than a specified amount Required Dead spreadsheet CommanditeCassa You will build a spreadsheet that performs common size analysis using five years of a company's income statements. Specifically, you will creats two sheets within the workbook, one for the horizontal analysis and one for the vertical anals. Further, you will use conditional formatting to visually differentiate between calls that reflect increases and cats that reflect decreases over a specified percentage HINT STEP-BY-STEP WALKTHROUGH 1. Hontal anal Create a new sheet within your Essal wirkbook that you will use to perform the horizontal analysis, comparing each year's income statement item to its corresponding them in year 1 Copy cum A from the Financial Statement Data sheet to Colume A in your new sheet. Aise copy the information in row 2 ta row 1 in your new sheets that the basic structure of the table will be the same in the new sheet but it Now rate formulas in your new sheet using the data in the financial Statement Data sheet that will reflect the correct percentages as described in the previous question. Instead of creating every formula one by one, how could you treat Jait one formula in cat 2 that can be copied and pasted to all calls? Note that there are negative values in the Financial Statement Data sheet. Chose the correct formula. I-Tinancial Statement Data 82/Financial Stat Financial Statement Data 82/Financial Statement Data 1502 -Viandal Statement Data 2/Financial Statement Data 02 Financial Statement Data 2/Financial Statement Data 82 Cey and paste that one formula to all the relevant cells in your new sheet. Round your answers to two decimal places Line Items Year 1 Year 2 Year 3 Year 4 Year 5
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