Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the income statement for Amazon.com, I need am excel spreadsheet showing actual numbers for projected revenues, expenses, etc. for the next five years

Based on the income statement for Amazon.com, I need am excel spreadsheet showing actual numbers for projected revenues, expenses, etc. for the next five years (2018-2022)

Also, I need an excel spreadsheet showing the best- and worst-case numbers for projections in 2018.

All of the elements from the income statement should refect onto the excel spreadsheet. The numbers should reflect for the future.

image text in transcribed

Income Statement Period Endin Revenue Total Revenue Cost of Revenue Gross Profit Operating Expenses Research Development Selling General and Administrative Non-Recurrin Others Total Operating Expenses Operating Income or Loss Income from Continuing Operations Total Other Income/Expenses Net Earnings Before Interest and Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income from Continuing Ops Non-recurring Events Discontinued Operations Extraordinary Items Effect of Accounting Changes 12/31/2017 12/31/2016 12/31/2015 177,866,000 135,987,000107,006,000 111,934,00088,265,00071,651,000 65,932,000 47,722,000 35,355,000 22,620,000 16,085,000 12,540,000 38,992,000 27,284,000 20,411,000 214,000 171,000 173,760,000 131,801,000 104,773,000 4,186,0002,233,000 167,000 4,106,000 304,000 4,106,000 848,000 3,802,000 769,000 687,000 4.186,0002.233,000 -459,000 1,546,000 950,000 390,000 484,000 3,796,000 1,425,000 3,033,000 2,371,000 596,000 Other Items Net Income Net Income Preferred Stock and Other Adjustments Net Income Applicable to Common Shares 3,033,000 2,371,000 596,000 3,033,000 2,371,000 596,000

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

Internal Audit Handbook Management With The SAP Audit Roadmap

Authors: Henning Kagermann, William Kinney, Karlheinz Küting, Claus-Peter Weber, Z. Keil, C. Boecker, J. Busch, O. Bussiek, M. H. Christ, P. Eckes, M. Falk, P. S. Greenberg, B. Reichert, M. Wolf

2008th Edition

3642430392, 978-3642430398

More Books

Students also viewed these Accounting questions