Final Exam Take Home Final Shane McClellan

.docx

School

Western Michigan University *

*We aren’t endorsed by this school

Course

6005

Subject

Business

Date

Feb 20, 2024

Type

docx

Pages

3

Uploaded by DeaconSnake481

Report
Memorandum To: Karen Brown, CEO From: Shane McClellan, Accountant Date: October 9, 2023 Subject: Financial Analysis and Recommendations – Pleasanton Studios Objective: To provide Karen Brown with a financial analysis and recommendations to help her make decisions about the company's three divisions. Analysis: Investment in the New Animation Studio The NPV of the new animation studio project is $1,027,269. The IRR of the project is 15%. Since the IRR is greater than the company's cost of capital of 12%, I recommend that the company invest in the new animation studio. Closing the Parks Division If the Parks division is closed, the company's operating income will increase by $1,246,450. However, the company will still have to pay the $1,680,000 mortgage payment on the land and buildings for the park. Therefore, the company's net income will decrease by $433,550 if the Parks division is closed. I recommend that the company close the Parks division. The division has been unprofitable for the past two years and closing it will improve the company's overall profitability. Evaluation of Angela Imanah’s Filed Complaint Streaming Division Manager, Angela Imanah's complaint might come with some validity behind it, especially if the bonus structure inherently favors older divisions or doesn't reward rapid growth. Based off her complaint, there is three areas of concern she asserts, below they are displayed and our evaluation of their validity: -Potential Growth and Performance: The Streaming division has experienced steady growth (20% annually since 2018). If Angela's management has directly contributed to this growth, her complaint about her bonus compared to Joe Freeman's (from the Entertainment division) might be valid. -Bonus Structure: Angela's concern revolves around the bonus payout structure, which seems to favor divisions with older assets (like Entertainment) over newer ones (like Streaming). If the bonus structure is heavily based on asset age or some other factor that inherently disadvantages newer divisions, her complaint is valid. -Asset Acquisition: Angela mentions that the Streaming division's assets were acquired more recently. If the bonus structure is influenced by asset depreciation or some other measure of use, as mentioned, it could inherently disadvantage newer divisions, making Angela's complaint valid. Conclusion I recommend that the company invest in the new animation studio and close the Parks division; it is currently unprofitable and closing it will increase the company's net income by $2,181,287. These decisions will improve the company's overall profitability and long-term success.
Appendices Appendix A: Full Segmented Income Statement The following segmented income statement provided an analyzed summary of this year's company performance, with negative operating income tax calculated for the Parks division: Segmented Income Statement Division Sales COGS Gross Margin Allocated Overhead Selling, Admin, and Marketing Operating Income Tax Expense Divisional Income Entertainment $54,583,52 0 $40,257,310 $14,326,21 0 $1,500,000 $3,259,520 $9,566,690 $2,391,673 $7,175,017 Streaming $30,184,57 0 $22,020,695 $8,163,875 $1,500,000 $944,620 $5,719,255 $1,429,814 $4,289,441 Parks $7,564,270 $3,698,928 $3,865,342 $1,500,000 $231,900 -$997,160 $249,290 -$1,246,450 Overall $92,332,36 0 $65,976,933 $26,355,42 7 $4,500,000 $4,436,040 $14,328,464 $4,070,777 $10,257,687 Appendix B : Below is the determined Return on Investment, Residual Income, and Economic Value Added for each division: Appendix C : NPV Calculation for the New Animation Studio ROI, Residual Income, and EVA by Division Division ROI (%) Residual Income ($M) EVA ($M) Entertainment 32.97 1.14 1.06 Streaming 22.23 0.78 0.73 Parks -23.72 -0.25 -0.31
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help