how to solve in excel

FOMO company is looking to buy YOLO and used DCF valuation to value YOLO. The industry forward EV/Earnings ratio is 20X. YOLO has $4000 in debt, 200 shares, and is growing at 20%. What is YOLO's value per share given the information below? WACC 7% Current Assets Current Liabilities Net Income Depreciation Interest Xp Change NWC Capex Year 0 1 2 3 3 0 1 0 7,000 2 3 NWC 5,000 6,000 10,000 7,000 10,000 Free Cash Flow