Question

In: Accounting

Suppose a government has to make the following payments to another government, in perpetuity. The first...

Suppose a government has to make the following payments to another government, in perpetuity.

  • The first payment is made on 1 July 2020, and is equal to $1 million;
  • All subsequent payments are made on the first of each month, but increasing at an inflation rate of 1% every 3 months.
  • That is, the payments on 1 August and 1 September are also $1 million each, but the payments on 1 October, 1 November, and 1 December 2020 are $1.01 million each, the payment on 1 January 2021 is equal to $1,020,100, and so on.

  1. Assuming an interest rate of 0.25% per annum, and including the value of the payment just made on 1 September 2079, use Excel to calculate the accumulated value of the above payments as at 1 September 2079. DO NOT hand in any excel workings.

Answer: ___________________________________                                               [2 marks]

  1. Complete the 8 missing entries labelled ‘?’ in the following table, using your cashflow projection from Excel.– just complete the table below.                     [8 marks]

Time (month)

Date

Payment

0

1 July 2020

$1,000,000

1

1 August 2020

$1,000,000

127

?

?

?

1 June 2046

?

?

1 August 2079

?

?

1 September 2079

?

  1. Suppose that the inflation rate is now not 1% per quarter at the end of each quarter, but 4% once per year, at the end of each year ending 1 July. Describe how you expect this to change your answer to (a) – does it increase, decrease, or stay the same? Give a reason for your answer.                                                                                                                                     [2 marks]

  1. The government making these payments is now concerned about a rapidly changing economic environment. It now expects inflation to be 1.555% per quarter, and interest rates to be 4.25% per year. What now is the accumulated of the above payments as at 1 September 2079? Give your answer to the nearest $million. [you do not need to show working, and DO NOT hand in any excel workings]     [2 marks]

Solutions

Expert Solution

SOLUTION:-

A). Accumulated value of the above payments as at 1 September 2079 will be $2,872 Million ($2,872,257,661).

This is estimated basis the assumption that 0.25% interest per annum will be applied monthly at 0,0208% per month and is applies at end of the month.

Thus, the 1 st jul 2020 will earn interest on 1st Aug 2020.

B) Table below:

Time

(month)

Date Payment ($)
0 1 Jul 2020 1,000,000
1 1 Aug 2020 1,000,000
127 1 Feb 2031 1,519,106
311 1 Jul 2046 2,787,353
709 1 Aug 2079 10,469,711
710 1 Sep 2079 10,469,711

C). The answer to above will decrease if the inflation is at 4% per annum instead of 1% per quater.

1% per quater when annualised works to 4.06% (as the percentage will be calculated on the sum after the inflation).

Since 4% per annum is less than 4.06% answer to above will decrease.

Thus, accumulated value of the above payments as at 1 September 2079 will be $2,765 Million ($2,765,426,889)

D). If the interest rate is 4.25% per annum (monthly 0.3542%) and inflation is 1.555%, accumulated value of the above payments as at 1 September 2079 will be $7,308 Million ($7,307,561,146)

THANK YOU, if any queries please leave your valuable comment on comment box........


Related Solutions

Suppose a government has to make the following payments to another government, in perpetuity. The first...
Suppose a government has to make the following payments to another government, in perpetuity. The first payment is made on 1 July 2020, and is equal to $1 million; All subsequent payments are made on the first of each month, but increasing at an inflation rate of 1% every 3 months. That is, the payments on 1 August and 1 September are also $1 million each, but the payments on 1 October, 1 November, and 1 December 2020 are $1.01...
A perpetuity will make annual payments with the first payment coming 12 years from now. The...
A perpetuity will make annual payments with the first payment coming 12 years from now. The first payment is for $4500, and each payment that follows is $150 dollars more than the previous one. If the effective rate of interest is 4.8%, what is the present value of the perpetuity?
Charlotte will receive quarterly payments from a perpetuity, beginning now. The amount of the first payment...
Charlotte will receive quarterly payments from a perpetuity, beginning now. The amount of the first payment is 100, and each subsequent payment is larger than the previous payment by an amount X. Assuming an interest of 6% convertible monthly, the present value of this perpetuity is $20,000. Find X.
Investment A will make N annual payments of $500 with the first of the N payments due immediately.
  6. Investment A will make N annual payments of $500 with the first of the N payments due immediately. Investment A has a value of $20,000. Investment B is an ordinary annuity that will make (N minus 1) annual payments of $500 with the first payment due in one year from today. If investment A and investment B have the same expected return, then what is the value of investment B?     $20,500     The value of...
A perpetuity costs 693.16 and makes end-of-month payments. The perpetuity pays 1 at the end of...
A perpetuity costs 693.16 and makes end-of-month payments. The perpetuity pays 1 at the end of each month of year 1, 2 at the end of each month of year 2, ...., 10 at the end of each month of year 10. After year 10, the payments remain constant at 10. Calculate the annual effective interest rate. (a) 8.30% (b) 9.38% (c) 10.47% (d) 11.57% (e) 12.68%
A perpetuity costs 693.16 and makes end-of-month payments. The perpetuity pays 1 at the end of...
A perpetuity costs 693.16 and makes end-of-month payments. The perpetuity pays 1 at the end of each month of year 1, 2 at the end of each month of year 2, ...., 10 at the end of each month of year 10. After year 10, the payments remain constant at 10. Calculate the annual effective interest rate. (a) 8.30% (b) 9.38% (c) 10.47% (d) 11.57% (e) 12.68%
Jill has an investment opportunity that will make three annual payments, the first coming 13 years...
Jill has an investment opportunity that will make three annual payments, the first coming 13 years from now. The payments will increase by 420 dollars from one payment to the next. If the nominal rate is 6.8 percent convertible quarterly and the present value of the investment now is 16600 dollars, how large is the first payment?
Q3) Maria Garcia has an (arithmetic) annuity immediate that will make 10 annual payments. The first...
Q3) Maria Garcia has an (arithmetic) annuity immediate that will make 10 annual payments. The first payment is P = $1000 and payment increases by Q = $100 from the payment before. The effective annual interest rate is i = 2.75%. a) Compute both the present and future value of Maria Garcia’s annuity by showing it is equivalent to the following 2 annuities: • Annuity A: Level pay, $900 for 10 years • Annuity B: Arithmetic increasing annuity immediate: starts...
You are offered an investment that will make three payments. The first payment of $5600 will...
You are offered an investment that will make three payments. The first payment of $5600 will occur four years from today. The second of $6700 will occur in five years, and the third of $7800 will follow in seven years. If you earn 11.1% what is the most this investment is worth today?
Mike buys a perpetuity-immediate with varying annual payments. During the first 5 years, the payment is constant and equal to 10.
Mike buys a perpetuity-immediate with varying annual payments. During the first 5 years, the payment is constant and equal to 10. Beginning in year 6, the payments start to increase. For year 6 and all future years, the payment in that year is K% larger than the payment in the year immediately preceding that year, where K < 9.2. At an annual effective interest rate of 9.2%, the perpetuity has a present value of 167.50. Calculate K
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT