2 Cash Flow Problem Sets<\/p>\n
Complete the following problem sets from Chapter 5 in Microsoft\u00ae Excel\u00ae:<\/p>\n
5-1
\n5-3
\n5-5
\n5-7
\n5-12
\n5-15
\n5-39 (Calculate monthly payment only)
\nClick the Assignment Files tab to submit your assignment.<\/p>\n
5-1 Future Value: 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. (LG5-1)<\/p>\n
5-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? (LG5-2)<\/p>\n
5-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. (LG5-3)<\/p>\n
5-7 Present Value of an Annuity: What\u2019s the present value of a $900 annuity payment over five years if interest rates are 8 percent? (LG5-4)<\/p>\n
5-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\u2019s the present value of the same annuity due? (LG5-6)<\/p>\n
5-15 Effective Annual Rate: A loan is offered with monthly payments and a 10 percent APR. What\u2019s the loan\u2019s effective annual rate (EAR)? (LG5-7)<\/p>\n
5-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? (LG5-9)<\/p>\n","protected":false},"excerpt":{"rendered":"
2 Cash Flow Problem Sets Complete the following problem sets from Chapter 5 in Microsoft\u00ae Excel\u00ae: 5-1 5-3 5-5 5-7 5-12 5-15 5-39 (Calculate monthly payment only) Click the Assignment Files tab to submit your assignment. 5-1 Future Value: Compute 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-18434","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/18434","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=18434"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/18434\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=18434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=18434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=18434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}