Welcome to your new job as an Analyst with Lexi Holdings, an investment firm with...
90.2K
Verified Solution
Link Copied!
Question
Accounting
Welcome to your new job as an Analyst with Lexi Holdings, an investment firm with a wide range of investment holdings! Your first assignment is to assess RetroSpin. Your new boss, Wally Oliver, hands you a multi-year Income Statement (Appendix A1) and multi-year Balance Sheet (Appendix A2) for RetroSpin Records. RetroSpin is record store, wholly owned by Lexi Holdings, catering to music enthusiasts who prefer vinal records over digital music or other music formats. RetroSpin brought on a new CEO in Jan 1, 2015. Your boss asks you to assess whether or not RetroSpin is doing well under the new CEO. Your job is to calculate and interpret important financial ratios and to make comments on how things have changed since the new CEO came on board. You are also required to compare RetroSpin to others in the industry. Appendix A3 contains industry average information.
Please use the information in Appendix A1 to A3 to calculate the following ratios:
Current ratio
Account Receivable ratio (or days receivable)
Accounts Payable ratio (or days payable)
Debt ratio
Gross Profit margin
Operating Profit margin
Net Profit margin
Return on Assets
Return on Equity
Calculate each of the ratios above for 2014, 2015 and 2016. Interpret your calculations: what does this information mean? How is the company doing under the new CEO? (You should compare things before and after the CEO came on board). How is the company doing relative to the industry?
Appendix A1:
RetroSpin Records
Comparative Income Statement ($M)
For the Years Ended Dec 31, 2013 to 2016
2013
2014
2015
2016
Sales
US$ 75,00
US$ 78,75
US$ 86,63
US$ 95,29
Cost of Goods Sold
US$ 41,94
US$ 44,03
US$ 46,24
US$ 48,55
Gross Profit
US$ 33,06
US$ 34,72
US$ 40,39
US$ 46,74
Selling and Administration
US$ 18,75
US$ 17,72
US$ 17,33
US$ 19,06
Depreciation
US$ 1,51
US$ 2,71
US$ 4,31
US$ 4,18
Operating Profit
US$ 12,81
US$ 14,29
US$ 18,76
US$ 23,50
Interest
US$ 1,88
US$ 2,51
US$ 7,10
US$ 4,93
Earnings Before Taxes
US$ 10,92
US$ 11,78
US$ 11,65
US$ 18,57
Taxes
US$ 2,73
US$ 2,95
US$ 2,91
US$ 4,64
Net Income
US$ 8,19
US$ 8,84
US$ 8,74
US$ 13,93
tax rate
25%
25%
25%
25%
1 - tax rate
75%
75%
75%
75%
Net Income + I(1-tax rate)
US$ 9,60
US$ 10,72
US$ 14,07
US$ 17,63
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
