Questions Uploads

Principles of Corporate Finance Main Menu Tenth Edition Chapter 3 Question 3

   
In February 2009 Treasury 6s of 2026 offered a semiannually compounded yield of
3.5965%. Recognizing that coupons are paid semiannually, calculate the bond’s price.
           
Enter the values in blue colored cells
Chapter 3
Question 3
  
  
Student Name:  
Course Name:   
Student ID:   
Course Number:   
Use Excel’s PRICE function to find the value of the bond under the following assumptions:
Settlement Date 
Maturity Date 
Coupon Rate 
YTM 
Price For help with Excel’s PRICE function
 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

Principles of Corporate Finance 10th Edition

Principles of Corporate Finance
Tenth Edition
Instructions
Navigating the Workbook
Entering your information
Entering data
Printing
Help
Navigating the Workbook
Each chapter of the spreadsheets to accompany Principles of Corporate Finance 
contains links to help you navigate the workbook.  These hyperlinks help you 
move around the workbook quickly.  The Main Menu contains links to each 
problem from the chapter that contains the Excel icon.  From the Main Menu, 
click on the question you wish to complete.  You can always return to the main 
menu by clicking on the link located in the upper right corner of each worksheet.  
You can move quickly around an Excel workbook by selecting the worksheet tab 
at the bottom of the screen.  Each worksheet in an Excel workbook will have its own
tab.  In the spreadsheets to accompany Principles of Corporate Finance, you will
see a separate tab for each problem, along with the Main Menu, Instructions and
Help Topics worksheets.
Another way to move quickly around an Excel workbook is by using the following 
keyboard shortcuts: 
CTRL+PAGE DOWN: Moves you to the next sheet in the workbook. 
CTRL+PAGE UP: Moves you to the previous sheet in the workbook. 
Entering your information
For each question, you will see the following lists and boxes:
Student Name:   
Course Name:   
Student ID:   
Course Number:   
Enter your information in these cells before submitting your work.
Entering data
To enter numbers or text for these questions, click the cell you want, type the data and 
press ENTER or TAB.  Press ENTER to move down the column or TAB to move across the row.  
For cells or columns where you want to enter text, select “Format,” and then “Cells” from 
Excel’s main menu at the top of your screen.  Select the “Number” tab and then “Text” 
from the category list.
Printing
To print your work, select “File,” and then “Print Preview” from Excel’s main menu at the top 
of your screen.  The print area for each question has been set, but be sure to review 
the look of your print job.  If you need to make any changes, select “Setup” when
you are previewing the document. 
Help
There are two sources of help throughout these spreadsheet templates.   First, you will find comments
in specific cells (highlighted in red) providing tips to what formula or function is needed to complete 
the problem.  Second, you will find links to Microsoft Office’s online help page when an Excel Function 
is needed to complete the problem.
 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

Corporate Finance.Week 1 Assignment

Read Chapters 3, 5, 6

Pay special attention to the NPV, IRR, & Annuities topics.  It might be beneficial for you to do a quick review of Chapter 2 if you are a bit rusty with PV concepts.

Answer the eight (8) problems in the attached Excel file.  Each problem is worth 10 points.  Submit the file via Blackboard by clicking on the title.

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

Corporate Finance.Week 1 Assignment

Read Chapters 3, 5, 6

Pay special attention to the NPV, IRR, & Annuities topics.  It might be beneficial for you to do a quick review of Chapter 2 if you are a bit rusty with PV concepts.

Answer the eight (8) problems in the attached Excel file.  Each problem is worth 10 points.  Submit the file via Blackboard by clicking on the title.

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"