Need assistance calculating the following utilizing excel

• Weight of debt
• weight of equity
• Cost of debt (using the YTM approach)

All for July 17, 2013

The balance sheet has been provided

Exhibit 5 Royal Mail ple: Cost of Capital Royal Mail Consolidated Balance Sheet (Reported as of the end of March in millions of GBP) Source: Royal Mail Annual Report 2015 Exhibit 5 Royal Mail ple: Cost of Capital Royal Mail Consolidated Balance Sheet (Reported as of the end of March in millions of GBP) Source: Royal Mail Annual Report 2015