Scribd
Upload
43 views2 pages

Blue Cells Model Estimates (Primary Input) Purple Cells Company Guidance Orange Cells Consensus Estimates

The document is an income statement and estimates for Apple Inc. for March 2017 and June 2017. It includes estimates for iPhone revenue, units sold, and average selling price. It also includes actual revenue figures for March 2017 and estimates for June 2017 for the iPhone, iPad, Mac, Apple Watch, other products, and services. The document provides key financial metrics and estimates to analyze Apple's performance and projections.

Uploaded by

Nivedita Nitesh Nawge
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
43 views2 pages

Blue Cells Model Estimates (Primary Input) Purple Cells Company Guidance Orange Cells Consensus Estimates

The document is an income statement and estimates for Apple Inc. for March 2017 and June 2017. It includes estimates for iPhone revenue, units sold, and average selling price. It also includes actual revenue figures for March 2017 and estimates for June 2017 for the iPhone, iPad, Mac, Apple Watch, other products, and services. The document provides key financial metrics and estimates to analyze Apple's performance and projections.

Uploaded by

Nivedita Nitesh Nawge
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Blue Cells= Model estimates (primary input)

Purple Cells= Company guidance


Orange Cells= Consensus estimates
Apple Revenue Sensitivity to iPhone ASP Mar-17 Jun-17

Apple Inc Income Statement


(Dollars in million except per share data)
Net Sales 52897 44972
Segment & Product Data

Estimates by product iPhone


iphone and related product and services revenue (dollar million) 33250 26650
iphone units sold (thousand of units) 50763 41000
iphone average selling price (in dollar) 655 650
ipad and related product and services revenue (dollar million) 3889 3698
Mac revenue 5844 4481
iWatch revenue 1093 984
Other products revenue 1780 1889
Services revenue 7041 7270
Total sales by product 52897 44972

You might also like