Calculo: De Prestaciones Honduras Excel

= End date – Start date + 1 Cell A6: Years exact = A5 / 365 Cell A7: Monthly salary = 20000 Cell A8: Daily salary = A7 / 30 Step 3: Calculate Indemnización Indemnización = A8 × 20 × A6

[ \textIndemnización = \textDaily salary \times 20 \times \textYears worked (proportional) ]

Aguinaldo: (20000/12) × (2 + 15/30) = 1666.67 × 2.5 = L 4,166.67

So: =MIN(10 + (A6-1)*1, 20) * A8

Vacaciones: Year 1: 10 days (Jan 2022 – Dec 2022) Year 2: 10 days (Jan 2023 – Dec 2023) Year 3: 3 months → proportional: 3/12 × 10 = 2.5 days Total = 22.5 days, but max is 20 days (by law 20 days/year cap after 10 years? Wait: max accrual is 20 days/year after 10 years service. But for indemnización vacation, it’s just 10 days/year for first 3 years? Let’s simplify: 10 days/year for first year, then 10 days/year + 1 day/year extra after 1 year, capped at 20 days/year. After 2 years = 11 days/year. So for 2.2 years: 10 + 11 + 2.2 = not logical. Better to use formula: vacation days = 10 + (years-1) capped at 20, then proportional for partial year.

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.

Months worked this year = (End date – Date(year(end),1,1) + 1) / 30.44 approx. calculo de prestaciones honduras excel

Example end date March 15 = 3.5 months.

[ \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.

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

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.)

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

Months worked = (End date – DATE(YEAR(End date), 1, 1) + 1) / 30.44. Let’s simplify: 10 days/year for first year, then

Aguinaldo = (A7/12) * 2.5.

But if terminated Dec 31, it’s full A7.