I have a mini case study. It is in Finance. I mostly just need help with the calculations to make sure I am doing them correctly. A template was supplied. I have done half and am now stuck. I am not able to attach the assignment here for some reason. I will try a copy/paste but I will have to send the template separate I believe.:

PAMPARV, INC.Evaluation of an Investment OpportunityPampaRV, Inc., a publicly traded firm, is considering the acquisition of ChicoClothing Company (CCC) for a price of $12 per share. CCCis a private company that specializes in manufacturing clothing, shoes and accessories for beauty pageant contestants. The RV business is slow, and Pampas CFO believes that the acquisition of CCCwill help to improve overall profitability and provide much needed cash flow. Pampas has 500,000 shares of common stock outstanding, currently tradingat $9.75 per share. The book value ofthe common stock is $5 per share. Pampaalso has bonds with a market value of $3,500,000 and a yield to maturity of 3.4%. Based on current market valuations, Pampais currently achieving its target debt to equity ratio. Pampas equity beta is 0.80.CCCis a private firm that was founded ten years ago by four sisters, who have a combined 100 years of experience in the beauty pageant business as competitors, judges, and coaches. CCCs cost of goods sold (COGS) is expected to be 38% of sales revenues, and selling, general and administrative (SG&A) expenses are expected to be 12% of revenues. These estimates are in line with the firms historical performance, which is expected to continue for the foreseeable future. The firm is 100% equity financed and has 100,000 shares of common stock outstanding. Its equity beta is estimated to be 1.353.CCChas experienced rapid growth over the last ten years. However, your analysis of industry structure suggests that competitionin the beauty pageant clothing and accessories market is likely to increase in the next few years. Thus, you forecast that the perpetual growth rate for free cash flows after five years will be a modest 1.5% per year.Your team has been hired as consultants to PampaRV to evaluate the proposed acquisition of CCC. Tables 1 and 2 below contain additional data that you have collected during your research. The corporate tax rate is 40% for all firms.Table 1Forecast Data for ChicoClothing CompanyYear 1Year 2Year 3Year 4Year 5Sales Revenue300,000335,000375,000410,000575,000Investment in CapEx and NWC18,00025,00040,00050,00065,000Depreciation115,00030,00040,00052,00060,0001The depreciation numbers listed above are not included in COGS percentage estimates.Table 2 Market DataCurrent yield to maturity on 30 year treasury bonds2.50%Estimate of expected average return on the S&P 500 over the next 30 years7.50%2Guidelines for Written Case ReportPrepare a report intended for the board of directors of PampaRV that contains a valuation of CCCand a recommendation of the potential value creation if CCCis acquired. Your report should contain answers to the following questions.1)What is thevalue of ChicoClothing Company? Assume that your valuation is performed today at Year 0, and that the revenues shown in Table 1 are end-of-year yearforecasts.2)Suppose PampaRV offers to pay $12 for each of CCCs outstanding shares. If the market fully impounds this information, what will be the new price per share of Pampas commonstock?3)What is the most that Pampashould pay for CCC?Why?4)Estimate the beta of the combined entity (Pampa+ CCC) after the merger. Based on your answer, will the merged firms cost of capital to be higher or lower than Pampas current cost of capital? Explain your answer. Hint: Firm beta is a value-weighted average of individualbetas.You may use the posted Case Template as a guide but are also free to create your own spreadsheet from scratch if you prefer.Structure and Content of Report: Your written report should adhere to the following format:1.Introduction2.Analysis3.Conclusion4.AppendixThe introduction sets the stage for the work to follow and should consist of one paragraph describing the key issue(s) that your analysis addresses.The text of your analysis will constitute the bulk of the written presentation. Here you will explain the process you took to develop responses to the questions above and report the results. Write in clear, concise, and complete sentences, and avoid the use of bullet points or numbered lists. Do not repeat thequestions above in the text of your report; instead, combine questions in paragraphs as appropriate and begin each paragraph with a relevant transition statement. Include in appendices all supplementary figures, tables, and any other data necessary to support the analysis. Be sure to reference informationin appendices in the text of yourreport.The conclusion should be one paragraph that summarizes the key results of the analysis and your recommendation, whereappropriate.Format of Report: The text of your report should not exceed fourpagesof Times New Roman 11-point font, double-spaced text, with 1-inchmargins at the sides, top, and bottom of the page. The page limit does not include appendices, which should be at the end of your written