What rate of return is built into the annuity

Assignment Help Financial Management
Reference no: EM131464451

Your girlfriend just won the Florida lottery. She has the choice of $15,000,000 today or a 20-year annuity of $1,050,000, with the first payment coming one year from today. What rate of return is built into the annuity? How would I find the answer using excel fucntions?

Reference no: EM131464451

Questions Cloud

Compute the amount that the couple deposited into account : Compute the amount that the couple deposited into the account when they opened it.
What is the net present value of the parking garage : The city of San Diego is deciding whether or not to convert a local park into a parking garage. What is the net present value of the parking garage?
Force sensors based on capacitive sensing technology : Allied Transistor is a company that makes load/force sensors based on capacitive sensing technology.
Interest rate swaps : "In March 2011, we entered into an interest rate swap that expires on March 1, 2016, with notional amount of $500 Million, accounted for as fair value hedge,
What rate of return is built into the annuity : Your girlfriend just won the Florida lottery. What rate of return is built into the annuity?
The price quotations of treasury bonds : The price quotations of treasury bonds in the wall street journal show an ask price of 104:32 and a bid price of 104:16.
Certificate of deposit from a bank : certificate of deposit (CD) from a bank with a three-year maturity and a fixed interest rate.
Studying for the next accounting examination : You and several classmates are studying for the next accounting examination.
Calculate the additional funds needed for company : Company XYZ is projecting its activities for the upcoming year. calculate the Additional Funds Needed (AFN) for Company XYZ next year.

Reviews

Write a Review

Financial Management Questions & Answers

  Make semiannual payments-what is the current bond price

Grohl Co. issued 9-year bonds a year ago at a coupon rate of 9 percent. The bonds make semiannual payments. If the YTM on these bonds is 8 percent, what is the current bond price?

  Calculate cash conversion cycle

Working Capital Cash Flow Cycle Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $140,000 (all on credit), and it earned a net profit of 6%. Calculate Strickl..

  Uses the internal rate of return method to evaluate projects

Flynn, Inc. is considering a four-year project that has an initial outlay or cost of $80,000. The future cash inflows from its project are $40,000, $40,000, $30,000, and $30,000 for years 1, 2, 3 and 4, respectively. Flynn uses the internal rate of r..

  Journalize the transactions of zach talbot

Record (journalize) transactions- Journalize the transactions of Zach Talbot, Architect. Include an explanation with each journal entry.

  Which of the cash flows are incremental cash flows

Which of the following cash flows are incremental cash flows that need to be considered when evaluating a capital project?

  Considered capital budgeting decision

Which of the following would NOT be considered a capital budgeting decision? The equivalent annual cost method is most appropriate in which of the following situations?  If a project has a profitability index greater than 1,

  Elements of a contract the paper must be four to five pages

elements of a contract. the paper must be four to five pages excluding the title page and references pages and

  To achieve your desired contract negotiation results you

1. fixed price cost reimbursable and time and material contracts are all potential agreements that could be reached

  Income appreciation fund current assets with market value

The World Income Appreciation Fund has current assets with a market value of $4.6 billion and has 160 million shares outstanding. What is the net asset value (NAV) for this mutual fund? The Madura HiGro Fund has a net asset value of $47 per share. It..

  The terms of the loan call for monthly payments

Your spouse needs a car and you believe you can afford no more than $350 a month for a 5-year car loan. If the interest rate on this loan is 5% percent, what is the maximum you can afford to borrow to purchase this car? You are borrowing $19,500 to b..

  Financial performance and the sustainability of the company

Is there any trade-off between the financial performance and the sustainability of the company?".

  Identical in all respects except capital structure

Consider two firms A and B that are identical in all respects except capital structure. Firm A has $160 million in equity outstanding and $40 million in bonds outstanding. Suppose an investor has an $8 million investment in the stock of firm A. What ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd