IAU Evaluation & Forcasting for Aramco Company Excel Table
Description
Requirements:
1- Select a company from Tadawul from non-financial sector with minimum of 4 years of historical data (Yr. 2021 should be the latest year).
2- Forecast the Income statement, Balance Sheet, Cash Flow Statement for the next 3 Years.
3- Complete Common Size Analysis (including forecasted years).
4- Complete Yr. to Yr. Comparative Analysis (including forecasted years).
5- Ratio Analysis (including forecasted years).
6- Firm Valuation (using atleast 2-Valuation Models).
7- Du Pont System of Ratio Analysis (including forecasted years).
8- Calculate the amount of external funding required (Using Sensitivity Analysis for forecasted years).
9- Make sure that Sheet 1 should be used only for data input (rest of the sheets should be linked with Sheet 1).
10- Make your sheets interactive by include Charts and Sparklines (where required).
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."