I have finance project/ it needs excel work
eray3497
Student Example
Bus 14A Finance Project – 2017 Lexus RC F
A) The reason I choose the 2017 Lexus RC F is very simple. I prefer Japanese automakers and
Lexus is a luxury car marquee of Toyota. The Lexus RC F is a sports model with a modern and
fashionable exterior. Since the car I am presently driving is a Toyota Corolla, I want to upgrade
and buy a luxury model of Toyota.
Putting added control into the hands of the driver, the RC F features an available
Torque Vectoring Differential. With three unique modes —Slalom, Track and Standard—
this system distributes power between the left and right wheels while the RC F is turning,
helping to rotate the RC F in the direction of the turn, powering drivers into and out of
corners with unprecedented confidence.
Specifications
Model 2017 Lexus RC F $64,165.00
Exterior Color Nebula Gary Pearl Included
Interior Color Circuit Red Leather with Included
Black Carbon Fiber Trim
Package Navigation/Mark Levinson $2,550.00
Package
Option Orange Beake Calipers $300.00
Accessories Door Edge Guards $139.00
Carpet Trunk Mat $105.00
Key Gloves $10.00
Delivery, Processing & Handling Fee $975.00
Build Total Excludes tax, title, and license. $68,244.00 Retailer sets actual price. All the information comes from www.lexus.com .
Student Example
Option 1 Financing Offer -- Purchase
Term 60 Months
Estimated Amount Financed $68,244.00
APR 1.9%
Monthly Payment $1,193.18
All information comes from the Payment Estimator at
www.lexus.com
Option 2 Financing Offer -- Purchase
Term 72 Months
Estimated Amount Financed $68,244.00
APR 2.9%
Monthly Payment $1,033.83
All information comes from Sun Trust Bank found at www.bankrate.com
Student Example
Comparison 1
Model 2017 Lexus RC 350 $43,010.00
Mileage New
Exterior Color Nebula Gary Pearl Included
Interior Color Circuit Red Leather with Included
Black Carbon Fiber Trim
Package F SPORT Package $2,550.00
Accessories Door Edge Guards $115.00
Carpet Trunk Mat $105.00
Key Gloves $10.00
Delivery, Processing & Handling Fee $975.00
Build Total Excludes tax, title, and license. $48,320.00 Retailer sets actual price.
All the information comes from www.lexus.com .
Financing Offer for Comparison 1
Term 72 Months
Estimated Amount Financed $48,320.00
APR 2.9%
Monthly Payment $732.00
All information comes from Payment Estimator at www.lexus.com
Student Example
Comparison 2
Model 2016 Lexus ES 300 Hybrid $41,820.00
Mileage Used – 6,000 miles
Exterior Color Nebula Gary Pearl Included
Interior Color Stratus Gray Leather with Included
Espresso Bird’s-Eye Maple Trim
Package Premium Package $730.00
Accessories Wood-and Leather-Trimmed $300.00
Steering Wheel
Door Edge Guards $140.00
Carpet Trunk Mat $105.00
Key Gloves $10.00
Delivery, Processing & Handling Fee $975.00
Total Excludes tax, title, and license. $44,080.00 Retailer sets actual price.
All the information comes from www.carmax.com .
Financing Offer for Comparison 2
Term 72 Months
Estimated Amount Financed $44,080.00
APR 1.9%
Monthly Payment $648.27
All information comes from Payment Estimator at www.carmax.com
Student Example
F) I would choose the 2016 Lexus ES 300 Hybrid - Used. After taking classes all morning, I
often have to go to work. Having a reliable car that I can drive to school, to my job, and to home
is extremely important to me. The hybrid model not only helps me save more on the cost of
gasoline every month, but it is also better for environment. Since it is used, I like that it has low
mileage and a lower monthly payment. The exterior of ES 300 HYBRID is similar to RC F, so it
is a good and economic choice for me.
G) A financial plan with supporting mathematical calculations for saving the money instead of
borrowing it. You may use a percentage from 1% to 2% if you are unable to find a percent from
financial institution.
What should I deposit monthly into a savings account to have enough to purchase the Lexus ES
300 HYBRID at $44,080.00 in 5 years from now if my interest rate is 1.5% compounded
monthly?
44080 = R*{ [ (1+0.015/12) ^ 60 - 1] / (0.015/12) }
FV = 44080 i=0.015/12 n=5*12=60
R=707.92
As a result, I should deposit $707.92 monthly into a savings account to have enough to purchase
the Lexus ES 300 HYBRID.