Payment schedule for Benefit Premiums

Internal Owner Week #

Date Benefit Type Weekly Total Owed # Weeks Owed # Weeks to Catch Up Weekly Catch Up Amount Regular Weekly Amount Weekly Premium Total $1$

$4/7/2023$ Medical $52$

Dental $52$

Vision $52$

Weekly Catch$-$up Total Combined Total

Date Benefit Type Weekly Total Owed # Weeks Owed # Weeks to Catch Up Weekly Catch Up Amount Regular Weekly Amount Weekly Premium Total $2$

$4/14/2023$ Medical $52$

Dental $52$

Vision $52$

Weekly Catch$-$up Total Combined Total

$1)$ From the first exercise on Tab $1,$ please use the Internal Owner's weekly premium for the Weekly Total Owed amount and calculate the following:

$1$a$)$ Weekly Catch Up Amount

$1$b$)$ Regular Weekly Amount

$1$c$)$ Weekly Premium Total

$1$d$)$ Weekly Catch Up Total

$1$e$)$ Combine Total

$**$Please note: We will be looking for correct formulas used, and how you calculated the totals.