-552x564.jpg "Analysis of financial data in Excel")
| The
course consists of three parts. First, we will learn how to calculate
interest on deposits and loan payments and practice credit analysis. Then we will study approaches for solving investment problems: discounting, amortization, excess, internal rate of return and investment valuation. We will conduct an investment analysis. Finally, we will touch on a little bit of statistical apparatus and learn how to accurately predict the return on certain investments and build trends. Microsoft Excel version 2010 or higher will be required for the course. Who this course is for: Financial consultants and analysts Business analysts who work with acquiring and parsing data Managers and executives who use financial analysis in their day-to-day work Accountants and auditors automating calculations What you will learn Calculating simple and compound interest Calculation of differentiated and annuity payments Overpayment and loan repayment Calculation of amortization Internal rate of return and present value of money Analyzing Stocks and Bonds Probabilities and Distributions Persentiles and confidence intervals Linear and nonlinear forecast Confidence interval for forecasting Financial Market Valuation Evaluation of investment strategies Course content 4 sections - 30 lectures - Total duration 3 h 24 min
|