Corporate Finance
QUESTION 1:
1. If the first deposit is at 36 years and the last expected deposit is at 65 years, then annual deposits will be made for 30 years. Expected annual withdrawals are $90,000 for 15 years from the retirement fund with a bank that offers compound interest of 8% annually.
Calculation
Present value (PV) =?
Future value (FV) = (90,000*15) = $1,350,000
Periodic payment amount (PMT) =?
Interest rate per period (Rate) = 8% or 0.08
Number of payment periods (Nper) = 30
Using the Excel function “PV”, the following data is entered into the presented fields
Rate = 8%
Nper = 30
PMT =?
Fv = 1,350,000
Type = blank
PMT = $9,416.15
$9,416.15 is the amount required for 30 annual deposits with an 8% compound interest to yield $90,000 for 15 years.
2. If a lump sum amount is deposited on my 35th birthday, then the principle will be compounded for 31 years.
Calculation
Using the compound interest formula
A = P (1+r/n) nt
Where; A = final amount, P = principal, r = interest rate n = number of times the interest is compounded per year and t = number of years
P= A/ (1+r/n) nt P = 1,350,000/ (1+0.08/1)31 P =1,350,000/ (1.08)31 P =1,350,000/ 10.868
The amount required for a lump sum deposit is $124,217.89
3. If an additional $1,500 from my employer bonus plan is deposited annually to the retirement account and a $25,000 is added to the account after 19 years (on my 55th birthday), then; using the total annual contribution obtained in (1),
The first deductions from my annual contribution will be $1,500 from the bonus plan
4,471.98 – 1,500 = 2,971.98
Distributing the $25,000 over the 30 year period, (25,000/30) = 833.33
2,971.98 – 833.33 = 2,138.65
To make $90,000 withdrawals for 15 years, I will need to make annual deposits of $2,138.65
QUESTION 2:
1.
a) Net Present Value
Using the MS-Excel function of NPV the rate of return (12%) is keyed into the “Rate” field and the returns
1. If the first deposit is at 36 years and the last expected deposit is at 65 years, then annual deposits will be made for 30 years. Expected annual withdrawals are $90,000 for 15 years from the retirement fund with a bank that offers compound interest of 8% annually.
Calculation
Present value (PV) =?
Future value (FV) = (90,000*15) = $1,350,000
Periodic payment amount (PMT) =?
Interest rate per period (Rate) = 8% or 0.08
Number of payment periods (Nper) = 30
Using the Excel function “PV”, the following data is entered into the presented fields
Rate = 8%
Nper = 30
PMT =?
Fv = 1,350,000
Type = blank
PMT = $9,416.15
$9,416.15 is the amount required for 30 annual deposits with an 8% compound interest to yield $90,000 for 15 years.
2. If a lump sum amount is deposited on my 35th birthday, then the principle will be compounded for 31 years.
Calculation
Using the compound interest formula
A = P (1+r/n) nt
Where; A = final amount, P = principal, r = interest rate n = number of times the interest is compounded per year and t = number of years
P= A/ (1+r/n) nt P = 1,350,000/ (1+0.08/1)31 P =1,350,000/ (1.08)31 P =1,350,000/ 10.868
The amount required for a lump sum deposit is $124,217.89
3. If an additional $1,500 from my employer bonus plan is deposited annually to the retirement account and a $25,000 is added to the account after 19 years (on my 55th birthday), then; using the total annual contribution obtained in (1),
The first deductions from my annual contribution will be $1,500 from the bonus plan
4,471.98 – 1,500 = 2,971.98
Distributing the $25,000 over the 30 year period, (25,000/30) = 833.33
2,971.98 – 833.33 = 2,138.65
To make $90,000 withdrawals for 15 years, I will need to make annual deposits of $2,138.65
QUESTION 2:
1.
a) Net Present Value
Using the MS-Excel function of NPV the rate of return (12%) is keyed into the “Rate” field and the returns