Portfolio - Khalid Hussain

Excel Project

Financial Statement Modeling

Domain/Function: Model Structuring, Data Cleaning, Data Analysis, Financial Calculation

Created a financial statement model to project income, balance sheet, and cash flow over five years, incorporating historical data and key assumptions for accurate forecasting.

Summarized revenues and expenses, company's assets, liabilities, and equity and details of cash inflows and outflows.

Used charts and graphs to visually represent data trends, comparisons, and metrics, aiding quick insights into performance and decision-making.

Project Details

This project involved developing a comprehensive financial statement model to forecast a company's financial performance over the next five years. The model includes projected income statements, balance sheets, and cash flow statements, integrating historical data and key assumptions such as revenue growth rates, operating expenses, and capital expenditures.
The model provided insights into profitability, liquidity, and overall financial health, facilitating informed decision-making for stakeholders. Assumptions were documented and to enhance understanding, charts and graphs were used to visualize key metrics such as revenue trends, profitability margins, and cash flow projections.

PowerBI Project

Performance Analysis

Domain/Function: Data Modeling, Power Query, Dax Measures

Building a condensed dynamic performance report that utilizes measures and calculated column, also bringing in some conditional formatting, visual design.

Creating data structures and relationships, helping to organize and manage data effectively.

Performance report that displays insights and key metrics, enabling informed decision-making.

Project Details

This project focused on performance analysis of a plant using Power BI to identify potential growth areas. The process begins by importing data from Excel into Power Query, where necessary transformations and adjustments are made, including the creation of virtual tables for an optimized data model.
Necessary DAX measures and calculated columns were developed to derive key performance indicators. The visual layout was designed to clearly show the insights, using color changes to highlight important data points.
Report was reviewed to make sure it meets user needs, allowing easy navigation and clear insights for decision-making. This analysis aims to improve performance and find areas for growth.

PowerBI Project

Data Professional Survey Analysis

Domain/Function: Power Query, Dax Measures, Conditional column

Project analyzes a survey of data professionals to understand trends, skills, and job satisfaction within the industry. Examined responses related to job roles, tools used, and challenges faced, analysis aims to identify key skills in demand and areas for professional development.

Use of power Query to simplifies data import, transformation, and preparation for analysis.

Dashboard was built to provide valuable insights needed for decision makers.

Project Details

Project analyzes a survey of 630 data professionals from various countries to uncover key insights that inform best practices and trends in the industry. The survey aims to gather information on average salary by job title, average age, satisfaction with salary, work-life balance, salary by gender, favorite programming languages, and in-demand skills.
Data was imported from Excel into Power Query, where necessary adjustments and transformations are made, including the creation of calculated columns to enhance the dataset. Dashboard was built to meet end-user requirements.
Analysis will help organizations understand industry standards, improve employee satisfaction, and identify essential skills for future hiring. By visualizing the data effectively, the dashboard serves as a valuable tool for decision-makers in the data profession.

Excel Project

DCF Valuation Model

Domain/Function: DCF Valuation, Enterprise Valuation, Equity Valuation, Equity Valuation per Share

Estimated the value of an investment based on its expected future cash flows. By discounting cash flows back to their present value using a specific discount rate, built a dashboard which helped investors in making informed decision-making.

Estimates the terminal value of an asset by calculating its future cash flows as a constant growth stream beyond the projection period.

Values the asset by applying industry-specific multiples to its projected cash flows, providing a relative valuation benchmark.

Project Details

DCF Valuation Model Project focused on enterprise and equity valuation through a structured analysis of future cash flows. It begins by calculating unlevered free cash flow (UFCF) over a forecast period, incorporating key metrics like revenue growth and operating expenses.
Using the Weighted Average Cost of Capital (WACC) as the discount rate, we discount these cash flows to their present value. Two primary methods are employed: the DCF perpetuity method for estimating terminal value, utilizing a terminal growth rate, and the DCF multiple method to establish value based on industry multiples.
The final output provides an equity value per share, allowing investors to gauge whether the asset is undervalued or overvalued relative to its market price. This project enhances skills in financial modeling and valuation, enabling a robust understanding of intrinsic value assessment in investment decision-making.

Hello, I am

Khalid Hussain

2

2

About

Key

My

Financial Statement Modeling

Performance Analysis

Data Professional Survey Analysis

DCF Valuation Model

Awards

Contact Me

Email

Github

Linkedin

Call

Khalid Hussain

Download Resume