iRobot Corp (NASDAQ:IRBT) Earnings Model

IRBT Consensus-Based Earnings Model.xlsx
File Size: 313 kb
File Type: xlsx
Download File
    Latest Update: February 9, 2017
    This model needs an update to include the latest results...Feel free to update the model yourself, or sign-up to get an email alert after an update has been posted.
    ​Model Tier: Tier 2, Consensus-based model. 
    ​Model Created by: Timothy Oh. Tim is a member of our Boston College Modeling Intern Team. Click here to visit Tim's contributor page. 
    ​Financial Modeling Approach: ​This model projects future earnings using Average Selling Price (ASP),  unit sales, gross margin, and operating expense ratios. 

Models From Our Community 

Last Updated: February 5, 2017
View on iRobot: Bullish
Price Target: $70 
​Model Up Votes-to-Total Votes: 67%
Summary of Model Estimates: In my version of the IRBT earnings model I have tweaked the estimates to reflect the recent strength in Asia on the back of the wet floor line (Braava Jet) and recent acquisition of the Japanese distribution business (Sales On Demand Corp). I believe this will have a downward impact on Average Selling Price (Braava series ASP is lower than Roomba), but should increase units shipped significantly. My model also assumes operating expense as a percentage of revenue will decline to 38% in 2017, due to the improved leverage associated with a higher revenue base. These assumptions result in a Next Twelve Month (NTM) EPS estimate of $1.91. My price target of $70 is based on the three-month average consensus NTM Price-Earnings ratio of 39.3x, plus net cash per share of $5.92.​
John Moschella IRBT Model.xlsx
File Size: 299 kb
File Type: xlsx
Download File
Last Updated: February 5, 2017
View on iRobot: Neutral
Price Target: $58
Model Up Votes-to-Total Votes: 50%
Visit Timothy's Contributor Page
Timothy Oh IRBT Model.xlsx
File Size: 313 kb
File Type: xlsx
Download File
StockTwits

Gutenberg Modeling Guide

New to earnings modeling?
​Our modeling guide demonstrates step-by-step how to create a financial model, similar to the models maintained by Wall Street Analysts.
Paperback
eBook

Past Model Updates

Become a Contributor

Step 1) Download the model above.
Step 2) Change the blue input cells.
Step 3) Submit your model for review.
Share on StockTwits