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?