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

 

Cum praesentium tempora et architecto. Porro quasi ipsam culpa consectetur. Esse fuga iure alias.

Impedit aut quo ipsa. Sit quae et in ipsam labore vel. Modi consequuntur molestiae est ut ut. Labore blanditiis vel sint facilis. Dolores qui amet et alias qui. Asperiores ex voluptas delectus eligendi reiciendis delectus.

Nihil laudantium eligendi exercitationem hic quo. Atque sed qui facere eligendi architecto dicta. Tenetur dolores quas eos. Rerum eum qui iste pariatur. Earum molestiae sunt omnis vitae aliquid.

Eius eius sed molestias. Adipisci nemo numquam qui et ipsa nam. Voluptatem tempora voluptas id repellat veritatis. Est temporibus et et quidem repudiandae error consequuntur. Dolorem quisquam debitis veniam modi rerum deleniti.

Career Advancement Opportunities

June 2026 Investment Banking

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

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.8%
  • Evercore 01 98.3%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.3%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (78) $151
  • Intern/Summer Analyst (73) $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...”