Computer Applications in

Finance

### Class Files

Importing Text                               PSX data | Emails

Lecture 8 : Capital Budgeting
Loan Amortization                        Lecture | Excercise  2

Lecture 9 : Time Value of Money                   Lecture | Exercises

Lecture 9 : Time value of Money II                Lecture

Lecture 11 : Income Tax with IF                     Excercise

Lecture 13 : Cell Protection                           Read

Lecture 15: Conditional Formatting  2           Read

Lecture 16 : Depreciation                              Lecture

Lecture 17: If Function                                  Exercise

Lecture 18: Vlookup Function     Part 2 | Part 3 | YouTube Video

Lecture 19 Graphs and Charts                     Exercise

Lecture 21 Pivot Tables                                Exercise

Lecture 22 : Macros                                     The Three pointsVideo 1 | Video 2 | Video 3 | Day1 Files

Lecture 23 : Macros                                     Day 2 | YouTube Video

Lecture 24: Macros                                      Visual Basic First Example

Lecture 25: Macros                                      Cheque Printing | YouTube Video

Lecture 26 Macros SD                                  YouTube Video | List of Macros for Final Exam

Lecture 27 : Solver Function for Capital Budgeting [Study Material ] [Coffee Shop Example.xls ]

Lecture 28: Find cost of equity with Excel Solver | Excel File | YouTube Video

Lecture 25: Panel Data Analysis [State 9] [Panel data slides ] [panel data example ] [ Panel Data
Lecture  26: Bonds and Stock Valuation

Ĉ
Attaullah Shah,
Feb 14, 2018, 12:09 AM
Ĉ
Attaullah Shah,
Feb 21, 2018, 12:15 AM
Ĉ
Attaullah Shah,
Feb 22, 2018, 12:29 AM
Ĉ
Attaullah Shah,
Sep 19, 2013, 8:13 AM
Ĉ
Beta.xlsx
(11k)
Attaullah Shah,
Nov 8, 2013, 6:38 AM
Ĉ
Attaullah Shah,
Apr 29, 2018, 10:22 PM
Ĉ
Attaullah Shah,
Mar 14, 2018, 1:36 AM
Ĉ
Attaullah Shah,
Apr 11, 2018, 11:13 AM
Ĉ
Attaullah Shah,
Apr 24, 2018, 12:00 AM
Ĉ
Attaullah Shah,
Apr 23, 2018, 11:55 PM
Ĉ
Attaullah Shah,
Sep 27, 2013, 8:07 AM
Ĉ
Attaullah Shah,
May 9, 2018, 11:52 PM
Ĉ
Attaullah Shah,
Sep 20, 2013, 8:11 AM
ĉ
Attaullah Shah,
Feb 28, 2018, 11:05 PM
ć
Attaullah Shah,
Sep 19, 2013, 8:12 AM
ċ
Attaullah Shah,
Feb 27, 2018, 1:28 AM
ċ
Attaullah Shah,
Feb 11, 2016, 5:52 AM
Ĉ
Attaullah Shah,
Mar 17, 2016, 5:23 AM
Ĉ
Attaullah Shah,
May 14, 2018, 11:25 PM
Ĉ
Attaullah Shah,
Apr 4, 2015, 1:15 AM
Ĉ
Attaullah Shah,
Apr 8, 2018, 11:49 PM