Question: please post answer eith excel formulas Q2 You are borrowing $32,000 to purchase a new car, and you are considering two loan options, The first

please post answer eith excel formulas

Q2 You are borrowing $32,000 to purchase a new car, and you are considering two loan options, The first is a 4 year loan with a 3.5% Interest rate, and the second is a 3 year loan with a 2.8% Interest rate. If your personal discount rate is 11.3% what is the Net Present Value of picking the second loan over the first one? (Hint: You need to think about what is different if you pick the second loan. What are your marginal cash flows?) NPV Cash Flow Month 1 2 3 4 5 6 2 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

UNIT 5 QZ, Q-20 UNIT 5 / UNIT 8 QUESTIONS KEEP ANSWERS SEPARATE BY UNITS UNIT II STUDY GUIDE Consumer Mathematics Reading Assignment See information below. Key Terms 1. Add-on interest method 2....

Please Help, my team and I have different answers. Problem 6.34 Present Value Tirade Owens, a professional athlete, currently has a contract that will pay him a large amount in the first year of his...

Instructions: Use the formulas for compound interest and amortizations to help you answer the questions below. As you work through the problems, try to spot the patterns that emerge to help you...

Using the Assignment Tools to Complete This Exam The tools for working with this exam are found in the Assignment menu. The Instruction Sheet icon displays all tasks for the exam at the same time in...

Assignment 2 Archway Computer advertises a $1,499 notebook computer that you can take home with no money down in exchange for end of the month payments of $42 at 14.9% APR. How many monthly payments...

Please answer questions in 2 hours. I have done them all the free response is what I need the most help with and question 20. Thank you. Question 2 (3.9 points) Two years ago an investor purchased a...

Please answer questions in 2 hours. I have done them all the free response is what I need the most help with and question 20. Thank you. Question 2(3.9 points) Two years ago an investor purchased a...

C39 B 1 Question 2: fx D E F G H 2 You are in the market to purchase a new car. The car has a price $ 28,600 The dealership has offered you the following two financing options. 3 Assume that interest...

you are borrowing $ 6 3 , 0 0 0 to purchase a new car, and you are considering two loan options. the first is a 7 year loan with an 8 . 6 % interest rate, and the second is a 4 year loan with an 8 ....

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

In many experimental thermo grams, such as that shown in Fig. 2.16, the baseline below TI is at a different level from that above T2 Explain this observation.

An analyst has gathered the following information about ABC Inc. and DEF Inc. The respective credit ratings are AA and BBB with CDS spreads of 200 and 300 basis points each. The associated...

A ( n ) 8 % APR with semiannually compounding is closest to A . an EAR of 6 . 5 6 % B . an EAR of 1 6 . 4 % C . an EAR of 8 . 2 % D . an EAR of 9 . 8 4 %

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".