- Please Solve This Problem Using Excel Spreadsheet To Show The Workings 1 (81.11 KiB) Viewed 19 times
Please solve this problem using excel spreadsheet to show the workings
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Please solve this problem using excel spreadsheet to show the workings
Please solve this problem using excel spreadsheet to show theworkings
Jiminy's Cricket Farm issued a 30-year, 7 percent semiannual bond 3 years ago. The bond currently sells for 93 percent of its face value. The company's tax rate is 22 percent. What is the pretax cost of debt? What is the aftertax cost of debt? Settlement Maturity Coupon rate Price (% of par) Redemption value (% of par) Payments per year Tax rate 01/01/00 01/01/27 7% 93 100 2 22%
Jiminy's Cricket Farm issued a 30-year, 7 percent semiannual bond 3 years ago. The bond currently sells for 93 percent of its face value. The company's tax rate is 22 percent. What is the pretax cost of debt? What is the aftertax cost of debt? Settlement Maturity Coupon rate Price (% of par) Redemption value (% of par) Payments per year Tax rate 01/01/00 01/01/27 7% 93 100 2 22%