17 Aug Financial Data Analysis and Report

Financial Data Analysis and Report

The project is to create a financial analysis report examining this person’s 2017 and 2018 bank statements to find out if the person was legible to pay for an invoice of $60,000.00 by examining their expenses to get an overview of how they spent their money. Then looking deeper into the withdrawals that don’t have an explanation (unclassified withdrawals); and also the transfers that don’t have explanation. The unexplainable withdrawals and transfers will give us an indication of the money that left the account without an explanation raising the question; was this person able to pay the $60,000.00 invoice but purposely withdrew money from their account to move it possibly to other account.

Attached is an excel file with data of 2017 and 2018 transactions. The first tab “Data” has all the data.

Second tab is the “Net amount summary” pivot table. This summary details all the net expenses amount per year/month.

1. Analyze the net expenses amount to find out an overview of the person’s spendings for 2017 and 2018. This will be the first part of the report. Analyzing an overview of the person’s inflow and outflow for these two years. Create pivot charts analysis of this person’s inflow and outflow for the two years and in a word document explain your findings.

The Fourth tab of the excel sheet has the “Withdrawals” pivot table. These are ATM/Bank withdrawals for 2017 and 2018.

2. Analyze the withdrawals the person made in 2017 and 2018. These withdrawals are suspicious withdrawals with no explanation, so we need to ping them. Find the total average withdrawals per month; total average withdrawals per year and create pivot charts representation of this data. Just as before, create pivot charts analysis of the withdrawals in the excel sheet and then in the word document, explain your findings.

The fifth tab of the excel sheet has the “transfers” pivot table. These are suspicion transfer that left the account in 2017 and 2018 with no explanation.

3. Analyze the transfer the person made in 2017 and 2018. These transfers are suspicious transfers with no explanation, so we need to ping them. Find the total average transfers per month; total average transfers per year and create pivot charts representation of this data. Just as before, create pivot charts analysis of the transfers in the excel sheet and then in the word document, explain your findings. Separate the “Cheque” transfers from the “VIREMENT INTERNET” transfers for this analysis.

Make sure all analysis is done using excel pivot charts in the same excel file so data can be updated as we go. Pivot chart must have clear labels; and be as detailed as possible. The second portion is to create a word document report of all your findings. The report must contain an introduction section, methods section with subsection of data and exploration analysis; a results section where you put in your pivot charts and explain their analysis and meaning, and finally a conclusion section where you again mention of all the unexplained withdrawals; all the unexplained transfers and how all these outflows need to provide further information because the money leaving the account could have been used to settle the $60,000 invoice.