Help! Doing Time Value of Money using Excell --- how do I do these problems ???? What is the formula for excell...

12. What is the house value on a 10% down mortgage with payments of $1491 per month for 30 years at 6%? ANSWER is 276318 but need formula in excell to work it

It is in these problems attached ... I have figured the others out but need help with this type...

Thank you JK

1 ASM01.02 1. Future Value. What is the future value of a. $1192 invested for 9 years at 11 percent compounded annually? b. $1127 invested for 9 years at 10 percent compounded annually? c. $550 invested for 6 years at 8 percent compounded annually? d. $1120 invested for 3 years at 9 percent compounded annually? 2. Present Value. What is the present value of a. $1174 to be received 11 years from now at a 13 percent discount rate? b. $727 to be received 13 years from now at a 9 percent discount rate? 0 $667 to be received 9 years from now at a 11 percent discount rate? d. $406 to be received 6 years from now at a 15 percent discount rate? 3. Future Value of an Annuity. What is the future value of a. $1195 a year for 6 years at 5 percent compounded annually? b. $1126 a year for 9 years at 11 percent compounded annually? c. $1092 a year for 9 years at 15 percent compounded annually? d. $202 a year for 6 years at 15 percent compounded annually? 4. Present Value of an Annuity. What is the present value of a. $795 a year for 15 years at a 12 percent discount rate? b. $1127 a year for 11 years at a 14 percent discount rate? c. $623 a year for 12 years at a 7 percent discount rate? d. $873 a year for 8 years at a 14 percent discount rate? 5. How many years will it take to grow a. $733 to a value of 2,201.96 at a compound rate of 13 percent ? b. $598 to a value of 1,705.85 at a compound rate of 14 percent ? c. $1043 to a value of 1,618.04 at a compound rate of 5 percent ? d. $274 to a value of 770.67 at a compound rate of 9 percent ? 6. Interest Rate. At what interest rate will it take to grow a. $328 to a value of 528.25 over 5 years? b. $391 to a value of 942.25 over 13 years? c. $903 to a value of 2,576.36 over 11 years? d. $343 to a value of 912.39 over 7 years? 7. Annuity. How many years will it take for a payment of a. $813 to grow to 14,543.31 at a compound rate of 7 percent ? b. $454 from a future value of 4,580.41 at a compound rate of 12 percent ? c. $1146 from a future value of 11,211.63 at a compound rate of 11 percent ? d. $234 from a future value of 3,314.37 at a compound rate of 11 percent ? 8. Annuity. At what interst rate will a payment of a. $1094 grow to 22,033.95 over a period of 12 years? b. $873 grow to 12,061.76 over a period of 10 years? c. $259 grow to 5,944.93 over a period of 13 years? d. $633 grow to 18,980.32 over a period of 13 years? ASM01.02 9. Car Loans (Hint: P/Y=12) How much is a car loan with a payment of a. $444 per month for 3 years at 6 interest per year? b. $547 per month for 6 years at 14 interest per year? c. $314 per month for 2 years at 14 interest per year? d. $212 per month for 6 years at 12 interest per year? 10. Car Loans. (Hint: P/Y=12) How many months will you pay on a car loan of a. $41232 with a payment of 778.10 per month at 5 interest per year? b. $32798 with a payment of 770.26 per month at 6 interest per year? c. $26044 with a payment of 816.12 per month at 8 interest per year? d. $34080 with a payment of 1,572.62 per month at 10 interest per year? 11. Car Loans. (Hint: P/Y=12) What is the interest rate on a loan of a. $8000 with a payment of 202.90 per month for' 4 years? b. $16000 with a payment of 445.29 per month for' 4 years? c. $24000 with a payment of 533.87 per month for' 5 years? d. $32000 with a payment of 744.58 per month for' 5 years? 12. What is the house value (critical thinking required) on a 10 percent down mortgage with payments of a. $1,491.00 per month for 30 years at 6 percent interest? b. $8,534.46 per month for 15 years at 12 percent interest? c. $2,345.35 per month for 30 years at 4 percent interest? d. $3,358.23 per month for 15 years at 9 percent interest? 13. Mortgages. (Hint: P/Y=12) What is the interest rate on a mortgage of a. $221956 with a payment of 2,806.51 for 30 years? b. $225562 with a payment of 2,563.73 for 15 years? c. $147880 with a payment of 706.00 for 30 years? d. $168673 with a payment of 1,333.86 for 15 years? 14. Mortgage. (Hint: P/Y=12) What is the payoff on a 30 year, 6% original mortgage of a. $128280 with a payment of 769.10 with 7 years remaining? b. $243558 with a payment of 1,460.25 with 7 years remaining? c. $143573 with a payment of 860.79 with 11 years remaining? d. $112520 with a payment of 674.61 with 12 years remaining? ASM01.02 15. Stock. What is the value of a stock with a requried return of 10% and has growth of a. 16 % for 2 years then growth of 6 % thereafter, with an intial dividend of 2.25 ? b. 11 % for 2 years then growth of 7 % thereafter, with an intial dividend of 1.25 ? c. 9 % for 2 years then growth of 8 % thereafter, with an intial dividend of 3.25 ? d. 11 % for 2 years then growth of 8 % thereafter, with an intial dividend of 2.25 ? 16. Stock. What is the value of a stock with a a. $1.25 dividend just paid and a 7 % required return with 0 % growth? b. $1.25 dividend just paid and a 7 % required return with 1 % growth? c. $0.25 dividend just paid and a 12 % required return with 2 % growth? d. $1.25 dividend just paid and a 12 % required return with 3 % growth? 17. Stock. What is the requried rate of return on a stock with a a. $1.5 expected dividend and a 40 price with 7 % growth? b. $3.25 expected dividend and a 29 price with 8 % growth? c. $4.5 expected dividend and a 29 price with 9 % growth? d. $0.25 expected dividend and a 19 price with 10 % growth? 18. Stock. What is the growth rate of the stock with a a. $2.5 expected dividend and a 36 price with 15 % required return? b. $2 expected dividend and a 22 price with 12 % required return? c. $3 expected dividend and a 16 price with 11 % required return? d. $1.77 expected dividend and a 21 price with 14 % required return? 19. Bond. What is the value of a $1000 par value bond with annual payments of a a. 12 % coupon with a maturity of 20 years and a 15 % required return? b. 9 % coupon with a maturity of 10 years and a 7 % required return? c. 6 % coupon with a maturity of 10 years and a 11 % required return? d. 8 % coupon with a maturity of 20 years and a 6 % required return? 20. Bond. What is the yield to maturity of a $1000 par value bond with a a. 7.5 % semi-annual coupon and 20 years to maturity and a 903 price? b. 8.5 % semi-annual coupon and 13 years to maturity and a 994 price? c. 9.5 % annual coupon and 19 years to maturity and a 986 price? d. 6.5 % annual coupon and 7 years to maturity and a 1241 price? 1 ASM01.02 Answer $3,049.18 $2,657.41 $872.78 $1,450.43 Yours 1 a. b. c. d. ($3,049.18) ($2,657.41) ($872.78) ($1,450.43) 2 $306.06 $237.13 $260.75 $175.53 a. b. c. d. ($306.06) ($237.13) ($260.75) ($175.53) 3 $8,128.29 $15,948.63 $18,330.14 $1,768.26 a. b. c. d. $8,128.29 $15,948.63 $18,330.14 $1,768.26 4 $5,414.64 $6,145.23 $4,948.29 $4,049.73 a. b. c. d. ($5,414.64) ($6,145.23) ($4,948.29) ($4,049.73) 5 9 8 9 12 a. b. c. d. $9.00 8.0000148519 9.0000591649 11.9999977383 6 10 7 10 15 a. b. c. d. 10% 7% 10% 15% 7 12 7 7 9 a. b. c. d. 11.9999995009 6.9999986024 6.9999990527 9.0000009556 8 9 a. 7 b. 9 c. 9% 7% 9% 13 d. 1 ASM01.02 # 1 Answer $14,594.73 $26,546.00 $6,539.91 $10,843.88 13% Yours 9 a. b. c. d. $14,594.73 $26,546.00 $6,539.91 $10,843.88 10 60 a. 48 b. 36 c. 24 d. 59.9998866346 48.0001396003 36.0002143899 23.9999846257 11 10 a. 15 b. 12 c. 14 d. 10% 15% 12% 14% 12 276318 a. 790117 b. 545844 c. 367888 d. 13 15.00 a. 11.00 b. 4.00 c. 5.00 d. 15% 11% 4% 5% 14 $52,647.47 $99,958.78 $83,031.72 $69,130.92 a. b. c. d. ($52,649.49) ($99,960.71) ($83,032.85) ($69,132.57) 1 ASM01.02 # 1 Answers 77.44 a. 49.63 b. 180.33 c. 131.72 d. Yours 15 16 17.86 a. 21.04 b. 2.55 c. 14.31 d. 17 10.75 a. 19.21 b. 24.52 c. 11.32 d. 18 8.06 a. 2.91 b. -7.75 c. 5.57 d. 19 $812.22 $1,140.47 $705.54 $1,229.40 a. b. c. d. 20 8.52% a. 8.58% b. 9.66% c. 2.68% d