6_14 Solution - =PV(5%,20,-4000,-100000) $87,537.79 Cell...

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

View Full Document Right Arrow Icon
Chapter 6 Question 14 Data FV ($100,000) nper 20 coupon rate 4.0% market rate 5.0% PMT ($4,000) 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(5%,20,-4000,-100000) $87,537.79 Cell Reference Formula Solution: =PV(B11,B9,B12,B8) $87,537.79...
View Full Document

Ask a homework question - tutors are online