Question

In: Finance

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.0753 = $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


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...
Annuity You are going to borrow money from the bank. But when considering your income, you...
Annuity You are going to borrow money from the bank. But when considering your income, you could afford to spend maximum 4000 euros per year as total repayments . Now, If the loan interest rate is 8% , what would be the maximum loan amount which you can borrow from the bank If the loan has duration of 5 years and the annual loan payment are calculated on the basis of annuity? Find also , what are the second year...
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...
A company is considering purchasing some new machinery. Collectively, the acquisition cost would be $3.72 million...
A company is considering purchasing some new machinery. Collectively, the acquisition cost would be $3.72 million plus a transportation charge of $94,0000 to get the machinery to the plant. To better engineer the production flow, $450,000 was spent to pay a production consultant. Special electrical service would be required, that and related (required) plant upgrades will be $124,000. Training of the production workers costing $34,000 is also necessary. An increase in inventory of $75,000 is needed, to supply these raw...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT