Please calculate the present worth of one or all three vehicles in excel using the information given. The monthly payment has not been calculated.

Choose three vehicles currently on the market: one with a traditional internal combustion

engine, one hybrid $($either plug$-$in or regular$),$ and one fully electric. Asaume you're buying a

new vehicle $-$ the used market is still recovering from the pandemic and shortages. All three

vehicles should be similar in style and capacity $($i$.$e$.$ full$-$size sedans, SUVs, etc.$).$

Assume that the useful life of each vehicle is $10$ years $(120$ months$).$ After that, you plan to

sell it$.$

Determine the following cash flows for each car:

a$.$ Initial investment. Assume that you have a down payment of $10\%$ of the MSRP plus

an additional $$2,000$ in fees

b$.$ Monthly payment, given a monthly interest rate of $0\mathrm{.}65\%.$

c$.$ Cost of ges per month assuming that you drive about $30$ miles per day, using the

listed gas mileage of the vehicle. For the electric vehicle, determine the cost of

electricity.

d$.$ Monthly maintenance costs. Again, you may need to assume a number here if you

can't find anything good on the internet.

e$.$ Market value at the end of the useful life, asauming you kept the vehicle in good

condition. Kelley Blue Book is a good resource for this. For the electric vehicle, you

are not planning to replace the battery, so assume that the market value is $$0$ at the

end of the useful life.

Find the Present Worth of each car, given a monthly interest rate of $0\mathrm{.}3\%$ for your checking

account. $\backslash$table$[[$Internal Combustion Engine Vehicle,Toyota Corolla,$$20,090],[$Hybrid Vehicle,Toyota Prius,$$24,030],[$Fully Electric Vehicle,Nissan Leaf,$$20,800]]$ Initial Investment : Down payment: $10\%$ of MSRP $+$$$2000$ in fees

Internal Combustion Engine : $$4009$

Hybrid Vehicle : $$4403$

Fully Electric Vehicle : $$4080$

Monthly Payment : Monthly Interest Rate $0\mathrm{.}65\%$

Internal Combustion Engine:

Hybrid Vehicle:

Fully Electric Vehicle:

Cost of Gas$/$Electricity per month :

Internal Combustion Engine : $$145\mathrm{.}83$

Hybrid Vehicle : $$62\mathrm{.}50$

Fully Electric Vehicle: $$56\mathrm{.}25$

Monthly Maintenance Costs :

Internal Combustion Engine : $$50$

Hybrid Vehicle : $$40$

Fully Electric Vehicle : $$30$

Market Value at the End of Useful Life :

Internal Combustion Engine : $$10000$

Hybrid Vehicle: $$12000$

Fully Electric Vehicle: $0$