Lynda com Microsoft Excel 2007 Financial Analysis | C6CCF96A4010DA7E2F976AA8B9B7DC0E44DDAFF4

Lynda com Microsoft Excel 2007 Financial Analysis

Name	Lynda.com.Microsoft.Excel.2007.Financial.Analysis	DOWNLOAD Copy Link
Total Size	247.3 MB
Total Files	52
Hash	C6CCF96A4010DA7E2F976AA8B9B7DC0E44DDAFF4

/00. Introduction/
00 01. Welcome.mov	18.0 MB
00 02. Using the exercise files.mov	515.2 KB
00 03. Disclaimer.mov	384.7 KB
/01. Designing a Financial Worksheet/
01 01. Separating inputs and formulas.mov	4.0 MB
01 02. Avoiding common mistakes.mov	10.5 MB
01 03. Tracing formula precedents and dependents.mov	5.5 MB
01 04. Evaluating Excel formulas step by step.mov	5.3 MB
/02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/
02 01. Tracking income and expenses using an Excel table.mov	6.9 MB
02 02. Creating a Pivot Table from table data.mov	8.6 MB
02 03. Pivoting a Pivot Table.mov	5.1 MB
02 04. Filtering a Pivot Table.mov	6.9 MB
02 05. Adding Pivot Table columns to enhance data analysis.mov	7.0 MB
02 06. Tracking cash flow using a Pivot Chart.mov	7.2 MB
/03. Analyzing Financial Statements/
03 01. Reading a corporate financial statement.mov	14.3 MB
03 02. Introducing common-sizing strategies for analyzing financial statements.mov	8.1 MB
03 03. Creating common-sized income statements.mov	6.4 MB
03 04. Creating common-sized balance sheets.mov	5.6 MB
03 05. Calculating percentage changes in financial statements.mov	5.8 MB
/04. Calculating Profitability Ratios/
04 01. Calculating earnings per share.mov	3.4 MB
04 02. Calculating return on equity and return on assets.mov	5.1 MB
04 03. Calculating gross profit margin and net profit margin.mov	6.3 MB
/05. Calculating Liquidity and Activity Ratios/
05 01. Calculating the current ratio and quick ratio.mov	2.5 MB
05 02. Calculating the average collection period.mov	3.6 MB
05 03. Calculating inventory turnover.mov	2.9 MB
/06. Calculating Leverage Ratios/
06 01. Calculating the equity ratio.mov	2.6 MB
06 02. Calculating the debt ratio.mov	5.7 MB
06 03. Calculating the times interest earned ratio.mov	3.4 MB
/07. Calculating the Effect of Interest Rates on Loan Repayment/
07 01. Calculating simple interest and compound interest.mov	4.5 MB
07 02. Applying nominal versus effective interest rates (APR versus APY).mov	4.3 MB
07 03. Calculating the number of days between events.mov	5.2 MB
/08. Determining Future Cash Flows/
08 01. Computing the future value of an investment.mov	4.3 MB
08 02. Calculating present value.mov	3.0 MB
08 03. Calculating net present value.mov	3.5 MB
08 04. Calculating internal rate of return.mov	3.1 MB
08 05. Calculating NPV and IRR for uneven input periods (XNPV and XIRR).mov	2.1 MB
/09. Forecasting Future Growth/
09 01. Projecting future results using the Forecast function.mov	2.7 MB
09 02. Performing quick forecasts using the Fill handle.mov	4.3 MB
09 03. Adding a trendline to a chart.mov	3.7 MB
/10. Determining Amortization and Depreciation Schedules/
10 01. Introducing amortization.mov	2.9 MB
10 02. Calculating payments on a fully amortized loan.mov	1.9 MB
10 03. Calculating payments on a partially amortized loan (balloon payments).mov	2.7 MB
10 04. Calculating interest and principal components of loan repayments.mov	7.9 MB
10 05. Introducing depreciation.mov	2.6 MB
10 06. Calculating straight line depreciation.mov	2.1 MB
10 07. Calculating declining balance depreciation.mov	2.8 MB
10 08. Calculating double declining balance depreciation.mov	4.4 MB
/11. Analyzing Bond Investments/
11 01. Introducing bonds and bond terminology.mov	2.0 MB
11 02. Calculating a bonds yield.mov	4.1 MB
11 03. Calculating the value of zero coupon bonds.mov	6.2 MB
11 04. Pricing bonds to be offered to investors.mov	4.4 MB
/12. Conclusion/
12 01. Goodbye.mov	527.4 KB
/Exercise Files/
Ex_Files_Excel07_Fin_Ana.zip	549.4 KB
Total files 52