Notes Payable (Historical)
Returns notes payable from historical balance sheets.
Syntax
=hf_Notes_payable(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
Stock ticker symbol
yearstringRequired
Fiscal year or period code
quarterstring
Calendar quarter (1-4)
TTMstring
Set to 'TTM' for trailing twelve months
Returns
number
Notes payable amount
Examples
=hf_Notes_payable("AAPL", 2023, 4)=hf_Notes_payable("MSFT", "ly", 2)When to Use
- Short-term debt analysis
- Liquidity assessment
- Working capital analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need long-term debt | hf_Long_term_debt() |
Common Issues & FAQ
What's the difference between notes payable and accounts payable?
Notes payable are formal written promises to pay; accounts payable are informal trade credit.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Number Of Days Cost Of Goods Sold In Inventory (Historical)
- Number Of Employees (Historical)
- Number of Part-time Employees (Historical)
- Operating Expenses (Historical)
- Operating Gains Losses (Historical)
- Operating Income (Historical)
- Operating Income After Depreciation (Historical)
- Other Current Assets (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?