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.


    SermonBox - Seasonal Collection

    SermonBox - The Series Pack Collection

    Top Rated News

    • Christmas Material
    • Laser Cut & Print Design Elements Bundle - ETSY
    • Daz3D - All Materials - SKU 37000-37999
    • Cgaxis - All Product - 2019 - All Retail! - UPDATED!!!
    • DigitalXModels Full Collections
    • Rampant Design Tools Full Collections Total: $4400
    • FilmLooks.Com Full Collection
    • All PixelSquid Product
    • The Pixel Lab Collection
    • Envato Elements Full Sources- 3200+ Files
    • Ui8.NET Full Sources
    • The History of The 20th Century
    • The Dover Collections
    • Snake Interiors Collections
    • Inspirational Collections
    • Veer Fancy Collections
    • All Ojo Images
    • All ZZVE Collections
    • All Sozaijiten Collections
    • All Image Broker Collections
    • Shuterstock Bundle Collections
    • Tattoo Collections
    • Blend Images Collections
    • Authors Tuorism Collections
    • Motion Mile - Big Bundle
    • PhotoBacks - All Product - 2018
    • Dekes Techniques - Photoshop & Illustrator Course - 1 to 673
    Telegram GFXTRA Group
    Udemy - Turkce Gorsel Ogrenme Setleri - Part 2
    Videohive Wow Pack Series


    rss