After winning some money at a casino, Tony is considering purchasing an annuity that promises to...

After winning some money at a casino, Tony is considering purchasing an annuity that promises to pay him $300 at the end of each month for 12 months, then $350 at the end of each month for 24 months, and then $375 at the end of each month for 36 months. If the first payment is due at the end of the first month and interest is 7.5% compounded annually over the life of the annuity, find Tony’s purchase price.

Solutions

Expert Solution

The timeline of cash flows is :

Months 1 to 12 - $300

Months 13 to 36 - $350

Months 37 to 72 - $375

The present value of the 1st series of cash flows is calculated using the PV function in Excel with these inputs :

rate = 7.5% / 12 (Converting annual rate into monthly rate)

nper = 12 (12 monthly payments)

pmt = -300 (monthly payment. this is entered as a negative figure because in an annuity, the initial amount is a cash outflow and the monthly payments are cash inflows)

PV is calculated to be $3,457.92

The value of the 2nd series of cash flows at the end of 12 months from now is calculated using the PV function in Excel with these inputs :

rate = 7.5% / 12 (Converting annual rate into monthly rate)

nper = 24 (24 monthly payments)

pmt = -350 (monthly payment. this is entered as a negative figure because in an annuity, the initial amount is a cash outflow and the monthly payments are cash inflows)

The value of the 2nd series of cash flows at the end of 12 months from now is $7,777.85

The present value of this needs to be calculated by discounting it back to the present at 7.5% rate for 1 year

present value = $7,777.85 / 1.075 = $7,235.21

The value of the 3rd series of cash flows at the end of 36 months from now is calculated using the PV function in Excel with these inputs :

rate = 7.5% / 12 (Converting annual rate into monthly rate)

nper = 36 (36 monthly payments)

pmt = -375 (monthly payment. this is entered as a negative figure because in an annuity, the initial amount is a cash outflow and the monthly payments are cash inflows)

The value of the 2nd series of cash flows at the end of 12 months from now is $12,055.47

The present value of this needs to be calculated by discounting it back to the present at 7.5% rate for 3 years

present value = $7,777.85 / 1.075³ = $9,704.18

Purchase price is the sum of the present values of the 3 series of cash flows

Purchase price = $3,457.92 + $7,235.21 + $9,704.18 = $20,397.31

jeff jeffy answered 5 months ago

Next > < Previous

Related Solutions

Wise Company is considering an investment that requires an outlay of $600,000 and promises an after-tax...

Wise Company is considering an investment that requires an outlay of $600,000 and promises an after-tax cash inflow of $693,000 one year from now. The company's cost of capital os 10%. 1. Break the $693,000 future cash inflow into three components: (a) the return of the original investment, (b) the cost of capital and, (c) the profit earned on the investment. Now compute the present value of the profit earned on the investment. 2. Conceptual Connection: Compute the NPV of...

A shipping line is considering purchasing some new ships at some time in the future and...

A shipping line is considering purchasing some new ships at some time in the future and has asked you as an expert to explain five main factors that have to be taken into account in considering the purchase of a new ship.

After experiencing such great success with their food cart, Nathan and Cody are considering purchasing a...

After experiencing such great success with their food cart, Nathan and Cody are considering purchasing a food truck to serve other communities. This would allow the Great Tamale, GT, to reach even more customers in different geographic locations. There would be an increase in the selling price per plate. There will also be an increase in the fixed costs of $30,000 for advertising to inform the public of this change (this amount is already included below under Food Truck data)....

Q8 You are looking at purchasing at investing some money you have in a infrastructure project...

Q8 You are looking at purchasing at investing some money you have in a infrastructure project that a firm you know is running. The project involves an up-front cost of $15,568.80. There are three additional costs that are required: $13,388.20 in year 7, $13,530.22 in year 9 and $24,011.86 in the second last year (it's a 20 year long project). The income from being a part of this project is $21,612.88 per annum, increasing annually by $562.31. What is the...

The government is considering purchasing some excavating equipment. It has a first cost of $68,000, will...

The government is considering purchasing some excavating equipment. It has a first cost of $68,000, will result in annual savings to the public of $20,000 per year, and will be sold for $15,000 at the end of its useful life. The useful life is 4 years, and the MARR is 4%. a. Determine the benefits to cost (B/C) ratio for this situation. Should the government invest in the excavating equipment? b. An intern working with the company came across some...

Tom is considering purchasing a £21,500 car. After five years, he will be able to sell...

Tom is considering purchasing a £21,500 car. After five years, he will be able to sell the vehicle for £7,500. Petrol costs will be £2,300 per year, insurance £700 per year, and parking £600 per year. Maintenance costs will be £950, rising by £400 per year thereafter. The alternative is for Tom to take taxis everywhere. This will cost an estimated £7,500 per year. Tom will rent a vehicle each year at a total cost (to year-end) of £700 for...

1. Suppose you put some money in a bank account. After one year, you have enough money to...

1. Suppose you put some money in a bank account. After one year, you have enough money to buy 3% more worth of goods than you can buy today. What statement must be true? A. Nominal interest rate is 3% B. Real interest rate is 3% C. Nominal interest rate exceeds real interest rate by 3% D. Inflation is 3% E. Inflation is negative ______ 2. Consumers in a certain region typically buy apples and bananas. If the price of apples were to rise dramatically, while the price of bananas stays...

You have been approached by an investor friend for some advice. She is considering purchasing bonds...

You have been approached by an investor friend for some advice. She is considering purchasing bonds in a new company that has recently started up and is producing a commodity. The company is a ring-fenced entity, which means the banking consortium which provided the debt only has a call on the plant assets, not the balance sheet of the parent companies involved. 60% of the capital cost of the plant was debt financed with 40% of the capital coming from...

You are interested to invest some money in the stock market, after careful research you have...

You are interested to invest some money in the stock market, after careful research you have short-listed Stock X and Stock Y as your potential purchase. Stock X is currently selling at $250 with an expected dividend of $15 and constant growth rate of 7%, while Stock Y is a preferred stock, currently selling at $100 with a $8 dividend paid each year. The required rates of return for both stocks are 10%. Answer on the basis of valuation of...

Atlantis Company sells computer components and plans on borrowing some money to expand. After reading a...

Atlantis Company sells computer components and plans on borrowing some money to expand. After reading a lot about earnings management, Andy, the owner of Atlantis, has decided he should try to accelerate some sales to improve his financial statement ratios. He has called his best customer and asked them to make their usual January purchases by December 31. Andy told the customers he would allow them, until the end of February, to pay for the purchases, just as if they...

Subjects