computer application in finance using excel

Final Project Guidelines: Computer Application in Finance

Purpose:

The student will develop a financial model. The final project is conducted via Microsoft Excel, which allows students to test their knowledge and skills. Each team manages all aspects, including company selection, assumptions, and calculations. The goal of the project is to estimate the valuation of a business and to compare companies to their industry competitors. 

Instructions

· The project will be teamwork, with 2-3 students in each group. Each group will submit only one excel file.

· As part of the course requirements, you will use Microsoft Excel to create your model.

· Each group needs to select its company as early as possible. Please note that two groups cannot have the same company. Click here to write the name of your company.

· Submission will be on Sunday, 30th October 2022.

· This project weighs 20% of your total grades.

Requirements

1- Select a company from Tadawul, excluding financial sectors, with a minimum of four years of historical data ( Yr. 2021 should be the latest year).

* Financial Sectors including Banking Industry, Insurance Industry, and Diversified Financials Industry*

2- Forecast the Income statement, Balance Sheet, and Cash Flow Statement for the next three Years.

3- Complete Common Size Analysis ( including forecasted years).

4- Complete Yr. to Yr. Comparative Analysis ( including forecasted years).

5- Include ratio analysis to help explain how pieces of information relate to one another ( including forecasted years).

6- Calculate the firm value by using at least 2-Valuation Models.

7- Calculate the company's ROE using the Du Pont System ( including forecasted years).

8- Calculate the amount of external funding required ( using sensitivity analysis for forecasted years ).

9- Make sure that you assign one sheet for your input, and the rest of the sheets should be linked to the input sheet.

10- Make your sheets interactive by including Charts and Sparklines ( where required).