Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions