Benefit consultant by pete mc nown

Assignment Help Financial Accounting

Reference no: EM13958067

Your business decides to purchase an additional warehouse to store their inventory in. The warehouse costs $280,000. You decide to put $50,000 down as a down payment and finance the rest through your bank. The bank decides they will loan it to you over 7 years at 6.5% interest. Please complete the following two questions

What will be your monthly payments?
Please draft a loan amortization schedule in Excel

You have been hired as a benefit consultant by Pete Mc Nown, the owner of Pete's Pet Emporium. He wants to establish a retirement plan for himself and his two employees, Ron and Aaron. Pete has provided the following information:

The retirement plan is to be based upon annual salary for the LAST year of service before retirement

i.The plan will provide for 60% of Pete's last year salary and,

ii.The plan will provide for 45% of Ron and Aaron's last year salary

iii.In the past, Pete has given himself and each employee a 3% year-end salary increase. Pete plans to continue this practice.

The plan will make annual payments to the employees at the beginning of each year for 20 years from the date of retirement.

Pete wishes to fund the plan by making 15 annual deposits beginning January 1, 2010

Invested funds will earn 10% compounded annually until January 1, 2025. At that time, the funds will be moved to a safer investment vehicle with an annual return of 5%.

Here is specific information on each employee:

i. Pete McNown; current salary of $52,000, estimated retirement 01/01/25

ii. Ron Farrell; current salary of $41,000, estimated retirement 01/01/30

iii. Aaron Cavey; current salary of $39,000 estimated retirement 01/01/35

Given the above information, please answer the following questions:

i. What will be the annual retirement benefit for each plan participant?

ii. What amount must be on deposit at the end of 15 years to ensure that all benefits will be paid?

iii. What is the amount of each annual deposit Pete must make to the retirement plan?

Reference no: EM13958067

Questions Cloud

What is the percentage of idle time : Balance the assembly line using the information below, and the most following task rule. The desired output is 360 units per day. Available production time per day is 8 hours. What is the percentage of idle time? Assign task to each work station. Wha..

Compare the bne prices if firm ls realized cost is high : Compare the BNE prices if Firm l's realized cost is high with the equilibrium prices in the game where it is common knowledge that Firm 1 has high marginal cost (cH).

Produce part it uses in assembly operation at the rate : A company can produce a part it uses in an assembly operation at the rate of $50 an hour. The company operates 8 hours a day, 300 days a year. Daily usage of the part is 300 parts. The company uses the part every day. The run size is 6000 parts. The ..

Calculate the total overhead assigned to the production : Calculate the total overhead assigned to the production of the Art of Design. Round to two decimal places.

Benefit consultant by pete mc nown : You have been hired as a benefit consultant by Pete Mc Nown, the owner of Pete's Pet Emporium. He wants to establish a retirement plan for himself and his two employees, Ron and Aaron.

Three main media used to communicate with consumers : List and describe the three main media used to communicate with consumers on the Internet. Summarize the ways product information is conveyed in each medium. As an advertiser, what tools can you use to make your website as visited as possible?

An analytical tool used in sixe process that breaks down : An analytical tool used in the sixe process that breaks down a problem into the relative contributions of its components is a

Maximum value of xp for which envelope detection ofm : Determine the maximum value of xp for which envelope detection ofm

Determined the demand points : A company has determined the "demand points" and their relative locations as follows: If a company desires to locate a manufacturing facility at the center of gravity, what would be the x and y coordinates of the facility?

User Account

All Pages