At age 25, Anthony establishes an Individual Retirement Account (IRA). If he invests P10,000 per year for 30 years in an ordinary annuity, the account earns 7.75% per year, how much will he have in the account at age 55?

At age 25, Anthony establishes an Individual Retirement Account (IRA). If he invests P10,000 per year for 30 years in an ordinary annuity, the account earns 7.75% per year, how much will he have in the account at age 55?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 45P: A project does not necessarily have a unique IRR. (Refer to the previous problem for more...

See similar textbooks

Similar questions

A project does not necessarily have a unique IRR. (Refer to the previous problem for more information on IRR.) Show that a project with the following cash flows has two IRRs: year 1, 20; year 2, 82; year 3, 60; year 4, 2. (Note: It can be shown that if the cash flow of a project changes sign only once, the project is guaranteed to have a unique IRR.)
In the financial world, there are many types of complex instruments called derivatives that derive their value from the value of an underlying asset. Consider the following simple derivative. A stocks current price is 80 per share. You purchase a derivative whose value to you becomes known a month from now. Specifically, let P be the price of the stock in a month. If P is between 75 and 85, the derivative is worth nothing to you. If P is less than 75, the derivative results in a loss of 100(75-P) dollars to you. (The factor of 100 is because many derivatives involve 100 shares.) If P is greater than 85, the derivative results in a gain of 100(P-85) dollars to you. Assume that the distribution of the change in the stock price from now to a month from now is normally distributed with mean 1 and standard deviation 8. Let EMV be the expected gain/loss from this derivative. It is a weighted average of all the possible losses and gains, weighted by their likelihoods. (Of course, any loss should be expressed as a negative number. For example, a loss of 1500 should be expressed as -1500.) Unfortunately, this is a difficult probability calculation, but EMV can be estimated by an @RISK simulation. Perform this simulation with at least 1000 iterations. What is your best estimate of EMV?
It is January 1 of year 0, and Merck is trying to determine whether to continue development of a new drug. The following information is relevant. You can assume that all cash flows occur at the ends of the respective years. Clinical trials (the trials where the drug is tested on humans) are equally likely to be completed in year 1 or 2. There is an 80% chance that clinical trials will succeed. If these trials fail, the FDA will not allow the drug to be marketed. The cost of clinical trials is assumed to follow a triangular distribution with best case 100 million, most likely case 150 million, and worst case 250 million. Clinical trial costs are incurred at the end of the year clinical trials are completed. If clinical trials succeed, the drug will be sold for five years, earning a profit of 6 per unit sold. If clinical trials succeed, a plant will be built during the same year trials are completed. The cost of the plant is assumed to follow a triangular distribution with best case 1 billion, most likely case 1.5 billion, and worst case 2.5 billion. The plant cost will be depreciated on a straight-line basis during the five years of sales. Sales begin the year after successful clinical trials. Of course, if the clinical trials fail, there are no sales. During the first year of sales, Merck believe sales will be between 100 million and 200 million units. Sales of 140 million units are assumed to be three times as likely as sales of 120 million units, and sales of 160 million units are assumed to be twice as likely as sales of 120 million units. Merck assumes that for years 2 to 5 that the drug is on the market, the growth rate will be the same each year. The annual growth in sales will be between 5% and 15%. There is a 25% chance that the annual growth will be 7% or less, a 50% chance that it will be 9% or less, and a 75% chance that it will be 12% or less. Cash flows are discounted 15% per year, and the tax rate is 40%. Use simulation to model Mercks situation. Based on the simulation output, would you recommend that Merck continue developing? Explain your reasoning. What are the three key drivers of the projects NPV? (Hint: The way the uncertainty about the first year sales is stated suggests using the General distribution, implemented with the RISKGENERAL function. Similarly, the way the uncertainty about the annual growth rate is stated suggests using the Cumul distribution, implemented with the RISKCUMUL function. Look these functions up in @RISKs online help.)
A 5-year annuity of ten $5,300 semiannual paymentswill begin 9 years from now, with the first payment coming 9.5 years from now. If thediscount rate is 12 percent compounded monthly, what is the value of this annuityfive years from now? What is the value three years from now? What is the currentvalue of the annuity?
I have a accounting firm and someone from real estate wants to invest and give my firm all her accounts but in return wants equal ownership of my firm, but i dont want to giver her equal ownership but wants her to invest in my firm , what are alternatives that i can offer her without giving her half ownership. Elaborate
A 15-year annuity pays $1,500 per month, and paymentsare made at the end of each month. If the interest rate is 12 percent compoundedmonthly for the first seven years, and 6 percent compounded monthly thereafter,what is the present value of the annuity?
Michelle, age 45, currently makes $95,000. Her wage replacement ratio is determined to be 75 percent. She expects that inflation will average 3 percent for her entire life expectancy. She expects to earn 8 percent on her investments and retire at age 65, possibly living to age 95. She has sent for and received her Social Security benefit statement, which indicated that her Social Security retirement benefit in today’s dollars adjusted for early retirement is $20,000 per year. How much capital does Jordan need to retire at age 65?.
Ana de la Cruz expects to receive P20,940 at the beginning of each period per year in Social Security payments. Assume that she receives these payments for 28 years and use a rate of 6% per year. Find the present value of her retirement payments.
Suppose that you want to invest $10,000 in the stock market by buying shares in one of two companies: A and B. Shares in company A though risky, could yield a 50% return on investment during the next year. If the stock market if conditions are not favorable (bear market) the stock may lose 20% of it value. Company B provides safe investments with 15% return in a bull market and only 5% in a bear market Ali the applications you have consulted are predicting a 60% chance for a bull market and 40% for a bear market. Where you invest your money? Construct a decision tree.
Consider a project with the following cash flows: year 1, 2$400; year 2, $200; year 3, $600; year 4, 2$900; year 5, $1000; year 6, $250; year 7, $230. Assume a discount rate of 15% per year.a. Find the project’s NPV if cash flows occur at the ends of the respective years.b. Find the project’s NPV if cash flows occur at the beginnings of the respective years.c. Find the project’s NPV if cash flows occur at the middles of the respective years.
You are managing a portfolio of $1 million. Your target duration is 11 years, and you can choose from two assets: a zero coupon bond with maturity 5 years, and a perpetuity, the yield is: A. .688 B. .417 C. .583 D. .312
A few years ago, Michael purchased a home for $394,000. Today, the home is worth $520,000. His remaining mortgage balance is $166,000. Assuming Michael can borrow up to 80 percent of the market value of his home, what is the maximum amount he can borrow?