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

1 Expert Approved Answer
Step: 1 Unlock

Answer Solution Month 1 2 3 4 5 6 7 8 9 10 11 12 Revenue 1457449 760646 861141 91754... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!