Present Value = Interest Per Period / Discount Rate
= 5/0.04
=125
( rate for semiannually would be =0.08/2=0.04
No excel solutions please. Thank you ) Consider a perpetuity, which make payments twice a year. The first-year payments are 5 at time 0.5 years and 5 at time 1, next year they are 10 at time 1.5...
2) You are given a perpetuity, with annual payments as follows: Payments of 1 at the end of the first year and every three years thereafter. Payments of 2 at the end of the second year and every three years thereafter. Payments of 3 at the end of the third year and every three years thereafter. The interest rate is 5% convertible semi-annually. Calculate the present value of this perpetuity. A. 24 B. 29 C. 34 D. 39 E. 47
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
ASSESSMENT 5. You want to buy a condo 5 years from now, and you plan to save $3,000 per year, beginningat the end of each year. You will make 5 deposits in an account that pays 6 % interest. Under these assumptions, how much will you have 5 years from today? a. $16,110,34 b. $16,911.28 c. $17,513.68 d. $15,976.84 e. $18,349.15 6. You have the opportunity to buy a perpetuity that pays $1,000 annually. Your required rate of return on...
1.What constant payment for the next 10 years (starting 1 year from now, 10 payments) would be equivalent to receiving $350 every other year starting 10 years from now. Assume the annual cost of capital is 13%. 2.Suppose you own two assets with the following payouts. (1) $250 at the end of every year starting 1 year from now. The annual cost of capital for these cash flows is 9%. (2) $650 one year from now and a cash flow...
please answer both! it would be greatly appreaciated
Consider a one-year cash flow as follows. Payments are made at end of a given month. What the value F at the end of month 12 if the nominal interest rate is 20%/year, c.q. (comp. quarterly). 0 1 2 3 4 5 6 7 8 9 10 End of Month Cash Flow, $ 11 12 - 100 -50 -50 -50 +190 +200 -50 +145 less than $100 Between $100-$200 Between $200-$300 Higher...
Previous Page Next Page Page 4 of 30 Question 4 (3.3 points) Which of the following statements is most correct? The first payment under a 3-year, annual payment, amortized loan for $1,000 will include a smaller percentage (or fraction) of interest if the interest rate is 5 percent than if it is 10 percent. If you are lending money, then, based on effective interest rates, you should prefer to lend at a 10 percent nominal, or quoted, rate but with...
ou deposit $10,900 annually into a life insurance fund for the next 10 years, at which time you plan to retire. Instead of a lump sum, you wish to receive annuities for the next 20 years. What is the annual payment you expect to receive beginning in year 11 if you assume an interest rate of 5 percent for the whole time period?
Chapter 5 Time Value of Money 179 ermediate blems 5-9 5-10 PRESENT AND FUTURE VALUES FOR DIFFERENT PERIODS Find the following values using the ators and then a financial calculator Compounding/discounting occurs annually. a. An initial $600 compounded for 1 year at 6% b. An initial $600 compounded for 2 years at 6% c. The present value of $600 due in 1 year at a discount rate of 6% d. The present value of $600 due in 2 years at...
Video Excel Online Structured Activity: Required annuity payments Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he retires, until he is 85. He wants a fixed retirement income that has the same purchasing power at the time he retires as $40,000 has today. (The real value of his retirement income will decline annually after he retires.) His retirement income will begin the day he retires, 10 years from...
1) Menke Auto Ltd invests $2.5 million at 25% for 3 years. Calculate the FV of this investment. (2.5 Marks) 2) Butcher's Ltd invests $2.5 million at 24% for 3 months. Calculate the FV of this investment. (2.5 Marks) 3) An insurance policy will pay $380,000 in 7 years' time. Assume the interest rate is 20%. Calculate the present value of such in lump sum payment. (5 Marks) 4) Karen was offered an annuity that would pay her $1000 per...