6_13 Solution - =PV(3%,40,-350,-10000) $11,155.74 Cell...

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

View Full Document Right Arrow Icon
Chapter 6 Question 13 Data FV ($10,000) nper 40 coupon rate 3.5% market rate 3.0% PMT ($350) Calc Excel Formula: =PV(rate,nper,pmt,fv,type) Numerical Formula Solution:
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: =PV(3%,40,-350,-10000) $11,155.74 Cell Reference Formula Solution: =PV(B11,B9,B12,B8) $11,155.74...
View Full Document

Ask a homework question - tutors are online