Lynda.com.Microsoft.Excel.2007.Financial.Analysis

Lynda Microsoft Excel 2007 Financial Analysis

种子大小：235.81 MB

收录时间：2009-08-27

链接操作：点赞0 dmca/举报

磁力链接：

磁力链接磁力资源磁力引擎网盘资源影视资源云盘资源磁力狗狗免费小说美女图片

文件列表：53File

00. Introduction00 01. Welcome.mov17.16 MB
03. Analyzing Financial Statements03 01. Reading a corporate financial statement.mov13.68 MB
01. Designing a Financial Worksheet01 02. Avoiding common mistakes.mov10.03 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables02 02. Creating a Pivot Table from table data.mov8.18 MB
03. Analyzing Financial Statements03 02. Introducing common-sizing strategies for analyzing financial statements.mov7.75 MB
10. Determining Amortization and Depreciation Schedules10 04. Calculating interest and principal components of loan repayments.mov7.5 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables02 06. Tracking cash flow using a Pivot Chart.mov6.9 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables02 05. Adding Pivot Table columns to enhance data analysis.mov6.65 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables02 04. Filtering a Pivot Table.mov6.61 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables02 01. Tracking income and expenses using an Excel table.mov6.55 MB
03. Analyzing Financial Statements03 03. Creating common-sized income statements.mov6.11 MB
04. Calculating Profitability Ratios04 03. Calculating gross profit margin and net profit margin.mov5.97 MB
11. Analyzing Bond Investments11 03. Calculating the value of zero coupon bonds.mov5.89 MB
03. Analyzing Financial Statements03 05. Calculating percentage changes in financial statements.mov5.49 MB
06. Calculating Leverage Ratios06 02. Calculating the debt ratio.mov5.44 MB
03. Analyzing Financial Statements03 04. Creating common-sized balance sheets.mov5.31 MB
01. Designing a Financial Worksheet01 03. Tracing formula precedents and dependents.mov5.22 MB
01. Designing a Financial Worksheet01 04. Evaluating Excel formulas step by step.mov5.01 MB
07. Calculating the Effect of Interest Rates on Loan Repayment07 03. Calculating the number of days between events.mov4.99 MB
04. Calculating Profitability Ratios04 02. Calculating return on equity and return on assets.mov4.84 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables02 03. Pivoting a Pivot Table.mov4.82 MB
07. Calculating the Effect of Interest Rates on Loan Repayment07 01. Calculating simple interest and compound interest.mov4.28 MB
10. Determining Amortization and Depreciation Schedules10 08. Calculating double declining balance depreciation.mov4.22 MB
11. Analyzing Bond Investments11 04. Pricing bonds to be offered to investors.mov4.21 MB
07. Calculating the Effect of Interest Rates on Loan Repayment07 02. Applying nominal versus effective interest rates (APR versus APY).mov4.14 MB
09. Forecasting Future Growth09 02. Performing quick forecasts using the Fill handle.mov4.13 MB
08. Determining Future Cash Flows08 01. Computing the future value of an investment.mov4.06 MB
11. Analyzing Bond Investments11 02. Calculating a bonds yield.mov3.92 MB
01. Designing a Financial Worksheet01 01. Separating inputs and formulas.mov3.83 MB
09. Forecasting Future Growth09 03. Adding a trendline to a chart.mov3.54 MB
05. Calculating Liquidity and Activity Ratios05 02. Calculating the average collection period.mov3.44 MB
08. Determining Future Cash Flows08 03. Calculating net present value.mov3.35 MB
04. Calculating Profitability Ratios04 01. Calculating earnings per share.mov3.23 MB
06. Calculating Leverage Ratios06 03. Calculating the times interest earned ratio.mov3.21 MB
08. Determining Future Cash Flows08 04. Calculating internal rate of return.mov2.99 MB
08. Determining Future Cash Flows08 02. Calculating present value.mov2.86 MB
05. Calculating Liquidity and Activity Ratios05 03. Calculating inventory turnover.mov2.8 MB
10. Determining Amortization and Depreciation Schedules10 01. Introducing amortization.mov2.78 MB
10. Determining Amortization and Depreciation Schedules10 07. Calculating declining balance depreciation.mov2.72 MB
09. Forecasting Future Growth09 01. Projecting future results using the Forecast function.mov2.57 MB
10. Determining Amortization and Depreciation Schedules10 03. Calculating payments on a partially amortized loan (balloon payments).mov2.56 MB
06. Calculating Leverage Ratios06 01. Calculating the equity ratio.mov2.47 MB
10. Determining Amortization and Depreciation Schedules10 05. Introducing depreciation.mov2.44 MB
05. Calculating Liquidity and Activity Ratios05 01. Calculating the current ratio and quick ratio.mov2.37 MB
08. Determining Future Cash Flows08 05. Calculating NPV and IRR for uneven input periods (XNPV and XIRR).mov2.03 MB
10. Determining Amortization and Depreciation Schedules10 06. Calculating straight line depreciation.mov2.02 MB
11. Analyzing Bond Investments11 01. Introducing bonds and bond terminology.mov1.87 MB
10. Determining Amortization and Depreciation Schedules10 02. Calculating payments on a fully amortized loan.mov1.79 MB
Exercise FilesEx_Files_Excel07_Fin_Ana.zip536.5 KB
12. Conclusion12 01. Goodbye.mov515.05 KB