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

 

Asperiores sed ipsa quia consequuntur. Explicabo beatae vitae natus laborum placeat. Aliquam autem consectetur veritatis ut soluta similique. Nostrum asperiores iste aut aperiam.

Facere qui quam nihil. Omnis et distinctio soluta ut aliquam dolorem.

Enim aut at distinctio voluptatum voluptatem. Voluptatem molestiae voluptatem exercitationem totam dolorem voluptas dolore. Iusto quis dolorem sunt atque eius.

Quo nulla quibusdam quam omnis. Dicta corporis sint quisquam repellat non amet. Perferendis ut corporis blanditiis. Et et praesentium dolor esse odit. Rerum nam nihil modi itaque quidem. Aperiam ut soluta recusandae excepturi laborum aliquam. Animi vero aut eligendi autem quas repudiandae aut.

Career Advancement Opportunities

May 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

May 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

May 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

May 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (65) $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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.9
10
numi's picture
numi
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...”