Presentation: Excel Formulas for Financial Data Analysis

This presentation focuses on the application of Excel formulas for financial data analysis. It covers various formulas, including those for calculating dates, counting business instances, identifying high/low income, computing tax and net income, calculating total and average net income, determining highest and lowest net income, and using SUMIF and AVERAGEIF functions. The presentation demonstrates how these formulas are used to analyze a dataset, providing practical examples and calculations. It highlights the significance of Excel formulas in simplifying data analysis and making informed decisions. The assignment is a presentation that details how to use Excel formulas to analyze financial data effectively.

Topic
ANALYSIS OF FUNCTIONS APPLIED EXCEL SHEET

INTRODUCTION
The power point presentation demonstrate information about different types of excel
formulas and their application for given data set. Basically, there are a range of
formulas in excel which reduces complexity of data set and gives outcome by just
one click.

Formula to present date in excel
The date is presented in excel sheet by applying a formula which is as:
=TODAY()

Formula of counting number of business
In order to find out number of business, there is a formula which is as:
=COUNT()

High/Low income formula
In order to measure lower and higher variable from a data set, this formula is
suitable:
=IF(B4>200000,”High”,”Low”)

Formula to compute tax and net income
In the excel sheet net income and tax values are computed by applying below
mentioned formulas:
For tax=B4*21% and For net income=B4-E4
Tax formula: Net income formula:

Formula for total and average net income
In the excel sheet values of total net income and average net income has been
computed by applying these formulas:
For total net income=SUM(F4:F9) and For average net income =AVERAGE(F4:F9)
Total net income

CONTINUE
Average net income formula:

Formula for highest and lowest
net income
In the excel sheet highest and lowest net income are computed by
applying below mentioned formulas:
For highest net income=MAX(F4:F9) and For Lowest net income=
income=MIN(F4:F9)
Highest net income Lowest net
income

Formula for total net income of rank 2
The value of total net income has been computed by applying this formula:
=SUMIF(C4:C9,F4:F9)

Formula for Average Net Income of rank
1
The value of average net income of rank 1 has been computed by applying this
formula:
=AVERAGEIF(C4:C9,1,F4:F9)

Formula for count of net income>500k
and >500k
The value of net income>500k and >500k has been computed by applying this
formula:
Count of Net Income >£500k: =COUNTIF(F4:F9,”>500000”)