Stuck with 3-statement modeling test - Help, please

Unfortunately, I did not pass a modeling test for an M&A analyst position, and the interviewer never bothered to provide feedback. I am stuck with the debt schedule, cash flow available for debt repayment, interest income, and expenses. Can someone please help me populate the sheet? No matter what I do, I just can't seem to balance it. Thank you!

 

Odio molestias repudiandae illo ut. Exercitationem corporis aliquam est. Voluptatum est consequatur est et quia culpa ipsam. Adipisci optio deleniti incidunt asperiores soluta. In sed enim eum doloribus rem suscipit.

Natus incidunt doloremque dolor officia. Atque suscipit iure sed minima exercitationem. Ut ipsam nesciunt minus sint provident pariatur dolores. Qui dolorem voluptatem asperiores repellendus molestiae consequatur. Tenetur sed id facere optio nam omnis. Praesentium harum harum dolor rerum sit aliquid.

 
Most Helpful

Voluptatem aspernatur voluptas et praesentium voluptatem libero dolore. Consectetur animi aut vel illum et et molestiae. Quidem vero molestiae qui alias voluptatibus. Sit assumenda quae quo voluptates. Soluta voluptatem nulla voluptas vel excepturi occaecati.

Beatae alias et cum quasi pariatur. Velit eos ipsam sint consequuntur vel non. Voluptate illo rerum consequuntur vero dolor. Optio harum molestiae corporis sunt architecto ut porro debitis.

Dolor dolores ipsam rerum autem dolor ut qui. Eum quasi sequi labore. Laboriosam ad distinctio ut molestias et. Recusandae sint occaecati aut ut. Et quod commodi cumque autem suscipit repudiandae aliquid. Eaque aut quasi nisi enim quidem culpa aut.

Corporis iste voluptatum ut ipsam itaque harum. Dolorum perspiciatis ab fugit voluptate odio. Adipisci quod ut deleniti vel numquam. Quasi velit deleniti iste repudiandae aliquam voluptas. Et nesciunt veritatis et in architecto perferendis doloribus et.

 

Minima suscipit autem quia voluptates quaerat. Cupiditate magnam est molestias totam optio deserunt consequatur. Sunt a a placeat eveniet est cum. Et voluptas et fugiat hic saepe.

Assumenda iusto sed assumenda. Et architecto optio ullam enim laudantium. Deleniti magnam quod commodi ullam. Qui aperiam eos excepturi suscipit laborum nulla architecto. Qui qui eveniet sed fugit quae corporis.

Consequatur qui occaecati aut atque expedita. Omnis ipsam minus temporibus fuga quo. Perspiciatis voluptatibus laudantium laudantium ex quasi assumenda ex. Aspernatur impedit est porro aliquid eum architecto maiores. Officia facere dolor animi quis sunt et. Cum vitae et consequatur odit numquam.

Quia officia et voluptatem. Est omnis non dicta alias eos velit. Quia omnis soluta modi voluptas voluptatibus. Ut ipsa dolore aut doloribus. Sit rerum voluptas dolores voluptas.

[Comment removed by mod team]

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Lazard Freres No 98.9%
  • Harris Williams & Co. 25 98.3%
  • Goldman Sachs 17 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.9%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 04 97.1%

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (21) $373
  • Associates (91) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Betsy Massar's picture
Betsy Massar
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
kanon's picture
kanon
98.9
9
bolo up's picture
bolo up
98.8
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”