math 141-j411-2

MATH 141 – Capstone Project

Overview

In this project, you will consider the purchase of a new vehicle (latest model). You will write a

professional report using appropriate technology and will apply mathematical skills and

techniques learned in class to help you evaluate your purchasing decisions as well as different

financing options.

In part I of this project, you will collect real life-data and use it to model the resale value of your

chosen car over time. Part II of the project will focus on considering different options of

financing the car such as choosing the length of the loan or reducing interest payments.

Guidelines for Being Successful:

 Read and follow instructions carefully

 Review the grading rubric carefully to ensure that you are familiar with the expectations

for each section

 If you need clarification about any part of this project, please be sure to ask your

instructor in a timely manner

o Ten percent will be deducted for each calendar day the project is submitted after

the due date.

o A project is considered as “submitted” when it is available to the professor to

view in Canvas. After you submit the project, please open it up in Canvas to

ensure it is readable

o No credit is given for projects submitted after five days after the due date (2

calendar days for winter/summer terms)

 Submit a neat professional report typed (double-spaced) using your choice of word

processing software. The use of appropriate technology is expected throughout the

project

o All mathematics must be typed using mathematical notation package and all

graphs, charts and diagrams must be created using a mathematical or statistical

software package

o All graphs must be “complete” and embedded into the report. Hand-drawn

graphs or graphs submitted in a separate document will not be accepted

 Group work is not allowed for this project. While you may discuss your ideas with

others, each student must submit his or her own original work.

Getting Help:

 You may discuss the project with others and may consult any available resource

(including your instructor, classmates, LAC and HR230 tutors, or the Internet) provided

that the computations, explanations and graphs in your project are your own original

work

 You must cite all of your resources using APA format

 If you need help with writing, use the HCC Writing Center: For further information, see

the HCC Web page under the heading “Writing Center” or call the Writing Center at

(443) 518-4101. PGCC students at the Laurel College Center should see the PGCC

Writing Center for assistance.

Guidelines for Submission:

 Submit your project via the Canvas link as a PDF file

 VeriCite will be used as a deterrent for plagiarism. This program is integrated into the

Canvas submission process. All submissions will be compared against the VeriCite

database and receive an “originality” rating. To avoid a false flag in VeriCite, do not

copy and paste the instructions/questions into your final submission

Part II – Financing a Car

In Part II of the Capstone Project, you will consider different options of financing your new car.

You will create and analyze the amortization schedule for your chosen loan and discuss how to

reduce the total interest and the length of your loan.

This is a research paper and should be written as a narrative.

Introduction (16 points):

 Provide the make, model and MSRP of your chosen car (2 pts)

 Provide the name, address and contact information of two local dealerships that sell

your car (with the features chosen in Part I of the project). Remember that you are

buying a new car (latest model) and hence do not use used car dealerships! (2 pts)

 Provide the Dealer Incentive for the car from each of the two dealerships. (Dealer

Incentive is a financial inducement used by manufacturers to motivate dealers to sell a

particular product by offering discounts on that product (a price lower than the listed

MSRP. A dealer incentive may also take the form of a cash incentive, such as a rebate,

awarded directly to the consumer) Based upon the Dealer incentive and/or other

contributing factors, decide from which dealership you will purchase your car. (Explain

your decision) (4 pts)

 Decide whether you would make a down payment on your car and state the amount (2

pts)

 If you are currently driving a car, find out the Trade-in Value of your current car and

decide whether you would want to trade it in upon purchasing the new car. You may

also decide not to trade-in your car, but you must explain your decision (such as passing

your current car to your teenage child, etc.) (2 pts)

 Calculate the amount financed. (This is the amount for which you will take a car loan. It

should consist of the dealer’s price –(down payment, trade-in vale, and any other

applicable incentives) (4 pts)

Considering Different Loan Options (9 points):

Car loan rates vary based on one’s credit score, term length of the loan and other factors

relevant to a lender’s risk in offering the loan. The annual percentage rate (APR) typically ranges

from 3% to 10%. In this project we will consider the following term lengths and APR’s:

Term length of the loan (in months)

36 48 60

APR (%)

3.71 3.81 3.93

 Using the amount financed for your car, calculate

o the monthly payment (PMT) (3 pts)

o the total amount paid over the length of the loan (3 pts)

o the total amount of interest paid over the length of the loan (3 pts)

for all three loans listed above. (Organize this information in a table)

 Choose one of these loans and justify your decision

 Create an amortization schedule for the chosen loan only. The schedule must be

embedded in your report and must include the following columns (6 pts):

o Payment Number

o Monthly Payment (PMT)

o Interest (I)

o Unpaid Balance Reduction (UBR)

o Unpaid Balance

Linear Regression Models I(x) and UBR(x) (22 points):

 Use technology to calculate the linear regression equation ( )I x where I is the interest

in dollars listed in the Interest column (I) of your amortization schedule and x is the

payment number. Round your figures to two decimal places (5 pts)

 Use technology to create the graph of ( )I x . Your graph must be a complete graph:

o The graph has a title (2 pts)

o Each axis is labeled with its variable (2 pts)

o Each axis is labeled with a subtitle (2 pts)

o Each axis shows appropriate tick marks and scaling (2 pts)

o Each line, curve or function is clearly drawn and labelled with its equation. A

legend may be used when appropriate. Equations must be professionally typed

using correct mathematical notation(2 pts)

o Vertical and horizontal intercepts are shown on the graph (2 pts)

o Incorporate your graph into your report in a smooth, professional way. Hand-

drawn graphs or hand-written description will not be accepted. Graphs

submitted in a separate document will not be accepted

 Use technology to calculate the linear regression equation ( )UBR x where UBR is the

unpaid balance reduction in dollars listed in the UBR column of your amortization

schedule and x is the payment number. Round your figures to two decimal places (5 pts)

 Use technology to create the graph of ( )UBR x . Your graph must be a complete graph

having all of the features listed for the graph of ( )I x

Discussion (22 points):

1. Using your linear regression equation for ( )I x , find the slope and interpret its meaning

within the context of the model (5 pts)

2. Using your linear regression equation for ( )UBR x , find the slope and interpret its

meaning within the context of the model (5 pts)

3. Discuss the relationship between the two slopes (3 pts)

4. Discuss at least three different options of paying the loan faster. (These must be all

sensible and financially sound options such as rounding up your monthly payment or

making an extra payment every year. Saying that you would slap the amount on credit

card or borrow the money from a friend does not constitute a sensible and financially

sound option.) Discuss the following for each of the options:

o Describe how you are going to shorten the loan (3 pts)

o Calculate by how much will the term of your loan be shortened (3 pts)

o Calculate the new total interest paid over the length of the loan (3 pts)