d being the distance travelled, R the earth’s radius
Excel: (all anglesin radians)
lat2: =ASIN(SIN(lat1)*COS(d/R) + COS(lat1)*SIN(d/R)*COS(brng))
lon2: =lon1 + ATAN2(COS(d/R)-SIN(lat1)*SIN(lat2), SIN(brng)*SIN(d/R)*COS(lat1))
* Remember that Excel reverses the arguments to ATAN2 – see notes below
For final bearing, simply take the initial bearing from the end point to the start point and reverse it with (brng+180)%360.