BYU Student Author: @Carter_Lee
Reviewers: @Trent_Barlow, @Kyle_Nilsen
Estimated Time to Solve: 30 Minutes
We provide the solution to this challenge using:
- Python
Need a program? Click here.
Overview
Welcome to the Logee Company Financial Analysis Automation Challenge! Logee Company is a medium-sized business operating in the logging industry. They deal with the harvesting and processing of timber products. As an accountant for Logee Company, you are responsible for analyzing financial statements to gain insights into the company’s performance. In order to streamline this process, you are tasked to create a Python script that can automate the company’s financial data analysis. The script needs to read financial data from a CSV file, perform various analyses on the data, and generate insightful visualizations to aid in management’s decision-making.
Instructions
- The provided CSV file contains financial data for Logee Company, including the date, revenue, expenses, and profit for each month. Your Python script should be able to process this data and perform the following analyses:
- Calculate the profit, profit margin, and net profit for each transaction and summarize these by month.
- Create and export a new CSV file containing the monthly summary above which should include gross profit, profit margin and net profit
- Find the most profitable customer by creating a dictionary of each customer and total profit, with customer as the key and profit as the value
- Create and export a new CSV file containing the total profit of each customer
- Identify trends and patterns in revenue, expenses, and profit over time.
- Visualize the financial data by using Matplotlib to create scatterplot charts and graphs. Set the x-axis to be the date and y-axis to be the revenue, expenses, or profit.
Data Files
Suggestions and Hints
- Gross Profit: Revenue - Expenses
- Profit Margin: (Profit / Revenue) * 100
- Generate visualizations to present the following insights:
- Monthly Revenue, Expenses, and Profit over time (line chart)
- Profit Margin trend over time (line chart)
- Monthly Gross Profit distribution (bar chart)
- Create a Dictionary for each new customer add the profit to the value
Solution
Challenge222_Solution.rtf
Solution Video: Challenge 222|Python – Financial Wizardry
