Calculo De Prestaciones Honduras Excel Apr 2026

[ \textAguinaldo prop. = \frac\textMonthly salary12 \times \textMonths worked in the year (including fraction) ]

Better for Excel:

So formula: =ROUND((A7/12) * (MONTH(C3)-1 + DAY(C3)/30), 2) = Aguinaldo + Vacaciones + Indemnización 3. Example calculation (March 15, 2024 termination) Start: Jan 1, 2022 End: March 15, 2024 Salary: L 20,000

Example end date March 15 = 3.5 months.

Then compare to cap: Cap = Monthly salary × 12. If indemnización > cap, use cap. Step 1: Input data cells | A | B | C | |---|---|---| | Monthly salary (Lempiras) | 20,000 | | | Start date (dd/mm/yyyy) | 01/01/2022 | | | End date (dd/mm/yyyy) | 15/03/2024 | | | Days worked total | =C3-C2+1 | | | Years worked | =C4/365 | | | Daily salary | =B1/30 | | Step 2: Aguinaldo Months worked in last year (Jan to Dec proportional? No – Aguinaldo is per calendar year worked.)

Formula: =IF(A6 < 1, (A5/365)*10, MIN(10 + INT(A6)-1, 20)) * A8 Proportional for calendar year of termination.

Then Vacation pay = Vacation days * A8.

In Excel: =MIN(A8 * 20 * A6, A7 * 12) If A6 < 1: Vacation days = (A5 / 365) * 10 Else: Vacation days = 10 + (INT(A6) - 1) capped at 20.

Actually, simpler: vacation days owed = MIN(10 + (INT(years)-1), 20) + (MOD(years,1)*10) capped total 20.

But by law: each full month = 1/12 of monthly salary. So formula: calculo de prestaciones honduras excel

For 2.2 years: 10 + 1.2 = 11.2 days → L 7,466.

[ \textAguinaldo = \textMonthly salary \times \frac\textDays worked in year365 ]

This is a practical guide to calculating in Honduras using Excel. [ \textAguinaldo prop

[ \textAguinaldo = \frac\textMonthly salary12 \times \textMonths worked (proportional) ] Honduras: 10 days vacation after 1 year (for first year: proportional). After 1 year: 10 days/year + 1 day per year up to 20 days.

Proportional formula (less than 1 year): [ \textVacation days = \frac\textDays worked365 \times 10 ] Then multiply by daily salary: