Have any of you performed a net present value (or even just raw $) analysis comparison between the total ownership and operating costs of ICE and electric automobiles (same functional capability of the vehicles assumed)?

Somebody please make my day and say "here is the spreadsheet", else I'll have to work my brain more than I'm used to in retirement!

I'm also considering an electric cargo bike which would take care of just about all my local driving as well as a fair bit of recreational driving down towards the coast which is usually less than about 50 miles.