Corporate Analyst (MS Excel (Macros) /Access –Specialist) Job

Employer Name: FEP Search Group	SpiderID: 2845279
Location: Toronto (Downtown), Ontario	Date Posted: 8/4/2009
Wage: $45K to $55K	Category: Accounting/Bookkeeping
Job Code:

Job Description:
1) To design and manage a central database of all mortgage information (Using Excel Macros and Access) and assist the finance team with monthly, quarterly and annual reporting.
2) Calculate effective interest rate and weighted average term to maturity for mortgage portfolio on a monthly basis (and other information as part of the mortgage package)
3) Calculate the fair value of mortgages on a quarterly basis
4) Ensure the validity and integrity of mortgage information with the underlying general ledger accounts
5) Calculate ratios and financial covenant tests (MFT, SIFT, interest coverage, etc.)
6) Assist the Finance Team with the preparation of quarterly analysis relating to the MD&A and financial statements
7) Calculate ratios by property and by lenders on a quarterly basis
8) Provide mortgage information required for financial statements and management discussion and analysis (MD&A)
9) Prepare quarterly reporting to banks
10) Calculate potential mortgage top-ups under various scenarios
11) Assist the Finance Team in preparation for auditors (including but not limited to preparing analytics)
12) Calculate sensitivity analysis for note disclosure to financial statements
13) Handle annual reporting to lenders and CMHC
14) Perform other duties and projects as assigned by the management

Job Requirements:
1) CMA/CGA designation (actively pursuing)
2) Financial/mortgage experience
3) Excellent communication skills (written and oral)
4) Good time management and organization skills
5) Superb computer skills including advanced macros for MS Excel and Access
6) Ability to independently analyze and resolve problems
7) Detail oriented and self-motivated with ability to take the initiative to learn new skills and enhance overall knowledge

Applicants are encouraged to apply directly by going to: http://www.fepsearchgroup.com/accounting-jobs/accounting-job-01090.html

Contact Information:

Contact Name: Jane Shah	Company Type: Employer
Company: FEP Search Group

City: Toronto
State: Ontario
Zip: M5G 1T6

Web Site: http://www.fepsearchgroup.com/acct.htm