Question: 1. Here's a basic exercise that will help you understand what's going on in the modeling of financial statements. Replicate the model in section 5.1.

1. Here's a basic exercise that will help
1. Here's a basic exercise that will help you understand what's going on in the modeling of financial statements. Replicate the model in section 5.1. That is, enter the correct formulas for the cells and see that you get the same results as the book. (This turns out to be more of an exercise in accounting than in finance. If you're like many financial modelers, you'll see that there are some aspects of accounting that you've forgotten!) 2. The model of section 5.1 includes costs of goods sold but not selling, general, and admin- istrative (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. 3. Suppose that in the model of section 5.1 the fixed assets at cost for years 1-5 are 100% of sales (in the current model, it is net fixed assets which are a function of sales). Change the model accordingly. Show the resulting profit and loss statements, balance sheets, and free cash flows for years 1-5. (Assume that in year 0, the fixed assets accounts are as shown in section 5.2. Note that since year 0 is given-it is the current situation of the firm, whereas years 1-5 are the predictions for the future there is no need for the year 0 ratios to conform to the predicted ratios for years 1- 5.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!