Question

In: Finance

Your company has a $125,000 liability it must pay 4 years from today. The company is...

Your company has a $125,000 liability it must pay 4 years from today. The company is opening a savings account so that the entire amount will be available when this debt needs to be paid. The plan is to make an initial deposit today and then deposit an additional $13,000 a year for the next 4 years, starting one year from today. The savings account pays a return of 8.00% compounded monthly. solve for the value

Question 8 options:

$43,284

$44,486

$45,688

$46,891

$48,093

Solutions

Expert Solution

Value of initial deposit required today to meet $125,000 in year 4:

Value of initial deposit required today is $48,093.34 or $48,093 (last option)

Steps:

1. First the future value of each of the yearly payment of $13,000 is computed using the excel function '=FV' as follows:

=FV(rate,nper,pmt,-pv) where

rate = 8%/12;

nper = for year 1 payment = 3 years remaining for 4th year * 12 = 3*12 = 36 months; for year 2 payment = 2 years remaining for 4th year * 12 = 2*12 = 24 months; for year 3 payment = 1 year remaining for 4th year * 12 = 1*12 = 12 months; for year 4 payment = 0 year remaining for 4th year * 12 = 0*12 = 0 months;

pmt = 0

pv = -$13,000

2. The total of all future value of $13,000 at year 4 is then deducted from $125,000 which is the future value of the today's initial deposit (which is $66,160.38)

3. The present of such value is then determined using the excel function '=PV' as follows:

=pv(rate,nper, pmt,-fv) where

rate = 8%/12

nper = 4 years * 12 months = 48

pmt = 0

fv = -$66,160.38


Related Solutions

Blackwell, Inc. has a $72,000 liability it must pay three years from today. The company is...
Blackwell, Inc. has a $72,000 liability it must pay three years from today. The company is opening a savings account so that the entire amount will be available when this debt needs to be paid. The plan is to make an initial deposit today and then deposit an additional $16,000 each year for the next three years, starting one year from today. The account pays a 4.5 percent rate of return. How much does the firm need to deposit today?
A company must pay a liability of $1,000 in 2 years. Zero coupon bonds with terms...
A company must pay a liability of $1,000 in 2 years. Zero coupon bonds with terms of 1 year and 4 years are available for investment. The effective rate of interest is 7.5%. How much of each bond should the company buy in order to achieve full immunization?
A company must pay a liability of $1,000 in 2 years. Zero coupon bonds with term...
A company must pay a liability of $1,000 in 2 years. Zero coupon bonds with term of 1 year and 4 years are available for investment. The effective rate of interest is 7.5%. (b) Show empirically that immunization has been achieved even for large changes in the interest rate. Take as an example a decrease in the interest rate to 0% and an increase to 100%.
A company must pay a liability of $1,000 in 2 years. Zero coupon bonds with term...
A company must pay a liability of $1,000 in 2 years. Zero coupon bonds with term of 1 year and 4 years are available for investment. The effective rate of interest is 7.5%. (a) How much of each bond should the company buy in order to achieve full immunization? (b) Show empirically that immunization has been achieved even for large changes in the interest rate. Take as an example a decrease in the interest rate to 0% and an increase...
Calculate the present value of $5,000 received five years from today if your investments pay (Do...
Calculate the present value of $5,000 received five years from today if your investments pay (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Present Value a. 6 percent compounded annually $ b. 8 percent compounded annually c. 10 percent compounded annually d. 10 percent compounded semiannually e. 10 percent compounded quarterly
john wishes to pay $1000 a year for 3 years, starting 5 years from today. interest...
john wishes to pay $1000 a year for 3 years, starting 5 years from today. interest rates are forecast at 2% compounded monthly over the next two years and 4% compounded monthly there after. how much must he set aside today?
Calculate the future value in four years of $7,000 received today if your investments pay (Do...
Calculate the future value in four years of $7,000 received today if your investments pay (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Future Value a. 5 percent compounded annually $ b. 7 percent compounded annually c. 9 percent compounded annually d. 9 percent compounded semiannually e. 9 percent compounded quarterly
Calculate the future value in six years of $4,000 received today if your investments pay (Do...
Calculate the future value in six years of $4,000 received today if your investments pay (Do not round intermediate calculations, and round answers to 2 decimal places please) A). 6 percent compounded annually B). 8 percent compounded annually C). 10 percent compounded annually D). 10 percent compounded semiannually E). 10 percent compounded quarterly
1. A bank has an average asset duration of 4 years and an average liability duration...
1. A bank has an average asset duration of 4 years and an average liability duration of 1.5 years. This bank has total assets of $500 million and total liabilities of $450 million. Currently, market interest rates are 10 percent. If interest rates rise by 1 percent (to 11 percent), what is this bank's change in net worth? a. net worth will decrease by $12.05 million b. net worth will decrease by $15.45 million c. net worth will increase by...
Question 6 A bank has an average asset duration of 4 years and an average liability...
Question 6 A bank has an average asset duration of 4 years and an average liability duration of 1.5 years. This bank has total assets of $500 million and total liabilities of $450 million. Currently, market interest rates are 10 percent. If interest rates rise by 1 percent (to 11 percent), what is this bank's change in net worth? A. Net worth will decrease by $12.05 million B. Net worth will decrease by $15.45 million C. Either the net worth...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT