Question
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
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