Financial Decision-Making Using MS Excel

Organizing workshop is a regular initiative of AIUB to strengthen students’ skills and aptitude for learning. On February 19, 2019 Department of Finance successfully organized a workshop on financial decision-making using MS Excel at Annex 3, Room No. 3208. The day-long workshop was conducted by Mr. Mahmood Taseen Chowdhury, Director, Project Management, Development Design Consultants Limited.

This development workshop was designed to demonstrate the various techniques of using MS Excel for financial decision making and enhance the competence of the student of the university in making a more stimulating and effective use of financial software. The session was inaugurated by Professor Dr. Nisar Ahmed; Director of MBA Program with an inspiring welcome speech.

MS Excel software package is regarded as an essential for financial and statistical analysis. It is the most popular and effective spreadsheet tool today. It is user friendly, robust, and packed with excellent features. Keeping its popularity and effectiveness in a workplace in mind, the Department of Finance, AIUB organized a workshop titled ‘Financial Decision-Making using MS Excel’ to help students to learn the following functions:

1. PV, FV, RATE, and NPER to take real life financial planning related decisions.
2. EFFECT & NOMINAL to convert nominal interest rate to effective interest rate and vice versa.
3. Amortization Schedule to understand loan repayment.
4. Data Analysis to calculate descriptive statistics.
5. AVERAGE & STDEV.S to calculate risk and return.
6. CORREL to calculate and interpret correlation coefficient between two data sets.
7. TREND to forecast data using least squares method.
8. Regression Analysis to understand which among the independent variables are related to the dependent variable, and to explore the forms of these relationships.
9. Pivot Table to extract the significance from a large, detailed data set.

A total of seventy-five students participated in the workshop. At the end of the program, Professor Dr. Charles C. Villanueva, Vice President, Academics and Dean Faculty of Business Administration expressed his vote of thanks to the guest speaker and presented with Certificate of Appreciation. The concluding session was further decorated with kind presence of Ms. Farheen Hassan, Director, BBA Program, Mr. Md. Faridul Alam, Head, Department of Accounting and other distinguished faculty members.

The workshop was organized by Mr. Md. Joynal Abedin, Assistant Professor, Department of Finance of FBA. The Department of Finance, Faculty of Business Administration gratefully acknowledges the open-handed support given by AIUB Management to make the event successful.