i want to know the formula we in excel file of this data

DCF Spreadsheet Valuation (Zero Terminal Growth) Pane: A: Expianution of Abbreviutions EBITDA w esmings before interest expente, taxes, depreciution, and arboritration EBIT = eamings before hterest expense and texos Ear m euinings before times NOI = net operating income nOPNT w not operaling profits atter inx Punol E; thitiul Growth Pariad Yeers 1. Pevienses 2. EBrOA 3. Depieciation 4. EBIT = NOI 5. Lass interest exponse 6. EDT =(4)(5) 7. Less: Tax 940% 8. Not income =(5)(7) 2. Add Interatt expense (1+7)=()(17) 10. NOPAT =(4)(17)(6)+(9) 10x. Aild: deprociation 106. Lesm capital expenditures 100. Lest changes in watkhg capital 11. Free cash low =( io )+(10x)(100)(10c) 12. Diseotent factor a 10.0% 13. Present whises of tree eash fow 14. Sum of inifial period present valuas Pand C: Termings Peviod 1. EBITOA of 2000 2. Free cash fow, 2000 3. Teminal peried dscourt rats 4. Tominat value in 2006 3. Present value faclor 1/(t+0.10)n 6. Present vatus of torrinal period Paned D: Cakuitafen of Equily Vatse 1. Sum of hitial period present viluses 2. Pretent value of teminal poriod 3. DCF anderpile vatue 4. Add axcens esth 5. Lesse debt 6. Equity vatuo 7. Number of ahares outstanding B. Valva per share 5. 502 8.3 .559 (1) 1,602 12 -12 13.347 0.62te \& A.2Be 5502 bass 58,790 0 2.000= E. 5.792 100