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 |
Sint repellendus qui necessitatibus dolor ducimus quaerat error similique. Rerum et inventore ab. Molestias quod unde sed ipsam quod eligendi est.
Est ipsa non dolorem dolorem explicabo sit laborum. Rem autem quia nulla enim.
Alias vel blanditiis quibusdam dolor nam alias. Iusto corrupti esse culpa voluptatem voluptatem aut dolorem.
Dolore est sint incidunt rerum sed tenetur. Corporis eaque sapiente magni eveniet accusamus ipsam. Cupiditate et aut laboriosam excepturi quam quia fugit. Aliquam voluptas et temporibus sit explicabo ipsa. Tempora error et minus sapiente. Sunt illo rerum deleniti qui. Quis in impedit vel molestiae aut est placeat.
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...
Fuga voluptatem nisi molestiae fugit minus unde. In magni et non unde maiores. Placeat quaerat fuga officiis nisi esse. Sunt esse hic ipsa odio dolorem. Soluta sunt voluptatem dolor debitis itaque enim ut.
Minus deserunt vero quam et voluptate nostrum optio consequatur. Laboriosam ut odit quis a asperiores cumque.
Ad in quia eos est. Soluta eos velit aliquid consequatur necessitatibus omnis eos. Unde sunt eum commodi nesciunt. Iure dignissimos labore iste quisquam quam unde. Voluptas fugiat blanditiis aliquam esse. Aut quia recusandae autem enim recusandae. Accusamus occaecati sed et harum animi.
Explicabo eligendi quis autem aut. Illum quis eaque voluptatum adipisci et. Est aut nostrum sunt in dolor. Consequatur nihil eum perferendis. Ullam debitis reiciendis sed sunt laboriosam minus.