Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 2 Construct a two-variable data table to analyze the impact of different interest rates and Price of the car on the Total amount paid

image text in transcribedimage text in transcribedimage text in transcribed
Part 2 Construct a two-variable data table to analyze the impact of different interest rates and Price of the car on the Total amount paid (Total Payments) using interest rates : 2.5%, 3%, 3.5%, 4%, 4.5% and 5% and car prices from 10K to 35K in 5K increments. What would be the Total payments for a car that has a price of $15,000 with a 4.50% interest rate ? Total Payments $0.05 $13,921.56 2.50% 3.00% 3.50% 4.00% 4.50% 5.00% $10,000.00 $0.03 $0.03 $0.04 $0.04 $0.05 $0.05 $15,000.00 $0.03 $0.03 $0.04 $0.04 $0.05 $0.05 $20,000.00 $0.03 $0.03 $0.04 $0.04 $0.05 $0.05 $25,000.00 $0.03 $0.03 $0.04 $0.04 $0.05 $0.05 $30,000.00 $0.03 $0.03 $0.04 $0.04 $0.05 $0.05 $35,000.00 $0.03 $0.03 $0.04 $0.04 $0.05 $0.05Auto Purchase Input Area Price of Car Down payment PR J Length of Note {years} Periodic Rate 13.38% Number of Payments 24 Monthly Payment $551.42 Total Payment5 $13,518.12 Total lntere5t Paid 5 513.12 Part 2 Construct a two-variable data table to analyze the impact of different interest rates and Price of the car on the Total amount paid (Total Payments) using interest rates : 2.5%, 3%, 3.5%, 4%, 4.5% and 5% and car prices from 10K to 35K in 5K increments. What would be the Total payments for a car that has a price of $15,000 with a 4.50% interest rate ? Total Payments $13,921.56 2.50% 3.00% 3.50% 4.00% 4.50% 5.00% $10,000.00 $15,000.00 $20,000.00 $25,000.00 $30,000.00 $35,000.00

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

Calculus

Authors: Laura Taalman, Peter Kohn

1st Edition

ISBN: 1464153035, 9781464153037

More Books

Students also viewed these Mathematics questions