Conduct a business valuation using Proforma I.S and Income Statement

Given information on the attached Excel spreadsheets, conduct a business valuation for Client, Inc. Calculate to answer the followings:
What is Cost of capital?
Company Value using Discounted Cash Flows (DCF)?
Company Value Residual Income Model (RIM)?
Conduct Sensitivity Analysis for DCF and RMI solutions.
Note, all the needed information has been provided.