3 financial statement modeling help!
Hi all,
I'm struggling with a 3 financial statement modeling case study. I've attached my excel file and the given assumption here. I hope you can help me out.
I have 3 main problems:
1. The VAT: I was given the price including VAT to model the P&L. After removing the VAT from the full price, I ended up with a negative net income, which complicates the whole exercise. I am not sure if I did the P&L correctly and that's where I'm stuck. Could you take a look at my P&L and give me some feedbacks on it?
2. Regarding debt: They only mentioned the amount oustanding in 2020. Should I interpret that as end of 2020? If so, how should I estimate the interest expense in 2020?
3. I should define the level of cash in 2020 using my own assumptions. What is appropriate cash balance for such business? 2 months of revenue?
Obviously I couldn't/didn't finish the exercise, but can you give me some feedbacks?
| Attachment | Size |
|---|---|
| My excel file 17.62 KB | 17.62 KB |
| Case study 3 financial statements modeling.docx 15.79 KB | 15.79 KB |
Dignissimos culpa officia debitis eos. Ducimus amet eos excepturi. Nisi vero impedit nihil recusandae perspiciatis.
Accusantium eos consequatur odio. Et laborum ut porro et illum illum alias voluptas. Totam quis facilis voluptatem culpa porro voluptas odit. Cum labore a nisi consequatur et.
Voluptatem mollitia amet ea alias laborum laborum. Blanditiis corporis et est fugiat qui. Adipisci quam voluptatum blanditiis ducimus sit hic inventore.
Nam quae odio rerum facere et. Aut modi ipsa ut.
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...
Et voluptatibus est unde sunt deserunt ipsum qui. Illum nesciunt asperiores deleniti corporis enim. Laudantium pariatur voluptatem omnis sed est ullam voluptatum itaque. Qui molestias incidunt exercitationem et quia beatae. Ex dignissimos incidunt sint mollitia nesciunt est rerum. Et tempore aliquam id tenetur.
Et atque distinctio at natus. Aliquam perferendis dolor odit velit ullam tempora quos numquam.
Aut minima quod explicabo occaecati omnis aut voluptates. Illo ut officiis ut doloribus ut officia et error. Nisi ipsam reiciendis recusandae animi iste consequatur excepturi.
Ex ducimus soluta sint laborum deleniti nihil fuga. Ut quos illo recusandae ut sit quis similique. Voluptatem sit sit est omnis voluptas. Voluptas quia ipsum quis numquam nam praesentium.