Please include a screenshot with excel formulas showing how you got the answers along with a screenshot of the answers. Thank you! If you zoom in you can see the font.
AutoSave As... Homework 1 Part 2 (Empty) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments fx - - - 2 A e Detinc Name v Vas 16 e Trace Precedents Trece Dependente Show Error Watch Hemove Arrows Formulas Checking Window E ! Calculate Now! Calculation calculate Sheet Options Text Insert Function Date & Lookup & Math & More Time Reference Trig Functions Create from Selection AutoSum Recently Financial Logical Used + x x C10 T A B E G H 1 1 K L M N P R Question 2 3 You want to buy a car by taking out a 3 year loan for $15,000 with a 7%. Interest rate. 5 A - Create an amortization table of the loan that shows the portion of interest and principal on each payment. 6 7 Period Beginning Balance Payment Interest Principal Ending Balance 1 2 3 4 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 28 30 31 32 33 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 21 Instructions 34 35 36 37 38 20 Your Info Q1 Q2 Q3 + Ready S: + 100% AutoSave As... Homework 1 Part 2 (Empty) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments fx 2 A Detinc Name v Vas 16 - e Trace Precedents Trece Dependente Show Error Watch Hemove Arrows Formulas Checking Window E ! Calculate Now! Calculation calculate Sheet Options Text Insert Function Auto Sur Recently Financial Logical Used Date & Lookup & Math & Math & More Time Reference Trig Functions Create from Selection C10 T xfx B C A D E G H 1 1 K L M N P R 33 34 35 36 37 38 39 40 41 42 43 44 45 25 26 27 28 29 30 31 32 33 34 35 36 B - Create a stacked column chart that shows interest and principal on each column 44 4 49 50 Place Chart Here! 52 53 54 55 56 57 58 59 60 61 62 63 C-Suppose that you have the option to buy the car with a 3 year car loan or lease the car during the same period of time. The 3 year lease aption will require a $3,000 down payment and monthly payments of $350. If the salvage value of the new vehide after 3 years is $5,000 and you can invest at a rate of return of 4%, what is your best option? (Ignore your old vehicle.) 64 65 66 G7 68 69 70 Buy Personal Investment Rate Salvage Value Car Loan Payments $ 4% 5,000.00 Instructions Your Info Q1 Q2 Q3 + Ready S: + 100% AutoSave As... Homework 1 Part 2 (Empty) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments fx 2 2 A A Detinc Name v Vas 16 e Trace Precedents Trece Dependents Show Error Watch Hemove Arrows Formulas Checking Window E ! Calculate Now! Calculation calculate Sheet Options Text Insert Function AutoSum Recently Financial Logical Used Date & Lookup & Math & More Time Reference Trig Functions Create from Selection C10 A x fx T B D E G H 1 1 K L M N P R A hz 63 C-Suppose that you have the option to buy the car with a 3 year car loan or lease the car during the same period of time. The 3 year lease option will require a $3,000 down payment and monthly payments of $350. If the salvage value of the new vehide after 3 years is $5,000 and you can invest at a rate of return of 4%, what is your best option? (Ignore your old vehicle. ) 64 65 | 66 67 68 GS 70 Buy Personal Investment Rate Salvage Value Car Loan Payments 48 5.000.00 $ Lease Down Payment Monthly Payments $ $ 3,000.00 350.00 72 73 24 75 76 77 78 29 NPV of Buying NPV of Leasing Buy or Lease 8 92 83 84 85 86 88 89 90 92 ELLER 93 94 95 96 97 98 99 110 Instructions Your Infos Q1 Q2 93 + Ready S: + 100% %
