->
Lynda - Excel 2007: Financial Analysis - 52291
Lynda - Excel 2007: Financial Analysis
Numbers and financial data drives today's business world and Excel 2007: Financial Analysis can help decode this information. The proper understanding of these numbers, and the formulas behind them, can be the gateway to corporate and personal success. Microsoft MVP (Most Valuable Professional) Curt Frye teaches basic fluency in corporate finance, enabling users to see the meaning behind essential financial calculations. Curt explains how to review formulas to ensure they have the proper inputs, and shows how to interpret formula output. He also covers how to calculate leverage ratios and amortization and depreciation schedules, as well as forecast future growth. Exercise files accompany this course.


Table of Contents

  • Introduction
  • 1. Designing a Financial Worksheet
  • 2. Analyzing Cash Flows Using Excel Tables and Pivot Tables
  • 3. Analyzing Financial Statements
  • 4. Calculating Profitability Ratios
  • 5. Calculating Liquidity and Activity Ratios
  • 6. Calculating Leverage Ratios
  • 7. Calculating the Effect of Interest Rates on Loan Repayment
  • 8. Determining Future Cash Flows
  • 9. Forecasting Future Growth
  • 10. Determining Amortization and Depreciation Schedules
  • 11. Analyzing Bond Investments
  • Conclusion
  • Lynda - Excel 2007: Financial Analysis


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss