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.

Download:
http://rapidshare.com/files/28846385...ysis.part1.rar
http://rapidshare.com/files/28852829...ysis.part2.rar

http://www.megaupload.com/?d=VOSCHS29
http://www.megaupload.com/?d=YUB62H1Y

http://www.mediafire.com/?nqzjzdnfjxm
http://www.mediafire.com/?j2tdtye0yxd

Table of contents

Introduction		02:06
	Welcome	1:08	11.1 MB
	Using the exercise files	0:32	0.5 MB
	Disclaimer	0:26	0.4 MB
1. Designing a Financial Worksheet		13:20
	Separating inputs and formulas	2:02	3.0 MB
	Avoiding common mistakes	5:39	7.0 MB
	Tracing formula precedents and dependents	2:52	4.0 MB
	Evaluating Excel formulas step by step	2:47	3.0 MB
2. Analyzing Cash Flows Using Excel Tables and Pivot Tables		18:40
	Tracking income and expenses using an Excel table	3:29	4.0 MB
	Creating a Pivot Table from table data	3:36	5.0 MB
	Pivoting a Pivot Table	2:22	3.0 MB
	Filtering a Pivot Table	3:11	4.0 MB
	Adding Pivot Table columns to enhance data analysis	3:05	4.0 MB
	Tracking cash flow using a Pivot Chart	2:57	4.0 MB
3. Analyzing Financial Statements		18:48
	Reading a corporate financial statement	6:01	8.0 MB
	Introducing common-sizing strategies for analyzing financial statements	3:59	5.0 MB
	Creating common-sized income statements	3:01	4.0 MB
	Creating common-sized balance sheets	2:53	4.0 MB
	Calculating percentage changes in financial statements	2:54	4.0 MB
4. Calculating Profitability Ratios		08:12
	Calculating earnings per share	1:54	2.0 MB
	Calculating return on equity and return on assets	2:50	3.0 MB
	Calculating gross profit margin and net profit margin	3:28	4.0 MB
5. Calculating Liquidity and Activity Ratios		06:19
	Calculating the current ratio and quick ratio	2:47	3.0 MB
	Calculating the average collection period	1:56	3.0 MB
	Calculating inventory turnover	1:36	2.0 MB
6. Calculating Leverage Ratios		06:12
	Calculating the equity ratio	1:26	2.0 MB
	Calculating the debt ratio	2:57	4.0 MB
	Calculating the times interest earned ratio	1:49	2.0 MB
7. Calculating the Effect of Interest Rates on Loan Repayment		10:58
	Calculating simple interest and compound interest	3:36	4.0 MB
	Applying nominal versus effective interest rates (APR versus APY)	3:21	4.0 MB
	Calculating the number of days between events	4:01	5.0 MB
8. Determining Future Cash Flows		13:32
	Computing the future value of an investment	3:30	4.0 MB
	Calculating present value	2:29	3.0 MB
	Calculating net present value	2:42	3.0 MB
	Calculating internal rate of return	2:24	3.0 MB
	Calculating NPV and IRR for uneven input periods (XNPV and XIRR)	2:27	3.0 MB
9. Forecasting Future Growth		07:30
	Projecting future results using the Forecast function	2:09	3.0 MB
	Performing quick forecasts using the Fill handle	2:57	4.0 MB
	Adding a trendline to a chart	2:24	3.0 MB
10. Determining Amortization and Depreciation Schedules		22:28
	Introducing amortization	2:20	3.0 MB
	Calculating payments on a fully amortized loan	2:21	3.0 MB
	Calculating payments on a partially amortized loan (balloon payments)	2:04	3.0 MB
	Calculating interest and principal components of loan repayments	5:32	7.0 MB
	Introducing depreciation	2:01	3.0 MB
	Calculating straight line depreciation	1:30	2.0 MB
	Calculating declining balance depreciation	3:24	4.0 MB
	Calculating double declining balance depreciation	3:16	4.0 MB
11. Analyzing Bond Investments		09:34
	Introducing bonds and bond terminology	1:37	2.0 MB
	Calculating a bond's yield	2:15	3.0 MB
	Calculating the value of zero coupon bonds	3:18	4.0 MB
	Pricing bonds to be offered to investors	2:24	3.0 MB
Conclusion		00:23
	Goodbye	0:23	0.4 MB