Amount of loan taken =23000-9000 =14000
Monthly payments are calculated using the PMT function:-
=PMT(rate,nper,pv)
=PMT(5%/12,3*12,14000)
=419.59
Question 4 10 pts You're eyeing on to purchase a $23,000 vehicle. With a $9.000 down...
Question 9 10 pts Consider a $25,000, three-year loan at an interest rate of 4%, payments to be made monthly. What is the monthly payment using add-on interest? Note: Show your answer in units of dollars, use plain numbers with at least two digits after the decimal (e.g, for $12,345.67, type 12345.67).
D Question 3 10 pts You are willing to pay $960 monthly for a car loan and currently have $2,000 that can be used toward down payment. You are offered a three-year loan at an APR of 5% What is the maximum car price that you can afford? Note: Show your answer in units of dollars, use plain numbers with at least two digits after the decimal (e.g., for $12,345.67, type 12345.67).
Question 6 10 pts Value a bond that is $1,000 par, semi-annual coupon payments, 20 years to maturity. 10% coupon rate, and with an 8% required (market) rate. Note: Show your answer in units of dollars, use plain numbers with at least two digits after the decimal (e.g., for $12,345.67, type 12345.67).
Question 3 10 pts A stock pays annual, fixed dividends of $21 forever. Assuming a required rate of return of 7%, what is the value of the stock? Note: Show your answer in units of dollars, use plain numbers with at least two digits after the decimal (e.g., for $12,345.67, type 12345.67).
Question 1 10 pts Consider an annuity that pays $700 per year for 11 years, with the first payment starting a year later (t=1). What is its future value 11 years from now at an expected return of 14% per year? Note: Show your answer in units of dollars, use plain numbers with at least two digits after the decimal (e.g., for $12,345.67, type 12345.67).
Question 5 10 pts Creeper estimates that financial resources worth $660,000 will be necessary to protect his family after his death. What amount of insurance, as per the needs analysis method, should Creeper purchase if he has current financial resources worth $500,000? Note: Show your answer in units of dollars, use plain numbers with at least two digits after the decimal (e.g., for $12,345.67, type 12345.67).
Question 2 10 pts A stock pays dividends annually. It just paid a dividend of $5 that is expected to grow at a constant rate of 4% forever. Assuming a required rate of return of 13%, what is the value of the stock using the constant growth model? Note: Show your answer in units of dollars, use plain numbers with at least two digits after the decimal (e.g., for $12,345.67, type 12345.67).
Question 8 10 pts Consider a $18,000, three-year loan at an interest rate of 2%, payments to be made monthly. What is the APR using simple interest? Note: Show your answer in units of percents, use plain numbers with at least two digits after the decimal (e.g., for 12.34%, type 12.34).
Question 4 10 pts Estimate the yield to maturity of a bond that is $1,000 par, semi-annual coupon payments, 25 years to maturity, 10% coupon, and is currently selling for $1,200. Note: Show your answer in units of percents, use plain numbers with at least two digits after the decimal (e.g., for 12.34%, type 12.34).
Question 3 10 pts An APR of 18% under monthly compounding gives an EAR of Note: Show your answer in units of percents, use plain numbers with at least two digits after the decimal (e.g., for 12.34%, type 12.34).