In this assignment, you will be calculating a company's weighted cost of capital using financial information taken from the company's liabilities and net worth accounts. 1. Open the Excel Spreadsheet captioned Weighted Cost of Capital located here and complete the top section: a. Weight, b. Rate, c. Adjusted Rate, d. Weighted Rate, and e. Total Weighted Cost of Capital (WAC). 2. Use the financial information provided in the middle section to perform the calculations, and the general expression of WAC in the lower section as a guide