How to Get Efficiency Ratios in Excel

Get efficiency ratios directly in Excel using custom formulas. Retrieve financial data, automate your workflows, and keep your spreadsheets updated with our Excel add-in.

Install Add-inView Pricing
No VBA/Macros Required
Microsoft Certified Add-in
2-Minute Setup
EXCEL FORMULA
=FDN("EfficiencyRatios", "MSFT", "year", 5)

This formula pulls data into your spreadsheet once our Excel add-in is installed.

Formula Result

See exactly how data fills into your sheet when the formula runs. This example shows the actual up-to-date information returned.

ABCDEFGHIJKLMNOPQRSTU
1trading_symbolcentral_index_keyregistrant_namefiscal_yearfiscal_periodperiod_end_dateasset_turnover_ratioinventory_turnover_ratioaccounts_receivable_turnover_ratioaccounts_payable_turnover_ratioequity_multiplierdays_sales_in_inventoryfixed_asset_turnover_ratiodays_working_capitalworking_capital_turnover_ratiodays_cash_on_handcapital_intensity_ratiosales_to_equity_ratioinventory_to_sales_ratioinvestment_turnover_ratiosales_to_operating_income_ratio
2MSFT0000789019MICROSOFT CORP2025FY2025-06-300.455125419424462112.1008296107213.746553982618643.146901833372011.802156754852553.25599731302161.1874988144991564.66699677698745.64430108388596—2.197196546975050.8202073489208950.002781090712896310.723057061974342.19192705091498
3MSFT0000789019MICROSOFT CORP2024FY2024-06-300.478601538963182122.7052980132454.050297837886963.172181669015711.907660618972952.974606686995711.5530810146392251.29494700598077.11571063632141—2.089420778224720.9130093080599080.002464079111626050.776530667198882.23992762694982
4MSFT0000789019MICROSOFT CORP2023FY2023-06-300.51438676039380935.05215540180954.17718774331534.00997938390751.9977209137681110.41305437043561.93186531685727137.9771134653042.645366255555—1.944062477880281.027601189004140.008866762617087040.8191312952490662.39389763112411
5MSFT0000789019MICROSOFT CORP2022FY2022-06-300.54344370134853614.55791797374234.158521750073413.005495444886792.1906786276134525.07226656025542.296359782722137.3366116911282.6577035468218—1.840117012155141.190510501855390.02170525041609930.9050449167397022.37782281760071
6MSFT0000789019MICROSOFT CORP2021FY2021-06-300.50359069923512317.38458978199374.071554010682233.109225938896272.3507549933797220.99560614182882.40036557849941207.9171921850461.755506584925171759.719540229891.985739612583881.183818350846550.0178745657036790.8073158314361742.40414211339321
ABCDEF
1trading_symbolMSFTMSFTMSFTMSFTMSFT
2central_index_key00007890190000789019000078901900007890190000789019
3registrant_nameMICROSOFT CORPMICROSOFT CORPMICROSOFT CORPMICROSOFT CORPMICROSOFT CORP
4fiscal_year20252024202320222021
5fiscal_periodFYFYFYFYFY
6period_end_date2025-06-302024-06-302023-06-302022-06-302021-06-30
7asset_turnover_ratio0.4551254194244620.4786015389631820.5143867603938090.5434437013485360.503590699235123
8inventory_turnover_ratio112.100829610721122.70529801324535.052155401809514.557917973742317.3845897819937
9accounts_receivable_turnover_ratio3.746553982618644.050297837886964.17718774331534.158521750073414.07155401068223
10accounts_payable_turnover_ratio3.146901833372013.172181669015714.00997938390753.005495444886793.10922593889627
11equity_multiplier1.802156754852551.907660618972951.997720913768112.190678627613452.35075499337972
12days_sales_in_inventory3.25599731302162.9746066869957110.413054370435625.072266560255420.9956061418288
13fixed_asset_turnover_ratio1.187498814499151.553081014639221.931865316857272.2963597827222.40036557849941
14days_working_capital64.666996776987451.2949470059807137.977113465304137.336611691128207.917192185046
15working_capital_turnover_ratio5.644301083885967.115710636321412.6453662555552.65770354682181.75550658492517
16days_cash_on_hand————1759.71954022989
17capital_intensity_ratio2.197196546975052.089420778224721.944062477880281.840117012155141.98573961258388
18sales_to_equity_ratio0.8202073489208950.9130093080599081.027601189004141.190510501855391.18381835084655
19inventory_to_sales_ratio0.002781090712896310.002464079111626050.008866762617087040.02170525041609930.017874565703679
20investment_turnover_ratio0.723057061974340.776530667198880.8191312952490660.9050449167397020.807315831436174
21sales_to_operating_income_ratio2.191927050914982.239927626949822.393897631124112.377822817600712.40414211339321
Efficiency ratios, also known as activity financial ratios, are used to evaluate how effectively a company uses its assets and resources. The formula provides key efficiency ratios calculated using data obtained from the company's financial statements.

Steps to Get Started

01
Install the Add-in

Open Excel, navigate to the Home tab, select Add-ins, and search for FinancialData.Net.

02
Grab Your Key

Sign in to your account at FinancialData.Net, open the dashboard, and copy your API key.

03
Run Your Formula

Open the task pane in Excel, save your API key, and start typing the =FDN(...) formula.

Formula Reference

Use the formula to retrieve financial data by specifying a dataset, ticker symbol, and additional parameters.

=FDN(dataset, identifier, argument, maxRows)
datasetString
Specifies the dataset to query. Enter the dataset name enclosed in quotation marks, for example "EfficiencyRatios".
identifierString
Accepts one or multiple identifiers such as ticker symbols (e.g., "AAPL" or "AAPL,MSFT") or other supported identifier types.
argumentString
Filters the dataset output using an additional parameter, such as a date like "2025-01-15" or a reporting period like "year" or "quarter".
maxRowsInteger
Limits the number of records returned by the formula. For example, setting the value to 5 returns the five most recent rows.

Troubleshooting & FAQ

If Excel doesn't recognize the =FDN() formula, the add-in may not have loaded correctly. Restart Excel or reinstall the add-in from the Office Add-ins Store.

Excel displays this error when it does not recognize the =FDN() formula. This means the add-in is either not installed or has been disabled.

The =FDN() formula outputs multiple rows and columns of data, which Excel blocks if any existing text or formatting occupies the surrounding cells. Simply clear these obstructing cells to allow the formula to expand completely.

Install the Excel Add-in

Access 80+ financial datasets directly in Excel using simple formulas.

Install via AppSource
Compatible with Office 365 and Excel for Web
Data Subscriptions for Excel
Standard SubscriptionCore financial data
$29 / mo
Premium Subscription
Full financial data
$69 / mo
Get Started