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.
Building a financial worksheet with Pivot Tables
Reviewing financial statements through common-sized balance sheets
Calculating percentage change over time in financial statements
Determining profitability ratios and return on investments
Studying liquidity and activity ratios through an average collection period
Computing the future value of an investment