Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A local car dealership is offering a three - year lease deal for the latest model of the Honda Civic LX for $ 2 2

A local car dealership is offering a three-year lease deal for the latest model of the Honda Civic LX for
$229 per month with $2,099 due at signing. Jared is debating whether he should lease or purchase the
vehicle. While the lease option offers lower monthly payment and down payment and gives Jared the
opportunity to drive a new car in three years without the hassle of having to sell the car, Jared is
wondering if it is financially smart to lease a vehicle. The market price for a Honda Civic LX is $19,980,
and the market value of a three-year-old Honda Civic LX is $14,159. The current national average for auto
loan interest rates is 5.27% on a 60-month loan.
A. Build a spreadsheet model that calculates the monthly payment, principal payment, interest payment,
beginning balance, and ending balance for each month of the five-year loan period, assuming a down
payment of $2,099.00. What is the ending balance of the loan at the end of the three-year period?
B. How much would Jared have paid out of pocket at the end of the three-year lease period if he decides
to lease the vehicle?
C. Does leasing or buying make more financial sense to Jared? Why?
D. For his weekend hobby of off-road driving, Jared wants to get an AWD Jeep Wrangler instead. A local
dealer is offering a three-year lease deal for the latest model of an AWD Jeep Wrangler for a monthly
payment of $275 with $3,995 down. The same vehicle is for sale for $31,795. Jared found that a three-
year old AWD Jeep Wrangler has a market value of $23,500. Using the spreadsheet model, you
developed to find out whether it is less expensive for Jared to lease or purchase? What is the difference
in dollar amount between the two options after three years?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions