You are provided with a csv file containing annual financial data for firms. Three important columns: fyear = fiscal year; tic = firm ID, ni = net income.

by | Sep 23, 2021 | Uncategorized | 0 comments

You are provided with a csv file containing annual financial data for firms. Three
important columns: fyear = fiscal year; tic = firm ID, ni = net income. Using this information,
you shall answer the following questions and the other requirements that follow the questions:
1. Overall, what is the effect of the crisis in financial terms? You can answer this by
calculating the percent by which average annual net income decreases for firms during
crisis years (2007-8) compared to pre-crisis years (2004-6).
2. What are the 10 firms with the largest and smallest changes respectively? List results for
absolute change and percent change separately.
3. How long does it take for firms to recover from the crisis? You can follow the following
algorithm. For each firm in the sample, identify the highest Net Income in the pre-crisis
period. Focusing now on the post-crisis period of 2009-14, identify when this highest
level was breached and set the variable ‘YearsRecover’ equal to the difference between
year level breached and 2008. If the highest level was not breached, set ‘YearsRecover’
to NA. Summarize this information in a table.
Show key steps in your work and be sure to demonstrate proficiency in dplyr or data.table or
both. Also, produce a data-supported overall conclusion concerning the effect of the crisis on
corporate profits.
Use Markdown skills to format the report appropriately. Recall that a formal report has
components such as introduction, body, and conclusion, and is labelled and formatted

Our Guarantees

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university, or professional, and we will assign a writer who has a respective degree.


Professional certified writers

We have hired a team of professionals who provide expert academic help. Most of them are native speakers and PhD holders who are able to take care of any assignment you need help with.


Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support team.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all sources and in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24/7 and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.


About us

We are a team of like-minded people who established to help students all over the world. It all began a few years ago when we, as students, helped each other complete our own assignments. Shortly after, we discovered that other students need help too: that is when Wileyscholars was created. It is an online service that provides help with academic assignments all over the world. Our main aim is to help hundreds of students pass their tests and home assignments by giving advice and helping to get to know the subject better.



Let’s Start a Conversation