Portfolio $-$ Excel Project

Select one of the following two scenarios for your portfolio project.

Scenario $1$: Vehicle Purchase

You have decided to purchase a vehicle. Research the cost of a vehicle, including all options and accessories you prefer. Then, create an Excel worksheet that contains the following:

Vehicle Cost

Interest Rate

Length of Loan $($in months$)$

Monthly Payment

Using a formula, calculate the monthly payment at $0\%$ for $36$ months.

Using the current interest rates provided below, create a scenario summary to see what your monthly payment would be if you increased the length of your loan.

$\backslash$table$[[$Current Interest Rates$],[$Interest Rate,Length of Loan $($in months$)],[0\%,36],[1\mathrm{.}90\%,48],[2\mathrm{.}90\%,60],[3\mathrm{.}90\%,72]]$

Assume you can afford $$500$ per month at $0\%$ for $36$ months. Use Goal Seek to determine the maximum cost of your vehicle.

Using data obtained from your scenario summary, create a column chart as a new worksheet to depict the monthly payment for each loan term.

Be certain to apply formatting $($e$.$g$.$ cell styles$)$ and insert a graphic for visual appeal.

NEED ALL STEPS TO COMPLETE THIS