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
Introduction1. Designing a Financial Worksheet2. Analyzing Cash Flows Using Excel Tables and Pivot Tables3. Analyzing Financial Statements4. Calculating Profitability Ratios5. Calculating Liquidity and Activity Ratios6. Calculating Leverage Ratios7. Calculating the Effect of Interest Rates on Loan Repayment8. Determining Future Cash Flows9. Forecasting Future Growth10. Determining Amortization and Depreciation Schedules11. Analyzing Bond InvestmentsConclusion
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.