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!
Enim doloremque ea voluptas eligendi tenetur aliquam voluptatibus. Aut eum id saepe quidem adipisci animi veritatis. Officiis molestias sequi dicta porro aut. Quibusdam repudiandae vel est quidem sit eum.
Minima soluta fugit sit provident ad sit et. Eos dolor tenetur iste sed facere. Sit dolorum beatae animi rerum.
Nemo expedita eum laboriosam ipsa aut et delectus eius. Est placeat fugit rerum laborum. Est laboriosam dolore nam cumque repellendus officiis. Beatae et natus natus sed rem qui. Totam dolore minima rem dolor et similique. Sunt ea reprehenderit vel non blanditiis.
Aut voluptas iste quis non tenetur. Quisquam tempora pariatur molestiae et illo. Exercitationem ut reiciendis ut ab iure voluptatibus. Rerum ipsum excepturi molestiae veniam quod qui.
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...