Question: 7. (optional) The Model for Reference in the Excel file includes costs of goods sold but not selling, general, and administrative (SG&A) expenses. Suppose that

7. (optional) The "Model for Reference" in the Excel file includes costs of goods sold but not selling, general, and administrative (SG&A) expenses. Suppose that the firm has $200 of these expenses each year, irrespective of the level of sales. (a) Change the model to accommodate this new assumption. Show the resulting profit and loss statements, balance sheets, the free cash flows, and the valuation. (b) Do a data table in which you show the sensitivity of the equity value to the level of SG&A. Let SG&A vary from $0 per year to $600 per year
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
