Pro rata is a Latin term used to describe a proportionate allocation. It translates to "in proportion." It's a process in which an allocated asset will be distributed in equal portions. An amount is assigned to one person according to their share of the whole if something is distributed to...
In cell F5, in the Amount column, insert the following formula: =E5*$C$13 Where, E5 = the fraction amount of the working days C13 = The annual salary Press ENTER to get the pro rata share for that employee. AutoFill the rest to finish the pro rata share calculation. Example 2 –...
In accounting andfinance, prorated means adjusted for a specific time period. For example, if an employee is due a salary of $80,000 per year, and they join the company on July 1, their prorated salary for that year would be $40,000. How to Prorate a Number Let’s look at an ex...