Here is theValuation Spreadsheetfor this weeks assignment. You can use these models to value your project company. My project company is Walmart.

Page 1 INPUTS FOR VALUATION Current Inputs Enter the current revenues of the firm = Enter current capital invested in the firm = Enter the current depreciation = Enter the current capital expenditures for the firm = Enter the change in Working Capital in last year = Enter beginning shareholder's equity Enter the value of current debt outstanding = Enter the number of shares outstanding = $12,406 $10,000 (Book Value of Equity + Book Value of Debt) $233 $298 (you might try an average of the prior 3 years) $115 (current assets - current liabilities for the most recent year) - (current assets - current liabilities for the prior year) $20,000 $10,000 1,500.00 High Growth Period Your Inputs Enter the growth rate in revenues for the next 5 years = 25.00% What will all operating expenses be as a % of revenues in the fifth year? 70.00% (Operating expenses include depreciation: This is equal to (1-Pre-tax Operating Margin)) How much debt do you plan to use in financing investments? Enter the growth rate in capital expenditures & depreciation 50% (you might try an average of the prior 3 years) 25.00% (you might try an average of the prior 3 years) Enter working capital as a percent of revenues 7.50% (current assets - current liabilities) / Revenues Enter the tax rate that you have on corporate income 36.00% (you might try an average of the prior 3 years) What beta do you want to use to calculate cost of equity = 1.25 Enter the current long term bond rate = 6.50%