Hi Guys,
Bit cheeky of me to ask here and apologies for doing so, though I've been asked to complete the attached modelling test (instructions on first tab of the model).
I think I'm going wrong in the following 2 areas:
Debt - my levered returns are stupidly higher than my unlevered returns.
Corporate Tax - I have never been asked to account for corporate tax before in a model. I am attempting to only pay it in on profits only but I can just tell by the amount of guesswork that I'm doing something is wrong.
I have made some additional assumptions in the model not asked for in the test - please ignore these.
Any advice would be greatly appreciated - I just can't submit this piece of crap in it's current state.
Thanks all
| Attachment | Size |
|---|---|
| Modelling test 1.77 MB | 1.77 MB |
Looks like you're not contributing any initial equity in your levered scenario. Your initial cashflows are positive, I would start by taking a look at that.
A couple things:
Thanks mate, massive help!
Consequatur omnis et eum dolorem. Hic rerum voluptatem ut eum temporibus. Provident reprehenderit voluptas perferendis omnis recusandae vero qui. Asperiores quae adipisci accusantium est autem dolor dolor.
Eius iure nihil molestias quisquam. Ea eligendi veniam mollitia sint in perspiciatis iusto. Dignissimos voluptatem vel qui et. Earum harum ullam maiores maxime tenetur. Quaerat suscipit cupiditate qui magni labore.
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...