Question
So I have to come up with three different answers and have them on excel? can someone help me? First Problem: Illinois Wholesale Company has
So I have to come up with three different answers and have them on excel? can someone help me? First Problem: Illinois Wholesale Company has an agreement with it sales manager entitling that individual to 7% of company earning as a bonus. Company income for the calendar year before bonus and income tax is $350,000. Income tax is 30% of income after bonus. 1. Compute the amount of bonus is the bonus is calculated on income before deductions for bonus and income tax. 2. Compute the amount of bonus is calculated on income after deduction for bonus but before deduction for income tax. Second Problem: Francisco Company has established a defined benefit pension plan for its lone employee, Derrald Ryan, Annual payments under the pension plan are equal to 3% of Derrald's highest lifetime salary multiplied by the number of years with the company. Derralds salary in 2014 was $75,000. Derrald is expected to retire in 20 years, and his salary increase are expected to average 4% per year during that period. As of the beginning of 2015, Derrald has worked for Francisco Company for 12 years. 1. What is the amount of the annual pension payment that should be used in computing Francisco's accumulated benefit obligation (ABO) as of January 1, 2015? 2. What is the amount of the annual pension payment that should be used in computing Francisco's projected benefit obligation (PBO) as of January 1, 2015? Third Problem: Pension plan information for Naperville WIndow Company is as follows: January 1, 2015 PBO.......................................................................... $4,780,000 ABO........................................................................... $3,950,000 During 2015 Pension benefits paid to retire employees................$315,000 December 31, 2015 PBO........................................................................... $ 5,425,000 ABO........................................................................... $ 4,245,000 Obligation Discount rate...................................................................................... 10% Assuming no change in actuarial assumptions, what is the pension service cost for 2015?
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