Payback analysis question

Would like to seek some help on the computation for payback analysis. I checked out Wallstreet Training's model (http://www.wallst-training.com/resources/WST_Payback_Period_Example.xls) and it used Undiscounted Net Cash Flow for computation.

With respect to an LBO model, can I check if my understanding is correct with regards to the Undiscounted Net Cash Flow:
1) The cash outflow in year 0 would be the PE firm's equity contribution (taken from the Sources and Uses section)?
2) The cash inflow in subsequent years would be taken from the cashflow statement (ending cash balance - beginning cash balance)?

Many thanks.

Career Resources

+171	How to stop feeling like shit for not making it in IB?	IB	64	3h
+124	If Tik Tok is forced to sell, what banks do you think would be involved in the deal?	IB	59	14h
+85	Updated LA Banking Scene (2024)	IB	61	14h
+40	Ranking banks that went under	IB	24	13h
+39	Burnt Out M&A ASO	IB	22	7h
+37	Relevance of A-Levels for U.K. London recruiting	IB	25	12h
+33	A strategy for SA applicants late to the game like myself	IB	17	10h
+32	Intern Ettiquette	IB	6	1h
+27	Series 79 Help / Tips to Pass The First Attempt	IB	11	3d
+23	What are hours like at BBs in London?	IB	47	1d

1	redever	99.2
2	BankonBanking	99.0
3	Betsy Massar	99.0
4	Secyh62	99.0
5	GameTheory	98.9
6	CompBanker	98.9
7	dosk17	98.9
8	kanon	98.9
9	Linda Abraham	98.8
10	numi	98.8

Payback analysis question

Trending Content