Question: Please show your work using EXCEL SPREADSHEET. Consider that you are 50 years old and considering early retirement. An insurance company offers to sell you

Please show your work using EXCEL SPREADSHEET.

Consider that you are 50 years old and considering early retirement. An insurance company offers to sell you the following Annuity in exchange for a portion of your IRA. The Annuity commits to paying you 2,000 per month for the next 25 years, with the first payment to be made beginning one month from today. Your price of the Annuity is $275,000 paid by you today from your IRA. The insurance company is rated AAA, but the investment is not FDIC insured like bank deposits.

What is the expected annual rate of return on this investment? From an investment point of view, do you consider this a good investment today? Explain why or why not.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

An ideal vapor-compression refrigeration cycle that uses refrigerant-134a as its working fluid maintains a condenser at 800 kPa and the evaporator at 20C. Determine this systems COP and the amount of...

Please show all work in Excel Spreadsheet! The CEO of St. Sebastian Health System, a moderate-sized hospital system in a mid-sized, Midwest city has hired you to help turn things around. The CFO is...

Please work using excel spreadsheet, and providing functions for review. Please and thank you, can you provide this quickly, greatly appreciate it. **The problems have already been worked, just need...

Ethan and Mary Varela are married. Ethan is employed as an engineer for a large multi-national company, and Mary operates a small, unincorporated business selling dental supplies and providing...

Please show the work in Excel Review the requirements of the Chapter 3 Mini-Case, parts b through j. Then apply those requirements to do an analysis of Starbucks. Do the analysis on the basis of the...

In this question, consider that you are 60 years old and considering retirement. An insurance company offers to sell you the following Annuity in exchange for a portion of your IRA: The Annuity...

Consider that you are 60 years old and considering retirement. An insurance company offers to sell you the following Annuity in exchange for a portion of your IRA: The Annuity commits to paying you...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

Safe Travel produces car seats for children from newborn to 2 years old. The company is worried because one of its competitors has recently come under public scrutiny because of product failure....

A manager of a store that sells and insta11s hot tubs wants to prepare a forecast for the number of hot tubs demanded during January , February, and March of next year. Her forecasts are a...

When evaluating a project's risk and return, which method provides a more accurate assessmentusing the Internal Rate of Return (IRR) or applying the Capital Asset Pricing Model (CAPM) to determine...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...