Question

In: Finance

Calculate the accumulated value at time 5 years of payments that are received continuously over each...

Calculate the accumulated value at time 5 years of payments that are received continuously over each year with payment of $100 during 1st year, $110 in 2nd year, $130 in 3rd year, $140 in 4th year and $200 in 5th year. Assume EAR = 5%.

Solutions

Expert Solution

If interest is compounded monthly,

Accumulated value = $100 * ( 1 + 0.05/12) ^ 60 + $100 * ( 1 + 0.05/12) ^ 59 + ..... + $100 * ( 1 + 0.05/12) ^ 49 + $ 110 * ( 1 + 0.05/12) ^ 48 + ..... + $110 * (1 + 0.05/12) ^ 37 + $130 * (1 + 0.05/12) ^ 36 + .... + $130 * ( 1 + 0.05/12) ^ 25 + $140 * (1 +0.05/12) ^ 24 + ... + $140 * ( 1 + 0.05/12) ^ 13 + $200 * ( 1 + 0.05/12) ^12 + ... + $200 * ( 1 + 0.05/12) ^ 1

= $100 * (1 + 0.05/12) ^49 * [ (1 + 0.05/12) ^ 12 - 1] / [ 1 + 0.05/12 - 1] + $110 * (1 + 0.05/12) ^37 * [ (1 + 0.05/12) ^ 12 - 1] / [ 1 + 0.05/12 - 1] + $130 * (1 + 0.05/12) ^25 * [ (1 + 0.05/12) ^ 12 - 1] / [ 1 + 0.05/12 - 1] + $140 * (1 + 0.05/12) ^13 * [ (1 + 0.05/12) ^ 12 - 1] / [ 1 + 0.05/12 - 1] + $200 * (1 + 0.05/12) * [ (1 + 0.05/12) ^ 12 - 1] / [ 1 + 0.05/12 - 1]

= $100 * 1.226 * *12.229 + $110 * 1.166 * 12.229 + $130 * 1.11 * 12.229 + $140 * 1.056 * 12.229 + $200 * 1.0042 * 12.229

= $1,499.2754 + $1,568.4915 + $ 1,764.6447 + $1,807.9354 + $ 2,546.0734

= $9,168.42

If interest is compounded yearly,

Accumulated value = $100*12* ( 1 + 0.05) ^ 4 + $110 * 12 * ( 1 + 0.05) ^ 3 + $130 * 12 * ( 1 + 0.05) ^ 2 + $140 * 12 * ( 1+ 0.05) ^ 1 + $200 * 12 * ( 1 + 0.05) ^ 0

= $1,458.6075 + $1,528.065 + $1,719.90 + $1,764 + $2,400

= $8,870.57


Related Solutions

Calculate the present value at time t = 0 of a 5-year annuity paid continuously at...
Calculate the present value at time t = 0 of a 5-year annuity paid continuously at a rate of h(t)=(1+t). The force of interest at time t is δ =(2(1+t))/((t^2) +2t+1)
What is the present value of annual $7,399 payments over the upcoming 5 years ,on an...
What is the present value of annual $7,399 payments over the upcoming 5 years ,on an interest rate of 10%?
Calculate the future value of the following annuity streams: a. $5,000 received each year for 5...
Calculate the future value of the following annuity streams: a. $5,000 received each year for 5 years on the last day of each year if your investments pay 7 percent compounded annually. (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16))   Future value $    b. $5,000 received each quarter for 5 years on the last day of each quarter if your investments pay 7 percent compounded quarterly. (Do not round intermediate calculations. Round your answer...
Calculate the future value of the following annuity streams: a. $5,000 received each year for 5...
Calculate the future value of the following annuity streams: a. $5,000 received each year for 5 years on the last day of each year if your investments pay 7 percent compounded annually. (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16))   Future value $ b. $5,000 received each quarter for 5 years on the last day of each quarter if your investments pay 7 percent compounded quarterly. (Do not round intermediate calculations. Round your answer...
Calculate the following time value of money: If I am to receive $10k in 5 years,...
Calculate the following time value of money: If I am to receive $10k in 5 years, given a 5% rate of return, what would be the present value of this amount? If I put $7k into the bank @ 3% interest for 10 years, what is the future value of this amount? If I deposit $1k a year into an account for 10 years @ 2%, what is the future value of that account? What is the FUTURE value of...
a company has accumulated statistics over the past years to determine the average waiting time (in...
a company has accumulated statistics over the past years to determine the average waiting time (in minutes) on major bus routes depending on the time of day. Here are the statistics observed: Waiting time conditional upon period of the day Wait<5 (A) 5 ≤ ???? ≤ 15 (B) wait≥ 15 (C) Rush hour(R) 64% 32% 4% Midday(M) 20% 65% 15% Evenings(E) 10% 60% 30% Distribution of the users Proportion of total users Rush Hours(R) 70% Midday(M) 25% Evenings(E) 5% A)(1...
Calculate the accumulated amount of annunity with depositis of $750 monthy at 5% for 20 years....
Calculate the accumulated amount of annunity with depositis of $750 monthy at 5% for 20 years. Discuss how the accumlated amount would change if the monthly deposits was decreased.
How much is accumulated over two years in each of the following savings plans ? a)...
How much is accumulated over two years in each of the following savings plans ? a) 40$ at the end of each month for 24 months at 12 percent compounded monthly. b) 30$ at the end of the first month, 31$ at the end of the second month, and so forth, increasing by 1$ per month at 12 percent compounded monthly.
The present value of $20,000 to be received in 5 years at an interest rate of...
The present value of $20,000 to be received in 5 years at an interest rate of 16%, compounded annually, is $9,522.Required:Using a present value table (Table 6-4 and Table 6-5), calculate the present value of $20,000 for each of the following items (parts a—f) using these facts: (Use the appropriate value(s) from the tables provided. Round your PV factors to 4 decimal places and final answers to the nearest whole dollar.)a. Interest is compounded semiannually. b. Interest is compounded quarterly....
A loan of $330,000 is amortized over 30 years with payments at the end of each...
A loan of $330,000 is amortized over 30 years with payments at the end of each month and an interest rate of 6.9%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT