Excel Canada Severance Calculator
Summary
Freelancer Client is hiring: Excel Canada Severance Calculator.
Location: Remote
I need a fully-functional severance calculator built directly in Microsoft Excel so our HR team can run it on Windows machines without additional software. The worksheet should allow users to enter the following variables in clearly labelled input cells:
What you'll do:
• Brief PDF or in-sheet notes explaining how to maintain or modify the model
Requirements:
• Years of service
Skills: Visual Basic, Excel, Software Architecture, Visual Basic for Apps, Financial Analysis, Excel VBA, Excel Macros, Data Analysis, Financial Modeling, Data Management
Budget: $250–$750 USD
Source: Freelancer Client via Remote / Online. Apply on the source website.
Original
I need a fully-functional severance calculator built directly in Microsoft Excel so our HR team can run it on Windows machines without additional software. The worksheet should allow users to enter the following variables in clearly labelled input cells:
• Years of service
• Age of employee
• Job position
• Job grade
• Short-term incentive eligibility
Province
Based on these inputs the file must return the correct statutory and common-law severance entitlements for Canadian employees, following current federal and provincial guidelines. All formulas should be transparent, with assumptions documented in a hidden but unlockable sheet so we can update rates later.
Deliverables
• Unlocked Excel workbook with user-friendly input area and results dashboard
• Table or chart showing calculation logic (service caps, age multipliers, position/grade adjustments, incentive percentages)
• Brief PDF or in-sheet notes explaining how to maintain or modify the model
I will test the file against several sample scenarios; accuracy within two decimal places is the acceptance criterion.
Location & Details
Apply on source →About this listing
This remote opportunity was imported from Freelancer and is shown here for discovery. To apply, follow the link to the original posting.