Lynda com Microsoft Excel 2007 Financial Analysis | 91C593F2D2BDFAE7E699D284CB327022CDEEA939

Lynda com Microsoft Excel 2007 Financial Analysis

Name	Lynda.com.Microsoft.Excel.2007.Financial.Analysis	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	247.3 MB
Total Files	53
Hash	91C593F2D2BDFAE7E699D284CB327022CDEEA939

/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 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
01 01. Separating inputs and formulas.mov	4.0 MB
/02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/
02 02. Creating a Pivot Table from table data.mov	8.6 MB
02 06. Tracking cash flow using a Pivot Chart.mov	7.2 MB
02 05. Adding Pivot Table columns to enhance data analysis.mov	7.0 MB
02 04. Filtering a Pivot Table.mov	6.9 MB
02 01. Tracking income and expenses using an Excel table.mov	6.9 MB
02 03. Pivoting a Pivot Table.mov	5.1 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 05. Calculating percentage changes in financial statements.mov	5.8 MB
03 04. Creating common-sized balance sheets.mov	5.6 MB
/04. Calculating Profitability Ratios/
04 03. Calculating gross profit margin and net profit margin.mov	6.3 MB
04 02. Calculating return on equity and return on assets.mov	5.1 MB
04 01. Calculating earnings per share.mov	3.4 MB
/05. Calculating Liquidity and Activity Ratios/
05 02. Calculating the average collection period.mov	3.6 MB
05 03. Calculating inventory turnover.mov	2.9 MB
05 01. Calculating the current ratio and quick ratio.mov	2.5 MB
/06. Calculating Leverage Ratios/
06 02. Calculating the debt ratio.mov	5.7 MB
06 03. Calculating the times interest earned ratio.mov	3.4 MB
06 01. Calculating the equity ratio.mov	2.6 MB
/07. Calculating the Effect of Interest Rates on Loan Repayment/
07 03. Calculating the number of days between events.mov	5.2 MB
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
/08. Determining Future Cash Flows/
08 01. Computing the future value of an investment.mov	4.3 MB
08 03. Calculating net present value.mov	3.5 MB
08 04. Calculating internal rate of return.mov	3.1 MB
08 02. Calculating present value.mov	3.0 MB
08 05. Calculating NPV and IRR for uneven input periods (XNPV and XIRR).mov	2.1 MB
/09. Forecasting Future Growth/
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
09 01. Projecting future results using the Forecast function.mov	2.7 MB
/10. Determining Amortization and Depreciation Schedules/
10 04. Calculating interest and principal components of loan repayments.mov	7.9 MB
10 08. Calculating double declining balance depreciation.mov	4.4 MB
10 01. Introducing amortization.mov	2.9 MB
10 07. Calculating declining balance depreciation.mov	2.8 MB
10 03. Calculating payments on a partially amortized loan (balloon payments).mov	2.7 MB
10 05. Introducing depreciation.mov	2.6 MB
10 06. Calculating straight line depreciation.mov	2.1 MB
10 02. Calculating payments on a fully amortized loan.mov	1.9 MB
/11. Analyzing Bond Investments/
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
11 02. Calculating a bonds yield.mov	4.1 MB
11 01. Introducing bonds and bond terminology.mov	2.0 MB
/12. Conclusion/
12 01. Goodbye.mov	527.4 KB
/Exercise Files/
Ex_Files_Excel07_Fin_Ana.zip	549.4 KB
/
Torrent downloaded from Demonoid.com.txt	0.0 KB
Total files 53