Lynda.com.Microsoft.Excel.2007.Financial.Analysis
LyndaMicrosoftExcel2007FinancialAnalysis
种子大小:235.81 MB
收录时间:2009-08-27
磁力链接:
资源下载:磁力链接 磁力资源 蜘蛛资源 磁力引擎 网盘资源 影视资源 云盘资源 免费小说 美女图片
文件列表: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