Manicoti
Create a financial model
Sign up
Log in
Enter your email if you want to get updates on Manicoti
Updates could be new features on our product, or interesting business plans on other companies being published.
Count me in !

Apple Simple Financial Model

Estimates for a typical month of early 2018

Created by Emmanuel for company
Apple
Revenue
Other products
var120 1 comment 1 source
Services
var119 1 comment 1 source
Mac sales
var118 1 comment 1 source
iPad sales
var117 1 comment 1 source
iPhone sales
var116 1 comment 1 source
Total Revenue
Expenses
Income Tax
var130 1 comment 1 source
Cost of Sales
var129 2 comments 1 source
Selling, general and administrative
var128 1 comment 1 source
Research and Development
var127 1 comment 1 source
Total Expenses
Profit
1,830,000,000
2,820,000,000
Show Submodel 2,291,600,000
Show Submodel 1,958,000,000
Show Submodel 19,800,000,000
$28.7 Billion
2,300,000,000
18,120,000,000
1,130,000,000
1,410,000,000
$23 Billion
$5.74 Billion
Revenue Variables
Other products

1,830,000,000
1 comment
Emmanuel <p>"Includes sales of Apple TV, Apple Watch, Beats products, iPod touch and Apple-branded and third-party accessories."</p>
6 months
Comment
Services

2,820,000,000
1 comment
Emmanuel
6 months
Comment
Mac sales

2,291,600,000
Submodel formula
Number of units of Macs sold1,700,000 * Average price of a Mac computer1,348
1 comment
Emmanuel
6 months
Comment
iPad sales

1,958,000,000
Submodel formula
Number of units sold4,400,000 * Average price of an iPad445
1 comment
Emmanuel
6 months
Comment
iPhone sales

19,800,000,000
Submodel formula
# of units sold25,000,000 * Average price of an iPhone sold792
1 comment
Emmanuel
6 months
Comment
Expense Variables
Income Tax

2,300,000,000
1 comment
Emmanuel <p>~7 billion of income taxes provisioned for the quarter</p>
6 months
Comment
Cost of Sales

18,120,000,000
2 comments
Emmanuel
6 months
Emmanuel <p>This is basically how much it costs them to make all the products they sell</p>
6 months
Comment
Selling, general and administrative

1,130,000,000
1 comment
Emmanuel
6 months
Comment
Research and Development

1,410,000,000
1 comment
Emmanuel
6 months
Comment
Other variables in submodels
Average price of a Mac computer

1,348
Comment
Number of units of Macs sold

1,700,000
Comment
Average price of an iPad

445
Comment
Number of units sold

4,400,000
Comment
Average price of an iPhone sold

792
Comment
# of units sold

25,000,000
Comment
Contact Us   Twitter