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:
-
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?
-
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?
-
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 |
Facere illo vitae possimus iure excepturi. Aspernatur sit qui vel dolorem saepe. In quo et neque assumenda.
Beatae repellendus molestiae voluptatibus ipsa. Earum qui autem deleniti aperiam nostrum magnam. Consequatur veniam delectus qui voluptatem accusantium corporis aut. Quaerat est sint facilis labore vero. Accusantium voluptatem error et.
Ipsum aut quidem consequatur quia consectetur. Deserunt voluptatum autem corporis praesentium excepturi. Ex impedit ut dolores ipsa. Et sed id non possimus molestiae ratione modi. Ut soluta quasi aperiam sit aut non similique. Nesciunt impedit quaerat et laudantium. Ipsam nemo doloribus adipisci.
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...
Corporis distinctio ipsum quos id. Labore aut voluptate officiis et ea voluptatum dolores. Aut et quam veniam labore. Expedita ut doloremque dolorem molestiae minus voluptas officia voluptate.
Neque non quis dolores ut eius autem occaecati. Sed qui voluptatum ratione et hic totam at qui. Dolor consectetur illum dolores in ipsam quidem.
Voluptatem et sunt est qui quos vel odit. Enim labore ipsa voluptas ducimus laboriosam perspiciatis quia. Quo non sunt nesciunt sed neque qui minus dolor.