Business Mathematics for Finance

سرفصل های دوره

Learn how to use all formulas and functions of Finance in excel i.e. Annuities, EMI, Beta, Std Deviation, Rate, TVM etc.

1. Introduction of Business Mathematics for Finance and Interest Rate Calculations

1. Introduction of Business Mathematics

2. Simple Interest and Compound Interest

3. Days Count Formula in Excel

4. Calculation of Effective Rate in Excel

5. Calculation of Nominal Rate in Excel

2. Understanding of Annuities with the help of real life examples

1. Calculation of FV of Annuities Formula in Excel

2. Calculation of FV Annuities - Case 1

3. Calculation of FV Annuities Case 2

4. Calculation of FV Annuities Case 3

5. Calculation of FV Annuities Case 4

3. Calculation of Rate and Period

1. Introduction of NPER in Excel

2. NPER - Case 1 in Excel

3. Calculation of Rate in Excel

4. Rate Case 1 in Excel

5. Rate Case - 2 in Excel

6. Rate - Case 3 in Excel

7. Rate Case 4 in Excel

8. Rate - Case 5 in Excel

4. Loan Amortization Schedule

1. Introduction of Loan Amortization Schedule in Excel

2. Loan Amortization Schedule Case 1 in Excel

3. Loan Amortization Schedule - Case 2 in Excel

4. Loan Amortization Schedule - Case 3 in Excel

5. Loan Amortization Schedule - Case 4 in Excel

6. Loan Amortization Schedule - Case 5 in Excel

5. Mean, mode & median

1. Introduction of Mean in Excel

2. Mean - Case 1 in Excel

3. Median - Case 1 in Excel

4. Median - Case 2 in Excel

5. Introduction of Mode in Excel

6. Mode - Case 1 in Excel

6. Calculation and Understanding of Risk and Uncertainty

1. Risk and Uncertainty - Standard Deviation

2. Continuity of Risk and Uncertainty

3. Understanding of Financial Risk

4. Case Study on Financial Risk

5. Beta Calculation

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy