02 Jun Question So I have to come up with three different answers and have them on excel? can someone help me?
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 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
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.