Honduras Excel — Calculo De Prestaciones

Cap = A7 × 12 Final indemnización = MIN(Indemnización, Cap)

But by law: each full month = 1/12 of monthly salary. So formula:

[ \textVacation pay = \textDaily salary \times \textVacation days owed ] calculo de prestaciones honduras excel

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

Total prestaciones = 29,400 + 7,466 + 4,167 = L 41,033 | Cell | Value / Formula | |------|------------------| | B1 | 20000 | | B2 | 01/01/2022 | | B3 | 15/03/2024 | | B4 | =B3-B2+1 | | B5 | =B4/365 | | B6 | =B1/30 | | B7 | =MIN(B6 20 B5, B1*12) | | B8 | =MIN(10+(B5-1)*1,20) B6 | | B9 | =(B1/12) (MONTH(B3)-1+DAY(B3)/30) | | B10 | =B7+B8+B9 | Cap = A7 × 12 Final indemnización =

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

But if terminated Dec 31, it’s full A7. Step 1: Input data cells | A |

Better for Excel:

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