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!

 

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

 

Et expedita non veniam nihil vero consequatur reiciendis. Laboriosam iure et labore quam.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
DrApeman's picture
DrApeman
98.9
9
kanon's picture
kanon
98.9
10
bolo up's picture
bolo up
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...”