Question

In: Finance

Payments of 75 each are made every 2 months from September 1, 2006 to July 1,...

Payments of 75 each are made every 2 months from September 1, 2006 to July 1, 2011, inclusive. For each of the following cases draw the time diagram line and find the value of the series:
(a) 2 months before the first payment at effective compound annual interest rate i = 0.05;
(b) 10 months before the first payment at nominal interest rate i(12) = 0.12 compounded monthly;
(c) 2 months after the final payment at nominal discount rate d(4) = 0.08 compounded quarterly;
(d) one year after the final payment at annual force of interest δ = 0.07.

Solutions

Expert Solution

(a) 2 months before the first payment at effective compound annual interest rate i = 0.05;
Assume September 1,2006 as Month 0
July 1, 2011, Month=58
Effective annual rate=0.05
Effective monthly rate=r
(1+r)^12=1.05
1+r=(1.05^(1/12))= 1.004074
r=Effective monthly rate= 0.004074
Present Value (PV) of Cash Flow:
(Cash Flow)/((1+i)^N)
i=Discount Rate=0.004074
N=Month of Cash Flow (a) (b) .(c) (d)
N A B=A/(1.004074^N) C=A/(1.01^N) D=A/(1.006623^N) E=A/(1.005654^N)
Date Month Cashflow PV of cash flow at 0.004074 PV of cash flow at 0.01 PV of cash flow at 0.006623 PV of cash flow at 0.005654
.Sep.1,2006 0 75 75 75 75 75
.Nov.1,2006 2 75 74.39261 73.5222 74.01633 74.15904
.Jan.1,2007 4 75 73.79015 72.07353 73.04557 73.32751
.Mar.1,2007 6 75 73.19256 70.65339 72.08753 72.5053
.May.1,2007 8 75 72.59981 69.26124 71.14207 71.69231
.July.1,2007 10 75 72.01186 67.89652 70.209 70.88844
.Sep.1,2007 12 75 71.42868 66.55869 69.28817 70.09358
.Nov.1,2007 14 75 70.85021 65.24722 68.37941 69.30763
.Jan.1,2008 16 75 70.27643 63.96159 67.48258 68.5305
.Mar.1,2008 18 75 69.7073 62.7013 66.59751 67.76208
.May.1,2008 20 75 69.14278 61.46584 65.72404 67.00228
.July.1,2008 22 75 68.58283 60.25472 64.86204 66.25099
.Sep.1,2008 24 75 68.02741 59.06746 64.01133 65.50813
.Nov.1,2008 26 75 67.47649 57.9036 63.17179 64.7736
.Jan.1,2009 28 75 66.93004 56.76267 62.34326 64.04731
.Mar.1,2009 30 75 66.38801 55.64422 61.52559 63.32916
.May1,2009 32 75 65.85036 54.54781 60.71865 62.61906
.July.1,2009 34 75 65.31708 53.473 59.92229 61.91692
.Sep.1,2009 36 75 64.78811 52.41937 59.13637 61.22266
.Nov.1,2009 38 75 64.26342 51.3865 58.36077 60.53618
.Jan.1,2010 40 75 63.74299 50.37399 57.59533 59.8574
.Mar.1,2010 42 75 63.22677 49.38142 56.83994 59.18623
.May.1,2010 44 75 62.71473 48.40841 56.09445 58.52259
.July.1,2010 46 75 62.20683 47.45457 55.35874 57.86638
.Sep.1,2010 48 75 61.70305 46.51953 54.63268 57.21754
.Nov.1,2010 50 75 61.20335 45.60291 53.91614 56.57597
.Jan.1,2011 52 75 60.7077 44.70435 53.209 55.94159
.Mar.1,2011 54 75 60.21606 43.8235 52.51113 55.31433
.May.1,2011 56 75 59.7284 42.96001 51.82242 54.6941
.July.1,2011 58 75 59.24469 42.11352 51.14274 54.08083
SUM 2004.711 1711.143 1870.147 1919.73
Value of the series on the date of first payment 2004.71
Value of the series 2 months before the date of first payment 1988.48 (2004.71/(1.004074^2)
(b) 10 months before the first payment at nominal interest rate i(12) = 0.12 compounded monthly;
Monthly interest =(0.12/12)= 0.01
Value of the series on the date of first payment 1711.14
Value of the series ten months before the date of first payment 1549.08 (1711.14/(1.01^10)
(c) 2 months after the final payment at nominal discount rate d(4) = 0.08 compounded quarterly
Quarterly interest=(8/4)=2%= 0.02
Effective annualinterest =(1.02^4)-1 0.082432
Effective Monthly Interest =r
(1+r)^12=1.082432
1+r=(1.082432^(1/12) 1.006623
Effective Monthly Interest =r= 0.006623
Value of the series on the date of first payment 1870.15
Value of the series 2 months after final payment ie(58+2)=60 months after first payment 2778.99 (1870.15*(1.006623^60)

(d) one year after the final payment at annual force of interest δ = 0.07.

Monthly effective interest=r
(1+r)^12=1.07
1+r=(1.07^(1/12)= 1.005654
Monthly effective interest=r= 0.005654
Value of the series on the date of first payment 1919.73
Value of the series one year after final payment ie, (58+12)70months after first payment 2848.66 (1919.73*(1.005654^70)

Related Solutions

On July 1, $12,000 rent on building is paid for the months of July, August, and September.
On July 1, $12,000 rent on building is paid for the months of July, August, and September. Merchandize inventory $40,000 is purchased on account. The company uses perpetual inventory system. On July 1, $20,000 is borrowed from a local bank, and a note payable is signed. Credit sales for the month are $62,000, The cost of merchandize sold is $38,000. $2,000 is paid on account for office supplies. $55,000 is collected from customers on account. $10,000 is paid to employees...
2 Assume that a bond will make payments every six months as shown on the following...
2 Assume that a bond will make payments every six months as shown on the following timeline​ (using six-month​ periods): The timeline starts at Period 0 and ends at Period 50. The timeline shows a cash flow of $ 19.31 each from Period 1 to Period 49. In Period 50, the cash flow is $ 19.31 plus $ 1,000. Period012nothing4950 Cash Flows nothing$ 19.31$ 19.31nothing$ 19.31$ 19.31 plus $ 1,000 a. What is the maturity of the bond​(in years)? b....
Tom receives pension payments of $6000.00 at the end of every six months from a retirement...
Tom receives pension payments of $6000.00 at the end of every six months from a retirement fund of $90 000.00. The fund earns 8.00% compounded semi-annually. a) How many payments will Tom receive? b) What is the size of the final pension payment?
it is July 2006 and you expect to receive ZAR 1 000 000 in October 2006...
it is July 2006 and you expect to receive ZAR 1 000 000 in October 2006 from a customer. While you believe that the $ will weaken in the next 3 months, you do not want to take chances, and therefore wish to hedge against the risk of a strengthening $. You gather the following information about the foreign currency and futures markets. spot exchange rate                                                       $1.7640 per ZAR Forecast spot rate in October                                        $1.7400 per ZAR Contract size                                                                  ...
1.Mr. Clark made deposits of $950 at the end of every 6 months for 15 years....
1.Mr. Clark made deposits of $950 at the end of every 6 months for 15 years. If interest is 3% compounded monthly and if he leaves the accumulated balance for another 10 years, what will be the balance in his account then? (i.e. 10 years after the last deposit)   _______________ How much of the accumulated amount is interest? 2.Amy borrowed $6,200 to buy a car to drive to school. She plans to study for three years, and then start her...
Glenn has made contributions of $250 at the end of every 3 months into an RRSP...
Glenn has made contributions of $250 at the end of every 3 months into an RRSP for 10 years. Interest for the first 10 years was 4% compounded quarterly. (a)What is the amount in the RRSP after the first 10 years? (b)After the first 10 years, Glenn stopped making contributions. The interest rate changed to 5% compounded monthly. How much will Glenn have in his RRSP three years after the last contribution? (c)Suppose Glenn then decides to withdraw the money...
Glenn has made contributions of​ $250 at the end of every three months into an RRSP...
Glenn has made contributions of​ $250 at the end of every three months into an RRSP for 10 years. Interest for the first 10 years was​ 4% compounded quarterly. ​(a) What is the amount in the RRSP after the first 10​ years? ​(b) After the first 10​ years, Glenn stopped making contributions. The interest rate changed to​ 5% compounded quarterly. How much will Glenn have in his RRSP three years after the last​ contribution? ​(c) Suppose Glenn then decides to...
Twelve payments of 2,250 each are made at 2-year intervals. Find the value of the series...
Twelve payments of 2,250 each are made at 2-year intervals. Find the value of the series at the time of the final payment at nominal annual discount rate d(4)=0.04. A) 39,342 B) 49,096 C) 43,653 D) 74,941 E) 67,717
Find the present value of payments of $200 every six months starting immediately and continuing through...
Find the present value of payments of $200 every six months starting immediately and continuing through four years from the present, and $100 every six months thereafter through ten years from the present, if i (2) = 0.06.
loan of EGP 80,000 is taken out. Interest payments are due every 3 months at j4=...
loan of EGP 80,000 is taken out. Interest payments are due every 3 months at j4= 10%. A sinking fund is set up to pay back the EGP 80,000 in one lump sum at the end of 5 years. The sinking fund earns j4 = 12 % and deposits are made quarterly. Find the quarterly debt expense.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT