I've tried to come up with similar exercise as official Wall Street Prep Course. This video will teach you basics of Valuing Company as LBO Target. All this is done on excel spreadsheet which you can find on the link bellow:



Download excel file, try to do it yourself, while you pause the video and then follow it to make sure you got it right.