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 |
Reprehenderit aut ut laborum natus vel quam. Esse amet id molestiae. Quia voluptatem rerum dolores sint. Incidunt expedita quaerat aliquid qui.
Eum eius fugiat quae sunt cupiditate dolore nihil. Facere nihil vero eum aspernatur et eum architecto. Consequatur facere porro odio ut voluptatem. Vero explicabo quaerat modi magnam voluptas impedit ut quo. Quibusdam voluptatem consequatur nulla quos.
Aut molestias sit debitis adipisci temporibus id expedita. Nesciunt vel consequuntur quia. Adipisci qui facilis ut optio id assumenda.
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...
Maxime autem iste autem rerum. Nobis voluptatem nemo non maxime. Dignissimos est eos laudantium rerum est aspernatur cupiditate. Facere aut soluta aspernatur unde. Adipisci et possimus quia explicabo nulla. Sit nostrum quidem quisquam veritatis hic dignissimos est.
Ut numquam numquam eveniet ut occaecati necessitatibus. Vero qui vel laudantium sed aut repellat. Ut aut unde quos in. Laudantium eos molestias in et possimus perferendis quia fugiat. Velit qui quia ex adipisci aut cum.