Calcuating annualised year to date income
Assuming constant pay.
365/(payslip date - start of year date) * Year to date gross income
or pay per payperiod * number of pay periods
--
Regards,
Tom Ogilvy
"Sam" wrote in message
...
Hello all
I want to create a formula to annualise a persons income based on their
gross financial year to date income.
Assuming that the financial year begins on 1/7/06. The variables would
be:-
Financial year start date (1/7/06)
Date of payslip
Year to date gross income
Result to calculate what the annualised income would be come 30/6/07
Thanks
|