Question

In: Finance

Hello, Present value of an annuity due is €600,000 Yearly repayments is = €50,000 Period (n)...

Hello,
Present value of an annuity due is €600,000

Yearly repayments is = €50,000

Period (n) = 10 years

Calculate the interest rate on this loan, assuming the first payment is made immediately.

Please show all your working out.

Solutions

Expert Solution

Yearly payments is given as €50,000 and number of payments, 10.

Accordingly, total payment itself, without considering time value of money =€50,000*10 =€500,000.

On discounting the cash flows at a positive interest rate, Present Value should have been less than €500,000 (Or the yearly payments should have been more than 600,000/10=60,000). However, the PV, as per problem, is higher at €600,000. This will be possible only with interest at negative rate.

Interest rate of the annuity= -3.836008% calculated using the RATE function of Excel as follows:


Related Solutions

The present value of an annuity due is equal to the present value of an ordinary...
The present value of an annuity due is equal to the present value of an ordinary annuity times (1 + i). Select one: True False
Annuity Due Converting an annuity to an annuity due decreases the present value. Generally speaking, this...
Annuity Due Converting an annuity to an annuity due decreases the present value. Generally speaking, this statement is True or False? Explain it. [“Converting an annuity to an annuity due” means if you always make payment at the end of each year, now you change to make the payment at the beginning of each year.] You believe you will need to have saved $1,000,000 by the time you retire in 40 years in order to live comfortably.  In order to meet...
You are given the present value of a n-payment annuity-due paying 1 per year is 13.0853...
You are given the present value of a n-payment annuity-due paying 1 per year is 13.0853 and the present value of a payment of 1 payable at the end of m years is 0.613913. Find the present value of an m-year deferred annuity-due with n-payments of 50,000.
Why does an annuity due have a higher present value than a similar ordinary annuity?
Why does an annuity due have a higher present value than a similar ordinary annuity?
Find the present value of an annuity due that pays $1,600.00 at the beginning of each...
Find the present value of an annuity due that pays $1,600.00 at the beginning of each quarter for 4 years, if interest is earned at a rate of 4%, compounded quarterly. The present value is $___ (Round to 2 decimal places.)
Present value of an annuity    Consider the following case.   Amount of annuity Interest rate Period​ (years)...
Present value of an annuity    Consider the following case.   Amount of annuity Interest rate Period​ (years) ​$44,000 12​% 13 a.  Calculate the present value of the annuity assuming that it is ​(1) An ordinary annuity. ​(2) An annuity due. b.  Compare your findings in parts a​(1) and a​(2). All else being​ identical, which type of annuity—ordinary or annuity due—is ​preferable? Explain why. The present value of the ordinary annuity is____.  (Round to the nearest​ cent.)
Present Value of an Annuity What is the present value of a $400 annuity payment over...
Present Value of an Annuity What is the present value of a $400 annuity payment over 6 years if interest rates are 9 percent? $670.84 $2,013.18 $238.51 $1,794.37
1. Present Value of $1 Annuity Table: Find the PV of $1/year annuity for each period...
1. Present Value of $1 Annuity Table: Find the PV of $1/year annuity for each period and discount rate in the table below. Period 8% 10% 20% 10 15 30
Find the periodic payment for the following simple annuity due. Future Value $21,200 Present Value _________?...
Find the periodic payment for the following simple annuity due. Future Value $21,200 Present Value _________? Payment Period 1 month Term of Annuity 10 years Interest Rate 11% Conversion Period monthly The periodic payment is ​$______ . ​(Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as​ needed.)
What is the present value of a five-period annuity of $3,000 if the interest rate per...
What is the present value of a five-period annuity of $3,000 if the interest rate per period is 12% and the first payment is made today? Three thousand dollars is deposited into an account paying 10% annually to provide three annual withdrawals of $1,206.34 beginning in one year. How much remains in the account after the second payment has been withdrawn? You will be receiving cash flows of: $1,000 today, $2,000 at end of year 1, $4,000 at end of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT