ROI calculator and much more - Financial Metrics Pro™ Excel spreadsheet

Upgrade Information

Owners of Financial Metrics Pro who purchased less than one year ago receive a free upgrade to V3. Please indicate your original order ID (or registered username and approxiamte date of purchase). Send e-mail request to smatrix@solutionmatrix.com

Registered owners of Financial Metrics Pro who purchsed more than one year ago, click here to upgrade to V3 for US$30. Please provide your original order ID (or registered username and approxiamte date of purchase) on the "Comments/Special Delivery Instructions block on the shopping cart order form. Also please indicate Excel 97-2003 or Excel 2007 version.

Registered owners of the Business Case Guide , click here to purchase Financial Metrics Pro V3 for US$30. Please provide your original order ID (or registered username and approxiamte date of purchase on the "Comments/Special Delivery Instructions block on the shopping cart order form. Also please indicate Excel 97-2003 or Excel 2007 version..

Financial Metrics Pro It's about time!

Saving your time, that is. Financial Metrics Pro™ is a comprehensive set of easy to understand, easy to use spreadsheet templates and working examples.

Newly enhanced and upgraded to V3! This new template system can save you hours or days of tedious spreadsheet programming and reduce the risk of errors at the same time.

For those working with ROI, NPV or other financial analyses for the first time, Financial Metrics Pro is a clear, easy to follow introduction to frequently used financial metrics: What they mean, how they are used, and how to build them into your own spreadsheets.

Financial Metrics Pro is also a comprehensive handbook and reference for professional analysts, students, consultants, managers, and everyone else who works with the business case or financial statement figures. It explains and shows you how to implement:

ROI and Other Cash Flow Metrics
Business case cash flow statements, with working examples of NPV, IRR, CAGR, ROI, breakeven, and dozens more.
Financial Statement Metrics
Income statement, balance sheet and other financial statements, with 6 categories of important financial ratios, multi-year comparisons, and a working Du Pont analysis system.

Each financial metric is defined and its meaning explained. The best methods for spreadsheet implementation and graphing are illustrated. The strengths and weaknesses of each financial metric are also explained, along with any special programming issues.

Abundant on-screen guidance helps ensure that you choose the financial metrics you need and build them easily into your own spreadsheet models and analyses. Financial Metrics Pro supports many different business case styles, but it is designed especially to complement the standard approach to financial modeling, set by the companion tool, Financial Modeling Pro, and as presented in The Business Case Guide.

Financial Metrics Pro is delivered in a single MS Excel workbook with 25 worksheets. All worksheets except the Users Guide can be modified as necessary, copied, and pasted into your own spreadsheets.

Fianncial Metrics Pro V3 is available in versions for Excel 97-2003 and for Excel 2007.

What's new in Financial Metrics Pro V3?

Hyperlink navigation throughout. Table of contents, chapter outlines, and cross-referenced terms take you to the reference with a mouse click.
"Everything you wanted to know about IRR but were afraid to ask." Expanded and enhanced chapter on IRR explains in clear terms what IRR really means, how the IRR metric can be misused, and how it compares to the cost of debt, NPV, ROI, and other financial metrics.
New, alternate approaches to many metrics. Implement payback period calculation , for instance either as a single cell formula, or use the simpler, easier-to-proofread approach with intermediate results.
Expanded and improved Users Guide, with an emphasis on the essential characteristics of cash flow metrics and financial statement metrics.
Special chapter on good practice in spreadsheet programming. Techniques that add credibility, usability, and professional appearance to spreadsheet models.
Special chapter on naming cells and ranges (Excel 2007 version, only). An illustrated tutorial on naming. Make your formulas easier to read and check by assigning names for cells and ranges.

Financial Metrics Pro V3 Contents

Chapter 1. Users Guide
• Introduction to financial metrics
• Cash flow metrics vs. financial statement metrics
    – Cash flow metrics
    – Financial statement metrics
• Financial Metrics Pro purpose
• Using the examples
    – Color code
    – Unlocking cells and modifying worksheets
    – Copying to other spreadsheets / breaking links
    – Adding or deleting cells, rows, or columns
    – Names for cells and cell ranges

Cash Flow Metrics

Chapter 2. Cash Flow
• Cash flow
• Cash flwo vs. income and cost
• Business case cash flow statements
• Business case vs. financial accounting
    – Full value vs. incremental cash flow
    – Inflows vs. outflows
    – Other statement structures
• Graphing cash flow

Chapter 3. Cumulative Cash Flow for the Business Case
• Cumulative cash flow
• Cumulative cash flow vs. payback
• Spreadsheet example: cumulative cash flow
• Estimating payback from cumulative cash flow

Chapter 4. Payback Period
• Payback period from net cash flow
•  Spreadsheet examples: Payback from net cash flow
     – Example: 5 yrs, net cash flow
     − Example: 10 yrs, net cash flow
• Payback from discounted cash flow
     – Example 5 yrs, discounted cash flow
     – Example 10 yrs, net cash flow
•  Spreadsheet examples: Payback from simpler formulas and intermediate results
• Payback period from graphs
• Payback period strengths, wekanesses, and cautions
•  Discounted vs. nondiscounted payback
• Mathematical basis for the payback calculation

Chapter 5. Discounted Cash Flow (DCF) and Net Present Value (NPV)
• Present value from a single cash flow event
• Net Present Value (NNPV)
• Spreadsheet example: Present value for a single cash flow event
• Present value in algebraic terms
• Choosing an interest rate for discounting
• Present value from a cash flow stream
     – Spreadsheet example: NPV with year-end discounting
     – Spreadsheet example: NPV with mid-year discounting
     – Spreadsheet example: NPV with semiannual, quarterly, or monthly discounting
• Using Excel's built in NPV function
• NPV strengths, weaknesses, and cautions
• Graphing net and discounted cash flow

Chapter 6. Compund Interest / Future Value
• Compound Interst
• Future value of a single cash flow event
• Spreadsheet example: Future value of a single cash flow event
• Future value in algebraic terms
• Future value over a series of compounding periods (single cash flow event)
• Spreadsheet examples:
     – FV with annual compounding
     – FV with compounding semiannually, quarterly, monthly, or daily (single cash flow event)
• Continuous compounding
• Compounding periods compared
• Future value of an annuity
     – Spreadsheet example: fixed annuity
     – Excel's built in FV function
     – Spreadsheet example: FV for multiple cash flow events, variable amounts
       (including variable annuity)
• Graphing compound interest growth

Chapter 7. Cumulative Average Growth Rate (CAGR)
• Calculating cumulative average growth rate
• Spreadsheet example: calculating CAGR
• CAGR in algebraic terms
• CAGR strengths, weaknesses, and cautions
• CAGR example

Chapter 8. Return on Investment (ROI)
• Return on Investment (ROI)
• Simple ROI in algebraic form
• Spreadsheet example: Simple return on investment (ROI)
• Spreadsheet example: Simple return on investment:
• Spreadsheet examples: Simple return on investment from cashflow
– Simple ROI using intermediate results
– Simple ROI using a single cell formula
• ROI strengths, weaknesses, and cautions

Chapter 9. Internal Rate of Return (IRR)
• Internal rate of return (IRR)
• Internal rate of return (IRR) from a cash flow stream
• Spreadsheet example: Excel's built in IRR function
– Note on MIRR results
• Modified internal rate of returnS (MIRR)
• Spreadsheet example: Excel's MIRR function
– Note on MIRR results
• IRR strengths, weaknesses, and cautions
• Graphical solution for IRR
• IRR vs NPV vs ROI vs Cost of Debt. What does IRR really mean?

Chapter 10. Breakeven Analysis
• Breakeven analysis
• Simple breakeven analysis
     – Simple breakeven in algebraic terms
     – Spreadsheet example: Simple breakeven
     – Graphing breakeven analysis
• Breakeven analysis with semivariable input (nonlinear breakeven)
     – Spreadsheet example: semivariable input
     – Mathematical basis for semivariable input analyais
     – Intermediate results for semivariable input analyais
     – Graphing breakeven with semivariable input

Financial Statement Metrics

Chapter 11. Introduction to Financial Statement Analysis
• Financial statement analysis
• Interpreting financial statement metrics
• Categories of metrics

Chapter 12. Income Statement
• The income statement
• Basic income statement equation
• Income statement terms
• Level of detail
• Nonprofit organizations
• Spreadhseet example: Income statement
• Spreadsheet example: Income statement

Chapter 13. Balance Sheet
• The balance sheet
• Basic balance sheet equation
• Balance sheet terms
• Level of detail
• Spreadsheet example: Balance sheet

Chapter 14. Changes in Financial Position (Cash Flow Statement)
• Changes in financial position
• Basic statement of changes in financial position equation
• Spreadsheet example: Statement of changes in financial position

Chapter 15. Statement of Retained Earnings
• Statement of retained earnings:
• Basic retained earnings equation
• Spreadsheet example: Statement of retained earnings

Chapter 16. Liquidity Metrics
• Liquidity metrics
• Liquidity metrics: General approach and set up data
• Working capital
• Current ratio (working capital ratio)
• Quick ratio (acid test ratio)

Chapter 17. Activity and Effectivity Metrics
• Activity and efficiency metriics
• General approach and set up data
• Sales revenue per employee
• Inventory turns
• Days sales in inventory (average turnover period)
• Accounts receivable turnover
• Average collection period (days sales outstanding)
• Total asset turnover
• Fixed asset turnover

Chapter 18. Leverage Metrics
• Leverage metrics: creditors vs. owners
• General approach and set up data
• Total debt to total assets ratio
• Debt to equity ratios
• Total debt to stockholders equity
• Long term debt to stockholders equity
• Times interest earned

Chapter 19. Profitability Metrics
• Profitability metrics
• General approach and set up data
• Profit margin on sales
• Operating profit margin
• Operating profit before taxes
• Operating profit after taxes
• Gross profit margin or gross margin
• Return on total assets
• Return on equity or return on owner's investment, or return on investment

Chapter 20. Valuation Metrics
• Valuation metrics
• General approach and set up data
• Spreadsheet examples
• Price to earnings ratio
• Book value per share
• Book value per share, common stock
• Book value per share, preferred stock
• Market-to-book ratio

Chapter 21. Multi Year Financial Statement Analysis
• Multi-Year Comparisons
• Four financial statements
• Making multi year comparisons
• Spreadsheet set up and data
     – Multi year income statement
     – Multi year balance sheet
     – Multi year statement of retained earnings
     – Multi year changes in financial position
• Multi year financial metrics and graphs
     – Liquidity Metrics: 1-10 year comparisons
     – Activity Metrics: 1-10 year comparisons
     – Leverage Metrics: 1-10 year comparisons
     – Profitability Metrics: 1-10 year comparisons
     – Valuation Metric (EPS): 1-10 year comparisons

Chapter 22. Growth Metrics
• Growth metrics
• General approach
• Spreadsheet examples: growth metrics
     – Sales growth
     – Net income / profit / earnings growth
     – Earnings per share growth
     – Dividends per share growth

Chapter 23. The Du Pont System
• The Du Pont system of analysis: Return on investment
(return on assets)
• Spreadsheet example: Du Pont system

Spreadsheet Programming

Chapter 24. Good practice in spreadsheet programming
• Good practice in spreadsheet programming
• Take time to format
• One file, many worksheets
• HIghlight user input and derived results
• Proofread and check formulas
• Prevent division by zero and other errors
• Use intermediate results

Chapter 25. Namiing cells and Ranges (Excel 2007 version only)
• Naming cells and ranges
• Two ways to name cells
• Using names in formulas
• Assigning and using range names - rows
• Assigning and using range names - columns
• Descriptive names for worksheets

<< Financial Metrics Pro

Financial Modeling Pro >>