Premium Essay

Accounting Formulas

In: Business and Management

Submitted By mike89671
Words 301
Pages 2
Accounting Formulas

Profitability ratios * Gross Margin Ratio Gross Profit/Sales * Operating Income Ratio Sustainable Operating Income/Sales * R&D Expense Percent R&D/Sales * SGA Expense Percent SGA/Sales * Net Margin Ratio Sustainable Net Income/Sales * Effective Tax Rate Income Tax Provision/Income Before Taxes * Return on Total Assets Sustainable Net Income/Total Assets * Return on Equity Sustainable Net Income/Shareholders’ Equity * DuPont Analysis Net Margin Ratio X Total Asset Turnover X Total Assets To Equity * Economic Value Added (EVA) (Return on Total Assets% - Cost of Capital%) X Total Assets
Liquidity Ratios * Current Ratio Current Assets/Current Liabilities * Quick Ratio (Cash + ST Investments + A/R) / Current Liabilities * Defensive Interval (Cash + ST Investments + A/R) / Daily Spending on Operating Expenses and Interest
Leverage Ratios * Total Assets to Equity Total Assets/Shareholders’ Equity * Total Liabilities to Equity Total Liabilities/Shareholders’ Equity * Debt to Equity Debt Financing/Shareholders’ Equity * Times Interest Earned EBITDA/Interest Expense * Altman’s Z Bankruptcy 3.3(EBT/TA)+1.2(WC/TA)+.6(MktEq/BkDebt)+ 1.4(RE/TA)+1(Revenue/TA) * Book Value Per Share Common Shareholders’ Equity/# of Shares Outstanding
Activity Ratios * Receivables Turnover Revenue/Accounts Receivable * Days Receivables 365/Receivables Turnover * Inventory Turnover Revenue/Inventory * Days Inventory 365/Inventory Turnover * Payables Turnover Revenue/Accounts Payable * Days Payables 365/Payables Turnover * Cash Cycle Days Inventory – Days Payables + Days Receivables * Fixed Assets Turnover Revenue/PP&E * Days Fixed Assets 365/Fixed Assets Turnovers * Total Assets Turnover Revenue/Total Assets…...

Similar Documents

Premium Essay

Accounting Formula

...Account Formular 1. Risk: Short-term liquidity ratios 1.1 Current Cash Debt Coverage Ratio = Net Cash Flows From Operations Average Current Liabilities 1.2 Current Ratio = Current Assets Current Liabilities 1.3 Quick Ratio = Cash+Marketable Securities+Net A/R Current Liabilities 1.4 Average Collection Period = Avg. A/R * 365 Net Credit Sales 1.5 Inventory Turnover = Costs of Goods Sold Avg. Inventory Day's Inventory = Avg. Inventory * 365 Costs of Goods Sold 1.6 Avg. Payment Period = Avg. Account Payable * 365 Net Purchases 1.7 Cash Cycle = Payment Period - (Days' Inventory+ Collection Period) 1.8 Free Cash Flow = CFO-CFI and Dividends = CFO-Capital Expenditures- Dividends 1.9 Cash Ratio = Cash + Cash Equivalent Current Liabilities 2. Risk: Long-term Solvency Ratio 2.1 Long-term Debt Ratio = Total Long-term Liabilities Liabilities+Stockholders' Equity 2.2 Debt to Equity Ratio = Total Liabilities Stockholders' Equity 2.3 Debt to Assets = Total Liabilities Total Assets 2.4 Leverage Ratio = Liabilities+Stockholders' Equity(Assets) Stockholders' Equity 2.5 Cash Interest Coverage Ratio = EBITDA Interest Expense *EBITDA = Pre-tax Profit + Interest Expense + Depreciation Expense + Amortization......

Words: 551 - Pages: 3

Premium Essay

Formulas

...• o Question o Answer o Side 3 • o Budgeted At Completion (BAC) o How much was originally planned for this project to cost. No one formula exists. Is derived by looking at the total budgeted cost for the project. o No one formula exists. Is derived by looking at the total budgeted cost for the project. • o Planned Value (aka Budgeted Cost of Work Scheduled) (PV or BCWS) o How much work should have been completed at a point in time based on the plan. Derived by measuring planned work completed at a point in time. Planned % Complete x BAC o Planned % Complete x BAC • o Earned Value (aka Budgeted Cost of Work Performed) (EV or BCWP) o How much work was actually completed during a given period of time. Derived by measuring actual work completed at a point in the schedule. EV = Actual % Complete x BAC o EV = Actual % Complete x BAC • o Actual Cost (aka Actual Cost of Work Performed) (AC or ACWP) o The money spent during a given period of time. Sum of the costs for the given period of time. o Sum of the costs for the given period of time. • o Cost Variance (CV) o The difference between what we expected to spend and what was actually spent. CV = EV-AC o CV = EV-AC • o Schedule Variance (SV) o The difference between where we planned to be in the schedule and where we are in the schedule SV = EV-PV o SV = EV-PV • o Cost Performance Index (CPI) o The rate at which the project performance is meeting cost expectations during a......

Words: 394 - Pages: 2

Premium Essay

Manacc Formulas

...CHAPTER 2: MANAGERIAL ACCOUNTING & COST CONCEPTS Direct Materials (DM) + Direct Labor (DL) + Manufacturing Overhead (MO) Manufacturing Costs (MC)/Product Costs (PC)/ Inventoriable Costs (IC) DM + DL Prime Cost DL + MO Conversion Cost Basic Equation for Inventory Accounts Beginning Bal + Additions to Inventory = Ending Bal + W/drawals from Inventory Cost of Goods Sold (COGS) in a Merchandising Co. Beg. Inv + Purchases = Ending I + COGS COGS = Beg. Inv + Purchases – Ending Inv Cost of Goods Sold (COGS) in a Mftg. Co. Beg. FG Inv + COGM = Ending FG + COGS COGS = Beg FG = COGM – Ending FG Beg WIP + MC Cost of Total Available units -Ending WIP COGM CHAPTER 8: SYSTEMS DESIGN : JOB-ORDER COSTING Unit PC = Total MC Total units produced Predetermined OH Rate = Est Total MO cost Est. Total amt of the alloc. Base CHAPTER 9: SYSTEMS DESIGN : PROCESS COSTING A. Weighted-Average Method Equiv. Units = No. of partially completed units x Percentage completion Equiv. Units of Production= Units transferred to the next dept or FG + Equiv.units in Ending WIP Cost per equiv. unit = Cost of Beg. WIP + Cost added during the period Equiv. units of production B. FIFO Method Equiv. Units = Equiv. units to complete BWIP + Units started and completed during the period + Equiv. units in EWIP OR Equiv. Units = Units transferred-out + Equiv. units in EWIP – Equiv. units in BWIP Equiv. units to complete BWIP = Units in BWIP x (100%- %completion of......

Words: 423 - Pages: 2

Premium Essay

Finance Formula

...Formula of Business Finance Time Value of Money ➢ Future Value of simple interest: [pic] ➢ Present Value of simple interest: [pic] ➢ Future Value of compound interest for single cash flow: [pic] ➢ Present Value of compound interest for single cash flow: [pic] ➢ Future Value of compound interest for multiple cash flows: [pic] ➢ Present Value of compound interest for multiple cash flows: [pic] ➢ Future Value of continuous compounding: [pic] ➢ Present Value of continuous compounding, [pic] ➢ Future Value of Ordinary or Immediate Annuity: [pic] ➢ Present Value of Ordinary or Immediate Annuity: [pic] ➢ Future Value of with continuous compounding: [pic] ➢ Present Value of Ordinary Annuity with continuous compounding [pic] ➢ Future Value of Annuity Due: [pic] ➢ Present Value of Annuity Due: [pic] ➢ Present Value of Perpetuity: [pic] ➢ Role of 72 to make double any amount: [pic] Or, [pic] ➢ Effective Annual Rate (EAR): [pic] ➢ Effective rate of nominal rate ‘r’ for continuous compounding: [pic] r = Stated or Quoted rate of interest in a year. i = Interest rate per period.= r/m m = Number of compounding per year. t = Number of years or Time expressed in years. n = Number of total periods = t × m R/C= cash flow per period. P / PV = Principal amount or Present Value F / FV =Future amount or Future......

Words: 1145 - Pages: 5

Free Essay

Formula

...To Write a Chemical Formula in OWL Enclose subscripts with underscores _. Enclose superscripts with carats ^. The underscore key is next to the number zero on the keyboard. The carat key is the number six on the keyboard. H_2_O = H2O Cr^3+^ = Cr3+ Combined: SO_4_^2−^ = SO42− Ions Unit Charge Ions Write the number first and then the charge. Do not include the number one in unit charge ions. N^3−^ = N3− Ca^2+^ = Ca2+ Na^+^ = Na+ Cl^−^ = Cl− Using the Chemical Formula Input The chemical formula input box displays the superscripts and subscripts as you enter the formula. There are 3 ways to use the input box. • Keyboard: Use the keyboard to enter underscores and carats on your own. • Buttons after: Enter the formula without underscores or carats, then highlight each superscript and/or subscript, click the appropriate subscript or superscript button, and the underscores or carats will be filled in automatically. • Button during: Use the subscript or superscript buttons to enter the underscores and carats while you type the formula. To Write a Chemical Formula in OWL Enclose subscripts with underscores _. Enclose superscripts with carats ^. The underscore key is next to the number zero on the keyboard. The carat key is the number six on the keyboard. H_2_O = H2O Cr^3+^ = Cr3+ Combined: SO_4_^2−^ = SO42− Ions Unit Charge Ions Write the number first and then the charge. Do not include the number one in unit charge ions. N^3−^ = N3− Ca^2+^ =......

Words: 264 - Pages: 2

Premium Essay

Finance Formula

...Formulae Final Examination Financial Accounting and Financial Statement Analysis l Equity Valuation and Analysis l Corporate Finance l Economics Table of Contents 1. Financial Accounting and Financial Statement Analysis 1.1 Generally Accepted Accounting Principles: Assets, Liabilities and 1 Shareholders’ Equities ......................................................................................... 1 1.1.1 1.2.1 1.3.1 1.3.2 1.3.3 Assets: Recognition, Valuation and Classification....................................... 1 Earning per Share ......................................................................................... 1 Profitability Analysis ..................................................................................... 2 Risk Analysis ................................................................................................ 5 Break-Even Analysis .................................................................................... 6 1.2 Financial Reporting and Financial Statement Analysis ...................................... 1 1.3 Analytical tools for Assessing Profitability and Risk......................................... 2 2. Equity Valuation and Analysis 2.1.1 2.1.2 2.1.3 7 2.1 Valuation Model of Common Stock .................................................................... 7 Dividend Discount Model............................................................................. 7 Free Cash Flow......

Words: 4580 - Pages: 19

Free Essay

Excel Formulas

...Microsoft Excel 2010 Formulas & Functions  Table of Contents Excel 2010 Formulas & Functions ……………………………………………….….. o Formula Basics ……………………………………………….….. o Order of Operation ……………………………………………….….. Conditional Formatting ……………………………………………….….. Cell Styles ……………………………………………….….. Formulas & Functions ……………………………………………….….. Basic Formulas ……………………………………………….….. o Add the Values in Rows or Columns ……………………………………………….….. o Find the Average, Maximum, or Minimum ……………………………………………….….. Ranges & Individual Cells ……………………………………………….….. Copy a Formula ……………………………………………….….. o Using the Fill Handle ……………………………………………….….. o Using Traditional Copy & Paste ……………………………………………….….. Referencing Cells in Formulas ……………………………………………….….. o Relative References ……………………………………………….….. o Absolute References ……………………………………………….….. o Mixed References ……………………………………………….….. o References to Other Worksheets ……………………………………………….….. o Other Workbook References ……………………………………………….….. Quick Reference Guide ……………………………………………….….. o Add, Subtract, Multiple & Divide ……………………………………………….….. o Understanding Error Values ……………………………………………….….. Practical Purposes of Excel Formulas ……………………………………………….….. o Using Date & Time Formulas ……………………………………………….….. Commonly Used Functions & Formulas ……………………………………………….….. o Math & Trig Icon ……………………………………………….….. Logical Icon ……………………………………………….….. Lookup & Reference Icon ……………………………………………….….. Date & Time Icon ……………………………………………….….. AutoSum Icon ……………………………………………….…........

Words: 478 - Pages: 2

Premium Essay

Key Accounting Formulas

...Formulas For Common Ratios Growth Rates One-year Growth Rate Xt −Xt−1 Xt−1 Xt Xt−n 1 n Compound Average Growth Rate (CAGR)1 −1 Profitability Ratios Gross Margin Operating Margin Net Margin Return on Assets (ROA)2 Return on Beginning Equity (ROBE)3 Return on Invested Capital (ROIC)4 Pretax Return on Invested Capital Gross Profit Sales EBIT Sales Net Income Sales EBIT(1-Tax Rate) Average Total Assets Net Income Beginning Equity EBIT(1-Tax Rate) Interest-bearing Debt + Equity EBIT Interest-bearing Debt + Equity 1 n denotes the number of periods between observations Xt and Xt−n . Ratios that compare balance sheet and income accounts are often computed using the average of the balance sheet item. The average is computed by averaging beginning and year-end account balances. 3 Some analysts use year-end or average equity when computing ROE. 4 Interest-bearing debt is commonly defined as the sum of long-term debt, current portion long-term debt, and shortterm debt. Analysts may use year-end or average invested capital. 2 HBS Finance Tutorial 1 Ratio Formulas Efficiency Ratios Asset Turnover Net Working Capital Turnover Fixed Assets Turnover Days in Inventory (Days) Inventory Turnover Collection Period (Days) Receivables Turnover Days’ Sales in Cash (Days) Payables Period (Days)5 Sales Average Total Assets Sales Average Net Working Capital Sales Net PP&E Average Inventory COGS/365 COGS Average Inventory Average Receivables Sales/365 Sales Average......

Words: 482 - Pages: 2

Premium Essay

Formulas

...Formulas: 4 Total Cost 4 Contribution Margin 4 Unit Contribution 4 Total Contribution 4 Profit 4 Channel Margins 5 Margins (in %) – Based on Price 5 Mark-Ups (in %) – Based on Costs 5 Example: 5 Moving Up & Down the Value Chain 6 Move “Up” Chain 6 Move “Down” Chain 6 Breakeven Analysis 6 BE (units) 6 BE (dollars of sales) 7 Market Share 7 Dollar Share 7 Unit Share 7 BE MS (Dollars) 7 BE MS (Units) 7 Cannibalization 7 Total Contribution (NP) 7 Net Present Value: Today’s $ v. Next Year’s $ 8 Customer Lifetime Value (CLV) 8 Mkt Strat I: Strategy Formulation, Market Assessment Tools (Frameworks), Porter’s Generic Strategies 9 Dolan’s 5 Cs 9 Porter’s 5 Forces Model 10 BCG Matrix 10 Marketing Strategy II: Segmentation and Positioning 11 S-T-P 11 Consumer Segmentation Variables: 11 Business Segmentation Variables: 11 Characteristics of Effective Segmentation 11 Bases for Segmentation Evaluation 12 Targeting the Markets 12 Pricing 12 Top 3 of 5 Deadly Pricing Sins 12 8 Steps to Better Pricing Decisions 12 Value-Based Pricing 13 Marketing Research 14 Steps in Marketing Research 14 Reliability v. Validity 14 Marketing Channels 15 Value Adding Roles of Intermediaries 15 Channel Conflict and Efficiency 15 Salesforce Management 15 McMurry’s sales representative types: 16 Motivating the Salesforce 16 Simple Salesforce Structures 16 Salesforce Size 17 Brand Management 17 Brand......

Words: 2241 - Pages: 9

Premium Essay

Formula

...Evaluation of Financial Policy GBA 546 Formula Sheet Prepared by P. Sarmas Cash Flow from Assets = Cash Flow to Creditors + Cash Flow to Stockholders Operating Cash Flow Interest Paid Dividend Paid - Net Working Capital - Net New Borrowing - Net New Equity - Net Capital Spending Cash Flow to Creditors Cash Flow to Stockholders Cash Flow from Assets EBIT Ending Net Fixed Assets + Depreciation - Beginning Net Fixed Assets - Taxes + Depreciation . Operating Cash Flow Net Capital Spending Ending Net Working Capital (CA – CL) - Beginning Net Working Capital (CA-CL) Change in Net Working Capital Ending L.T. Debt Ending Equity - Beginning L.T. Debt - Beginning Equity Net New Borrowing - Addition to Retained Earnings Net New Equity Dividend Payout Ratio = Dividends  Net Income ROADuPont = Profit Margin * Total Assets t/o ROEDuPont = Profit Margin * Total Assets t/o * Equity Multiplier Earnings Retention Ratio = b = 1 – Dividend Payout Ratio = 1- DIV/NI (1+R) = (1+r)*(1+h) Operating Cycle = Inventory Period + Accounts Receivable Period Cash Cycle = Operating Cycle – Accounts Payable Period Operating Cash Flow = EBIT + Depreciation – Taxes Operating Cash Flow = (Sales – OC – Depreciation)*(1-T) + Depreciation......

Words: 311 - Pages: 2

Premium Essay

Business Accounting Formulas

...UKAF 1073 BUSINESS ACCOUNTING 2 – LECTURE 8 Page 1 of 2 DEFINITION OF RATIOS (TO BE USED FOR GROUP ASSIGNMENT AND FINAL EXAMINATION) |CATEGORY |TYPES |DEFINITION | |PROFITABILITY |Gross profit margin |Gross profit x 100% | |(expressed in %) | |Sales | | | | | | |Operating profit margin |Profit before interest and tax x 100% | | | |Sales | | |Net profit margin | | | | |Profit after tax x 100% | | | |Sales | | |Return......

Words: 302 - Pages: 2

Premium Essay

Formulas

...MAR 4231 = Financial Formulas Note: When calculating the financials, please round to four decimal places. For example: 1.7658643983 = 1.7659 (four decimal places) 0.4322222222 = 0.4322 (four decimal places) Asset turnover = Net sales Total assets Cost complement = is the relationship of cost to retail value of merchandise available for sale Total cost valuation Total retail valuation Cost of goods sold = Cost of merchandise available for sale – cost value of ending inventory Ending retail book value of inventory = on paper, how much is your inventory worth (at retail) = Merchandise available for sale – Sales – Deductions Financial Leverage = Total assets Net worth Gross Profit = Sales – Cost of Goods Sold Net Profit = Gross Profit – Operating Expenses Net Profit Margin = Net profit after taxes Net sales Profit & Loss Statement = Sales – less cost of goods sold = gross profit Return of Assets = Net profit margin x asset turnover Return on Net worth = Net profit margin x Asset turnover x Financial leverage Stock Shortages = how much inventory was stolen/lost? Ending retail book value of inventory – physical inventory at retail Total merchandise available (at cost) = Beginning monthly inventory + Net purchases + transportation charges Total merchandise available (at retail) = Beginning monthly inventory + Net purchases Adjusted ending retail book value of inventory = adjusted the value of the retail book value of......

Words: 369 - Pages: 2

Premium Essay

Formulas

...FORMULAS CHAPTERS 12, 14, 15 AND 16. CH 12 BREAK EVEN ANALYSIS Sales price EBIT = 0 = units X per unit Break-even level of units variable cost - units X sold per unit total fixed + sold cost total fixed cost = sales price variable cost per unit − per unit Total fixed cost S* = F/ [1 – (VC / S)] Break-even level of revenues = variable cost 1revenues Degree of operating leverage DOLs = Q (P – V) / [Q (P – V) – F] DOLs = revenue before fixed cost / EBIT = S – VC / [S - VC – F] Degree of financial leverage DFLEBIT = EBIT / (EBIT - I) Degree of combined leverage DCLS = (DOLS) X (DFLEBIT) EBIT – EPS indifference point: EPS: Stock plan (EBIT – I)(1 – t) – P / Ss = EPS: Bond plan (EBIT – I)(1 – t) – P / Sb EBIT = [Ib – Is (Sb / Ss ] / [ 1 - (Sb / Ss) ] 14 SHORT-TERM FINANCIAL PLANNING CURRENT ASSETS AS A PERCENTAGE OF SALES = Current assets / sales Projected current assets = projected sales X (current assets / sales) Projected addition net income cash dividends X 1 − = projected sales X to retained earnings sales net income Discretionary financing = projected total assets – projected liabilities – projected owner’s equity needed (DFN) predicted change predicted change − DFN = in total assets predicted change − in spontaneous liabilities in retained earnings External financing needs (EFN) EFN = predicted change in total assets – change in retained earnings ...

Words: 532 - Pages: 3

Premium Essay

Formulas

... Higgins)  Summary of the used chapters in the lecture (WM0609LR)  Written by: Joris Van Gestel    Chapter 1 Interpreting financial statements  Accounting Information provided by 3 annual reports: Balance Sheet Cash-Flow statement Income statement   Figure 1 Cash flow­production cycle  (Operating) working capital: movement of cash into inventory  Investment: flow from cash into new fixed assets  Depreciation: the loss in value of fixed assets ⇒ increase in value of merchandise made + needed for  growth  Solvency: ability to have cash to buy fixed assets and inventory (outflow cash)  Financial statements: Balance sheet The balance sheet  Equity= assets - liabilities current assets current liabilities cash ! inventories ! acc receivable ! equipment ! plant accounts payable ! ! fixed assets long-term liabilities long-term debt ! total shareholders equity stock ! retained earnings ! total assets x total liabilities + equity x Figure 2 example of a balance sheet    Financial snapshot: 1 moment in time  Assets against the claims    Liability: obligation to deliver something of value in the future  Equity: difference between assets and liabilities  Liquidity: speed at which an item can be turned into cash    Accounting: income statement Assets and liabilities are listed in order of decreasing liquidity  ‐ Current: liquidity 1 year  Earnings Before Interest, Taxes,......

Words: 4665 - Pages: 19

Premium Essay

Excel Formulas

...has hundreds of functions and nobody knows them all, but spend some time and learn to create more powerful formulas. Students will dive into decision making functions like if() and lookup() and make Excel work for them! Students will also explore efficient use of multiple sheets in a workbook, creating multi-sheet and multi-workbook formulas. Students will learn about: if() functions, lookup() functions, conditional formatting, and using multiple worksheets in a workbook. 1. Course objectives. a. To provide the class with an exploration of spreadsheet design. b. To develop computer and spreadsheet literacy. c. To address the class' questions. 2. Schedule a. 9:00 Registration b. 9:30 Morning session c. 12:00 Departure 3. Handouts available in Adobe Portable Document Format (PDF) for download at www.crowleycomputers.com/handouts.htm 1. 2. Formulas: All formulas begin with = or basic math function a. Simple operators Monthly weather (1) + averages.xls (2) (3) * multiply (4) / divide (5) ^ exponent (6) = < > comparison b. Order of operator precedence (or Algebraic Order of Operations, for those of you as old as me!) determines what order calculations occur. (1) Calculations do not occur from left to right. (2) 3+4*5 does not equal (3+4)*5 (3) When you’re not sure, use (parenthesis) to force order of calculation. c. Edit via double clicking on cell, clicking on formula bar or F2 Operators ( in order of......

Words: 1729 - Pages: 7