PRIN.OF CORPORATE FINANCE >BI<
PRIN.OF CORPORATE FINANCE >BI<
12th Edition
ISBN: 9781260431230
Author: BREALEY
Publisher: MCG CUSTOM
bartleby

Videos

Textbook Question
Book Icon
Chapter 2, Problem 38PS

Annuities Use Excel to construct your own set of annuity tables showing the annuity factor for a selection of interest rates and years.

Blurred answer
Students have asked these similar questions
Calculate the future value of an​ annuity, with case A being an ordinary annuity and case B being an annuity due.   SEE PIC for NUMBER DETAILS
Using a spreadsheet generate your own set of Discount and AnnuityTables for, say, all discount rates between 1% and 20% (at 1 percentagepoint intervals) and for time periods 1 to 30 (at one time periodintervals), as well as time periods 50 and 100. You should generate thesetables by inserting the numbers for the time periods in the first columnof each row and the discount rates in the first row of each column, andthen inserting the appropriate formula into one cell of the table – year 1at 1% - and then copying it to all other cells in the matrix. (Hint: Do notforget to anchor the references to periods and discount rates using the“$” symbol.)Answer: Write the discount formula into spreadsheet as shown below and then copyacross 20 columns (headed 1% through 20%) and down 50 rows (headed 1 to 50).
Present value of an annuity   Consider the following case.  ​(Click on the icon located on the​ top-right corner of the data table below in order to copy its contents into a​ spreadsheet.)   Amount of annuity Interest rate Period​ (years)   ​$26,000 9​% 4   a.  Calculate the present value of the annuity assuming that it is ​(1) An ordinary annuity. ​(2) An annuity due. b.  Compare your findings in parts a​(1) and a​(2). All else being​ identical, which type of annuity—ordinary or annuity due—is ​preferable? Explain why.

Chapter 2 Solutions

PRIN.OF CORPORATE FINANCE >BI<

Ch. 2 - Prob. 3PSCh. 2 - Prob. 4PSCh. 2 - Opportunity cost of capital Which of the following...Ch. 2 - Perpetuities An investment costs 1,548 and pays...Ch. 2 - Growing perpetuities A common stock will pay a...Ch. 2 - Prob. 8PSCh. 2 - Present values What is the PV of 100 received in:...Ch. 2 - Continuous compounding The continuously compounded...Ch. 2 - Compounding intervals You are quoted an interest...Ch. 2 - Future values and annuities a. The cost of a new...Ch. 2 - Prob. 13PSCh. 2 - Present values A factory costs 800,000. You reckon...Ch. 2 - Present values A machine costs 380,000 and is...Ch. 2 - Opportunity cost of capital Explain why we refer...Ch. 2 - Present values A factory costs 400,000. It will...Ch. 2 - Present values and opportunity cost of capital...Ch. 2 - Prob. 19PSCh. 2 - Prob. 20PSCh. 2 - Annuities David and Helen Zhang are saving to buy...Ch. 2 - Annuities Kangaroo Autos is offering free credit...Ch. 2 - Present values Recalculate the NPV of the office...Ch. 2 - Prob. 24PSCh. 2 - Prob. 25PSCh. 2 - Continuous compounding How much will you have at...Ch. 2 - Perpetuities You have just read an advertisement...Ch. 2 - Compounding intervals Which would you prefer? a....Ch. 2 - Compounding intervals A leasing contract calls for...Ch. 2 - Annuities Several years ago, The Wall Street...Ch. 2 - Prob. 31PSCh. 2 - Prob. 32PSCh. 2 - Prob. 33PSCh. 2 - Prob. 34PSCh. 2 - Prob. 35PSCh. 2 - Amortizing loans Suppose that you take out a...Ch. 2 - Prob. 37PSCh. 2 - Annuities Use Excel to construct your own set of...Ch. 2 - Declining perpetuities and annuities You own an...
Knowledge Booster
Background pattern image
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Personal Finance
Finance
ISBN:9781337669214
Author:GARMAN
Publisher:Cengage
What is an Annuity? Are Annuities a Good Investment? Basics of an Annuity, a Whiteboard Animation; Author: Learn to invest;https://www.youtube.com/watch?v=Wq7nq8Gx78w;License: Standard YouTube License, CC-BY