Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need row and column for what if function: Data table Part 2 Construct a two-variable data table to analyze the impact of different interest rates

image text in transcribedimage text in transcribed

need row and column for what if function: Data table

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 2.50% 3.00% 3.50% 4.00% 4.50% 5.00% $13,921.56 $10,000.00 $15,000.00 $20,000.00 $25,000.00 $30,000.00 $35,000.00 Auto Purchase Input Area Price of Car Down payment APR Length of Note (years) Number of Payments Per Year 2 $15,000.00 $ 2,000.00 4.50% 3 12 B 1 Output Area 5 Amount of Note (Loan Amount $13,000.00 5 Periodic Rate 0.38% Number of Payments 24 3 Monthly Payment $567.42 Total Payments $13,618.12 Total Interest Paid $ 618.12 1 2

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

Indebted To Intervene Critical Lessons In Debt Communication Art And Theoretical Practice

Authors: Oliver Vodeb , Nikola Janovic Kolenc

1st Edition

1922216267,1783206411

More Books

Students also viewed these Finance questions