{"id":148913,"date":"2021-11-04T14:12:39","date_gmt":"2021-11-04T18:12:39","guid":{"rendered":"https:\/\/qa.bluevaultpartners.com\/?p=148913"},"modified":"2023-09-18T08:59:32","modified_gmt":"2023-09-18T12:59:32","slug":"dynamic-balance-sheet-modeling-for-business-planning","status":"publish","type":"post","link":"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/","title":{"rendered":"Dynamic Balance Sheet Modeling for Business Planning"},"content":{"rendered":"<h1>Dynamic Balance Sheet Modeling for Business Planning<\/h1>\n<p>September 21, 2021 | Jordan Taylor | UMB<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9364\" src=\"https:\/\/qa.bluevaultpartners.com\/wp-content\/uploads\/2016\/10\/Featured-News-Image_0007_Financing_22-300x213.jpeg\" alt=\"\" width=\"300\" height=\"213\" srcset=\"https:\/\/qa.bluevaultpartners.com\/wp-content\/uploads\/2016\/10\/Featured-News-Image_0007_Financing_22-300x213.jpeg 300w, https:\/\/qa.bluevaultpartners.com\/wp-content\/uploads\/2016\/10\/Featured-News-Image_0007_Financing_22.jpeg 600w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>The pandemic has caused an abundance of uncertain times. It\u2019s becoming repetitive to talk about, but it\u2019s of major importance for the banking industry. At one point, it looked like things were getting back normal, but then a new variant of the virus has created some confusion for the future.<\/p>\n<p>For the upcoming budgeting season, we thought it would be beneficial to discuss some dynamic options for balance sheet models that we can run for banks. These models provide an idea of what rate sensitivity analysis could look like if banks wanted to compare different scenarios with different balance sheet totals.<\/p>\n<p>Before we dive in, let\u2019s see a quick market update from second quarter 2021 to now. There really hasn\u2019t been too much change regarding interest rates, as you can see from the charts below. The effective fed funds target rate remained relatively unchanged between .08% and .10% (according to the St. Louis Federal Reserve website) while U.S. Treasury rates declined slightly.<\/p>\n<p><a class=\"fasc-button fasc-size-medium fasc-type-flat\" style=\"background-color: #33809e; color: #ffffff;\" target=\"_blank\" rel=\"noopener\" href=\"https:\/\/blog.umb.com\/institutional-banking-insight-balance-sheet-modeling-for-business-planning\/\">\u2261 Read Article<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div style=\"clear:both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Dynamic Balance Sheet Modeling for Business Planning September 21, 2021 | Jordan Taylor | UMB The pandemic has caused an abundance of uncertain times. It\u2019s becoming repetitive to talk about, &hellip; <\/p>\n<p><a href=\"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/\" class=\"read-more\">Read more<\/a><\/p>\n","protected":false},"author":3464,"featured_media":9364,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[2742,2734],"tags":[],"class_list":["post-148913","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-service-provider-news","category-umb"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Dynamic Balance Sheet Modeling for Business Planning - Blue Vault<\/title>\n<meta name=\"description\" content=\"The pandemic has caused an abundance of uncertain times. It\u2019s becoming repetitive to talk about, but it\u2019s of major importance for the...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dynamic Balance Sheet Modeling for Business Planning - Blue Vault\" \/>\n<meta property=\"og:description\" content=\"The pandemic has caused an abundance of uncertain times. It\u2019s becoming repetitive to talk about, but it\u2019s of major importance for the...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/\" \/>\n<meta property=\"og:site_name\" content=\"Blue Vault\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-04T18:12:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-18T12:59:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/qa.bluevaultpartners.com\/wp-content\/uploads\/2016\/10\/Featured-News-Image_0007_Financing_22.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"426\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"becki.clifton@bluevaultpartners.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"becki.clifton@bluevaultpartners.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/\",\"url\":\"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/\",\"name\":\"Dynamic Balance Sheet Modeling for Business Planning - Blue Vault\",\"isPartOf\":{\"@id\":\"https:\/\/bluevaultpartners.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/qa.bluevaultpartners.com\/wp-content\/uploads\/2016\/10\/Featured-News-Image_0007_Financing_22.jpeg\",\"datePublished\":\"2021-11-04T18:12:39+00:00\",\"dateModified\":\"2023-09-18T12:59:32+00:00\",\"author\":{\"@id\":\"https:\/\/bluevaultpartners.com\/#\/schema\/person\/676e3314716f6c1292fd2cbce2d1206c\"},\"description\":\"The pandemic has caused an abundance of uncertain times. It\u2019s becoming repetitive to talk about, but it\u2019s of major importance for the...\",\"breadcrumb\":{\"@id\":\"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/#primaryimage\",\"url\":\"https:\/\/qa.bluevaultpartners.com\/wp-content\/uploads\/2016\/10\/Featured-News-Image_0007_Financing_22.jpeg\",\"contentUrl\":\"https:\/\/qa.bluevaultpartners.com\/wp-content\/uploads\/2016\/10\/Featured-News-Image_0007_Financing_22.jpeg\",\"width\":600,\"height\":426},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/qa.bluevaultpartners.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dynamic Balance Sheet Modeling for Business Planning\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bluevaultpartners.com\/#website\",\"url\":\"https:\/\/bluevaultpartners.com\/\",\"name\":\"Blue Vault Partners\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bluevaultpartners.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/bluevaultpartners.com\/#\/schema\/person\/676e3314716f6c1292fd2cbce2d1206c\",\"name\":\"becki.clifton@bluevaultpartners.com\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bluevaultpartners.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f78f7e1d0eaf01db87dbca7e1393a9e8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f78f7e1d0eaf01db87dbca7e1393a9e8?s=96&d=mm&r=g\",\"caption\":\"becki.clifton@bluevaultpartners.com\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dynamic Balance Sheet Modeling for Business Planning - Blue Vault","description":"The pandemic has caused an abundance of uncertain times. It\u2019s becoming repetitive to talk about, but it\u2019s of major importance for the...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/","og_locale":"en_US","og_type":"article","og_title":"Dynamic Balance Sheet Modeling for Business Planning - Blue Vault","og_description":"The pandemic has caused an abundance of uncertain times. It\u2019s becoming repetitive to talk about, but it\u2019s of major importance for the...","og_url":"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/","og_site_name":"Blue Vault","article_published_time":"2021-11-04T18:12:39+00:00","article_modified_time":"2023-09-18T12:59:32+00:00","og_image":[{"width":600,"height":426,"url":"https:\/\/qa.bluevaultpartners.com\/wp-content\/uploads\/2016\/10\/Featured-News-Image_0007_Financing_22.jpeg","type":"image\/jpeg"}],"author":"becki.clifton@bluevaultpartners.com","twitter_card":"summary_large_image","twitter_misc":{"Written by":"becki.clifton@bluevaultpartners.com","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/","url":"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/","name":"Dynamic Balance Sheet Modeling for Business Planning - Blue Vault","isPartOf":{"@id":"https:\/\/bluevaultpartners.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/#primaryimage"},"image":{"@id":"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/#primaryimage"},"thumbnailUrl":"https:\/\/qa.bluevaultpartners.com\/wp-content\/uploads\/2016\/10\/Featured-News-Image_0007_Financing_22.jpeg","datePublished":"2021-11-04T18:12:39+00:00","dateModified":"2023-09-18T12:59:32+00:00","author":{"@id":"https:\/\/bluevaultpartners.com\/#\/schema\/person\/676e3314716f6c1292fd2cbce2d1206c"},"description":"The pandemic has caused an abundance of uncertain times. It\u2019s becoming repetitive to talk about, but it\u2019s of major importance for the...","breadcrumb":{"@id":"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/#primaryimage","url":"https:\/\/qa.bluevaultpartners.com\/wp-content\/uploads\/2016\/10\/Featured-News-Image_0007_Financing_22.jpeg","contentUrl":"https:\/\/qa.bluevaultpartners.com\/wp-content\/uploads\/2016\/10\/Featured-News-Image_0007_Financing_22.jpeg","width":600,"height":426},{"@type":"BreadcrumbList","@id":"https:\/\/qa.bluevaultpartners.com\/dynamic-balance-sheet-modeling-for-business-planning\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/qa.bluevaultpartners.com\/"},{"@type":"ListItem","position":2,"name":"Dynamic Balance Sheet Modeling for Business Planning"}]},{"@type":"WebSite","@id":"https:\/\/bluevaultpartners.com\/#website","url":"https:\/\/bluevaultpartners.com\/","name":"Blue Vault Partners","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bluevaultpartners.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/bluevaultpartners.com\/#\/schema\/person\/676e3314716f6c1292fd2cbce2d1206c","name":"becki.clifton@bluevaultpartners.com","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bluevaultpartners.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f78f7e1d0eaf01db87dbca7e1393a9e8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f78f7e1d0eaf01db87dbca7e1393a9e8?s=96&d=mm&r=g","caption":"becki.clifton@bluevaultpartners.com"}}]}},"_links":{"self":[{"href":"https:\/\/qa.bluevaultpartners.com\/wp-json\/wp\/v2\/posts\/148913"}],"collection":[{"href":"https:\/\/qa.bluevaultpartners.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qa.bluevaultpartners.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qa.bluevaultpartners.com\/wp-json\/wp\/v2\/users\/3464"}],"replies":[{"embeddable":true,"href":"https:\/\/qa.bluevaultpartners.com\/wp-json\/wp\/v2\/comments?post=148913"}],"version-history":[{"count":3,"href":"https:\/\/qa.bluevaultpartners.com\/wp-json\/wp\/v2\/posts\/148913\/revisions"}],"predecessor-version":[{"id":162043,"href":"https:\/\/qa.bluevaultpartners.com\/wp-json\/wp\/v2\/posts\/148913\/revisions\/162043"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/qa.bluevaultpartners.com\/wp-json\/wp\/v2\/media\/9364"}],"wp:attachment":[{"href":"https:\/\/qa.bluevaultpartners.com\/wp-json\/wp\/v2\/media?parent=148913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qa.bluevaultpartners.com\/wp-json\/wp\/v2\/categories?post=148913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qa.bluevaultpartners.com\/wp-json\/wp\/v2\/tags?post=148913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}