Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. create an excel spreadsheet to enable users to cal

Create an Excel spreadsheet to enable users to calculate can compare 3 car loans. The objective...

70.2K

Verified Solution

Question

Finance

Create an Excel spreadsheet to enable users to calculate cancompare 3 car loans. The objective is to see the Total Amount Paidfor a given loan amount, with different interest rates and a numberof finance months. Allow the user to enter car price and downpayment amount in cells that will be used by all 3 loan options.Add charts to compare the three loans visually. Make sure tocompare monthly, months, as well as the total cost of the callafter all payment, is done.

Answer & Explanation Solved by verified expert
4.1 Ratings (605 Votes)
The 3 car loans that I have considered below areLoan 1 Loan amount is 100000 with 0 down payment and paymentto be made in 24 months with interest rate of 12Here monthly payment will be PMT1212 24 90000 470735 per monthLoan 2 Loan amount is 100000 with 0 down payment and paymentto be made in 12 months with interest rate of 12Here monthly payment will be PMT1212 12 100000 888488 per monthLoan 3 Loan amount is 100000 with 0 down payment and paymentis made in 18 months with interest rate of 18Here monthly payment will be PMT1812 18 100000 638058 per monthThe excel for all the 3 options    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Create an Excel spreadsheet to enable users to calculate cancompare 3 car loans. The objective is to see the Total Amount Paidfor a given loan amount, with different interest rates and a numberof finance months. Allow the user to enter car price and downpayment amount in cells that will be used by all 3 loan options.Add charts to compare the three loans visually. Make sure tocompare monthly, months, as well as the total cost of the callafter all payment, is done.

Other questions asked by students

Q

Sylvan Forests Ltd is analysing a new paper product with the following after-tax cash flows: YEAR CASH FLOW 0 -200,000 1 60,000 2 64,000 3 64,000 4 68,000 5 68,000 Sylvan...

Finance
Q

Which of the following types of inheritance involve epigenetic modifications? Choose All That Apply (pts deducted for...

Biology
Q

Triangle ABC and EFG are similar with the measurements shown G C AA 7 A...

Geometry
Q

10 Perpetuities Perpetuities are also called annuities with an extended or unlimited life Based on...

Basic Math
Q

A room contains 4 people, each of a different age. The people leave the room...

Calculus
Q

Choose the expression that is equivalent to x 3x 4 in each of the tables...

Algebra
Q

Sheridan Company uses a...

Accounting
Q

Best Buy uses the lower-of-cost-or-net realizable value basis for its inventory. The following data are...

Accounting
Q

Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: The...

Accounting
Q

Which one below is NOT an advantage of Activity Based Costing (ABC)? A) ABC is...

Accounting
Q

S P I 3 cor Student Name Case 85goon B.V-5 On Jan 1, 2018 Droop...

Accounting
Q

Using the Delta Company Ltd. financial statements on the next tab and additional information provided,...

Accounting