Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS



Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord


ALRM Income Statement

Invalid dateDec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccretionOnPreferredStock-674000.03 M5 M14 M
AccruedPreferredStockDividends19 M
Amortization of intangibles-2 M-2 M-12 M-15 M105 M113 M113 M148 M
Basic EPS from continuing operations1.111.591.051.131.63
Basic EPS total-
Basic weighted shares outstanding24 M46 M47 M48 M48 M49 M50 M50 M50 M
Cost of sales-52 M-69 M-116 M-146 M184 M227 M306 M343 M325 M
Depreciation6 M6 M18 M22 M22 M28 M30 M31 M31 M
Depreciation unreconciled6 M6 M18 M22 M22 M28 M30 M31 M31 M
DepreciationAndAmortization6 M6 M18 M22 M22 M28 M30 M31 M31 M
Diluted EPS total-
Diluted normalized net income/share1.061.531.011.071.53
Diluted weighted shares outstanding24 M48 M49 M50 M50 M51 M52 M55 M55 M
Dividends paid per share0.36
Earnings from equity interest-681000.0-81000.0
GeneralAndAdministrativeExpense35 M58 M55 M96 M70 M79 M87 M107 M113 M
Gross operating profit132 M162 M223 M275 M319 M391 M443 M500 M557 M
Income before tax17 M14 M32 M12 M59 M80 M46 M57 M98 M
Income restructuring and M&A-12 M-6 M-33 M
Income taxes6 M4 M3 M-10 M6 M4 M-5 M962000.017 M
Interest income2 M5 M870000.0587000.09 M30 M
InterestExpenseNonOperating178000.0190000.02 M3 M3 M3 M16 M3 M3 M
MinorityInterests201000.01 M1 M707000.0703000.0
MiscOtherSpecialCharges-348000.0513000.01 M143000.07 M26 M-134000.0-59000.05 M
Net income from total operations12 M10 M29 M22 M54 M78 M52 M56 M81 M
NetIncomeCommonStockholders-7 M10 M29 M22 M54 M78 M52 M56 M81 M
NetIncomeContinuousOperations12 M10 M29 M22 M54 M78 M52 M56 M81 M
NetIncomeDiscontinuousOperations500000.04 M800000.01 M
NetNonOperatingInterestIncomeExpense-178000.0-190000.0-2 M-646000.02 M-2 M-15 M6 M26 M
Normalized income77 M
Operating income18 M14 M33 M12 M50 M56 M62 M51 M67 M
Operating income before depreciation (EBITDA)24 M22 M53 M37 M92 M120 M118 M106 M149 M
OperatingExpense-114 M-148 M-189 M-263 M268 M334 M381 M449 M490 M
Other income net348000.0-513000.0-1 M-143000.0-7 M-26 M134000.059000.0-5 M
OtherGandA35 M58 M55 M96 M70 M79 M87 M107 M113 M
OtherOperatingExpenses-300000.0-600000.0-718000.0-857000.0-718000.0-1 M-2 M-2 M-2 M
OtherunderPreferredStockDividend19 M-674000.03 M5 M14 M
PreferredStockDividends19 M-674000.03 M5 M14 M
PromotionAndAdvertising-4 M-5 M-4 M-11 M8 M12 M10 M6 M3 M
ProvisionForGainLossOnDisposal500000.04 M800000.01 M
RentAndLandingFees35 M58 M55 M96 M
Research & development expense40 M44 M73 M89 M114 M152 M178 M219 M245 M
ResearchExpense40 M44 M73 M89 M114 M152 M178 M219 M245 M
RestructringAndMnAIncome-12 M-6 M-33 M
Revenue per share-3 M-3 M-13 M-17 M107 M116 M129 M153 M6 M
SalariesAndWages-4 M-5 M-13 M-13 M-5 M-8 M-10 M-2 M500000.0
Selling Gen & administrative expense68 M97 M99 M152 M132 M155 M174 M199 M213 M
SellingAndMarketingExpense32 M39 M43 M56 M62 M76 M87 M93 M100 M
SellingExpense32 M39 M43 M56 M
Special income/charges12 M-12000.034 M800000.0
Total Income available for interest expense (EBIT)18 M15 M34 M15 M62 M83 M62 M60 M101 M
Total common shares outstanding91 M92 M94 M96 M97 M50 M50 M50 M50 M
Total net income12 M10 M29 M22 M54 M78 M52 M56 M81 M
Total ordinary shares50 M50 M50 M50 M50 M50 M50 M50 M50 M
Total revenues209 M261 M339 M420 M502 M618 M749 M843 M882 M
TotalExpenses-165 M-217 M-306 M-408 M452 M562 M687 M792 M815 M
TotalRevenue68 M88 M339 M420 M502 M618 M749 M843 M882 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu


I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.


Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University