Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use excel to do your analysis. Follow the steps and have what if analysis data table for your car loan case. You are loaning 20,000

Use excel to do your analysis. Follow the steps and have what if analysis data table for your car loan case. You are loaning 20,000 with 8.5 % interest for 60 months. In this scenario you need to pay $410 monthly. Use Excel’s PMT function to calculate monthly loan amount. What will your monthly payment be if you have different interest rates and terms (total term of months)? Use Excel’s what if data table analysis to check various options with different interest rates and terms. (Range your interest rates between 3% to 11% with 0.5 % increments, term as 24 months to 90 months increasing 6 months each time.) Also add data validation to loan amount.

Prepare a list of various loan amounts (15,000 20,000 25,000)

My Car Loan

Loan Amount

20000

Term (months)

60

Interest Rate

8.5%

Payment

($410.00)


Step by Step Solution

3.48 Rating (148 Votes )

There are 3 Steps involved in it

Step: 1

For... 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

Document Format ( 2 attachments)

PDF file Icon
60900f91021a7_21461.pdf

180 KBs PDF File

Word file Icon
60900f91021a7_21461.docx

120 KBs Word File

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

Personal Finance

Authors: Jeff Madura

5th edition

132994348, 978-0132994347

More Books

Students also viewed these Banking questions

Question

What are your most important product lines or services?

Answered: 1 week ago

Question

Describe Hobbess beliefs about human nature.

Answered: 1 week ago

Question

Who offers health insurance? Do employers offer health insurance?

Answered: 1 week ago