{"id":2037,"date":"2014-07-24T10:00:58","date_gmt":"2014-07-24T17:00:58","guid":{"rendered":"https:\/\/berkonomics.com\/?p=2037"},"modified":"2014-08-04T11:55:13","modified_gmt":"2014-08-04T18:55:13","slug":"create-a-ten-percent-profit-model","status":"publish","type":"post","link":"https:\/\/berkonomics.com\/?p=2037","title":{"rendered":"Create a ten percent profit model."},"content":{"rendered":"<p>Most entrepreneurs, when starting to model their business operations using a spreadsheet, start with expected revenue by month. Then they calculate cost of sales, and then project their expenses, to find the bottom line profit or loss each projected month.<\/p>\n<p>There is a rarely-used twist that makes lots of sense. Add a new row at the bottom of the spreadsheet. Project your revenues and costs as in the original exercise. Then consider that an operating entity should be able to generate a ten percent operating profit based upon revenues, and add a row to your spreadsheet immediately below \u201coperating profit\u201d that calculates 10% profit from sales each month. Compare that with the operating profit as calculated, which surely will be<\/p>\n<div id=\"attachment_1429\" style=\"width: 160px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/berkonomics.com\/wp-content\/uploads\/2012\/10\/Basic_Berkonomics_front_cover.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1429\" class=\"size-thumbnail wp-image-1429\" src=\"https:\/\/berkonomics.com\/wp-content\/uploads\/2012\/10\/Basic_Berkonomics_front_cover-150x150.jpg\" alt=\"From Basic Berkonomics: Available Amazon, B&amp;N,  berkus.com and booksellers everywhere.\" width=\"150\" height=\"150\" \/><\/a><p id=\"caption-attachment-1429\" class=\"wp-caption-text\">From Basic Berkonomics: Available Amazon, B&amp;N, berkus.com and booksellers everywhere.<\/p><\/div>\n<p>lower, probably negative, for months or even years. The difference is something new \u2013 a target for reduction of expenses or addition to revenue for each month in which the calculated number is lower than 10% of revenues.<\/p>\n<p><span style=\"color: #993300;\"><em>[Email readers, continue here&#8230;]<\/em><\/span>\u00a0 We are not taught to think this way, but rather to find the month in which we break even in our plan, then calculate the accumulated losses to that point, add all the cash needed for investment in fixed assets, and end up with the amount needed to finance the business to breakeven through equity or debt financing. This new tool gives you that number <em>plus <\/em>the amount needed to make the business a viable entity with a chance of long term survival.\u00a0\u00a0 The longer the time it takes to break even, the higher the number of dollars needed. Sometimes, the difference is a reminder to consider a reduction of expenses, if revenues cannot be raised from projected levels.<\/p>\n<p>And sometimes, it is just a reminder that we are all in business to make money, not to break even. Just like assuring that your own at-market salary is included in a forecast even if not drawn in cash during the earliest periods, the 10% target reminds us all that the target must be higher than merely breaking even, even if that means reassessing all expenses until the target is met or exceeded.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Most entrepreneurs, when starting to model their business operations using a spreadsheet, start with expected revenue by month. Then they calculate cost of sales, and then project their expenses, to find the bottom line profit or loss each projected month. &hellip; <a href=\"https:\/\/berkonomics.com\/?p=2037\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[11,20],"tags":[],"class_list":["post-2037","post","type-post","status-publish","format-standard","hentry","category-growth","category-protecting-the-business"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/berkonomics.com\/index.php?rest_route=\/wp\/v2\/posts\/2037","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/berkonomics.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/berkonomics.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/berkonomics.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/berkonomics.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2037"}],"version-history":[{"count":0,"href":"https:\/\/berkonomics.com\/index.php?rest_route=\/wp\/v2\/posts\/2037\/revisions"}],"wp:attachment":[{"href":"https:\/\/berkonomics.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/berkonomics.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/berkonomics.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}