种子简介

种子名称： Lynda.com.Microsoft.Excel.2007.Financial.Analysis
文件类型： 视频
文件数目： 51个文件
文件大小： 235.29 MB
收录时间： 2017-10-4 00:33
已经下载： 3次
资源热度： 237
最近下载： 2024-12-25 20:22

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:91c593f2d2bdfae7e699d284cb327022cdeea939&dn=Lynda.com.Microsoft.Excel.2007.Financial.Analysis 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

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

00. Introduction/00 01. Welcome.mov17.16MB

00. Introduction/00 02. Using the exercise files.mov503.17KB

00. Introduction/00 03. Disclaimer.mov375.72KB

01. Designing a Financial Worksheet/01 02. Avoiding common mistakes.mov10.03MB

01. Designing a Financial Worksheet/01 03. Tracing formula precedents and dependents.mov5.22MB

01. Designing a Financial Worksheet/01 04. Evaluating Excel formulas step by step.mov5.01MB

01. Designing a Financial Worksheet/01 01. Separating inputs and formulas.mov3.83MB

02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 02. Creating a Pivot Table from table data.mov8.18MB

02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 06. Tracking cash flow using a Pivot Chart.mov6.9MB

02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 05. Adding Pivot Table columns to enhance data analysis.mov6.65MB

02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 04. Filtering a Pivot Table.mov6.61MB

02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 01. Tracking income and expenses using an Excel table.mov6.55MB

02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 03. Pivoting a Pivot Table.mov4.82MB

03. Analyzing Financial Statements/03 01. Reading a corporate financial statement.mov13.68MB

03. Analyzing Financial Statements/03 02. Introducing common-sizing strategies for analyzing financial statements.mov7.75MB

03. Analyzing Financial Statements/03 03. Creating common-sized income statements.mov6.11MB

03. Analyzing Financial Statements/03 05. Calculating percentage changes in financial statements.mov5.49MB

03. Analyzing Financial Statements/03 04. Creating common-sized balance sheets.mov5.31MB

04. Calculating Profitability Ratios/04 03. Calculating gross profit margin and net profit margin.mov5.97MB

04. Calculating Profitability Ratios/04 02. Calculating return on equity and return on assets.mov4.84MB

04. Calculating Profitability Ratios/04 01. Calculating earnings per share.mov3.23MB

05. Calculating Liquidity and Activity Ratios/05 02. Calculating the average collection period.mov3.44MB

05. Calculating Liquidity and Activity Ratios/05 03. Calculating inventory turnover.mov2.8MB

05. Calculating Liquidity and Activity Ratios/05 01. Calculating the current ratio and quick ratio.mov2.37MB

06. Calculating Leverage Ratios/06 02. Calculating the debt ratio.mov5.44MB

06. Calculating Leverage Ratios/06 03. Calculating the times interest earned ratio.mov3.21MB

06. Calculating Leverage Ratios/06 01. Calculating the equity ratio.mov2.47MB

07. Calculating the Effect of Interest Rates on Loan Repayment/07 03. Calculating the number of days between events.mov4.99MB

07. Calculating the Effect of Interest Rates on Loan Repayment/07 01. Calculating simple interest and compound interest.mov4.28MB

07. Calculating the Effect of Interest Rates on Loan Repayment/07 02. Applying nominal versus effective interest rates (APR versus APY).mov4.14MB

08. Determining Future Cash Flows/08 01. Computing the future value of an investment.mov4.06MB

08. Determining Future Cash Flows/08 03. Calculating net present value.mov3.35MB

08. Determining Future Cash Flows/08 04. Calculating internal rate of return.mov2.99MB

08. Determining Future Cash Flows/08 02. Calculating present value.mov2.86MB

08. Determining Future Cash Flows/08 05. Calculating NPV and IRR for uneven input periods (XNPV and XIRR).mov2.03MB

09. Forecasting Future Growth/09 02. Performing quick forecasts using the Fill handle.mov4.13MB

09. Forecasting Future Growth/09 03. Adding a trendline to a chart.mov3.54MB

09. Forecasting Future Growth/09 01. Projecting future results using the Forecast function.mov2.57MB

10. Determining Amortization and Depreciation Schedules/10 04. Calculating interest and principal components of loan repayments.mov7.5MB

10. Determining Amortization and Depreciation Schedules/10 08. Calculating double declining balance depreciation.mov4.22MB

10. Determining Amortization and Depreciation Schedules/10 01. Introducing amortization.mov2.78MB

10. Determining Amortization and Depreciation Schedules/10 07. Calculating declining balance depreciation.mov2.72MB

10. Determining Amortization and Depreciation Schedules/10 03. Calculating payments on a partially amortized loan (balloon payments).mov2.56MB

10. Determining Amortization and Depreciation Schedules/10 05. Introducing depreciation.mov2.44MB

10. Determining Amortization and Depreciation Schedules/10 06. Calculating straight line depreciation.mov2.02MB

10. Determining Amortization and Depreciation Schedules/10 02. Calculating payments on a fully amortized loan.mov1.79MB

11. Analyzing Bond Investments/11 03. Calculating the value of zero coupon bonds.mov5.89MB

11. Analyzing Bond Investments/11 04. Pricing bonds to be offered to investors.mov4.21MB

11. Analyzing Bond Investments/11 02. Calculating a bonds yield.mov3.92MB

11. Analyzing Bond Investments/11 01. Introducing bonds and bond terminology.mov1.87MB

12. Conclusion/12 01. Goodbye.mov515.05KB