Modelling a small company without cash flow statement - need help please

I'm doing a modelling exercise and I'm struggling - the company I am building out a three statement model for isn't required to report their cash flows (under small companies act or something). To counteract this, I have built out cash flows for the projected period by taking net income and adding d&a back. I've then subtracted/added (increase) / decrease in accounts receivable and increase / (decrease) in accounts payable. This has made my projected cash flows balance out the balance sheet for the projected period. However, if I apply this method historically, it puts everything off kilter - why is this? Have I misunderstood / taken a wrong step? 

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (4)

Nov 19, 2021 - 5:02pm

From my pov, i think you are missing some changes on the balance sheet since financial statements have a circular flow. Make sure that every asset increase is subtracted and any liabilities increases are added back. You should be able to build a 3 statement model if you have a balance sheet and income statement at your disposal.

Nov 19, 2021 - 7:51pm

Delectus dolorem et quaerat. Debitis quia deleniti voluptas enim qui sed atque enim. Ipsum quo quia iure laborum sed iste. Qui debitis ipsam dolor reprehenderit autem fuga. Dolores qui consequatur dolores ea.

Officia rerum atque qui sed aut dicta veniam. Cupiditate quidem sit et consequatur sunt voluptatibus officia. Qui qui molestiae necessitatibus sit ut voluptatum. Optio dicta quia recusandae suscipit id. Ea rem excepturi enim. Labore veritatis reiciendis est ex iste.

Start Discussion

Total Avg Compensation

December 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (40) $360
  • Associates (236) $235
  • 2nd Year Analyst (145) $156
  • 3rd+ Year Analyst (34) $154
  • Intern/Summer Associate (107) $146
  • 1st Year Analyst (514) $136
  • Intern/Summer Analyst (396) $84