Corporate Finance - Problems to be solved in excel

profileCHEGG
solved2.xlsx
Home>Business & Finance homework help>Corporate Finance - Problems to be solved in excel

Sheet1

1 Price 1,050.00
Coupon 40.00
Face value 1,000.00
Time 24.00
Cost of existing debt 7.37%
Flotation cost 5.00%
Cost of new debt 7.75%
2 Par 1,000.00
Interest payment 70.00
Time 20.00
Rate 8.00%
Price $901.82