BALANCE

Get the balance sheet for a given company.

Syntax

=OBB.EQUITY.FUNDAMENTAL.BALANCE(symbol,[period],[limit])

Examples

=OBB.EQUITY.FUNDAMENTAL.BALANCE("AAPL")

=OBB.EQUITY.FUNDAMENTAL.BALANCE("AAPL","annual",5)

---

Parameters

Name	Type	Description	Required
symbol	Text	Symbol to get data for.	True
period	Text	Time period of the data to return.	False
limit	Number	The number of data entries to return.	False

---

Data

• fmp

Name	Description
period_ending	The end date of the reporting period.
fiscal_period	The fiscal period of the report.
fiscal_year	The fiscal year of the fiscal period.
reported_currency	The currency in which the balance sheet is reported.
cash_and_cash_equivalents	Cash and cash equivalents.
cash_and_due_from_banks	Cash and due from banks.
restricted_cash	Restricted cash.
short_term_investments	Short term investments.
federal_funds_sold	Federal funds sold.
accounts_receivable	Accounts receivable.
note_and_lease_receivable	Note and lease receivable. (Vendor non-trade receivables)
inventories	Net Inventories.
customer_and_other_receivables	Customer and other receivables.
interest_bearing_deposits_at_other_banks	Interest bearing deposits at other banks.
time_deposits_placed_and_other_short_term_investments	Time deposits placed and other short term investments.
trading_account_securities	Trading account securities.
loans_and_leases	Loans and leases.
allowance_for_loan_and_lease_losses	Allowance for loan and lease losses.
current_deferred_refundable_income_taxes	Current deferred refundable income taxes.
other_current_assets	Other current assets.
loans_and_leases_net_of_allowance	Loans and leases net of allowance.
accrued_investment_income	Accrued investment income.
other_current_non_operating_assets	Other current non-operating assets.
loans_held_for_sale	Loans held for sale.
prepaid_expenses	Prepaid expenses.
total_current_assets	Total current assets.
plant_property_equipment_gross	Plant property equipment gross.
accumulated_depreciation	Accumulated depreciation.
premises_and_equipment_net	Net premises and equipment.
plant_property_equipment_net	Net plant property equipment.
long_term_investments	Long term investments.
mortgage_servicing_rights	Mortgage servicing rights.
unearned_premiums_asset	Unearned premiums asset.
non_current_note_lease_receivables	Non-current note lease receivables.
deferred_acquisition_cost	Deferred acquisition cost.
goodwill	Goodwill.
separate_account_business_assets	Separate account business assets.
non_current_deferred_refundable_income_taxes	Noncurrent deferred refundable income taxes.
intangible_assets	Intangible assets.
employee_benefit_assets	Employee benefit assets.
other_assets	Other assets.
other_non_current_operating_assets	Other noncurrent operating assets.
other_non_current_non_operating_assets	Other noncurrent non-operating assets.
interest_bearing_deposits	Interest bearing deposits.
total_non_current_assets	Total noncurrent assets.
total_assets	Total assets.
non_interest_bearing_deposits	Non interest bearing deposits.
federal_funds_purchased_and_securities_sold	Federal funds purchased and securities sold.
bankers_acceptance_outstanding	Bankers acceptance outstanding.
short_term_debt	Short term debt.
accounts_payable	Accounts payable.
current_deferred_revenue	Current deferred revenue.
current_deferred_payable_income_tax_liabilities	Current deferred payable income tax liabilities.
accrued_interest_payable	Accrued interest payable.
accrued_expenses	Accrued expenses.
other_short_term_payables	Other short term payables.
customer_deposits	Customer deposits.
dividends_payable	Dividends payable.
claims_and_claim_expense	Claims and claim expense.
future_policy_benefits	Future policy benefits.
current_employee_benefit_liabilities	Current employee benefit liabilities.
unearned_premiums_liability	Unearned premiums liability.
other_taxes_payable	Other taxes payable.
policy_holder_funds	Policy holder funds.
other_current_liabilities	Other current liabilities.
other_current_non_operating_liabilities	Other current non-operating liabilities.
separate_account_business_liabilities	Separate account business liabilities.
total_current_liabilities	Total current liabilities.
long_term_debt	Long term debt.
other_long_term_liabilities	Other long term liabilities.
non_current_deferred_revenue	Non-current deferred revenue.
non_current_deferred_payable_income_tax_liabilities	Non-current deferred payable income tax liabilities.
non_current_employee_benefit_liabilities	Non-current employee benefit liabilities.
other_non_current_operating_liabilities	Other non-current operating liabilities.
other_non_current_non_operating_liabilities	Other non-current, non-operating liabilities.
total_non_current_liabilities	Total non-current liabilities.
capital_lease_obligations	Capital lease obligations.
asset_retirement_reserve_litigation_obligation	Asset retirement reserve litigation obligation.
total_liabilities	Total liabilities.
commitments_contingencies	Commitments contingencies.
redeemable_non_controlling_interest	Redeemable non-controlling interest.
preferred_stock	Preferred stock.
common_stock	Common stock.
retained_earnings	Retained earnings.
treasury_stock	Treasury stock.
accumulated_other_comprehensive_income	Accumulated other comprehensive income.
participating_policy_holder_equity	Participating policy holder equity.
other_equity_adjustments	Other equity adjustments.
total_common_equity	Total common equity.
total_preferred_common_equity	Total preferred common equity.
non_controlling_interest	Non-controlling interest.
total_equity_non_controlling_interests	Total equity non-controlling interests.
total_liabilities_shareholders_equity	Total liabilities and shareholders equity.