Financial Journey with Apple Inc.

Thermal Zone

Apple has subsidiaries in many cities around the globe. This notebook is a tool to analyze temperature of all cities with an Apple subsidiary.  The mean temperature of all cities with an Apple subsidiary ranges from 2C in Anchorage, USA to 29C in Chennai, India. The standard deviation of all cities with an Apple subsidiary ranges from 1C in Bogotá, Columbia to 13C in Winnipeg, Canada. (April, 2022)

Here is the link to the notebook and the data.

I/S Top to Bottom 

This notebook is a tool to analyze Apple's Common Size Income Statement. It provides an interactive chart to help visualize how Steve Jobs' journey affects Apple's profitability. 

Here is a link to the notebook.

B/S Data Dashboard

This notebook is a tool to generate visuals about liquidity and solvency ratios based on any measures/denominators you choose from the Balance Sheet of Apple Inc.

Here is a link to the notebook.

Has Apple Lost its Soul? 

Apple's ROE keeps rising in recent years after Jobs died. Why do people say Apple lost its soul? This notebook analyzes Apple's ROE (We adjusted the scale so everything ends at 1). After Jobs returns, the margin increases, which leads the ROE to increase. After Jobs dies, the leverage increases instead, which leads the ROE to increase. Here is a link to the notebook.

Δrevenue-Δcost

When Apple's revenue changes 1% from last year to this year, how much does Apple's cost change? 1%? More than 1%? Less than 1%? Here is a link to the notebook that answers this question. Takeaway is Apple's product cost is mostly variable and its operational expenses have more fixed cost component. 

1% up != down


When Apple's revenue is shrinking, there is a delay in the cost reduction because Apple cannot lay off people or close stores immediately. Here is a notebook that visually illustrate the concept of cost stickiness: 1% of revenue increase may immediately cause the cost to increase, but 1% of revenue decrease may not necessarily cause the cost to decrease.