Download link
File List
-
00. Introduction/00 01. Welcome.mov 17.16 MB
00. Introduction/00 02. Using the exercise files.mov 503.17 KB
00. Introduction/00 03. Disclaimer.mov 375.72 KB
01. Designing a Financial Worksheet/01 01. Separating inputs and formulas.mov 3.83 MB
01. Designing a Financial Worksheet/01 02. Avoiding common mistakes.mov 10.03 MB
01. Designing a Financial Worksheet/01 03. Tracing formula precedents and dependents.mov 5.22 MB
01. Designing a Financial Worksheet/01 04. Evaluating Excel formulas step by step.mov 5.01 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 01. Tracking income and expenses using an Excel table.mov 6.55 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 02. Creating a Pivot Table from table data.mov 8.18 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 03. Pivoting a Pivot Table.mov 4.82 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 04. Filtering a Pivot Table.mov 6.61 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 05. Adding Pivot Table columns to enhance data analysis.mov 6.65 MB
02. Analyzing Cash Flows Using Excel Tables and Pivot Tables/02 06. Tracking cash flow using a Pivot Chart.mov 6.9 MB
03. Analyzing Financial Statements/03 01. Reading a corporate financial statement.mov 13.68 MB
03. Analyzing Financial Statements/03 02. Introducing common-sizing strategies for analyzing financial statements.mov 7.75 MB
03. Analyzing Financial Statements/03 03. Creating common-sized income statements.mov 6.11 MB
03. Analyzing Financial Statements/03 04. Creating common-sized balance sheets.mov 5.31 MB
03. Analyzing Financial Statements/03 05. Calculating percentage changes in financial statements.mov 5.49 MB
04. Calculating Profitability Ratios/04 01. Calculating earnings per share.mov 3.23 MB
04. Calculating Profitability Ratios/04 02. Calculating return on equity and return on assets.mov 4.84 MB
04. Calculating Profitability Ratios/04 03. Calculating gross profit margin and net profit margin.mov 5.97 MB
05. Calculating Liquidity and Activity Ratios/05 01. Calculating the current ratio and quick ratio.mov 2.37 MB
05. Calculating Liquidity and Activity Ratios/05 02. Calculating the average collection period.mov 3.44 MB
05. Calculating Liquidity and Activity Ratios/05 03. Calculating inventory turnover.mov 2.8 MB
06. Calculating Leverage Ratios/06 01. Calculating the equity ratio.mov 2.47 MB
06. Calculating Leverage Ratios/06 02. Calculating the debt ratio.mov 5.44 MB
06. Calculating Leverage Ratios/06 03. Calculating the times interest earned ratio.mov 3.21 MB
07. Calculating the Effect of Interest Rates on Loan Repayment/07 01. Calculating simple interest and compound interest.mov 4.28 MB
07. Calculating the Effect of Interest Rates on Loan Repayment/07 02. Applying nominal versus effective interest rates (APR versus APY).mov 4.14 MB
07. Calculating the Effect of Interest Rates on Loan Repayment/07 03. Calculating the number of days between events.mov 4.99 MB
08. Determining Future Cash Flows/08 01. Computing the future value of an investment.mov 4.06 MB
08. Determining Future Cash Flows/08 02. Calculating present value.mov 2.86 MB
08. Determining Future Cash Flows/08 03. Calculating net present value.mov 3.35 MB
08. Determining Future Cash Flows/08 04. Calculating internal rate of return.mov 2.99 MB
08. Determining Future Cash Flows/08 05. Calculating NPV and IRR for uneven input periods (XNPV and XIRR).mov 2.03 MB
09. Forecasting Future Growth/09 01. Projecting future results using the Forecast function.mov 2.57 MB
09. Forecasting Future Growth/09 02. Performing quick forecasts using the Fill handle.mov 4.13 MB
09. Forecasting Future Growth/09 03. Adding a trendline to a chart.mov 3.54 MB
10. Determining Amortization and Depreciation Schedules/10 01. Introducing amortization.mov 2.78 MB
10. Determining Amortization and Depreciation Schedules/10 02. Calculating payments on a fully amortized loan.mov 1.79 MB
10. Determining Amortization and Depreciation Schedules/10 03. Calculating payments on a partially amortized loan (balloon payments).mov 2.56 MB
10. Determining Amortization and Depreciation Schedules/10 04. Calculating interest and principal components of loan repayments.mov 7.5 MB
10. Determining Amortization and Depreciation Schedules/10 05. Introducing depreciation.mov 2.44 MB
10. Determining Amortization and Depreciation Schedules/10 06. Calculating straight line depreciation.mov 2.02 MB
10. Determining Amortization and Depreciation Schedules/10 07. Calculating declining balance depreciation.mov 2.72 MB
10. Determining Amortization and Depreciation Schedules/10 08. Calculating double declining balance depreciation.mov 4.22 MB
11. Analyzing Bond Investments/11 01. Introducing bonds and bond terminology.mov 1.87 MB
11. Analyzing Bond Investments/11 02. Calculating a bonds yield.mov 3.92 MB
11. Analyzing Bond Investments/11 03. Calculating the value of zero coupon bonds.mov 5.89 MB
11. Analyzing Bond Investments/11 04. Pricing bonds to be offered to investors.mov 4.21 MB
12. Conclusion/12 01. Goodbye.mov 515.05 KB
Exercise Files/Ex_Files_Excel07_Fin_Ana.zip 536.5 KB
Download Info
-
Tips
“Lynda.com.Microsoft.Excel.2007.Financial.Analysis” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.