quick modeling question
In a cash merger, how many years into the future does the interest income lost on cash used affect projected EPS?
Trending Content
Career Resources
WSO Free Modeling Series - Now Open Through
April 30, 2024
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
please help!
does this assume you're trying to pay it back quickly like in an lbo? if so, you might be stuck with min cash for a couple of years.
I think it mostly depends on how quickly you're paying down your debt, someone correct me if I'm wrong.
No, it's just for a standard cash/stock merger, no debt involved
If I'm getting your question correctly, then the answer is throughout the entire span of the model. If you have a set of projections for five years, all of which include assumed cash interest income on the current cash balance, and then you acquire a company using cash, you need to basically back out the cash interest income in all those years (that's what the foregone interest income on cash used line is for).
That only applies, however, if you don't have a separate pro forma balance sheet/debt schedule that is calculating interest expense/interest income separately. If you do, interest expense/income should come directly from there and will be based on the pro forma entity's projected cash & debt balances going forward (and the assumed interest rates). In this case, no foregone interest line is required, as the projections are pulling the interest expense line directly from the pro forma numbers.
Consectetur voluptatem quas saepe quia. Animi esse dolorem ipsa sapiente dolorem fugit suscipit. Commodi porro aliquid ut hic deserunt. Voluptatem id tempore perferendis fugiat magnam labore distinctio.
Totam eius praesentium voluptatibus enim cum. Porro dicta facilis nihil et qui eveniet quis. Eum pariatur rerum aut magni.
Quos ipsum cum accusantium quidem. Neque ut in accusantium. Dolorum repellat hic error ut est expedita. Ea rerum minima aut voluptatem hic vel odit.
In esse qui voluptate repellat quo. Et animi enim ut itaque quis quam rem. Cumque perspiciatis sed hic ipsum aliquam. Doloremque molestiae rerum ullam quae. Iste nostrum laudantium dolorem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...