Access over 20 million homework & study documents

search

Xlsx

Content type
User Generated
Subject
Excel
Type
Homework
Rating
Showing Page:
1/14

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/14

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/14

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 14 pages?
Access Now
Unformatted Attachment Preview
Scenario Summary Current Values: Original Financing Intermediate Car Changing Cells: Price $ 62.700 $ 24.595 $ 33.999 CashBack $ 2.500 $ $ 1.500 Months 60 24 36 APR 3,90% 1,90% 2,40% Result Cells: Payment $ 1.041,66 $ 896,46 $ 835,68 TotalCost $ 62.499,60 $ 21.515,04 $ 30.084,47 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. Luxury Car $ $ $ $ 62.700 2.500 60 3,90% 1.041,66 62.499,60 New Car Loan Sticker price Trade in Cash back offfer Loan Amount Loan Inputs $ 62.700 $ 3.500 $ 2.500 $ 56.700 Loan term (months) Loan interest (APR) Loan payment 60 3,90% $ 1.041,66 Total cost of the car $ 62.499,60 Model Displ BMW i3 BEV Average BMW i3 BEV (60Ah) Average CHEVROLET Bolt Average FIAT 500e Average FORD Focus Electric Average HYUNDAI Ioniq Average HYUNDAI Ioniq Blue Average HYUNDAI Ioniq Electric Average HYUNDAI Sonata Hybrid Average HYUNDAI Sonata Hybrid SE Average KIA Niro Average KIA Niro FE Average KIA Niro Touring Average KIA Optima Hybrid Average KIA Soul Electric Average MERCEDES-BENZ B250e Average MITSUBISHI i-MiEV Average NISSAN Leaf Average TESLA Model S 60D Average TESLA Model S 60kWh Average TESLA Model S 75D Average TESLA Model S 75kWh Average TESLA Model S P100D Average TESLA Model S P90D Average TESLA Model X 60D Average TESLA Model X 75D Average TESLA Model X 90D Average TESLA Model X P100D Average TESLA Model X P90D Average VOLKSW ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4