Please show all excel formula used

Tested Outcomes

Use What$-$If analyses

Two$-$way Data Tables

Goal Seek

Context

You're considering purchasing an electric vehicle $($EV$)$ instead of an internal combustion $($ICV$)$ gasoline vehicle. You want to determine at what point the EV becomes more cost$-$effective than the gasoline vehicle, considering the initial cost difference and ongoing fuel$/$electricity costs. Your analysis will be based on the simple payback period formula:

"Simple Payback Period $[$yr$]"=("$Sale Price EV$"-$"Sale Price ICV" $)/("$Annual Fuel Cost ICV" $-$"Annual Fuel Cost EV$")$

The following will be our initial assumptions:

EV Sale Price $$40,000$

ICV Sale Price $$30,000$

Electricity Cost per Mile $$0\mathrm{.}04/$mile

Gasoline Cost per Mile $$0\mathrm{.}12/$mile

Annual Mileage $10,000$ miles$/$yr

Task

Part $1$

Create a one$-$way data table in Excel to determine the simple payback period $($in years$)$ for the EV compared to the gasoline vehicle at the different annual mileages provided in Excel.

Part $2$

Create a two$-$way data table in Excel to determine the simple payback period $($in years$)$ for the EV by considering different annual mileages and electricity costs provided in Excel.

Part $3$

Use Goal Seek to find out the required EV Sale Price needed so the simple payback period is $5$ years assuming annual mileage of $10,000$ miles, electricity and gasoline costs per mile are $$0\mathrm{.}04/$mile and $$0\mathrm{.}12/$mile$,$ respectively $($see table above$).$ Please take a screenshot of your completed goal seek input box $($see example below$)$ and paste it into your Excel worksheet.