Home > Excel Business Solutions > Business Finance > Financial Analysis > Financial Functions Share

Financial Functions

Excel financial functions for financial analysis


Excel Financial Functions

Rate this solution:
(3/5 from 2 votes)
Financial Functions screenshot
Financial Functions for Excel (JEM Plus) is designed to add productivity to workbook and worksheet management in Excel as well as providing a large set of financial analysis calculations and functions. Utilities added to the Excel menu cover a wide range time saving tools for reporting information and managing tasks within workbooks and sheets.  Moreover, over 200 powerful functions are added for dates, system information, logic, string manipulation, human resources including 173 financial functions.

Excel Financial functions include:

  • Bankruptcy Functions - Altmans Measure for Business Failure Index for Private Owned Manufacturer, Private Owned Non-manufacturer and Public Owned Manufacturer.
  • Bonds - Taxable Equivalent Yield.
  • Capital Tangible Investment - Accounting Rate of Return, Average Accounting Rate of Return and Payback Period.
  • Cash Management - Cash Conversion Cycle, Target Cash Balance (Baumol and Miller-Orr), Trade Credit Rate and Working Capital.
  • Cost Accounting - Break Even (Dollars/Units/Contribution Margin), Inventory (EOQ Economic Order Quantity points and costs), Learning Curves, Actual/Normal/Standard Costing (Direct/Variable/Fixed Costs and Factory Overhead), Rates (fized/Variable/Fringe Benefit), Standards/Budgets/Variance (Labor and Material Mix/Yield, Market Share/Size, Sales Control/Price/Volume Variance) and more.
  • Derivatives - Return on Warrant and Value of Call/Put/Stock Right/Warrant.
  • Fundamentals - Activity (Accounts Payable/Receivable Turnover/Days, Inventory/Assets), Assets (Deferred Charges/Intangibles/Repairs/Retained Earnings /Equity ratios), Expenses (Categorized calculations and ratios), Leverage and Liquidity (Balance Sheet item ratios), Profitability and Capital Market (EBITDA, Earnings, P/E, Sales, Margin, Book, ROI and more ratios), Solvency (Coverage, Cash Flow and relevant ratios).
  • Market Indicators - Barrons Confidence Index, Bearish Sentiment Index, Breadth Index, Puts to Calls, and Odd Lot indexes.
  • Market Investment - CAPM, Sharpe, Continuous Compounding Rate, Effective Annual Interest, Perpetuity, Present Values, Short Sales and more.

Get It

(Pricing is available on the next page)
(Updated on 2012-12-01)

Related Excel Solutions for Financial Functions

Financial CalculationsFinancial Analysis  Financial Formula CalculationsFinancial Analysis  Finance Templates and CalculatorsFinancial Analysis  Financial Ratio TemplatesFinancial Accounting  Economic Order Quantity (EOQ) TemplateSupply Chain and Inventory  2010 Training CoursesTraining and Tutorials  Derivatives AnalysisTechnical Analysis  Financial Analysis FunctionsFinancial Analysis

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum or proposed as a project to the Excel freelance community.