$15.00 Here are the answers for you (CHECKED)
- This tutorial hasn't been purchased yet.
- Posted on Apr. 26, 2009 at 11:28:33AM
A:
Preview: ... swers ...
The full tutorial is about 5 words long plus attachments.
Attachments:
Unit5_Finance_Doc.doc (130K) (Preview)
Bonds_4.xls (16K)
$15.00 Complete tutorial with explanations, answers, and tips on how to solve in Excel
- This tutorial hasn't been purchased yet.
- Posted on Apr. 28, 2009 at 01:10:54AM
A:
Preview: ... <br> Year Pmt PV(Pmt)<br> 1 80 73.4 <br> 2 80 67.3 <br> 3 80 61.8 <br> 4 80 56.7 <br> 5 80 52.0 <br> 6 80 47.7 <br> 7 80 43.8 <br> 8 80 40.1 <br> 9 80 36.8 <br> 10 1080 456.2 <br> 935.8 <br><br> Ans: 935.8 <br><br><br>2 YTM 11.50% <br> Rf 8.70% <br> Current Rf premium 1.40% <br> Current Rf 7.80% <br> New Bond Rate 9.200% <br><br> Ans: 9.200% <br><br><br>3 Par Value $1,000 <br> Coupon 8.5% <br> Current Yield 8.0% <br> Current Bond Price $1,062.50 The Current Yield is equal to the coupon payment divided by the bond price. So the bond price is the coupon payment divided by the current yield.<br> <br> Year Pmt PV(Pmt) <br> 1 $85.0 79.0 <br> 2 $85.0 73.4 <br> 3 $85.0 68.3 <br> 4 $85.0 63.4 <br> 5 $85.0 59.0 <br> 6 $85.0 54.8 <br> 7 $85.0 50.9 <br> 8 $85.0 47.4 <br> 9 $ ...
The full tutorial is about 424 words long plus attachments.
Attachments:
9 Questions - Finance.xls (71K)
$15.00 Unit_5 Finance
- This tutorial was purchased 1 time and hasn't been rated yet.
- Posted on Apr. 28, 2009 at 02:59:09AM
A:
Preview: ... pped to 6% <br>Rate = 6% <br>NPER = 19 <br>PMT = -70 <br>FV = -1,000 <br>PV =? <br>Solve for PV <br>PV = $1,111.58 <br> <br> <br>7) <br>PMT = 80 <br>PV = -1,025 <br>NPER = 9 <br>FV = 1,000 <br>Rate =? <br>Solve ...
The full tutorial is about 109 words long plus attachments.
Attachments:
Unit5_Finance_Doc.doc (152K) (Preview)
unit 5 - finance.xls (20K)
