Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started