Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help You are an analyst for Oputent Wealth Management. One of the companles you follow is Metagrobolize Industries. While looking at the company's financials,
please help
You are an analyst for Oputent Wealth Management. One of the companles you follow is Metagrobolize Industries. While looking at the company's financials, you have become concemed with certain aspects of Metagrobolize's defined benefit pension plan. You have enlisted the assistance of your staff to create a Tableau Dashboard depicing trends in pension expense, pension liabilities, and pension assets for the most recent ten years, plus projected amounts of pension liabilities, and pension assets for next year (\$ in miltions). Finnded Statue ar Dancin. Din.. Actual vs Expected Return on Plan Assets Pawing from the data availablo, assess the following: Complete this question by entering your answers in the tabs below. Drawing from the data avallable, assess the following: Complete this question by entering your answers in the tabs below. What was the funded status of Metagrobolize's pension plan in 2021? $105 million Net Pension Liability $413 million Net Pension Liability 5578 million Net Pension Asset. Drawing from the data avaliable, assess the following: Complete this question by entering your answers in the tabs below. How would you describe the trend in the company's funded status? Aeginning in 2020, there is a szable and growing underfunding of the pension obhation The companys pension assets have mantained a somewhat steady growth rate The funded status of the pension obligation has shufed between being underfunded and oveifunded but with no discemable trend. Drawing from the dota avallable, assess the following: Complete this question by entering your answers in the tabs below. How would you describe the trend in the company's pension expense? Drawing from the data avallable, assess the following: Complete this question by entering your answers in the tabs below. How would you characterize the relationship between the company's actual return on plan assets and the expected return? Metagrobolize increased its expected return on plan assets in 2018 while the actual teturn was declining. Metagrobolize increasod its expected return on plan assets in 2018, and that increase contributed to the increase in pension expense Iniakn the actual return, the expected return has no elfoct on pension expense Drawing from the data avallable, assess the following: Complete this question by entering your answers in the tabs below. How might your onoivsis of the Dashbobrd affect your opinion on the position of Metagrobolite's pension plan? The growthin the ste of the person plan and pension expense reflect arowiog stiength in the position of Matagrobolizes pension plan The satteins the Denhboard conveys do nod rane any conceems that might asoct your openion on the postion of Motagrobolize's ponsion plan. The scratile and growno underfunding of the pension obigation togother with the maskng etllect on the cost of the pension plan of increasing the Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started