PF BS Adjustments question

Hi everyone I am currently interviewing for IBD and I am trying to learn how to adjust a BS PF for a M&A transaction.

Any help will be much appreciated!!

Thanks so much!

p.d I tried uploading a picture/excel but I dont have enough bannanas

Assumptions

Seller EBITDA 50
Multiple 5,0x
Purchase Price 250,0
Less: Net Debt (141,0)
equity value 109,0

BV Assets (61,5)
PPA 47,5

Write up Assets 15,0
Write off existing Goodwill (30,0)
DTL created 4,5
Goodwill created 58,0

Buyer Tax 30%
PP&E % Write-up 10%

S&U

Sources
Cash on Seller BS 9,0
Debt Assumed 150,0
Issued Debt (RCF) 70,0
Cash on Buyer BS 30,0
Total Sources 259,0

Uses
Equity 109,0
Debt Assumed 150,0
Total Uses 259,0

Buyer Balance Sheet
PP&E 500,0
Goodwill 100,0
Other 50,0
Total Non-current Assets650,0

A/R 60,0
Inventory 40,0
DTA 20,0
Other 10,0
Cash 60,0
Total Current Assets190,0

Total Assets840,0

RCF 300,0
Sub Debt 200,0
Total Non-Curent Liabilities 500,0

A/P 100,0
DTL 5,0
Total Curent Liabilities 105,0

Total SE 235,0

Total Liabilities & SE 840,0

Seller BS
PP&E 150,0
Goodwill 30,0
Other 15,0
Total Non-current Assets 195,0

A/R 18,0
Inventory 12,0
DTA 6,0
Other 3,0
Cash 9,0
Total Current Assets 48,0

Total Assets 243,0

RCF 90,0
Sub Debt 60,0
Total Non-Curent Liabilities 150,0

A/P 30,0
DTL 1,5
Total Curent Liabilities 31,5

Total SE 61,5

Total Liabilities & SE 243,0