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

Financial Analysis Functions

Excel financial analysis functions for financial analysis


Excel Financial Analysis Functions

Rate this solution:
(4.7/5 from 3 votes)
Financial Analysis Functions screenshot
Excel Financial Analysis Functions (tadXL) is an add-in for Excel 2007 and later that adds over 100 useful and accurate cell functions designed specifically for financial analysis solutions.

The financial functions are available with Excel like any other built in function allowing to quickly and easily make calculations required for financial analysis project and work. Detailed and targeted functions are categorized by investment and analysis purpose with descriptions provided for each function.

Key features of the Excel financial analysis functions include:
  • Interest rate functions for bond and fixed interest investment securities with support for single rate and schedules of both periodic and non-periodic nature.
  • Present and future value calculation through various DCF valuation techniques and assumptions including separate functions for capital costs and CAPM components.
  • Factor analysis functions provide calculations for sensitivities such as capital recovery, compound, present worth, sinking and growing annuity for present and future values.
  • Financial ratios such as cost/benefit ratio as together with key performance indicators (KPI) such as internal rates of return (IRR), payback period and profitability metrics allows fast building of financial analysis dashboards.
  • Bond calculations with solving for yield to maturity with sensitivities on duration and convexity allow fast analysis of debt and interest rate investment assets.

Try It  Get It

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

Related Excel Solutions for Financial Analysis Functions

Investment and Business ValuationBusiness Valuation  Investment NPV and IRR CalculationBusiness Valuation  Technical Analysis FunctionsTechnical Analysis  Financial FunctionsFinancial Analysis  Financial CalculationsFinancial Analysis  Financial Formula CalculationsFinancial Analysis  Finance Templates and CalculatorsFinancial Analysis  Financial Security Analysis TemplatesTechnical Analysis  Financial Ratio TemplatesFinancial Accounting  Financial Valuation and Modeling CourseBusiness Valuation

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.