6_12 Solution - $4,673.53 Cell Reference Formula Solution:...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 6 Question 12 Data FV ($5,000) nper 30 coupon rate 6.0% market rate 6.5% PMT ($300) Calc Excel Formula: =PV(rate,nper,pmt,fv,type) Numerical Formula Solution: =PV(6.5%,30,-300,-5000)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $4,673.53 Cell Reference Formula Solution: =PV(B11,B9,B12,B8) $4,673.53 Bonds issued 10,000 Total Proceeds $46,735,331...
View Full Document

This note was uploaded on 02/15/2012 for the course LABOR STUD 575:385 taught by Professor Lawrence during the Fall '10 term at Rutgers.

Ask a homework question - tutors are online