Question

In: Accounting

Under the MLB deferred compensation plan, payments made at the end of each year accumulate up...

Under the MLB deferred compensation plan, payments made at the end of each year accumulate up to retirement and then retirees are given two options. Option 1 allows the retiree to select the amount of the annual payment to be received, and option 2 allows the retiree to specify over how many years payments are to be received. Assume Sosa has had $5,000 deposited at the end of each year for 40 years, and that the long-term interest rate has been 7%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Required: a. How much has accumulated in Sosa's deferred compensation account? b. How much will Sosa be able to withdraw at the beginning of each year if he elects to receive payments for 20 years? c. For how many years will Sosa be able to receive payments if he chooses to receive $115,000 per year at the beginning of each year?

a. Balance in Fund __

b. Withdrawal Amount___

c. Receive payment ____ years

Solutions

Expert Solution

Solution:

Solution a) Calculation of fund accumulated in Sosa's deferred compensation account.

Following are the steps to be followed on Microsoft Excel to calculate the Future Value:

Step 1: Click on "FORMULAS" tab at the top of Microsoft Excel
Step 2: Select the option "Financial"
Step 3: Under "Financial" select the option "FV"
Step 4: Insert Rate = 0.07 Nper = 40 PMT = -5000

FV = $998,175.56

Therefore, the fund accumulated in Sosa's deferred compensation account after 40 years is $998,175.56


Solution b) Calculation of the amount Sosa will be able to withdraw at the beginning of each year if he elects to receive payments for 20 years

Following are the steps to be followed on Microsoft Excel to calculate the yearly withdrawal amount:

Step 1: Click on "FORMULAS" tab at the top of Microsoft Excel
Step 2: Select the option "Financial"
Step 3: Under "Financial" select the option "PMT"
Step 4: Insert Rate = 0.07 Nper = 20 PV = -998,175.56 Type = 1

PMT = $88,056.74

Therefore, the amount Sosa will be able to withdraw at the beginning of each year if he elects to receive payments for 20 years is $88,056.74

Solution c) Calculation of number of years Sosa will be able to receive payments if he chooses to receive $115,000 per year at the beginning of each year

Following are the steps to be followed on Microsoft Excel to calculate the number of years:

Step 1: Click on "FORMULAS" tab at the top of Microsoft Excel
Step 2: Select the option "Financial"
Step 3: Under "Financial" select the option NPER"
Step 4: Insert Rate = 0.07 PMT = 115000 PV = -998,175.56 Type = 1

NPER = 12.40

Therefore, Sosa will be able to withdraw $115,000 at the beginning of each year for 12.40 Years.


Related Solutions

Under the NBA deferred compensation plan, payments made at the end of each year accumulate up...
Under the NBA deferred compensation plan, payments made at the end of each year accumulate up to retirement and then retirees are given two options. Option 1 allows the retiree to select the amount of the annual payment to be received, and option 2 allows the retiree to specify over how many years payments are to be received. Assume Hardaway has had $6,100 deposited at the end of each year for 30 years, and that the long-term interest rate has...
Under the NBA deferred compensation plan, payments made at the end of each year accumulate up...
Under the NBA deferred compensation plan, payments made at the end of each year accumulate up to retirement and then retirees are given two options. Option 1 allows the retiree to select the amount of the annual payment to be received, and option 2 allows the retiree to specify over how many years payments are to be received. Have the assumption Hardaway has had $7,800 deposited at the end of each year for 30 years, and that the long-term interest...
XYZ Corporation has a deferred compensation plan under which it allows certain employees to defer up...
XYZ Corporation has a deferred compensation plan under which it allows certain employees to defer up to 40 percent of their salary for five years. For purposes of this problem, ignore payroll taxes in your computations a. Assume XYZ has a marginal tax rate of 21 percent for the foreseeable future and earns an after-tax rate of return of 12 percent on its assets. Joel Johnson, XYZ’s VP of finance, is attempting to determine what amount of deferred compensation XYZ...
XYZ Corporation has a deferred compensation plan under which it allows certain employees to defer up...
XYZ Corporation has a deferred compensation plan under which it allows certain employees to defer up to 35 percent of their salary for five years. (For purposes of this problem, ignore payroll taxes in your computations.) PV Table (Round your PV factors to 5 decimal places. Round your intermediate calculations and final answers to the nearest whole dollar amount.) a. Assume XYZ has a marginal tax rate of 35 percent for the foreseeable future and earns an after-tax rate of...
XYZ Corporation has a deferred compensation plan under which it allows certain employees to defer up...
XYZ Corporation has a deferred compensation plan under which it allows certain employees to defer up to 35 percent of their salary for five years. (For purposes of this problem, ignore payroll taxes in your computations.) PV Table (Round your PV factors to 5 decimal places. Round your intermediate calculations and final answers to the nearest whole dollar amount.) a. Assume XYZ has a marginal tax rate of 35 percent for the foreseeable future and earns an after-tax rate of...
XYZ Corporation has a deferred compensation plan under which it allows certain employees to defer up...
XYZ Corporation has a deferred compensation plan under which it allows certain employees to defer up to 20 percent of their salary for five years. For purposes of this problem, ignore payroll taxes in your computations. (Use Table 1.) (Round your intermediate calculations and final answers to the nearest whole dollar amount.) Problem 13-61 Part a a. Assume XYZ has a marginal tax rate of 21 percent for the foreseeable future and earns an after-tax rate of return of 13...
The following payments are made under an annuity: 12 at the end of the 44th year,...
The following payments are made under an annuity: 12 at the end of the 44th year, 11 at the end of the 55th year, decreasing by 11 each year until nothing is paid. Find the present value if the annual effective rate of interest is 3%.
Find the amount of each of 5 payments made at the end of each year into...
Find the amount of each of 5 payments made at the end of each year into a 6% rate sinking fund which produces $21,000 at the end of 5 years. A. $2,053.18 B. $3,514.46 C. $3,725.32 D. $4,200.00
Assume the payments will be made at the end of each year (The first payment is...
Assume the payments will be made at the end of each year (The first payment is made on December 31, 2019.); recalculate your answer for case # 3. Calculate the annual payment required.  Show your final answer and show all the work to support your answer. Prepare the amortization table for the loan using the format covered in class. Case #3 info: On January 1, 2019, ABC Corp. borrowed $81,000 by signing an installment loan.  The loan will be repaid in 20...
A 13-year annuity pays $1,400 per month, and payments are made at the end of each...
A 13-year annuity pays $1,400 per month, and payments are made at the end of each month. The interest rate is 12 percent compounded monthly for the first Five years and 11 percent compounded monthly thereafter. Required: What is the present value of the annuity? A) $1,343,944.86 B) $109,755.50 C) $111,995.40 D) $152,061.20 E) $114,235.31
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT