Kaitlyn.Stewart-EX2021-ChallengeYourself-4-3

.xlsx
School
Liberty University **We aren't endorsed by this school
Course
BUSI 201
Subject
Economics
Date
Oct 13, 2023
Pages
14
Uploaded by kaitstewart1 on coursehero.com
Scenario Summary Current Values: Original Financing Mid-Size Changing Cells: $B$3 $ 70,000 $ 22,999 $ 27,999 $B$5 $ 2,500 $ - $ 1,500 $B$8 60 36 36 $B$9 2.90% 3.90% 3.90% Result Cells: $B$10 $ 1,138.19 $ 560.08 $ 663.26 $B$12 $ 68,291.53 $ 20,162.93 $ 23,877.35 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.
Dream Car $ 70,000 $ 2,500 60 2.90% $ 1,138.19 $ 68,291.53 h
New Car Loan Loan Inputs Sticker price $ 70,000 Trade in $ 4,000 Cash back offer $ 2,500 Loan amount $ 63,500 Loan term (months) 60 Loan interest (APR) 2.90% Loan payment $ 1,138.19 Total cost of the car $ 68,291.53
Page1of 14
Uploaded by kaitstewart1 on coursehero.com