Answered step by step
Verified Expert Solution
Question
1 Approved Answer
So this is for my accounting annual report project for Facebook. It asked me to make a spreadsheet which is what the theirs picture is.
So this is for my accounting annual report project for Facebook. It asked me to make a spreadsheet which is what the theirs picture is. Im unsure if I did it correctly so far but Im not sure on how to get the formulas its asking for in columns E F and G. FURTHER ANALYSIS 4. Prepare common-size income statements for the three years presented, expressing each income statement item as a percentage of total revenue. (Total revenue = 100%). (Refer to the discussion of vertical analysis in your textbook.) Use a spreadsheet program to do this part of the assignment Label the spreadsheet "Common Size Analysis-Income Statement.List the revenue and expense classifications in column A, the amounts for the three years in columns B, C, and D. In columns E, F and G, use a formula to convert thee amounts to percentages INFORMATION FOR DECISION MAKING
So this is for my accounting annual report project for Facebook. It asked me to make a spreadsheet which is what the theirs picture is. Im unsure if I did it correctly so far but Im not sure on how to get the formulas its asking for in columns E F and G.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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