589689.xyz

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

  • 收录时间:2018-03-19 13:05:02
  • 文件大小:236MB
  • 下载次数:63
  • 最近下载:2020-08-26 08:10:26
  • 磁力链接:
立即下载 复制链接

文件列表

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