• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

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.

Course Excel 2007: Financial Analysis Author Curt Frye SKU ISBN Release Date 2009-08-25 Duration 2.18 hrs / 51 tutorials Work files Yes Price $ 49.95 Retail price $ 99.95 Language Tags

Introduction Welcome 01:08 Using the exercise files 00:32 Disclaimer 00:26 1. Designing a Financial Worksheet Separating inputs and formulas 02:02 Avoiding common mistakes 05:39 Tracing formula precedents and dependents 02:52 Evaluating Excel formulas step by step 02:47 2. Analyzing Cash Flows Using Excel Tables and Pivot Tables Tracking income and expenses using an Excel table 03:29 Creating a Pivot Table from table data 03:36 Pivoting a Pivot Table 02:22 Filtering a Pivot Table 03:11 Adding Pivot Table columns to enhance data analysis 03:05 Tracking cash flow using a Pivot Chart 02:57 3. Analyzing Financial Statements Reading a corporate financial statement 06:01 Introducing common-sizing strategies for analyzing financial statements 03:59 Creating common-sized income statements 03:01 Creating common-sized balance sheets 02:53 Calculating percentage changes in financial statements 02:54 4. Calculating Profitability Ratios Calculating earnings per share 01:54 Calculating return on equity and return on assets 02:50 Calculating gross profit margin and net profit margin 03:28 5. Calculating Liquidity and Activity Ratios Calculating the current ratio and quick ratio 02:47 Calculating the average collection period 01:56 Calculating inventory turnover 01:36 6. Calculating Leverage Ratios Calculating the equity ratio 01:26 Calculating the debt ratio 02:57

Calculating the times interest earned ratio 01:49 7. Calculating the Effect of Interest Rates on Loan Repayment Calculating simple interest and compound interest 03:36 Applying nominal versus effective interest rates (APR versus APY) 03:21 Calculating the number of days between events 04:01 8. Determining Future Cash Flows Computing the future value of an investment 03:30 Calculating present value 02:29 Calculating net present value 02:42 Calculating internal rate of return 02:24 Calculating NPV and IRR for uneven input periods (XNPV and XIRR) 02:27 9. Forecasting Future Growth Projecting future results using the Forecast function 02:09 Performing quick forecasts using the Fill handle 02:57 Adding a trendline to a chart 02:24 10. Determining Amortization and Depreciation Schedules Introducing amortization 02:20 Calculating payments on a fully amortized loan 02:21 Calculating payments on a partially amortized loan (balloon payments) 02:04 Calculating interest and principal components of loan repayments 05:32 Introducing depreciation 02:01 Calculating straight line depreciation 01:30 Calculating declining balance depreciation 03:24 Calculating double declining balance depreciation 03:16 11. Analyzing Bond Investments Introducing bonds and bond terminology 01:37 Calculating a bond's yield 02:15 Calculating the value of zero coupon bonds 03:18 Pricing bonds to be offered to investors 02:24 Conclusion Goodbye 00:23