FIN 370 Week 2 Cash Flow Problem Sets\tComplete\u00a0the following problem sets from Chapter 5 in Microsoft\u00ae\u00a0Excel\u00ae:\t\u00b7 \ufffd\u00a0\u00a0\u00a0 5-1\t\u00b7 \ufffd\u00a0\u00a0\u00a0 5-3\t\u00b7 \ufffd\u00a0\u00a0\u00a0 5-5\t\u00b7 \ufffd\u00a0\u00a0\u00a0 5-7\t\u00b7 \ufffd\u00a0\u00a0\u00a0 5-12\t\u00b7 \ufffd\u00a0\u00a0\u00a0 5-15\t\u00b7 \ufffd\u00a0\u00a0\u00a0 5-39 (Calculate monthly payment only)\t\u00a0\t5-1FutureValue Compute the future value in year 9 of a $2,000 deposit in year 1 and another $1,500 deposit at the end of year 3 using a 10 percent interest rate.\t\u00a0\t5-3 Future Value of an Annuity What is the future value of a $900 annuity payment over five years if interest rates are 8 percent?\t\u00a0\t\u00a0\t5-5 Present Value Compute the present value of a $2,000 deposit in year 1 and another $1,500 deposit at the end of year 3 if interest rates are 10 percent.\t5-7 Present Value of an Annuity What’s the present value of a $900 annuity payment over five years if interest rates are 8 percent?\t\u00a0\t5-12 Present Value of an Annuity Due If the present value of an ordinary, 6-year annuity is $8,500 and interest rates are 9.5 percent, what’s the present value of the same annuity due?\t\u00a0\t5-15Effective Annual Rate A loan is offered with monthly payments and a 10 percent APR. What’s the loan’s effective annual rate (EAR)?\t\u00a0\t\u00a0\t\u00a0\t5-39 Loan Payments You wish to buy a $25,000 car. The dealer offers you a 4-year loan with a 9 percent APR. What are the monthly payments? How would the payment differ if you paid interest only? What would the consequences of such a decision be?<\/p>\n","protected":false},"excerpt":{"rendered":"
FIN 370 Week 2 Cash Flow Problem Sets Complete\u00a0the following problem sets from Chapter 5 in Microsoft\u00ae\u00a0Excel\u00ae: \u00b7 \ufffd\u00a0\u00a0\u00a0 5-1 \u00b7 \ufffd\u00a0\u00a0\u00a0 5-3 \u00b7 \ufffd\u00a0\u00a0\u00a0 5-5 \u00b7 \ufffd\u00a0\u00a0\u00a0 5-7 \u00b7 \ufffd\u00a0\u00a0\u00a0 5-12 \u00b7 \ufffd\u00a0\u00a0\u00a0 5-15 \u00b7 \ufffd\u00a0\u00a0\u00a0 5-39 (Calculate monthly Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-216484","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/216484","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=216484"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/216484\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=216484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=216484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=216484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}