1) ZZZ Inc. has the following book and market values in millions. Book value Accounts payable 10 Accruals 15 Long-term debt 35 Preferred stock 5

I need guidence setting up a spreadsheet to answer the attached problem. The non bold part is my attempt to get it going but I keep getting stuck. Ideally I can get the steps to set up an excel sheet and be able to recreate answers to this type of problem.