<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Kelly Hinkle on Medium]]></title>
        <description><![CDATA[Stories by Kelly Hinkle on Medium]]></description>
        <link>https://medium.com/@kellyhinkle?source=rss-b4f7d952d1da------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/2*gd9mHAsJDmRlngu_LsGYgw.jpeg</url>
            <title>Stories by Kelly Hinkle on Medium</title>
            <link>https://medium.com/@kellyhinkle?source=rss-b4f7d952d1da------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 23:29:35 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@kellyhinkle/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[How Much Will My Startup Cost?]]></title>
            <link>https://medium.com/masterplans/how-much-will-my-startup-cost-b8591278f1f7?source=rss-b4f7d952d1da------2</link>
            <guid isPermaLink="false">https://medium.com/p/b8591278f1f7</guid>
            <category><![CDATA[business-plan]]></category>
            <category><![CDATA[sba]]></category>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[startup-lessons]]></category>
            <category><![CDATA[sba-loans]]></category>
            <dc:creator><![CDATA[Kelly Hinkle]]></dc:creator>
            <pubDate>Thu, 19 Jan 2023 19:59:41 GMT</pubDate>
            <atom:updated>2023-01-19T20:00:39.753Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Startup Business Loan Calculator" src="https://cdn-images-1.medium.com/max/1024/1*5zzy9M9bRcOnrbXQMTbMkw.jpeg" /></figure><p>One of my favorite aspects of financial modeling is that it is a logic puzzle. You take one piece of data and figure out how it is related to other pieces of data before stitching them together to form a picture.</p><blockquote>Today, I’d like to show you how you can use free data from the SBA to estimate how much money you may need to start a business, as well as how much revenue you might need to be successful!</blockquote><h3>How SBA Loan Data Can Help You Figure Out Your Startup Costs</h3><p>Perhaps you are at the very beginning of your business planning journey and want an initial estimate of the size of the loan you might need. You wonder if you can afford a 10–20% required owner contribution.</p><p>The SBA publishes <a href="https://data.sba.gov/dataset/7-a-504-foia">historical loan approval data</a> which includes industry, loan amount, loan term, and lender. If you assume that these loan amounts were 80% of the total cost to start or expand a business, you can back into an estimated total budget. For example, If a loan was $100K and that represented 80% of the cost (a safe bet), the total cost is $100K divided by 80% or $125K.</p><p>Using the same logic, if the owner contribution was the remaining 20%, a related down payment would be $25K. Based on a review of your industry’s loan data and by using this math, can you afford an average down payment? We’ve made this easy for you later on in this post by highlighting our estimates for ten of the most common SBA 7(a) loan industries. <a href="https://masterplans.com/resources/startup-loan-calculator">You can also check out our much more extensive calculator that lets you tinker with several inputs for other business types.</a></p><figure><img alt="Masterplans Startup Business Loan Calculator" src="https://cdn-images-1.medium.com/max/346/1*Y7e3rRo2d0avO7J3TxtMIQ.jpeg" /></figure><blockquote><strong><em>NOT SEEING YOUR TARGET INDUSTRY?</em></strong></blockquote><blockquote><strong><em>WANT TO PLAY AROUND WITH INPUTS LIKE LOAN SIZE AND INTEREST RATE?</em></strong></blockquote><blockquote><strong>Try our </strong><a href="https://masterplans.com/resources/startup-loan-calculator"><strong>Startup Business Loan Calculator</strong></a><strong>!</strong></blockquote><h4>Estimating Required Revenue</h4><p>Once you are able to estimate your total project size and down payment, you can roughly estimate your business’s required revenue for its first full operating year. Let’s go back to the earlier example of a $100K loan with $25K owner equity and assume it applies to your dream business. If the $100K loan had a 10 year term and 10% annual interest, you can input those numbers into an online amortization calculator to arrive at a monthly loan payment of $1,322. On an annual basis, your loan will cost you $15,864 per year. It’s likely that an SBA lender will want to see that your forecasted earnings will be able to cover this cost by at least a factor of 1.2. To be conservative, you should safely estimate a multiple of 1.5 or in industry terms, a 1.5 debt service coverage ratio (DSCR).</p><blockquote>Required Annual Earnings: 1.5 DSCR x $15,864 = $23,796</blockquote><p>You may know that a start-up company like your dream business can earn a profit margin of 8% of revenue, so armed with that information, you can back into required annual revenue to cover your debt service.</p><p>If you divide $23,796 in profits by 8% you arrive at $297,450. Do you think your business will earn this much revenue in its first year? If so, it may be time to start that business plan!</p><h3>Down Payment &amp; Revenue Estimates for 10 Common Businesses</h3><p>To estimate industry-average start-up costs for ten common businesses, owner down payments, and required revenue, we’ve analyzed SBA loan approval data from January of 2020 to June of 2022 and made some estimates.</p><p>Our methodology for calculating startup cost, down payment, and required revenue:</p><ul><li>We assumed that average loan amounts were historically 80% of total budgets and owner down payments were 20%.</li><li>To estimate debt service on average industry loan sizes, we assumed a 10% rate of interest (though interest was likely much lower during this time period), and average SBA loan terms specific to the industries.</li><li>We calculated required debt service coverage at 1.5 times debt service.</li><li>We backed into required revenue by dividing required debt service by an 8% profit margin. Notably, average profit margins vary widely across different industries and you’ll want to research what profit margin is reasonable for your business type in your market. Need help with that? A professional business plan financial modeler like me can help.</li></ul><p>The results of our industry analysis follows along with a hypothetical discussion of the amount of the transaction volume you might need to present an attractive financial model to meet bank requirements.</p><h4>Restaurants</h4><p>(Full &amp; Limited Service, Average)</p><figure><img alt="Estimated startup budget for a restaurant (limited or full-service)" src="https://cdn-images-1.medium.com/max/740/0*d3bdWGmyKuig_8RQ.jpg" /></figure><p>Based on SBA 7(a) loan averages, an owner’s investment in their restaurant could require a $75K down payment. If hypothetically, this restaurant required $809K in annual revenue, and the average ticket (meal) was $25, the restaurant would need to sell 108 tickets per day over 300 operating days per year. If it were open 12 hours per day, it would need to sell about 9 meals per hour. While these estimates/averages could differ meaningfully from the start-up cost and planned price point of your restaurant, it’s great to start thinking along these lines. If you add up your restaurant’s expected start-up cost, can you pay 10–20% of these costs as your owner’s contribution? How many meals would you need to sell to pay your debt back by a factor of 1.5 times if you had an 8% profit margin?</p><h4>Hotels &amp; Motels</h4><p>(Excludes Casinos)</p><figure><img alt="Estimated startup budget for a hotel (non-casino)" src="https://cdn-images-1.medium.com/max/740/0*OqLmj4xHaRjkvIcw.jpg" /></figure><p>Let’s suppose that a hotel required $2.675 million to complete and had 35 rooms at a development cost of about $76K/room. If the hotel were open 365 days per year, and the average nightly rate was $400, it would require an occupancy rate of about 87% to reach the required amount of revenue with an implied 8% profit margin.If that nightly rate were too high in comparison to the local competition, this hotel owner might need to find some creative ways to increase revenue (getting commissions for sales of services or tour packages, or offering room add-ons or amenities) or lower expenses if they were going to make this business work. It’s these types of considerations that a well researched financial model will help you determine.</p><h4>General Freight Trucking</h4><p>(Long-Distance &amp; Local, Average)</p><figure><img alt="Estimated startup budget for freight trucking (local &amp; long-distance)" src="https://cdn-images-1.medium.com/max/740/0*GAsPV2QSdqqAerO8.jpg" /></figure><p>Based on average loan information, we estimate that it may cost about $73K to start a trucking company. We suspect this also entails leasing trucking and trailer equipment. Based on averages, a 20% down payment for this business could require over $14.6K in funds from a potential trucking business owner. If they managed an 8% average profit margin, and drove 245 days per year at a mileage rate of $3/mile, they would need to drive 5,423 miles per month to generate enough income to repay their debt and have an attractive operating cushion. Is your dream to escape office life and hit the open road? Can you afford the owner equity requirement? If so, by putting the finishing touches on your trucking business plan with well thought out trucking financials, you can make your dream a reality.</p><h4>Fitness &amp; Recreation Centers</h4><figure><img alt="Estimated startup budget for a fitness center" src="https://cdn-images-1.medium.com/max/740/1*Zcu5aIOl8ciw4p7c_4Q8pg.jpeg" /></figure><p>Maybe you were a high school sports team captain that became a personal trainer with a dream to someday open your own gym. Based on average loan amounts, your own gym, with new machines and weight stations, could cost over $350K to start. If your SBA loan requires a 20% owner equity contribution, you’d need to put down $71,500 of your own money. If your gym was able to reach a profit margin of 8% and you charged $100/month per membership, you’d need 679 memberships to make it work. Does that seem like too many for the size of your gym? Could you increase the membership monthly rate, offer some private personal training sessions, or sell smoothies and merchandise to lower memberships required? When you are building your financial model for your gym, you’ll need to see what you can tweak to reach required revenue but also make sure you’re being realistic. What is the competition charging? What are people spending on fitness in general in your market area? Is your market saturated or is their opportunity? Some good business plan market research for your gym can be very illuminating.</p><h4>Landscaping Services</h4><figure><img alt="Estimated startup budget for a landscaper service" src="https://cdn-images-1.medium.com/max/740/1*XRoCukTupTjOGzVHPGhGkA.jpeg" /></figure><p>Are your thumbs greener than most and your lawn the most manicured on your block? Do you have a bunch of neighbors who have committed to hire you if you were to start your own landscaping business? According to SBA 7(a) loan averages, you may need a $100K loan, which could require a $25K down payment. If you planned on charging customers $150/month for lawn maintenance, you would need 165 monthly clients, if you had an 8% profit margin. Is that doable?</p><h4>Residential Remodelers</h4><figure><img alt="Estimated startup budget for residential remodeling" src="https://cdn-images-1.medium.com/max/740/1*86PG8f6KABYSclu6LQvSFw.jpeg" /></figure><p>Of all the industries in this list, residential remodelers have the lowest average loan amount and required down payment based on averages. Besides relevant experience, maybe you’d just need a truck, licensing, a marketing budget, and some tools to launch your own remodeling business. Do you think you could secure three $50K jobs per year to hit the required revenue that a hypothetical 8% profit margin implies? If that seems achievable and you can afford a $12,500 down payment, you could be your own boss soon!</p><h4>General Automotive Repair</h4><figure><img alt="Estimated startup budget for auto repair shop" src="https://cdn-images-1.medium.com/max/740/1*-8oTUEab2Py2LwNAp07WJA.jpeg" /></figure><p>A general automotive repair business might require $375K to start. You’ll likely need to buy diagnostic equipment, lifts, and possibly renovate an existing garage, which could require $300K from the bank and $75K from you. With an 8% profit margin, you might need to perform $728K in automotive repairs per year. If you were open 49 weeks per year and 6 days per week and your average service cost $350, you might need to have 3–4 cars on each of your two bays every day. Has your research determined that your market has enough of a driving population that is not being served by existing businesses to keep you that busy?</p><h4>Plumbing, Heating, &amp; Air-Conditioning Contractors</h4><figure><img alt="Estimated startup budget for plumbers, electrician, and HVAC" src="https://cdn-images-1.medium.com/max/740/1*Exq6Nj2NSLFlRIuYHIAfHw.jpeg" /></figure><p>Do you think you can do a better job than your current employer in servicing clients and want to start your own plumbing, heating, and/or air-conditioning contracting business? It might take a $161K loan and about $40K of your own money. If you were open 245 days per year and your average job was $1K, do you think you could average just over 1.8 jobs per day to attractively cover your debt service? Maybe this is especially doable if your current employer is turning away this much business since they are so busy and are unable to hire enough quality trades people like you.</p><h4>Pet Care Services</h4><p>(Excluding Veterinary Services)</p><figure><img alt="Estimated startup budget for a pet care service" src="https://cdn-images-1.medium.com/max/740/1*mCibp-JGB-pi3iNo7NI8jg.jpeg" /></figure><p>This average loan amount of $277K likely includes very different types of businesses like doggy day cares or overnight boarding, cat cafes, or pet groomers, which could have much different start-up costs. In any case, based on the industry averages, for a loan this size, you might need to put down a $69K down payment to start up your dream pet care business. If you were able to achieve an 8% profit margin, and you charged $50/day for dog boarding, your 50-dog capacity kennel would need to be 76% occupied. Are there lots of jet-setting dog owners in your neighborhood and not enough kennel space at facilities that keep dogs stimulated and happy? If so, the timing may be right for you to launch your very own pet care business.</p><h4>Dentist Office</h4><figure><img alt="Estimated startup budget for a dental office" src="https://cdn-images-1.medium.com/max/740/0*aFY2BtASItCj119y.jpg" /></figure><p>You may have been at a dental group for a while and now the owner is retiring and selling the building. If you can swing a possible $151K down payment, it could be the perfect time to strike out on your own, inherit their clients, and even hire a second dentist. If you both work 245 days per year and see over 10 patients per day each at an average visit of $300/patient, you could achieve the required revenue of $1.4 million per year at an 8% profit margin — based on the average loan size of $606K.</p><blockquote>You can <a href="https://masterplans.com/hubfs/Downloads/startup-costs-top-10-industries.jpg">download the complete infographic</a> from our website!</blockquote><figure><img alt="Startup costs and budgets for the top 10 SBA loan industries" src="https://cdn-images-1.medium.com/max/300/0*UbQZhma9mC27rtAk.jpg" /></figure><p><em>Originally published at </em><a href="https://blog.masterplans.com/startup-cost"><em>https://blog.masterplans.com</em></a><em>.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b8591278f1f7" width="1" height="1" alt=""><hr><p><a href="https://medium.com/masterplans/how-much-will-my-startup-cost-b8591278f1f7">How Much Will My Startup Cost?</a> was originally published in <a href="https://medium.com/masterplans">Masterplans</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Unsure if Your Business Idea is Any Good? Try Making a Fake Ad]]></title>
            <link>https://medium.com/masterplans/unsure-if-your-business-idea-is-any-good-try-making-a-fake-ad-3bb56513cd39?source=rss-b4f7d952d1da------2</link>
            <guid isPermaLink="false">https://medium.com/p/3bb56513cd39</guid>
            <category><![CDATA[business-ideas]]></category>
            <category><![CDATA[business-plan]]></category>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[entrepreneurship]]></category>
            <category><![CDATA[sba-loans]]></category>
            <dc:creator><![CDATA[Kelly Hinkle]]></dc:creator>
            <pubDate>Tue, 22 Nov 2022 18:09:32 GMT</pubDate>
            <atom:updated>2022-11-22T18:09:32.958Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Visualize Your Future Business! Create a Fake Ad!" src="https://cdn-images-1.medium.com/max/1024/1*hwm8LKpSg98qZg6md3qlQw.jpeg" /></figure><h4>A great business idea sometimes strikes you. Then, it may consume your thoughts when you can’t sleep. Later, it can full-on haunt you.</h4><p>In <a href="https://www.elizabethgilbert.com/">Elizabeth Gilbert’s</a> excellent book, <a href="https://www.goodreads.com/book/show/24453082-big-magic">Big Magic: Creative Living Beyond Fear </a>, she talks about how these big ideas originate (I won’t spoil it for you) and how certain people may let a good idea die, while others, if the timing is right, will find a way to create what they’ve been obsessing over.</p><p>To encourage more business idea exploration, refinement, and follow-through, we’ve developed a fake ad exercise. We believe this practice can help at different stages of the business development journey: when ideas are in their infancy or when they are ready for proper business planning (to secure bank or investor funding).</p><h4>Why make a fake ad?</h4><p>When you see an ad for your future business on paper, it makes it more real. This is the essence of vision boarding. Being able to visualize what you might want keeps your brain spinning and working through the steps it takes to make it happen.</p><p>This exercise can help you develop or hone your product’s or service’s unique selling proposition. What will differentiate your business from competitors or what could endear you to customers? It can help you see the business through the eyes of customers or people who can help fund your business.</p><p>When making a fake ad for your business idea, you are forced to concentrate all the greatness of your product or service onto a small canvas. With limited space, what items or images would you highlight to demonstrate what makes it attractive and inspire a customer purchaser to buy it? What would you minimize or ignore?</p><p>Making a fake ad can help you measure your desire to launch the business you are considering. Does what you created feel intuitively right? Does it compel you to continue?</p><h4>Does making a fake ad work?</h4><p>Yes! Before starting (and eventually selling) my <a href="https://moderncat.com/articles/your-new-fave-thing-cat-sticker-club/">profitable sticker subscription business</a>, I used this process to visualize my idea. The process made me think about what others could find desirable about it and fueled my momentum to keep going. Here is what my fake ad looked like:</p><figure><img alt="Masterplans Create An Ad: Cat Sticker Club" src="https://cdn-images-1.medium.com/max/1024/1*X-KTJlCFnsqZ3384ZUysfg.jpeg" /></figure><blockquote><em>And because I’m a cat owner, </em><a href="https://www.instagram.com/p/BmPKFuCHVL7/?hl=en"><em>want to see my cat</em></a><em>?</em></blockquote><h4>What I Learned from this Exercise</h4><p>Putting together this ad helped me see why I would want this product: it’s a cheap but fun way to show how much I love cats. I found my unique selling proposition! I also wanted to highlight the most important product feature (in this case, the quality of the stickers) and how it helps the customer (who doesn’t want fun mail?). Since my customers were cat lovers by definition, giving a portion of profits to cat shelters was just another way to make them feel good about their purchase.</p><p>What Makes an Effective Ad</p><ul><li>Start with an attention getter</li><li>Focus on your unique selling proposition</li><li>Explain its features, but also remember to say why your customer benefits from it</li><li>Keep it punchy (bullets work great!)</li><li>Use your customer’s language and address them directly</li></ul><p>For more inspiration, here is another example of a fake ad:</p><figure><img alt="Masterplans Create An Ad: FineDine App" src="https://cdn-images-1.medium.com/max/1024/1*O_dJlHTv3Y5CJANoG79JjA.jpeg" /></figure><p>This one is for a made-up app I wish actually existed. With this product, I focused on how it works, which is a great way to help your customer envision its value. I also highlighted the unique selling proposition, in this case, making a dinner party less stressful.</p><h4>Ready to Try it for Yourself?</h4><p>Let’s get both the right and left sides of your brain working on a fake ad for your idea. Remember, the goal of this exercise is to help you define what’s great about your idea and visualize it as being a real, marketable thing.</p><p>Grab a sheet of paper and a pen(cil), markers, or crayons (or be like me and launch your favorite digital design software like <a href="https://www.canva.com/">Canva</a>), and get started making a great visual pitch!</p><p>Keep in mind that this is an exercise intended to get your creative juices flowing and help you look at your business from a fresh perspective. Since it’s a fake ad, you don’t need to stress about file format or technical specifications.</p><p>We hope you find this exercise stimulating and we’d love to see what you come up with! Send us what you create at <a href="/service/mailto:info@masterplans.com?subject=Make%20An%20Ad">info@masterplans.com</a> and I’ll let you know what I think!</p><p>Hopefully you can take what you learn from it and use it to guide your approach when writing your business plan.</p><p>I’ll leave you with this quote from our magical thinker, Elizabeth Gilbert:</p><blockquote>“Do whatever brings you to life, then. Follow your own fascinations, obsessions, and compulsions. Trust them. Create whatever causes a revolution in your heart.”</blockquote><p><em>Originally published at </em><a href="https://blog.masterplans.com/make-a-fake-ad"><em>https://blog.masterplans.com</em></a><em>.</em></p><p><em>Based in Portland, Oregon, </em><a href="https://www.masterplans.com/"><em>Masterplans</em></a><em> is a veteran-owned company that helps entrepreneurs develop fundable business plans and pitch decks. </em><a href="https://www.masterplans.com/"><em>See how we can help you.</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3bb56513cd39" width="1" height="1" alt=""><hr><p><a href="https://medium.com/masterplans/unsure-if-your-business-idea-is-any-good-try-making-a-fake-ad-3bb56513cd39">Unsure if Your Business Idea is Any Good? Try Making a Fake Ad</a> was originally published in <a href="https://medium.com/masterplans">Masterplans</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Sales Tax Compliance for Subscription Boxes]]></title>
            <link>https://medium.com/@kellyhinkle/sales-tax-compliance-for-subscription-boxes-d59505d80d69?source=rss-b4f7d952d1da------2</link>
            <guid isPermaLink="false">https://medium.com/p/d59505d80d69</guid>
            <category><![CDATA[subscription-boxes]]></category>
            <category><![CDATA[subscription]]></category>
            <category><![CDATA[sales-tax]]></category>
            <category><![CDATA[small-business]]></category>
            <category><![CDATA[subscription-economy]]></category>
            <dc:creator><![CDATA[Kelly Hinkle]]></dc:creator>
            <pubDate>Wed, 21 Oct 2020 16:17:14 GMT</pubDate>
            <atom:updated>2020-10-21T16:27:31.022Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/600/0*2ZXvhI1uxTyCr8x8.png" /><figcaption><a href="https://stickerclubs.mybigcommerce.com/trans-rights-are-human-rights/">Trans Rights are Human Rights</a> by Meech Boakye.</figcaption></figure><p>For over five years, I’ve been running a couple of monthly sticker clubs: <a href="https://www.feministstickerclub.com/">Feminist Sticker Club</a> and <a href="https://catstickerclub.com/">Cat Sticker Club</a>. All had gone pretty smoothly operations-wise until a recent change in legislation (related to the <a href="https://en.wikipedia.org/wiki/South_Dakota_v._Wayfair,_Inc."><em>Wayfair vs. South Dakota</em></a> Supreme Court Case) eliminated certain exemptions for charging sales tax for online sellers. (We are located in Oregon, which doesn’t have sales tax, so we previously didn’t have to charge sales tax).</p><p>As a result of the legal changes, we found ourselves at a crossroads:<strong> hustle to become sales tax compliant or close up shop.</strong> It took dozens of hours to sort technology partners and integrations and I won’t lie — it was a major headache. I contemplated folding the businesses a couple of times out of frustration and fears that costs were too prohibitive for a small (under $100K in annual revenue) side-business. I did decide to persevere though, and my software applications are now finally charging and transmitting tax (phew!).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/479/0*0WTM-bfUiVOOPVZ9.jpeg" /><figcaption><a href="https://stickerclubs.mybigcommerce.com/adopt-dont-shop/">Adopt Don’t Shop</a> by Rachel Katstaller.</figcaption></figure><p>To hopefully save others (including the business-planning clients of my day-job employer, <a href="http://masterplans.com/">Masterplans</a>) time, I’m going to map out the steps of my transition to sales tax compliance here. (Also, please don’t be shy about consulting a tax specialist given the intricacies of your specific subscription business).</p><p><strong>Step 1:<br>Find a Subscription Billing Service That Can Collect Sales Tax<br></strong>We had been using <a href="http://moonclerk.com/">Moonclerk </a>for monthly subscription billing (with <a href="http://stripe.com/">Stripe</a> as a payment processor). Their platform was cute/clean, their interface was intuitive, and they were cheap (about $50 for $4K in monthly billing.) Yet, the software was too bare bones. Want to change prices? You need to update client records individually. Need to charge sales tax? You have to manually enter sales tax rates for each subscriber, one by one. Then you have to monitor if those rates changed, file sales tax returns for each state, and basically this seems like hell on earth and is not feasible.</p><p>After a bunch of research, I decided upon <a href="http://chargebee.com/">Chargebee</a> for subscription billing. They are about five times costlier for me, but they are fancy! (and integrate with Stripe). Bulk record updates are a snap and they have a ton of functionality that I may never use, but I’m grateful that I can grow into it. Plus they integrate with some great sales tax software.</p><p>While the transition to Chargebee was a bit tiresome as migrations take a lot of thought in terms of configurations and trying to avoid doing something stupid like double-billing customers by mistake (guilty!), their support team in India are geniuses and incredibly helpful. They were super responsive, even on the weekends.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/664/0*-fZSe_Pl_2TNTTw8.jpeg" /><figcaption>Chargebee analytics</figcaption></figure><p><strong>Step 2:<br>Find a Sales Tax Collection &amp; Remittance Software<br></strong>The two leading solutions for small businesses are <a href="http://avalara.com/">Avalara</a> &amp; <a href="http://taxjar.com/">Tax Jar</a>. My primary contact at Chargebee had heard that Tax Jar was cheaper, but I didn’t find that to be true for us. Apart from just the basic costs of sales tax software, filing sales tax returns can be costly. With Avalara, you can use the <a href="https://www.streamlinedsalestax.org/">Streamlined Sales Tax</a> program, which basically lets you file for over 20 states with just one filing and saves you lots of money, time, and effort. While you have to speak with a sales consultant at Avalara to get your custom pricing (they shared a quote with me over a screen share), at the end of the day, Avalara, which appeared to be the more luxury solution, turned out to be surprisingly cheaper for us.</p><p><em>Of note: you may not have to charge sales tax for all states that charge sales tax. Most states have different </em><a href="https://www.avalara.com/us/en/learn/guides/state-by-state-guide-economic-nexus-laws.html"><em>thresholds that you must exceed</em></a><em> before you are required to charge sales tax. For instance, for Maine, you need to have annual sales of over $100K or over 200 transactions per year before you must collect tax. Given the recurring nature of subscription billings, transaction volumes usually trigger taxes before sales dollar amounts. It’s worth running an analysis of your expected volumes before you engage with Tax Jar or Avalara to get the best quotes for your unique business.</em></p><p><strong>Step 3:<br>Find an eCommerce Store that Integrates with Your Sales Tax Software<br></strong>If in addition to your monthly subscriptions, you sell back issues/products through an online store, you’ll need to make sure they can collect sales tax too. We used Squarespace to sell extra stickers and were surprised to find that they only offered a very manual solution. I wound up migrating to <a href="http://bigcommerce.com/">BigCommerce</a> which integrates easily with Avalara. Their store-building interface isn’t as intuitive as Squarespace, but I was able to get a simple store up and running in a day. As a plus, they have neat analytics and bulk update tools. I’m a fan.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/746/0*2K-giOVDsSGtAgUU.jpeg" /><figcaption>BigCommerce Analytics</figcaption></figure><p><strong>Step 4:<br>Grab a Relaxing Beverage of Choice and Pat Yourself on the Back<br></strong>You decided that some near term pain to reach compliance was worth your business’s longevity and that’s awesome! While the unknown is if your customer base will balk at the additional tax and unsubscribe (ours didn’t), you’ll have at least advanced your business to another decision point — one based on numbers/math and not fear/inconvenience. And being sales-tax compliant feels good.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/364/0*O8eOZBZMmPHHgxqx.jpeg" /><figcaption>BigCommerce Shopping Cart</figcaption></figure><p>If you’d like to share any tips/frustrations/fears about your sales tax journey, I’d love to hear them!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d59505d80d69" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[“CARES Act” 7(a) Loan Benefits: Don’t Get Disqualified]]></title>
            <link>https://medium.com/masterplans/cares-act-7-a-loan-benefits-dont-get-disqualified-269f1cf8e041?source=rss-b4f7d952d1da------2</link>
            <guid isPermaLink="false">https://medium.com/p/269f1cf8e041</guid>
            <category><![CDATA[covid19]]></category>
            <category><![CDATA[sba-loans]]></category>
            <category><![CDATA[small-business]]></category>
            <dc:creator><![CDATA[Kelly Hinkle]]></dc:creator>
            <pubDate>Fri, 27 Mar 2020 16:08:05 GMT</pubDate>
            <atom:updated>2020-03-27T16:08:05.996Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*gsOu0-APh4Wfp_0G3VGPMg.jpeg" /></figure><p>My initial read of the Senate’s Coronavirus Aid, Relief, and Economic Securit<em>y</em> Act<em> (</em>CARES Act<em>)</em> is that it shows that Congress can functionally work together to produce balanced legislation to address the struggles of individuals and businesses (even if it takes a pandemic for that to happen).</p><p>When tasked with the question, <em>“</em>How do we efficiently and smartly inject $2.2 trillion into the economy for individuals and businesses<strong> </strong>with oversight?”, conservative and progressive voices appear to have found a compelling middle ground.</p><p>Read this <a href="https://medium.com/u/3126f7dd42c1">Forbes</a> article now for a comprehensive overview of how the act can specifically help small businesses.</p><p><a href="https://www.forbes.com/sites/anthonynitti/2020/03/25/congress-reaches-agreement-on-a-coronavirus-relief-package-tax-aspects-of-the-cares-act/#1f0b837e5f99"><strong><em>Congress Reaches Agreement On A Coronavirus Relief Package: Tax Aspects Of The CARES Act</em></strong></a><strong><em> by Toni Nitti</em></strong></p><p>My sense is that the best way to think of <a href="https://medium.com/masterplans/what-the-economic-stimulus-really-means-for-small-businesses-205815b68555">the $350 billion in <strong>forgivable </strong>loans being offered to small businesses through the 7(a) program</a>, is not to think of it as a loan program at all. This is a vehicle to deploy cash to keep companies in business and avoid layoffs that would flood the unemployment benefits program. By funneling funds through SBA-approved lenders, the government is outsourcing some of the administrative burdens of deploying this enormous relief package by utilizing bankers who do underwriting and loan oversight for a living. The program removes the personal guarantees of business owners since the aim of this program is to stop the bleeding versus traditional goals of funding entrepreneurial endeavors. (The remaining loan after forgiveness will be 100% guaranteed by the government until December 2020 and from that point on, for loans with balances over $150,000, the government guarantee will be reduced to 85%).</p><p>This bill is essentially throwing small businesses a life raft to allow them to stay open and preserve jobs for eight weeks. <strong>The support provided (in the form a loan) will equal to 2.5 months of a business’s average payroll.</strong> The repayment of this loan will be reduced by the business’s payroll and facility expenditures over the first eight-week term of the loan. The hitch is that the loan forgiveness will be reduced if salaries are reduced by more than 25% or if the workforce is reduced over a comparable year-ago period (please refer to <a href="https://www.documentcloud.org/documents/6819239-FINAL-FINAL-CARES-ACT.html">the entire bill</a> for specifics.)</p><p>If you believe this payroll protection loan may help your business, here are a few steps to help get you prepared to pull the trigger (and avoid disqualifying yourself from loan forgiveness). (At <a href="http://masterplans.com/">Masterplans.com</a>, we’re actively considering the following as well.)</p><ol><li><strong>Think about the forgiveness provisions as they relate to your near-term plans and operations</strong>. For instance, did you recently sign up for a state-run <a href="https://www.politico.com/news/agenda/2020/03/18/smart-way-save-jobs-coronavirus-135544">Work Share</a> program that allows you to reduce hours by up to 40% and your employees to collect partial unemployment benefits? If so, you’ll want to weigh this payroll reduction against the possibility of losing/reducing loan forgiveness if you decide to apply for a <em>CARES Act</em> SBA loan. With counsel/additional research and some math, you’ll need to determine if it makes sense to (temporarily, during the 8–week period) lower your employee hour reduction to 20% (if over that amount) to not trigger the 25% payroll cut restriction.</li><li><strong>To get ready to apply for this SBA Coronavirus relief loan, get your historical employment/payroll numbers ready.</strong> To determine the amount of your potential loan, you’ll need to have average monthly payroll numbers from the previous year. For later, after you are funded and when you apply for loan forgiveness, you’ll need comparative payroll and employee counts for the eight-week period from a year earlier (if you get your loan on May 1, 2020, you’ll need to pull numbers from the 8-week period starting May 1, 2019).</li><li><strong>Get up to date on your taxes. </strong>You’ll likely need to submit 2019 taxes to apply.</li></ol><p>While economic impacts and uncertainty can be crushing (and panic-inducing), it’s important to try to keep a clear head to be able to scout for opportunities like the CARES Act loan relief programs and act on them if they make sense for your business. And be sure to take many deep breaths.</p><p><em>Masterplans is a veteran-owned business that specializes in providing the highest-level business development consulting. For 17 years we have helped thousands of entrepreneurs launch new businesses and put their ideas in motion. Now, more than ever, we want to see these same businesses survive the largest economic disaster of our generation. We are offering our expertise in navigating the SBA world and will do it at cost</em>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=269f1cf8e041" width="1" height="1" alt=""><hr><p><a href="https://medium.com/masterplans/cares-act-7-a-loan-benefits-dont-get-disqualified-269f1cf8e041">“CARES Act” 7(a) Loan Benefits: Don’t Get Disqualified</a> was originally published in <a href="https://medium.com/masterplans">Masterplans</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[45 Ways to Plan Your Business While Social Distancing]]></title>
            <link>https://medium.com/masterplans/45-ways-to-plan-your-business-while-social-distancing-e4b846b60083?source=rss-b4f7d952d1da------2</link>
            <guid isPermaLink="false">https://medium.com/p/e4b846b60083</guid>
            <category><![CDATA[business-plan]]></category>
            <category><![CDATA[social-distance]]></category>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[entrepreneurship]]></category>
            <category><![CDATA[business]]></category>
            <dc:creator><![CDATA[Kelly Hinkle]]></dc:creator>
            <pubDate>Thu, 19 Mar 2020 22:31:07 GMT</pubDate>
            <atom:updated>2020-03-19T22:34:45.820Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VGd0fyxK0TFc16ZhCtr-Kg.jpeg" /></figure><p>Obviously, most of us are experiencing many new challenges during this COVID-19 pandemic* and the adjustments can be extremely mentally taxing. To distract myself a bit, I’ve been pulling tarot cards and this one keeps appearing. It pretty much sums up the general mood right now.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/509/1*IfpHM7pVKf-m7m7-DCHB6g.jpeg" /><figcaption>9 of Swords</figcaption></figure><p>Still, as much as we desire everything to get back to normal, it seems important to see opportunity in our restraints. I mean, <a href="https://www.washingtonpost.com/history/2020/03/12/during-pandemic-isaac-newton-had-work-home-too-he-used-time-wisely/">Isaac Newton, had one of his most productive years during the Bubonic plague</a>, and Lars von Trier’s documentary <a href="https://en.wikipedia.org/wiki/The_Five_Obstructions"><em>The Five Obstructions</em></a><em> </em>cleverly shows how some of the best art can be made when we are confined.</p><p>So, if you have the luxury of some free time while self-isolating during the mandatory social distancing regulations due to COVID-19 pandemic* (e.g., you’re not dealing with childcare, taking care of a sick relative, or hustling for extra cash), perhaps now is the time to start planning your dream business. To help encourage creativity and inspire business entrepreneurship, my colleagues at <a href="http://masterplans.com/">Masterplans.com</a> have assembled a list of 45 ways to creatively plan your business — or help generate a good idea for a business — while you’re hunkered down at home.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*TVFmg990_c4g36v8WuVbHA.jpeg" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*9R86K0knkDMppA9N3Iqg0A.png" /></figure><p>Nature isn’t canceled like that big concert was. Get out and get some fresh air, go for a walk, and stretch your legs. You’ll feel refreshed, less cooped up, and more inspired.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*1v7f-UEWyTnhKomI8CBt6g.png" /></figure><p>Try out a new podcast to keep your mind off isolation, discover a new interest, or learn more about a particular business or industry</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*nPrlzgvNSjwYnl_YFcgRCQ.png" /></figure><p>Keep a journal with you — and use it. Make a list of every time you felt annoyed by something. If that annoyance can be felt by more people than just you, it is almost definitely a business opportunity. It’s a pain point waiting to be solved by an innovative thinker. Enlist your family in logging their annoyances. Tell kids that their siblings do not count as annoyances.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*DV6NorhYcLc0wPLmwls9EA.png" /></figure><p><a href="https://www.youtube.com/watch?v=XfXfOCIIFcY">Cones of Dunshire</a> move over. Figure out a new game: make a board, cut out some cards, customize some dice, and get your kids to test it out. Make sure you’ve got your probabilities right if it’s a luck game or your skill levels dialed in if it’s strategy-based.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*kf4hEI3mYxKpe7a36wXASA.png" /></figure><p>Does your website need a refresh or not exist yet? Check out some design tips, scope out some award winners, and get building. <a href="https://www.wix.com/">Wix</a>, <a href="https://www.squarespace.com/">Squarespace</a>, and <a href="https://www.shopify.com/">Shopify</a> are all great website builders for early stage businesses.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*eIomDyIhntfky9o4nzjPjg.png" /></figure><p>Test bake that perfect loaf of bread. Ever had freshly made English muffins from a bakery? Me neither! <a href="https://www.bonappetit.com/recipe/bas-best-english-muffins">Time to figure it out</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*o7eeNNUMvUvZjQMwlIMOrw.png" /></figure><p>Turn your bathtub into a DIY float tank with some Epsom salt and white noise (clear your mind and wait for inspiration).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*thc5oDnZ4ivaAZpfhLe89g.png" /></figure><p>Grab some markers or crayons and start doodling a logo. Enlist your young children for some outside of the box ideas.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*xtu-WwkFLyMwB26gCzWrXQ.png" /></figure><p>Sample the competition (order some takeout from a competitor restaurant or play with a competitor’s app) and make some lists on how you’d like to differentiate your business.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*vOYlDPVOPY_yC76r-mu7ew.png" /></figure><p>Dream up ways your company can give back to the community.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*ojVyIQIDqGjvPCJiKwyRLQ.png" /></figure><p>Practice your sales pitch over FaceTime with a friend or relative.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*nJmB8EGXnMi1YQi0AfkvBg.png" /></figure><p>Dust off that piano or guitar and tinker with creating a catchy jingle. Even if it never has an audience, it can be a musical mantra for you as you plan.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*v-2V_ssCG-wKUU8_3q0STg.png" /></figure><p>Assemble a <a href="https://www.pinterest.com/">Pinterest </a>board to solidify your aesthetic.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*7TOknGVWz9fwHtJI4KrBUA.png" /></figure><p>Turn that envelope or napkin on its back and scribble some calculations. How many products or services do I need to sell to cover rent?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*Mzls986tzv0PaiY1jOB95g.png" /></figure><p>Imagine responding to the question, “what do you do for a living” with a description of your role at your future business. Does it feel right?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*h7w-DpriH03EWb_RRryJVA.png" /></figure><p>Pour yourself your favorite beverage and create/update your bio. Highlight any experience that is relevant to your future business.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*Mtb387eqHHBUDb-GyFR9kA.png" /></figure><p>Begin building your email contact database. If you don’t have a website yet, start with a plain page with an email opt-in form. Then do a soft pre-launch announcing your concept to your personal and professional network and ask them to share it with their networks, linking them to your homepage. Your marketing campaign will begin with reaching out to those first people who liked your concept and wanted to hear more.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*wYN0aj40s0EW-z_OjAGKsw.png" /></figure><p>Have difficult decisions to make about your product or service offerings? Can’t decide if your logo looks better in red or blue? There has never been a better time to ask people to fill out a quick survey. Create a survey and post it on your social networking channels or email it to friends that fit your target demographic, and make informed decisions using the results.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*N8fL3G6YpqUOSkWUPZiHJw.png" /></figure><p>Lots of entrepreneurs are big idea thinkers. They love solving big strategic problems but are tripped up by small and boring tasks like filling out forms. Now that you’re bored, you have no excuse but to visit your Secretary of State’s website to fill out your online LLC registration and follow the easy online steps to <a href="https://www.sba.gov/business-guide/launch-your-business/get-federal-state-tax-id-numbers">get your EIN</a>. Get cracking!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*1zj1z3NwzEL38kqnnK0LYQ.png" /></figure><p>Secure your website domain and social media handles.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*3BR3AF27MvyudOI9rLeUZw.png" /></figure><p>Scope out the competition by checking out their website, social media channels, and reviews. What do people complain about when it comes to their business? What could you do better? Imagine how you can turn these competitor’s weaknesses into your business’s strengths.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*yY9x12cnm8yu4hVxWzJx7w.png" /></figure><p>Fire up your Amazon Prime or Netflix and check out a few of these <a href="https://www.99signals.com/movies-entrepreneur-watch-inspiration">“21 “Movies Every Entrepreneur Should Watch for Inspiration.”</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*SqJzlg_TdDSNs__6oagzTQ.png" /></figure><p>Work on developing a new healthy habit. For example: wake up at the same time every morning, drink a glass of water, verbalize gratitude, or start taking vitamins.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*Zm7oCKkLXua_7ai66QfA0A.png" /></figure><p>Choose a dedicated work space. Slumped on the couch with a laptop won’t get your creative juices flowing — it will just give you back problems. Clear the dining room table off, set up a desk in an empty space, or go full-force and claim that spare bedroom as your own creative den.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*LfdJGgQfZrmeyNMtUAmsZQ.png" /></figure><p>Find an inspiring playlist. Spotify and Pandora have a wide variety of playlists based on genre, mood, artist, and top lists. Discover what gets you amped to be productive and effective.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*wB_Wg71MpIWjo-koh2xmhw.png" /></figure><p>Create a <a href="https://www.crowdspring.com/blog/small-business-branding-mood-board/">mood board for your business</a> — either old school collage-style with magazines and scissors, or using free digital mood board platforms and Google images.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*aE80neQyYEfUPAklMHE7Bg.png" /></figure><p>Read a thought-provoking book: <a href="https://www.amazon.com/Lean-Startup-Entrepreneurs-Continuous-Innovation/dp/0307887898"><em>The Lean Startup</em></a><em> </em>by Eric Ries, <a href="https://www.amazon.com/Psychology-Selling-Increase-Thought-Possible/dp/0785288066"><em>The Psychology of Selling</em></a><em> </em>by Brian Tracy, Guy Kawasaki’s <a href="https://www.amazon.com/Art-Start-2-0-Time-Tested-Battle-Hardened/dp/0241187265/ref=sr_1_1?keywords=the+art+of+the+start&amp;qid=1584472350&amp;s=books&amp;sr=1-1"><em>Art of the Start</em></a>, and <a href="https://www.amazon.com/Startup-Playbook-Fastest-Growing-Startups-Entrepreneurs/dp/1452105049/ref=sr_1_4?keywords=startup+playbook&amp;qid=1584472408&amp;s=books&amp;sr=1-4"><em>The Startup Playbook</em></a><em> </em>by David Kidder, are all books on our shelf. Check out <a href="https://www.amazon.com/Brain-Rules-Updated-Expanded-Principles/dp/098326337X/ref=sr_1_1?keywords=brain+rules&amp;qid=1584472474&amp;s=books&amp;sr=1-1"><em>Brain Rules</em></a> by John Medina for tips to get that brain of yours operating at peak performance. (#Protip: An <a href="http://www.audible.com/%20%E2%80%8E%20%E2%80%8E">Audible</a> account is an entrepreneur’s best friend.)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*8uuDMYtp6IuDb9jlEryISg.png" /></figure><p>Consider all the software solutions you might need for your business. If you will be selling products online, you’ll need to find or build a selling platform, pick a merchant card processor/payment gateway, and engage a company like <a href="http://www.avalara.com/">Avalara </a>to track/report sales tax.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*kjJ60CUJolllGCgv9JpkeQ.png" /></figure><p>Start a garden. It doesn’t have to be a full-fledged nursery, but growing something and being responsible for keeping it alive is rewarding, inspiring, and teaches responsibility and discipline.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*0GkS0a28HK7drJuzkjXgLQ.png" /></figure><p>Borrow your friend or neighbor’s dog and go for a walk. Get your steps in and reap the benefits from the joy only a dog can give.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*ew1jJAsAyggg3wW8wo1vBA.png" /></figure><p>Play Shark Tank with your family: everyone creates a business and pitches it at the end of the day.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*v3gIHrH6Ut8Ejh4lfZFYGA.png" /></figure><p>Take this time to review your expenses. What can be removed both in your business and personally?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*wpif6C2CmqpF45t8stpbKA.png" /></figure><p>Meditate the virus panic away!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*9279m5eaQoy9-F8wXC3bsQ.png" /></figure><p>Learn a new skill — <a href="https://youtu.be/0Kj3wWKjMSQ">YouTube</a> exists for a reason and you’ve got all the time you need.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*ZgJLDIJJ1sAW5DZSJRtNnA.png" /></figure><p>Call an old friend or colleague you haven’t connected with in a long time. It’s not only good to keep up with your community but you might learn something new or spark an idea for a business venture.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*WyGggd3D4__Kx2lV5F6MDg.png" /></figure><p>Take a step to make your dream seem real. Design a business card on a site like <a href="https://www.moo.com/us/">Moo.com</a> and order a small batch.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*ahsDtHvwjOtL7_kMoe7b1A.png" /></figure><p>Are you married to the name of your business (that <em>really great</em> one that you came up with) but haven’t workshopped it with friends and family? Send out a mass email to your closest friends, family, and colleagues, and ask for their genuine thoughts about your business name.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*KRl4FV3wq9adEQbdnhMZ8g.png" /></figure><p>Hop on <a href="https://www.fiverr.com/">fiverr </a>or <a href="https://99designs.com/">99designs </a>and develop an inexpensive logo.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*ahsDtHvwjOtL7_kMoe7b1A.png" /></figure><p><a href="https://www.forbes.com/sites/markmurphy/2018/04/15/neuroscience-explains-why-you-need-to-write-down-your-goals-if-you-actually-want-to-achieve-them/#133f994d7905">Write a list of goals</a> for the business and then share them with friends.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*KRl4FV3wq9adEQbdnhMZ8g.png" /></figure><p>Are you handy? Build a working prototype.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*SgPD7tJA9d4DW9hSNBS0YQ.png" /></figure><p>Research banking options and open a business bank account.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*EdH9H9sOWZUZZQos--X82w.png" /></figure><p>Reinvest time into your side hustle and start looking at ways to expand your skillset.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*myBawl14MMoXem5m6nw_3Q.png" /></figure><p>Take graphic design into your own hands and try playing with the free design platform <a href="https://www.canva.com/">Canva</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*iwPZjqidFXaRsksDllLMIw.png" /></figure><p>Think about the order and timing of launching your business. Remember, just like in home improvement, not everything gets done on an ideal schedule — but if it did, how would that look? When would you hire your first employee? When would you get sold into a major retailer? Or expand into a brick-and-mortar location? Putting your goals on a timeline can help you realize what steps you need to take to accomplish them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*icp_rKp9jXfU-3W0_CmqxQ.png" /></figure><p>Create short-term and long-term goals. This will help you stay on track and avoid procrastination.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*G3K4ENnH_zZtJXbCgXK7gw.png" /></figure><p>Find a professional mentor you trust, respect, and can call upon for honest advice.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*XR8Vr7BiuU6fyHfzV7_ScA.png" /></figure><p>Contact <a href="https://masterplans.com/">Masterplans.com</a> to get your business plan in motion!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*TVFmg990_c4g36v8WuVbHA.jpeg" /></figure><p>*We realize our world is turned upside down right now and businesses need real help with staying alive. Check out <a href="https://medium.com/u/ac499f470014">Ben Worsley</a>’s post about the <a href="https://medium.com/masterplans/making-sense-of-the-coronavirus-sba-loan-program-2f93655b89da">SBA Economic Injury Disaster Loan Program</a>.</p><p><em>Masterplans is a veteran-owned business that specializes in providing the highest level business development consulting. For 17 years we have helped thousands of entrepreneurs launch new businesses and put their ideas in motion.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e4b846b60083" width="1" height="1" alt=""><hr><p><a href="https://medium.com/masterplans/45-ways-to-plan-your-business-while-social-distancing-e4b846b60083">45 Ways to Plan Your Business While Social Distancing</a> was originally published in <a href="https://medium.com/masterplans">Masterplans</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Microsoft Word & Excel Linking — Bringing the Office Back Together]]></title>
            <link>https://medium.com/@kellyhinkle/microsoft-word-excel-linking-bringing-the-office-back-together-f32ea1304c0f?source=rss-b4f7d952d1da------2</link>
            <guid isPermaLink="false">https://medium.com/p/f32ea1304c0f</guid>
            <category><![CDATA[linking]]></category>
            <category><![CDATA[microsoft-word]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[business-plan]]></category>
            <category><![CDATA[tech]]></category>
            <dc:creator><![CDATA[Kelly Hinkle]]></dc:creator>
            <pubDate>Fri, 15 Nov 2019 18:23:24 GMT</pubDate>
            <atom:updated>2019-11-15T18:58:54.683Z</atom:updated>
            <content:encoded><![CDATA[<h3>Microsoft Word &amp; Excel Linking — Bringing the Office Back Together</h3><p>Sometimes I’m nostalgic for 2003. I was still under 30, finally coming out of my shell a bit, dating confusing people, and listening to Interpol’s <a href="https://pitchfork.com/reviews/albums/4113-turn-on-the-bright-lights/"><em>Turn on the Bright Lights</em></a><em> </em>on<em> </em>repeat. More importantly, <strong>it was also the birth year of Microsoft Office 2003</strong>, the last great version of the product <strong>when Excel &amp; Word linking worked perfectly</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3X5CS59Jq-RnJHJ5hzaylw.jpeg" /></figure><p>What is Word/Excel linking? Basically, you can paste an Excel table/chart into a Word document by pasting it as a link (paste, paste-special, paste link). Then, later, if your Excel spreadsheet gets updated, you can right-click on the table or chart in Word and update the Excel data in it automatically.</p><p>This functionality is crucial for a business like mine (<a href="http://masterplans.com/">masterplans.com</a>, a business plan consulting company). We frequently update Word documents that are full of data tables and charts. For instance, say we had a client that was going to sell cat beds, but then decides to pivot to start the “Uber of cat grooming.” With Excel/Word link magic, we can update a table in a Word document with a few clicks.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/606/1*ylG6ZtoTDCuqlOKKcCO82g.gif" /></figure><p>Unfortunately, while Microsoft Office has improved in important ways since 2003, its Excel/Word linking has devolved. With newer versions of Office, Excel/Word links mysteriously break. They turn handy links into unhelpful image files. Our workaround has been to stick with the technologies of years past. Until recently, we had a strict “save as Word 97–2003” file-type policy.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/281/1*2GlyBKYrZCHb7pU4w_gdbg.jpeg" /></figure><p>Our “save as .doc instead of .docx” file solution worked well until we realized that we were missing out on modern Microsoft Office conveniences like easy document color palette changes and cool org chart builders. It helped to have a new employee say, “You guys are still saving to Word 2003? That version is <strong>sixteen years </strong>old.”</p><p>Because I didn’t want to be that tenured employee who is tied to doing things the old way, I embarked on a mission to finally figure this issue out. Surely I was missing something (and disclaimer: I probably still am). Yet after countless Google searches, I wasn’t getting many helpful answers.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*7RWXx_cJXvjOs71PZh5wbQ.gif" /></figure><p>I’d find discussions like this where others were as stumped as I was and the “best answer” was often a defeatest workaround.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*TNFW5MRGJu2x1LxBtnlifA.png" /><figcaption>Source: <a href="https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_win10-mso_o365b/making-excel-links-in-word-portable-ie-relative/8f67c68e-6406-4ef2-9b97-4d96c43dcb2c">https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_win10-mso_o365b/making-excel-links-in-word-portable-ie-relative/8f67c68e-6406-4ef2-9b97-4d96c43dcb2c</a></figcaption></figure><p>Long story short, <strong>I’ve spent a dozen hours researching this solution</strong> and <strong>below is a summary of my findings</strong>. (Excuse my very non-technical understanding).</p><p><strong>What I found:</strong></p><ul><li>Word/Excel linking functionality breaks (your previously linked tables/charts turn to images) when the Word file can’t find the source Excel file. This happens when you change the name of an Excel file or move the Word document to another computer. With Office 2003, you were able to just redirect the link paths to reconnect to the source file.</li><li>One way to fix this problem is to save shared files on a file system like <a href="https://medium.com/u/2d2c8f4cb281">Dropbox</a>, with a common file path and static name. All of your collaborators can set their shared folder location to C:\. This way, the Excel file never moves and Word can always locate its data source.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/508/1*s7xjXzONWnayEUD7Se1dVw.png" /></figure><ul><li>This solution does have one major drawback (at least with Dropbox). Each time you open a Word document that is embedded with Excel links, Word goes through the process of hunting for each link. If you are saving files to the cloud and your internet connection is slow, it might take Word two minutes to open your document. <strong>One way to speed this up is to have Excel open (with a blank sheet). </strong>I haven’t been able to find a way to prevent Word from seeking out the links. It appears that Microsoft had a registry patch for this at one point, but it’s no longer functional.</li><li>If you need to relink a Word document with existing Excel links to a different Excel source, first save a copy of it as a Word 97–2003 file. Then, relink the Excel tables/charts within that Word 97–2003 document. (There are some weird errors that can occur if you try to navigate to another Excel data source with a .docx file when working on the cloud). After you relink the tables, you can copy the tables from your 97–2003 file into the .docx version of your file. While this is a bit of a pain, you should be good from then on out.</li></ul><p>I mostly writing about this because I’ve yet to uncover a thread on this topic with a simple solution. My hope is that someone with more technical knowledge will comment with some obvious answer and if not, our interim hacks might save someone else some time. Or best case, <a href="https://medium.com/u/d97749d23c4a">Microsoft</a> could re-examine the user impacts of its post Office 2003 linking technology shift so that its next Office version is the best yet.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f32ea1304c0f" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>