(in Polish) Microsoft Excel w pracy finansisty-praktyczne przykłady zastosowań 2400-INTER-MEPR-OG

The scope of the course includes financial mathematics (time value of money, studying the attractiveness of bank deposits, conducting credit analysis), financial evaluation of investment projects, analysis of stock market data (valuation of stocks and bonds), creation of effective investment portfolios, evaluation and forecasting of returns on investment portfolios.
The course MS Excel in the work of a financier, is designed for people who want to learn, or systematize the knowledge of financial models used in business. It is also a course for people who work a lot in Excel and want to learn about financial applications used every day in the work of financiers, as well as those less familiar Excel tools.

Topics of the course
1 Time value of money.
Interest rate, simple and compound interest, comparison of simple and compound interest.

2. Deposits.
Definition and types of deposits, calculation of return on deposit, effective interest rate, taxation of deposits, comparison of cash flows payable at different times.

3 Credit.
Definition and basic features of loans, classification of loans, analysis of loans, repayment and cost of loans, types of loans by method of repayment (loan with fixed installment, loan with decreasing installment, repayment by sinking fund, current interest payment and repayment of principal in the last installment, comparison of results from four methods, MS Excel functions used to analyze a loan with fixed installments.

4.Evaluation of investment projects.
Payback period, discounted payback period, net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR).

5 Stocks.
Definition and basic characteristics of stocks, stock analysis methods, stock valuation, dividend models.

6. Bonds.
Definition and basic features of bonds, types of bonds, bond valuation, coupon payment dates, accrued interest, yield (YTM), bond risk associated with interest rate changes, average maturity of bonds.

7 Creating efficient investment portfolios.
Risk diversification, return on assets, risk, correlation matrices, variance-covariance matrices, return and variance of a portfolio of two assets, Markowitz model, efficient portfolios - with minimum risk (MVP), for a given rate of return, taking into account risk-free instruments.

8. Portfolio evaluation and return forecasting.
Expected portfolio return, Sharpe's single-asset model, beta coefficient estimation, risk decomposition (systematic and specific), risk measure (Value at Risk), CAPM model, portfolio optimization, portfolio management quality measures (Jensen's, Sharpe's, Treynor's alpha).

Notes:
1. Classes are held in the form of e-learning (full class materials with solutions and pre-prepared instructional videos explaining the issues discussed - no live classes) on the platform: https://elearning.wne.uw.edu.pl.

2 It is possible to implement the courses "Microsoft Excel in statistical and business applications" and "Microsoft Excel in the work of a financier-practical examples of applications" in one semester. The courses will be implemented one after the other - Excel in statistical and business applications until mid-November (6 blocks of 5 hours each), and the course "Excel in the work of a financier" from mid-November (8 blocks of 3 hours 45 minutes each).

3 The software version valid for the course is Microsoft Office 2019 or later (language version: Polish, operating system: Windows). The use of an earlier version is possible, but will involve some difficulties. English language version l operating system (e.g. Mac) may involve some difficulties (different Ribbon design, different operation of some Excel tools, different keyboard shortcuts). The University of Warsaw does not provide participants with the necessary computer hardware or software.