Question: i need help with this fin ace excel spreadsheet attached. thanks Balance sheet OA Financial Assets Total Asset Value of Operation (Enterprise value)0=Net Operating Assets0+Present

 i need help with this fin ace excel spreadsheet attached. thanks

i need help with this fin ace excel spreadsheet attached. thanks

Balance sheet OA Financial Assets Total Asset Value of Operation (Enterprise value)0=Net

Balance sheet OA Financial Assets Total Asset Value of Operation (Enterprise value)0=Net Operating Assets0+Present value of expected economic profits (EVA) VoO0=NOA0+EVA1/(1+WACC)^1+EVA2/(1+WACC)^2+... Economic profit valuation for Nike, Inc Required return for operations is 9.1% (amount in millions of dollars expect per-share numbers) Please complete the estimate of Nike stock value by filling in the numbers in colored cells. Required return for operations is 9.1% (amount in millions of dollars expect per-share numbers Operating income (OI) Net operating assets (NOA) Economic Income (EVA) Discount rate (1.091^t) PV of EVA Total PV of EVA Terminal Value of EVA (TV) PV of TV Enterprise Value (Value of Operation) Book Value of Net Financial Asset (Financial Asset-Financial obligation) Value of common equity Value per share (on 484 milliion shares) The TV calculation (growth rate g=4%) TV=(1526*1.04)/(1.091-1.04)=31,118 PV of TV=31,118/1.417=21,961 EVA=NOPAT-NOA*WACC OL Financial Obligations Equity Total Liablity+Total Equity NOA=OA-OL NFA=Financial Asset-Financial Liability d economic profits (EVA) 2010A 2011E 2012E 2013E 2014E 1,950 2,042 2,102 2,146 5,514 6,287 6,549 6,814 7,089 1,448 1,470 1,506 1,526 31,118 4,371

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!