E7-11. Present Value, Note Payable Prices. Wiz Khalifa would like to invest in an $80,000 face value note payable. The note has a 12-year term and pays 10% annual interest at the end of each year....


how to solve this in excel? I got for


a)








$251,074.27

b)








$311,678.08

c)








$713,288.04


What am I doing wrong?


E7-11. Present Value, Note Payable Prices. Wiz Khalifa would like to invest in an $80,000 face value note payable.<br>The note has a 12-year term and pays 10% annual interest at the end of each year. Interest is compounded<br>annually.<br>a. What would he pay for the note if he wanted the note to yield 10%?<br>b. What would he pay for the note if he wanted the note to yield 12%?<br>c. What would he pay for the note if he wanted the note to yield 20%?<br>

Extracted text: E7-11. Present Value, Note Payable Prices. Wiz Khalifa would like to invest in an $80,000 face value note payable. The note has a 12-year term and pays 10% annual interest at the end of each year. Interest is compounded annually. a. What would he pay for the note if he wanted the note to yield 10%? b. What would he pay for the note if he wanted the note to yield 12%? c. What would he pay for the note if he wanted the note to yield 20%?

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here