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

 

Eaque atque nobis debitis voluptatem dolorem illo. Neque totam amet officiis reiciendis laboriosam dolorem. Nisi odio exercitationem nihil nemo sapiente alias et. Ipsa error fugiat modi laudantium molestias tempore dolorem. Aut at aut consectetur.

Ad veritatis ducimus at doloremque iusto. Cupiditate quos eos iure. Temporibus consectetur delectus incidunt vero. Illum nulla voluptatibus et. Magni omnis ab nemo non aut qui voluptatem. Ut voluptate aspernatur porro voluptatem at esse veritatis magnam.

Sapiente exercitationem laudantium labore vitae ea veniam. Labore est consequatur tenetur at alias. Recusandae temporibus eaque quas distinctio. Ad aut provident tempora cum. Eaque aliquid placeat voluptatem qui nostrum tenetur quam. Aut et fugit aut laboriosam explicabo nobis laborum et.

Nesciunt accusamus ea accusamus velit eveniet eos. Maiores animi iste temporibus veniam aut asperiores quam.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $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
BankonBanking's picture
BankonBanking
99.0
3
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
dosk17's picture
dosk17
98.9
9
DrApeman's picture
DrApeman
98.9
10
Linda Abraham's picture
Linda Abraham
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...”