{"id":60,"date":"2020-09-19T01:03:20","date_gmt":"2020-09-19T01:03:20","guid":{"rendered":"http:\/\/www.slameeting.com\/bodoct2021\/?page_id=60"},"modified":"2021-10-12T17:51:01","modified_gmt":"2021-10-12T17:51:01","slug":"revenue-forecast","status":"publish","type":"page","link":"https:\/\/www.slameeting.com\/bodoct2021\/revenue-forecast\/","title":{"rendered":"Revenue Forecast"},"content":{"rendered":"\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h1 class=\"wp-block-heading\">Revenue Forecast<\/h1>\n\n\n\n\n\n<h2 class=\"has-text-align-left wp-block-heading\">2021 Revenue Prediction<\/h2>\n\n\n\n<p>Based on actual premium received through September, the data implies that we will bring in <strong>$32.5M in registered stamping fees <\/strong>by the end of 2021, based on a<strong> submitted premium of $13.5B. <\/strong>This is a result of a <strong>21% increase in received premium from 2020 to 2021. <\/strong>We expect <strong>transaction counts to come in at around 820,000 (6% increase).<\/strong><\/p>\n\n\n\n<h6 class=\"has-text-align-left wp-block-heading\">2020 Predictions<\/h6>\n\n\n\n<p>Stamping Committee\/Board Predictions for 2020 from the 2019 Stamping Meeting:&nbsp;<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>In the 2020 Stamping Committee Meeting, we predicted 2021 premium to be $11.7B or 8.1% growth and stamping fees to be $24.5M. [Exhibit A-1]<\/li><li>Transactions were expected to grow 5.1% to 768,000 which we expect and to hold tight for the upcoming years at 5-7% growth. [Exhibit A-2]<\/li><li>The stamping fee lag extended well into 2021, farther than what we had expected.&nbsp; 2021 stamping fees did not increase at the same rate as the premium.&nbsp; This appears to largely be due to broker backlogs from Covid-19; however, policies have been coming in less late this year.&nbsp; Average lag from effective date to filing date in in 2020 is 142 days and in 2021 it averaged 119 days. [Exhibit A-3]<\/li><\/ol>\n\n\n\n<h6 class=\"has-text-align-left wp-block-heading\">2021 Predictions<\/h6>\n\n\n\n<p>Multiple Models were used, Outliers Releveled:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Using the 2021 actual monthly premium numbers, we forecasted the remaining months of 2021 for premium using several models with a high degree of fit. [Exhibit A-4]<\/li><li>As shown in the first table [Exhibit A-1] we are on track to bring in over $3M per month for the remaining three months of this fiscal year, bringing us to approximately $32.5M by the end of 2021.\u00a0 This represents a 33% increase over 2020 in stamping fees.\u00a0 Note that 12% of this increase was due to the stamping fee increase (still receiving prior stamping fee policies at first half of the year) and the other 21% was due to increased filed premium.<\/li><\/ol>\n\n\n\n\n\n<h2 class=\"has-text-align-left wp-block-heading\">Revenue Forecast Exhibits<\/h2>\n\n\n\n<h6 class=\"wp-block-heading\">A-1: Monthly FORECAST FOR 2021 PREMIUM AND StAMPING FEES<\/h6>\n\n\n<div class=\"wpdt-c\">\n    <div class=\"alert alert-danger m-10\" role=\"alert\">\n        <span class=\"wdt-alert-title f-600\">Error<br><\/span>\n        <span class=\"wdt-alert-subtitle\">You are trying to load a table of an unknown type. Probably you did not activate the addon which is required to use this table type.<\/span>\n    <\/div>\n<\/div>\n\n\n<div class=\"wpdt-c\">\n    <div class=\"alert alert-danger m-10\" role=\"alert\">\n        <span class=\"wdt-alert-title f-600\">Error<br><\/span>\n        <span class=\"wdt-alert-subtitle\">You are trying to load a table of an unknown type. Probably you did not activate the addon which is required to use this table type.<\/span>\n    <\/div>\n<\/div>\n\n\n\n<h6 class=\"wp-block-heading\">A-1: Total Premium by Effective\/Submitted Year (2005-2023) in $M<\/h6>\n\n\n<div class=\"visualizer-front-container\" id=\"chart_wrapper_visualizer-69-692575453\"><style type=\"text\/css\" name=\"visualizer-custom-css\" id=\"customcss-visualizer-69\">.locker,.locker-loader{position:absolute;top:0;left:0;width:100%;height:100%}.locker{z-index:1000;opacity:.8;background-color:#fff;-ms-filter:\"progid:DXImageTransform.Microsoft.Alpha(Opacity=80)\";filter:alpha(opacity=80)}.locker-loader{z-index:1001;background:url(https:\/\/www.slameeting.com\/bodoct2021\/wp-content\/plugins\/visualizer\/images\/ajax-loader.gif) no-repeat center center}.dt-button{display:none!important}.visualizer-front-container.visualizer-lazy-render{content-visibility: auto;}.google-visualization-controls-categoryfilter label.google-visualization-controls-label {vertical-align: middle;}.google-visualization-controls-categoryfilter li.goog-inline-block {margin: 0 0.2em;}.google-visualization-controls-categoryfilter li {padding: 0 0.2em;}.visualizer-front-container .dataTables_scrollHeadInner{margin: 0 auto;}.visualizer-editor-front-container{position:relative;width:auto;margin:5%;background:#fff}.visualizer-editor-front{overflow:hidden;width:100%;height:500px}.visualizer-editor-front-actions{padding-bottom:3px}.visualizer-editor-save,.visualizer-editor-cancel{margin:0 4px;padding:2px 15px}.visualizer-cw-error .visualizer-actions{display:none !important;} <\/style><div id=\"visualizer-69-692575453\" class=\"visualizer-front  visualizer-front-69\"><\/div><!-- Not showing structured data for chart 69 because description is empty --><\/div>\n\n\n\n<h6 class=\"wp-block-heading\">A-2: Transactions Count FORECAST By Year (2005-2023)<\/h6>\n\n\n<div class=\"visualizer-front-container\" id=\"chart_wrapper_visualizer-118-2019240665\"><style type=\"text\/css\" name=\"visualizer-custom-css\" id=\"customcss-visualizer-118\">.locker,.locker-loader{position:absolute;top:0;left:0;width:100%;height:100%}.locker{z-index:1000;opacity:.8;background-color:#fff;-ms-filter:\"progid:DXImageTransform.Microsoft.Alpha(Opacity=80)\";filter:alpha(opacity=80)}.locker-loader{z-index:1001;background:url(https:\/\/www.slameeting.com\/bodoct2021\/wp-content\/plugins\/visualizer\/images\/ajax-loader.gif) no-repeat center center}.dt-button{display:none!important}.visualizer-front-container.visualizer-lazy-render{content-visibility: auto;}.google-visualization-controls-categoryfilter label.google-visualization-controls-label {vertical-align: middle;}.google-visualization-controls-categoryfilter li.goog-inline-block {margin: 0 0.2em;}.google-visualization-controls-categoryfilter li {padding: 0 0.2em;}.visualizer-front-container .dataTables_scrollHeadInner{margin: 0 auto;}.visualizer-editor-front-container{position:relative;width:auto;margin:5%;background:#fff}.visualizer-editor-front{overflow:hidden;width:100%;height:500px}.visualizer-editor-front-actions{padding-bottom:3px}.visualizer-editor-save,.visualizer-editor-cancel{margin:0 4px;padding:2px 15px}.visualizer-cw-error .visualizer-actions{display:none !important;} <\/style><div id=\"visualizer-118-2019240665\" class=\"visualizer-front  visualizer-front-118\"><\/div><!-- Not showing structured data for chart 118 because description is empty --><\/div>\n\n\n\n<h6 class=\"wp-block-heading\">A-3: Monthly Average Number of Days Late for Late Filings<\/h6>\n\n\n<div class=\"visualizer-front-container\" id=\"chart_wrapper_visualizer-103-1000164031\"><style type=\"text\/css\" name=\"visualizer-custom-css\" id=\"customcss-visualizer-103\">.locker,.locker-loader{position:absolute;top:0;left:0;width:100%;height:100%}.locker{z-index:1000;opacity:.8;background-color:#fff;-ms-filter:\"progid:DXImageTransform.Microsoft.Alpha(Opacity=80)\";filter:alpha(opacity=80)}.locker-loader{z-index:1001;background:url(https:\/\/www.slameeting.com\/bodoct2021\/wp-content\/plugins\/visualizer\/images\/ajax-loader.gif) no-repeat center center}.dt-button{display:none!important}.visualizer-front-container.visualizer-lazy-render{content-visibility: auto;}.google-visualization-controls-categoryfilter label.google-visualization-controls-label {vertical-align: middle;}.google-visualization-controls-categoryfilter li.goog-inline-block {margin: 0 0.2em;}.google-visualization-controls-categoryfilter li {padding: 0 0.2em;}.visualizer-front-container .dataTables_scrollHeadInner{margin: 0 auto;}.visualizer-editor-front-container{position:relative;width:auto;margin:5%;background:#fff}.visualizer-editor-front{overflow:hidden;width:100%;height:500px}.visualizer-editor-front-actions{padding-bottom:3px}.visualizer-editor-save,.visualizer-editor-cancel{margin:0 4px;padding:2px 15px}.visualizer-cw-error .visualizer-actions{display:none !important;} <\/style><div id=\"visualizer-103-1000164031\" class=\"visualizer-front  visualizer-front-103\"><\/div><!-- Not showing structured data for chart 103 because title is empty --><\/div>\n\n\n\n<h6 class=\"wp-block-heading\">A-4: REsults <strong>of Forecasting Models Used to Predict 2021 Premium<\/strong><\/h6>\n\n\n\n<table id=\"tablepress-4\" class=\"tablepress tablepress-id-4\">\n<tbody>\n<tr class=\"row-1\">\n\t<td class=\"column-1\"><b>FISCAL YEAR<\/b><\/td><td class=\"column-2\"><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-2\">\n\t<td class=\"column-1\"><\/td><td class=\"column-2\"><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-3\">\n\t<td colspan=\"3\" class=\"column-1\"><b>Averages fill-in model (9 Month Avg)<\/b><\/td>\n<\/tr>\n<tr class=\"row-4\">\n\t<td class=\"column-1\">Transactions<\/td><td class=\"column-2\">Premium<\/td><td class=\"column-3\">Stamping Fees<\/td>\n<\/tr>\n<tr class=\"row-5\">\n\t<td class=\"column-1\"><b>830,207<\/b><\/td><td class=\"column-2\"><b>13,388,302,243<\/b><\/td><td class=\"column-3\"><b>31,731,140<\/b><\/td>\n<\/tr>\n<tr class=\"row-6\">\n\t<td class=\"column-1\"><\/td><td class=\"column-2\"><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-7\">\n\t<td colspan=\"3\" class=\"column-1\"><b>Linear Forecast Model (2-year base)<\/b><\/td>\n<\/tr>\n<tr class=\"row-8\">\n\t<td class=\"column-1\">Transactions<\/td><td class=\"column-2\">Premium<\/td><td class=\"column-3\">Stamping Fees<\/td>\n<\/tr>\n<tr class=\"row-9\">\n\t<td class=\"column-1\"><b>840,990<\/b><\/td><td class=\"column-2\"><b>13,923,948,809<\/b><\/td><td class=\"column-3\"><b>33,070,257<\/b><\/td>\n<\/tr>\n<tr class=\"row-10\">\n\t<td class=\"column-1\"><\/td><td class=\"column-2\"><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-11\">\n\t<td colspan=\"3\" class=\"column-1\"><b>Linear Forecast Model (4-year base)<\/b><\/td>\n<\/tr>\n<tr class=\"row-12\">\n\t<td class=\"column-1\">Transactions<\/td><td class=\"column-2\">Premium<\/td><td class=\"column-3\">Stamping Fees<\/td>\n<\/tr>\n<tr class=\"row-13\">\n\t<td class=\"column-1\"><b>829,305<\/b><\/td><td class=\"column-2\"><b>13,365,524,292<\/b><\/td><td class=\"column-3\"><b>31,674,196<\/b><\/td>\n<\/tr>\n<tr class=\"row-14\">\n\t<td class=\"column-1\"><\/td><td class=\"column-2\"><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-15\">\n\t<td colspan=\"3\" class=\"column-1\"><b>Seasonal Model<\/b><\/td>\n<\/tr>\n<tr class=\"row-16\">\n\t<td class=\"column-1\">Transactions<\/td><td class=\"column-2\">Premium<\/td><td class=\"column-3\">Stamping Fees<\/td>\n<\/tr>\n<tr class=\"row-17\">\n\t<td class=\"column-1\"><b>815,636<\/b><\/td><td class=\"column-2\"><b>13,428,066,238<\/b><\/td><td class=\"column-3\"><b>33,570,166<\/b><\/td>\n<\/tr>\n<tr class=\"row-18\">\n\t<td class=\"column-1\"><\/td><td class=\"column-2\"><\/td><td class=\"column-3\"><\/td>\n<\/tr>\n<tr class=\"row-19\">\n\t<td colspan=\"3\" class=\"column-1\"><b>Average of All Models<\/b><\/td>\n<\/tr>\n<tr class=\"row-20\">\n\t<td class=\"column-1\">Transactions<\/td><td class=\"column-2\">Premium<\/td><td class=\"column-3\">Stamping Fees<\/td>\n<\/tr>\n<tr class=\"row-21\">\n\t<td class=\"column-1\"><b>829,034<\/b><\/td><td class=\"column-2\"><b>13,526,460,395<\/b><\/td><td class=\"column-3\"><b>32,511,440<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<!-- #tablepress-4 from cache -->\n\n\n\n<p><strong>NOTE1:<\/strong> Eliminating the July 2021 premium of $660M from PGE\/Uber results between $11.7B-$12.1B in premium and $28.8M-$29.8M for 2021.<\/p>\n\n\n\n<p><strong>NOTE2:<\/strong> Average of all models with outliers removed results in $11.95B in premium and $29.8M in stamping fees.<\/p>\n\n\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Revenue Forecast<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"folder":[],"class_list":["post-60","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.slameeting.com\/bodoct2021\/wp-json\/wp\/v2\/pages\/60"}],"collection":[{"href":"https:\/\/www.slameeting.com\/bodoct2021\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.slameeting.com\/bodoct2021\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.slameeting.com\/bodoct2021\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.slameeting.com\/bodoct2021\/wp-json\/wp\/v2\/comments?post=60"}],"version-history":[{"count":68,"href":"https:\/\/www.slameeting.com\/bodoct2021\/wp-json\/wp\/v2\/pages\/60\/revisions"}],"predecessor-version":[{"id":813,"href":"https:\/\/www.slameeting.com\/bodoct2021\/wp-json\/wp\/v2\/pages\/60\/revisions\/813"}],"wp:attachment":[{"href":"https:\/\/www.slameeting.com\/bodoct2021\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"folder","embeddable":true,"href":"https:\/\/www.slameeting.com\/bodoct2021\/wp-json\/wp\/v2\/folder?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}