Need tips for Technical Interview - Looking to get prepared to nail it!

Hi everyone, this is my first post on here!
I applied for a Finance & Development Analyst position for a big retail company in Canada (1300+ employees in head office). The HR people met me and although I have no experience in Corp. Fin., they liked me enough to schedule me for a technical interview.

I currently work in Fund Accounting (back-office) but this looks to be a job with a lot more research and analysis (an upgrade for me!)

I'm looking for any useful info to get prepared for the technical interview with the manager (what questions to expect, what financial ratios can be relevant, etc.) Keep in mind this for the International side of their business

Here is a short breakdown of the job posting expectations:

• Assisting in the preparation of the division’s annual budget and five-year plan
• Reviewing the division’s monthly financial statements
• Monitoring franchisees’ accounts receivables on a weekly basis and following up with customers to minimize financial exposure
• Improving and standardizing various processes and reports
Researching new markets and business opportunities
• Participating in the international site selection process, including financial valuation
• Reviewing potential customer’s business plans, with a focus on financial feasibility and sales growth potential
• Developing and enhancing cross-channel financial models to assess and support strategic development decisions
• Streamlining development processes and tools
• Participating in other key divisional initiatives

Also asking for "excellent command of excel" (Modeling, decision trees and macros)

Thank you for any kind of help!

5 Comments
 

I have no idea, but interested to hear what some of the responses are. I've tagged some of the CUs that know their stuff, hopefully one of 'em will be able to help.

@"accountingbyday" @"GoIllini" @"bird" @"AllDay_028" @"Poff" @"TheGrind"

"You stop being an asshole when it sucks to be you." -IlliniProgrammer "Your grammar made me wish I'd been aborted." -happypantsmcgee
 
Best Response
Geoffrey R.

Hi everyone, this is my first post on here!
I applied for a Finance & Development Analyst position for a big retail company in Canada (1300+ employees in head office). The HR people met me and although I have no experience in Corp. Fin., they liked me enough to schedule me for a technical interview.

I currently work in Fund Accounting (back-office) but this looks to be a job with a lot more research and analysis (an upgrade for me!)

I'm looking for any useful info to get prepared for the technical interview with the manager (what questions to expect, what financial ratios can be relevant, etc.) Keep in mind this for the International side of their business

Here is a short breakdown of the job posting expectations:

• Assisting in the preparation of the division’s annual budget and five-year plan
• Reviewing the division’s monthly financial statements
• Monitoring franchisees’ accounts receivables on a weekly basis and following up with customers to minimize financial exposure
• Improving and standardizing various processes and reports
Researching new markets and business opportunities
• Participating in the international site selection process, including financial valuation
• Reviewing potential customer’s business plans, with a focus on financial feasibility and sales growth potential
• Developing and enhancing cross-channel financial models to assess and support strategic development decisions
• Streamlining development processes and tools
• Participating in other key divisional initiatives

Also asking for "excellent command of excel" (Modeling, decision trees and macros)

Thank you for any kind of help!

Know the 3 main financial statements, and how they relate. Under NWC, basic accounting, and basic ratios.

 

Agree with GoIllini.,..Also know how to construct a cash flow model and/or P&L to do some pro-forma analysis, create specialized aging reports-maintain a spreadsheet of delinquent and persistently late payers for any credit decisions in the future, and likely some ad-hoc modeling (DCF, IRR, etc) for the strategic decisionmaking....nothing too crazy

 

Id doloremque ut nihil aut magni quos. Provident numquam veritatis qui unde hic nemo voluptas. Qui id recusandae id quo iusto est. Sed sed incidunt nostrum alias consectetur nisi consequatur. Excepturi omnis earum aperiam veritatis eos. Nam rerum quibusdam qui ut eaque culpa quisquam.

Qui dolorum quae nam dolor consequatur. Illo pariatur quia voluptatem eos. Quia facilis et aspernatur eaque in quia repudiandae. Consequuntur expedita quis autem quisquam distinctio.

Ea qui optio labore. Aut non qui ullam modi ad. Commodi omnis consectetur facilis et eos.

Career Advancement Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 08 97.8%
  • Goldman Sachs 02 97.3%

Overall Employee Satisfaction

August 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.4%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.3%

Total Avg Compensation

August 2026 Investment Banking

  • Vice President (16) $429
  • Associates (48) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (25) $178
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (83) $151
  • Intern/Summer Analyst (75) $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

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...”