Question: You're about halfway through an important job interview, and things seem to be going well. The interviewer has sat back in her chair, and seems

You're about halfway through an important job interview, and things seem to be going well. The interviewer has sat back in her chair, and seems increasingly comfortable talking with you. Then she slides her laptop over to you. Excel is running, and there is a table showing annual growth in profit for their company for the past 5 years:
You're about halfway through an important job interview, and things

a.)The interviewer then says, "And we also give a short Excel proficiency test during interviews like this. I'm going to go grab some coffee. May I get you a cup? Just go ahead and calculate the 1-, 3-, and 5-year average annual growth rates on those figures and I'll be back in a few minutes." Required: Calculate the average annual growth rates in 3 minutes or less.
b.)Assume you calculate the growth rates correctly. The interviewer looks over your work and says, "Great €“ believe it or not, many job applicants can't do that. One more thing €“ looking at those growth rates you calculated, how would you describe the trend in the company's growth?" Required: Give her a concise, accurate answer.

Annual Net Income (thousands) 2006 2007 2008 2009 2010 2011 $49,520 $53,200 $61,875 $72,190 $85,640 $103,127

Step by Step Solution

3.44 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a Heres how the growth rates were calculated And here are the answers in ... 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

Document Format (1 attachment)

Word file Icon

502-B-A-E (1764).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!