Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can somebody help me with my accounting project, here are the instructions: I chose Netflix This is your first project concerning the company you have

Can somebody help me with my accounting project, here are the instructions: I chose Netflix

This is your first project concerning the company you have chosen to analyze. Please attach and submit your excel spreadsheets here below. This should include both the vertical and horizontal analysis for a minimum of a 3 year period for the income statement you have as chosen. You need to do a vertical and two horizontal analysis techniques. You need to find via the Internet the latest publicly traded income statement that the company has provided the government. The vertical analysis is referred to as the common size analysis. For this technique you divide each value in the statement by the most important value on the income statement and that is total revenues. Then move on to the two horizontal analysis tools. The horizontal technique you need to do initially is the amount and percentage of change. Here you take the latest year value and subtract the previous years value for each category on the income statement for the amount of change. Then for the percent of change you take that answer and divide it by the older year's value. Remember you increase or decrease from last year to current year. Then you do the same process with the second year and the oldest year. The last techniques you need to do is a trend analysis for 3 years for the income statement. Each value of the latest statement is to divided by the oldest statement. Thus each year is compared yo the earliest statement. Try to see the difference of the two methods. If you can download your company's financial statements great, otherwise you must build them in excel (remember to use excel for such things as subtotals and totals). The formulas you need to construct in excel are basic subtractions and division formulas. If you have no experience in excel I suggest you find a resource and many of my students use the Internet Good luck as this is a real world type of financial analysis.

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

GCP Auditing Methods And Experiences

Authors: Editio

1st Edition

3871932841, 978-3871932847

More Books

Students also viewed these Accounting questions

Question

Identify and control your anxieties

Answered: 1 week ago

Question

Understanding and Addressing Anxiety

Answered: 1 week ago