Prepaid Insurance Calculator in Excel format with Regular year and leap year.
NOTE:
THERE IS SOME HIDE FUNCTION SO DON’T EDIT OTHER CELL
THIS IS FOR LEAP YEAR , FOR REGULAR PLEASE INSERT IN “REGULAR” SHEET
Example For Leap Year
INPUT CELL PLEASE INPUT IN YELLO CELLS ONLY
FROM TO AMOUNT
10-04-2015 09-04-2016 25000.00
AUTO OUTPUT CELL
DETAIL FROM TO DAYS AMOUNT
INSURANCE EXPS 10-04-2015 31/03/2016 357 24385.00
PREPAID INSURANCE 01-04-2016 09-04-2016 9 615.00
366 25000.00
NOTE
** ONLY FILL DATA IN YELLO CELLS.
Example for Regular year
NOTE:
THERE IS SOME HIDE FUNCTION SO DON’T EDIT OTHER CELL
FOR LEAP YEAR PLEASE INSERT DATA IN “LEAP YEAR” SHEET
INPUT CELL PLEASE INPUT IN YELLO CELLS ONLY
FROM TO AMOUNT
10-05-2014 09-05-2015 20158.00
AUTO OUTPUT CELL
DETAIL FROM TO DAYS AMOUNT
INSURANCE EXPS 10-05-2014 31/03/2015 326 18004.00
PREPAID INSURANCE 01-04-2015 09-05-2015 39 2154.00
365 20158.00
NOTE
** ONLY FILL DATA IN YELLO CELLS.
CLICK HERE / CLICK HERE TO DOWNLOAD PREPAID INSURANCE CALCULATOR IN EXCEL FORMAT