Question
Scenario: You are a data scientist working for a consulting company. one of your colleagues in the audit department have asked you to help them
Scenario: You are a data scientist working for a consulting company. one of your colleagues in the audit department have asked you to help them assess the financial statement of organization X. You have been given two data vectors: monthly income and expenses for the year in question.
income in 12 months (14574.49, 7606.46, 8611.41, 9175.41, 8058.65, 8105.44, 11496.28, 9766.09, 10305.32, 14379.96, 10713.97, 15433.50)
expenses in 12 months (12051.82, 5695.07, 12319.20, 12089.72, 8658.57, 840.20, 3285.73, 5821.12, 6976.93, 16618.61, 10054.37, 3803.96)
Required:
financial metrics:
- profit of each month
- profit after taxes of each month (the tax rate is 30%)
- profit margin for each month - equals profit after tax divided by revenue
- good months - where profit after taxes was higher than the average for the year
- bad months - where the profit after taxes was less than the average of the year
- the best month - where the profit after taxes was maximum for the year
- the worst month - where the profit after taxes was minimal for the year
All results must be presented as vectors. Results for dollar values should be calculated with $0.01
precision, but must be presented in Units of $1,000 (ie 1k) with no decimal points. Results for the benefit
Margin ratio must be presented in units of % with no decimal points. Note: Your colleague has warned
that it is okay for any month's tax to be negative (in accounting terms, negative tax translates to
in a deferred tax asset).
Step by Step Solution
3.45 Rating (152 Votes )
There are 3 Steps involved in it
Step: 1
Answer Solution Month 1 2 3 4 5 6 7 8 9 10 11 12 Revenue 1457449 760646 861141 91754...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started