Noob Excel Question

I'm on a make-shift Corp Dev team at a Tech company with no real transactions experience (go figure lol).

Building out a customer forecasting model for a target on Google Sheets. I'll be download as a .XLS and building Data Tables for Sensitivities on the sheet and exporting the values into Google Sheets. (any better way to do this for people who have used sheets?)

Question(s):

I have my model built out with all my assumptions / inputs in the top rows, say rows 1-20, and the actual monthly forecast below it. It looks like shit, especially with all the frozen pains for the line items.

  • If I move all my assumptions / inputs to a separate sheet before exporting, will I still be able to do the Data tables? From what I understand, the assumptions / inputs need to be on the same sheet as the formula that's driving the data table

  • Can I build the data tables independtly on a seperate sheet?

  • Is there a better way to do this given my Google Sheets constraint? I can't have this on an excel sheet because our CEO / CFO / CorpDev prefer to be able to work on things together.

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 (5)

Aug 16, 2020 - 6:40pm

I have an answer to #2...

No, at least not the standard way. You would have to use self-ref IF functions, and they are not too difficult to implement.

There can only be one Dirty Dan, the rest of you are Pin-head Larrys...

Aug 16, 2020 - 11:00pm

Sheets can't do anything Excel can - try again

Array
Aug 17, 2020 - 1:25am
“Can I have some money now?” -H. Simpson
Start Discussion

Total Avg Compensation

April 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (35) $364
  • Associates (188) $234
  • 2nd Year Analyst (107) $150
  • Intern/Summer Associate (96) $145
  • 3rd+ Year Analyst (26) $145
  • 1st Year Analyst (392) $132
  • Intern/Summer Analyst (323) $82