{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Business Plan Sample"],"not_rendered":{"images":2,"defined_names":30},"read":"whole","date_system":"1900"}

{"sheet":"Business Plan Sample","index":0,"n_rows":342,"n_cols":10,"rows_kept":342,"merged":[[2,1,2,7],[3,1,3,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7],[9,1,9,7],[13,1,16,1],[13,2,13,4],[13,5,13,7],[14,2,14,4],[14,5,14,7],[15,2,15,4],[15,5,15,7],[16,2,16,4],[16,5,16,7],[17,2,17,7],[18,1,21,1],[18,2,18,7],[19,2,19,7],[20,2,20,7],[21,2,21,7],[22,2,22,7],[23,2,23,7],[24,2,24,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[28,2,28,7],[29,2,29,7],[30,1,31,1],[30,2,30,7],[31,2,31,7],[32,1,35,1],[32,2,32,7],[33,2,33,7],[34,2,34,7],[35,2,35,7],[36,2,36,7],[37,1,37,7],[38,2,38,7],[39,2,39,7],[40,2,40,7],[41,2,41,7],[42,2,42,7],[43,2,44,7],[45,2,45,7],[46,2,46,7],[47,2,47,7],[48,1,51,1],[48,2,48,5],[48,6,48,7],[50,2,50,5],[50,6,50,7],[51,2,51,5],[51,6,51,7],[52,2,52,7],[53,1,57,1],[53,2,53,7],[54,2,54,7],[55,2,55,7],[56,2,56,7],[57,2,57,7],[58,2,58,7],[59,1,59,7],[63,2,63,4],[63,5,63,7],[64,5,64,6],[65,5,65,6],[66,5,66,6],[67,5,67,6],[68,5,68,6],[69,1,70,1],[69,5,69,6],[70,5,70,6],[71,5,71,6],[72,5,72,6],[73,3,73,4],[73,5,73,6],[74,1,75,1],[76,1,79,1],[80,2,80,7],[81,1,81,7],[82,2,82,7],[83,2,83,7],[84,2,84,7],[85,2,85,7],[86,2,86,7],[87,2,88,7],[89,2,89,7],[90,2,90,7],[91,2,91,7],[92,1,96,1],[92,2,92,3],[92,4,92,7],[93,2,93,3],[93,4,93,7],[94,2,94,3],[94,4,94,7],[95,2,95,3],[95,4,95,7],[96,2,96,3],[96,4,96,7],[97,2,97,7],[98,1,101,1],[98,2,98,3],[98,4,101,7],[99,2,99,3],[100,2,100,3],[101,2,101,3],[102,2,102,7],[103,2,103,7],[108,5,108,6],[109,5,109,6],[110,5,110,6],[114,1,115,1],[114,5,114,6],[116,5,116,6],[117,5,117,6],[118,5,118,6],[119,3,119,4],[119,5,119,6],[120,2,120,7],[121,2,121,7],[122,2,122,7],[123,2,123,7],[124,1,126,1],[124,2,124,7],[125,2,125,7],[126,2,126,7],[127,2,127,7],[128,2,128,7],[129,2,129,7],[130,2,130,7],[131,2,131,7],[132,2,132,7],[133,2,133,7],[134,2,134,7],[135,2,135,7],[136,2,136,7],[137,2,137,7],[138,2,138,7],[139,2,139,7],[140,2,140,7],[141,2,141,7],[142,2,142,7],[143,2,143,7],[144,2,144,7],[145,2,145,7],[146,2,146,7],[147,2,147,7],[148,2,148,7],[149,2,149,7],[150,2,150,7],[151,2,151,7],[152,2,152,7],[153,2,153,7],[154,2,154,7],[155,2,155,7],[156,2,156,7],[157,2,157,7],[158,2,158,7],[159,2,159,7],[160,2,160,7],[161,2,161,7],[180,1,180,2],[181,2,181,6],[182,1,183,1],[182,2,182,6],[183,2,183,6],[184,1,184,2],[184,3,184,4],[185,1,185,2],[185,3,185,4],[186,1,186,2],[186,3,186,4],[187,1,187,2],[187,3,187,4],[188,1,188,2],[188,3,188,4],[189,1,189,2],[189,3,189,4],[190,1,190,2],[190,3,190,4],[191,1,191,2],[191,3,191,4],[192,1,192,2],[192,3,192,4],[193,1,193,2],[193,3,193,4],[194,1,194,2],[194,3,194,4],[195,1,195,2],[195,3,195,4],[196,1,196,2],[196,3,196,4],[197,1,197,2],[197,3,197,4],[198,1,198,2],[198,3,198,4],[199,1,199,2],[199,3,199,4],[200,1,200,2],[200,3,200,4],[201,1,201,2],[201,3,201,4],[202,1,202,2],[202,3,202,4],[203,1,203,2],[203,3,203,6],[204,1,204,2],[204,3,204,6],[205,1,206,2],[205,3,205,6],[206,3,206,6],[207,1,207,2],[207,3,207,4],[207,5,207,6],[208,1,209,2],[208,3,209,4],[208,5,208,6],[209,5,209,6],[210,1,210,2],[210,3,210,4],[210,5,210,6],[211,1,211,2],[211,3,211,4],[211,5,211,6],[212,1,212,2],[213,1,213,2],[214,1,214,2],[215,1,215,2],[215,3,215,4],[216,1,216,2],[216,3,216,4],[219,1,219,2],[219,3,219,4],[220,1,220,2],[220,3,220,4],[221,1,221,2],[221,3,221,4],[222,1,222,2],[222,3,222,4],[223,1,223,2],[223,3,223,4],[223,5,223,6],[224,1,225,2],[224,3,225,4],[224,5,224,6],[225,5,225,6],[226,1,226,2],[226,3,226,4],[226,5,226,6],[227,1,227,2],[227,3,227,4],[228,1,228,2],[228,3,228,4],[229,1,229,2],[229,3,229,4],[230,1,230,2],[230,3,230,4],[231,1,231,9],[232,1,232,9],[233,1,233,9],[234,1,234,9],[235,1,235,9],[236,1,236,9],[263,1,263,3],[264,1,264,3],[265,1,265,3],[266,1,266,3],[267,1,267,3],[268,1,268,3],[269,1,269,3],[270,1,270,3],[271,1,271,3],[272,1,272,3],[273,1,273,3],[274,1,274,3],[275,1,275,3],[276,1,276,9],[277,1,277,9],[278,1,278,2],[279,1,279,2],[280,1,280,2],[299,1,299,9],[300,1,300,9],[302,1,302,7],[304,1,304,7],[306,1,306,7],[311,1,311,6],[314,1,314,7],[318,1,318,7],[320,1,320,7],[322,1,322,7],[324,1,324,7],[334,1,334,7],[343,1,343,7]]}
[]
[]
[null,"A SAMPLE BUSINESS PLAN"]
[null,"Your Business, Inc."]
[]
[null,"A well-written business plan is a crucial ingredient in preparing for business success. Without a sound business plan, a firm merely drifts along without any real direction. Yet, entrepreneurs, who tend to be people of action, too often jump right into a business venture without taking time to prepare a written plan outlining the essence of the business."]
[null,"You should begin by writing down the answer to the very basic question, \"What business am I in?\" This may sound elementary, but answering this question with thought and consideration will help you focus on the major purpose of the business, which leads to establishing goals and objectives. In turn, these serve as aids in creating strategies, policies, and procedures. Every small business should have policies concerning credit, customers, product lines, image, prices, advertising, and so on. It is important to plan in writing; otherwise, the planning function either is ignored altogether or is conducted too informally."]
[null,"This template has all of the ingredients to produce an excellent business plan."]
[]
[null," "]
[null,"Executive Summary"]
[]
[]
[null,"Key executives:","Mr. James K. Quadrant",null,null,"Mr. Isiah M. Gradient"]
[null,null,"978 Lakeside Drive",null,null,"113 Broughton Road"]
[null,null,"Hamilton, New York 13346",null,null,"Hamilton, New York 13346"]
[null,null,"(515) 555-5431",null,null,"(315) 555-6871"]
[null," "," "]
[null,"Business:","Quadrant Surveying & Equipment Company"]
[null,null,"600 Madison Drive"]
[null,null,"Hamilton, New York 13346"]
[null,null,"(315) 555-4000"]
[null," "," "]
[null,"Business size:","$378,000 in billings in latest fiscal year. Qualify under SBA definition of a \"small business.\""]
[null," "," "]
[null,"Form of ownership:","S Corporation"]
[null," "," "]
[null,"Loan purpose:","To purchase 1 Zeiss total stage with data storage and transfer capabilities to improve the quantity and the quality of the surveying jobs performed for clients."]
[null," "," "]
[null,"Amount requested:",{"v":25000,"d":"$25,000"}]
[null,"."]
[]
[null," ","Mr. James K. Quadrant"]
[null,null,"978 Lakeside Drive"]
[null,null,"Hamilton, New York 13346"]
[null,null,"(315) 555-5431"]
[null,"."," "]
[null,"Work experience:"]
[null,"1974-present","Quadrant Surveying & Engineering Company, Hamilton, New York. Manager-Partner. Created business and continues to actively manage technical aspects of field operations. Supervised project managers of six field crews."]
[null,"."," "]
[null,"1970-1974","Boise-Cascade Timber Co., Freeport, Maine. Survey project manager. Supervised field activities of a six-man survey crew. Planned weekly work schedules and monitored work quality."]
[null,"."," "]
[null,"1965-1970","Hi-Tech Survey Co., Albany, New York Technician. Performed various surveying tasks as a part-time member of a field crew while attending college. Earned 80% of college expenses."]
[null,"Education:","Rensselaer Polytechnical Institute, Troy, New York Master of Science in Engineering Management. Grades in top 10% of class, GPR of 3.7/4.0."]
[null,"1969-1970"]
[null,"."," "]
[null,"1965-1969","Rensselaer Polytechnical Institute, Troy, New York Bachelor of Science degree in Civil Engineering Graduated with honors."]
[null,"."," "]
[null,"References:","Mr. Frank Boland",{"$nulls":3},"Mr. Jeff Anderson"]
[null,null,"President, Hi-Tech Survey Co.",{"$nulls":3},"President, Sound Investment Co."]
[null,null,"Troy, New York 12180",{"$nulls":3},"Hamilton, New York 13346"]
[null,null,"(315) 555-1890",{"$nulls":3},"(315) 555-3671"]
[null,"."," "]
[null," ","Ms. Sally LeGrand"]
[null,null,"Account Executive"]
[null,null,"Merrill, Lynch, Pierce, Fenner, and Smith"]
[null,null,"Portland, Maine 04111"]
[null,null,"(207) 555-1218"]
[null," "," "]
[null,"."]
[null," ","Personal Financial Statement"]
[]
[]
[null," ","Assets",null,null,"Liabilities"]
[null," ","Cash-Savings account",{"v":12000,"d":"$12,000"},null,"Notes payable",null,{"v":10000,"d":"$10,000"}]
[null," ","Checking account",{"v":3000,"d":"3,000"},null,"Mortgage",null,{"v":41000,"d":"41,000"}]
[null," ","Stocks",{"v":22000,"d":"22,000"},null,"Miscellaneous",null,{"v":6000,"d":"6,000"}]
[null," ","Keogh contributions",{"v":31000,"d":"31,000"},null,"Total liabilities",null,{"$f":"SUM(H65:H67)","v":{"v":57000,"d":"$57,000"}}]
[null," ","Home",{"v":96000,"d":"96,000"},null,"Net worth",null,{"v":135000,"d":"$135,000"}]
[null," ","Autos",{"v":20000,"d":"20,000"},null,"Total liabilities"]
[null,null,"Miscellaneous assets",{"v":8000,"d":"8,000"},null,"& net worth",null,{"$f":"SUM(H68:H69)","v":{"v":192000,"d":"$192,000"}}]
[null," ","Total assets",{"$f":"SUM(D65:D71)","v":{"v":192000,"d":"$192,000"}},null," ",null," "]
[null," ",{"$nulls":3}," ",null," "]
[null,"."," "," ",null," ",null," "]
[null," ",null," ",null," ",null," "]
[]
[null," ","Mr. lsiah M. Gradient"]
[null,null,"113 Broughton Road"]
[null,null,"Hamilton, New York 13346"]
[null,null,"(315) 555-6871"]
[null,"."," "]
[null,"Work experience:"]
[null,"1976-Present","Quadrant Surveying & Engineering Co., Hamilton, New York. Managing partner. Supervises internal managerial operations, including financial, accounting, personnel, and planning duties."]
[null," "," "]
[null,"1971-1975","New York Department of Health & Sanitation, Albany, New York. District Maintenance Engineer. Designed water and sewage projects for cities. Supervised staff of twelve."]
[null,"1966-1970","Hi-tech Survey Co., Albany, New York Technician. Worked part-time as field crew member performed various surveying duties."]
[null," "," "]
[null,"Education:","University of Virginia, Charlottesville, Virginia. Master of Business Administration. GPR of 40/4.0."]
[null,"1975-1976"]
[null," "," "]
[null,"1966-1970","Clemson University, Clemson, South Carolina. Bachelor of Science degree, in Civil Engineering."]
[null," "," "]
[null,"References:","Mr. John Molooney",null,"Dr. Fred Target"]
[null,null,"Assistant Vice President",null,"Professor of Engineering"]
[null,null,"Con-Edison",null,"Rensselaer Polytechnical Institute"]
[null,null,"New York, New York 10014",null,"Troy, New York 12181"]
[null,null,"(212) 555-2268",null,"(518) 555-3196"]
[null," "," "]
[null," ","Mr. Sam Hough",null," "]
[null,null,"Certified Public Accountant"]
[null,null,"Charlottesville, Virginia 22201"]
[null,null,"(804) 555-3241"]
[null," "," "]
[null," "," "]
[null," ","Personal Financial Statement"]
[]
[]
[null," ","Assets",null,null,"Liabilities"]
[null," ","Cash-Savings account",{"v":6000,"d":"$6,000"},null,"Notes payable",null,{"v":14000,"d":"$14,000"}]
[null," ","Checking account",{"v":4000,"d":"4,000"},null,"Mortgage",null,{"v":59000,"d":"59,000"}]
[null," ","Mutual funds",{"v":27000,"d":"27,000"},null,"Miscellaneous",null,{"v":6000,"d":"6,000"}]
[null," ","Stocks",{"v":18000,"d":"18,000"},null,"Total liabilities",null,{"$f":"SUM(H109:H111)","v":{"v":79000,"d":"$79,000"}}]
[null," ","Keogh contributions",{"v":24000,"d":"24,000"},null,"Net worth",null,{"v":138000,"d":"$138,000"}]
[null," ","Home",{"v":94000,"d":"94,000"},null,"Total liabilities"]
[null," ","Real estate",{"v":17000,"d":"17,000"},null,"& net worth",null,{"$f":"SUM(H112:H113)","v":{"v":217000,"d":"$217,000"}}]
[null,null,"Autos",{"v":19000,"d":"19,000"}]
[null," ","Miscellaneous assets",{"v":8000,"d":"8,000"},null," ",null," "]
[null," ","Total assets",{"$f":"SUM(D109:D117)","v":{"v":217000,"d":"$217,000"}},null," ",null," "]
[null," ",{"$nulls":3}," ",null," "]
[null," "," "," ",null," ",null," "]
[null," ","COMPANY HISTORY"]
[null," ","James K. Quadrant created Quadrant Surveying & Engineering Company in 1974 as a part-time business venture designed to serve the surveying needs of the local community. Mr. Quadrant began part-time operation of the business in 1975, and Mr. Gradient joined the firm in 1976 to manage the internal operations of the business, while Mr. Quadrant's major responsibilities remained in the area of surveying operations. The two principals' skills, abilities, and areas of concentration are complementary. Annual sales have increased steadily to a record high of $378,000 in the latest fiscal year, and profits peaked at $48,965."]
[null," "," "]
[null," ","INDUSTRY TRENDS AND THE STATE OF THE ART"]
[null," ","Demand for surveying and engineering services should continue to climb during the next decade for three important reasons. First, the rapid escalation of property values during the 1980s has increased the need for these services by several customer groups. Second, greater mobility among the general public has increased the number of land transfers. Third, the trend of larger financial institutions to buy and sell residential and commercial mortgages translates into more work for surveyors, who must provide closing plats showing property boundaries, location of permanent fixtures, encroachments, and easements. There has been an extremely rapid growth in golf course communities in the last two years, with new development announced to begin in the next three years."]
[]
[null,null,"The development of \"state of the art\" equipment in the surveying industry has paralleled the expansion in the service's demand. The surveyor's tools have undergone a major transformation in the last ten years; they are more sophisticated, more accurate, and more refined than ever before. Technological advances have manifested themselves in two important forms: (1) the development of speedy, accurate computational equipment (e.g., microcomputers, programmable calculators, etc.) that allows the surveyor to perform complex calculations on field data, and (2) the introduction of electronic distance meters (EDMs), which yield more accurate survey measurements faster and facilitate data processing."]
[null," "," "]
[null," ","KEY SUCCESS FACTORS"]
[null," ","The principals see the following factors playing a critical role in the success of the company:"]
[null,null,"Providing services in a timely fashion."]
[null,null,"Accuracy of work."]
[null,null,"\"Guaranteed satisfaction.\""]
[null,null,"Professional image."]
[null,null,"Capable work force."]
[null," "," "]
[null," ","MARKET ANALYSIS"]
[null," ","Quadrant has been extremely successful in carving out a specialty niche for itself as well as in meeting the surveying needs of the general public. The company has earned a reputation as the expert in surveying and planning golf courses. After completing work on two local courses, Quadrant obtained a contract on a large, \"upscale\" golf course 125 miles west of Hamilton. The work is progressing on schedule and will be finished on time and within budget."]
[null," "," "]
[null," ","TARGET MARKET"]
[null," ","The principals of Quadrant have identified their primary target market (in descending order of importance) as: (1) golf courses; (2) realtors; (3) attorneys; (4) private landowners. The firm's marketing strategy is designed to attain the return customer by providing quality surveying and engineering service with prompt turnaround. The firm has built its reputation by focusing on quality, and its pricing policy reflects this professional image. General strategy is to tailor pricing to the \"cream of the crop.\""]
[null," "," "]
[null," ","COMPETITOR ANALYSIS"]
[null," ","Quadrant Surveying & Engineering Company faces no direct competition in its hometown, Hamilton, New York, but there are three primary competitors conducting similar operations in towns within a fifty-mile diameter of Hamilton."]
[]
[null,null,"Geodetic Survey, Inc. A small corporation (three principals) whose primary focus is surveying large land tracts for timber companies. Serves 28% of local markets."]
[]
[null,null,"Photogrammetry Engineers, Ltd. A small partnership that performs all types of surveying jobs and specializes in surveying by aerial photography. Controls 22% of local market."]
[]
[null,null,"Land Surveyors, Inc. A relatively new, aggressive company that also performs all types of surveying jobs and specializes in surveying for local architectural firms, Controls 18% of the local market."]
[null," "," "]
[null," ","PLAN OF OPERATION"]
[null," ","Quadrant employs the S Corporation form of ownership primarily for tax reasons. The organizational chart is attached on a separate form."]
[null," "," "]
[null," ","KEY PERSONNEL"]
[null," ","In addition to the principals, whose experience and network of contacts is crucial to the company's success, two long-term field managers play major roles in the firm. As Quadrant grows over the next year, another field manager will be hired,"]
[null," "," "]
[null," ","FINANCIAL DATA"]
[null," ","The following audited financial statements summarize Quadrant's latest operations:"]
[null," "," "]
[null," ","Quadrant Surveying and Engineering Company"]
[null," ","Balance Sheet"]
[]
[]
[null," ","Assets"," ",null,"Liabilities"," "]
[null," ","Current assets:"," ",null,"Current liabilities:"," "]
[null," ","Cash",{"v":5000,"d":"$5,000"},null,"Accounts payable",null,{"v":2500,"d":"$2,500"}]
[null," ","Accounts receivable",{"v":4700,"d":"4,700"},null," ",null," "]
[null," ","Total current assets",{"$f":"SUM(D167:D168)","v":{"v":9700,"d":"$9,700"}},null,"Long term liabilities:",null," "]
[null," ","Fixed assets:"," ",null,"Notes Payable",null,{"v":11500,"d":"11,500"}]
[null," ","20 vehicles",{"v":40500,"d":"40,500"},null,"Mortgages On real",null," "]
[null," ","3 computers",{"v":30000,"d":"30,000"},null,"property",null,{"v":43000,"d":"43,000"}]
[null," ","6 sets EDM equipment",{"v":48000,"d":"48,000"},null,"Total L-T liabilities",null,{"$f":"SUM(H167:H172)","v":{"v":57000,"d":"$57,000"}}]
[null," ","4 transits",{"v":6000,"d":"6,000"},null,"Total liabilities",null,{"v":57000,"d":"57,000"}]
[null," ","4 levels",{"v":4800,"d":"4,800"},null,"Owner’s equity",null,{"v":127500,"d":"127,500"}]
[null," ","Misc. field equipment",{"v":20000,"d":"20,000"},null,"Total liabilities &",null," "]
[null," ","Office fixtures & equip.",{"v":18000,"d":"18,000"},null,"Owners' equity",null,{"$f":"SUM(H174:H175)","v":{"v":184500,"d":"$184,500"}}]
[null," ","leasehold improvements",{"v":7500,"d":"7,500"},null," "," "]
[null," ","Total fixed assets",{"$f":"SUM(D171:D178)","v":{"v":174800,"d":"$174,800"}},null," "," "]
[null," ","Total assets",{"$f":"D179+D169","v":{"v":184500,"d":"$184,500"}},null," "," "]
[null," ",null," "," "," "," "]
[null," ","Income Statement"]
[null," "]
[]
[null," ",null,"Net sales",null,{"v":378000,"d":"$378,000"}," "]
[null," ",null,"Operating expenses:",null," "]
[null," ",null,"Labor expense",null,{"v":219800,"d":"$219,800"}]
[null," ",null,"Gas expense",null,{"v":29993,"d":"29,993"}]
[null," ",null,"Telephone expense",null,{"v":6270,"d":"6,270"}]
[null," ",null,"Equipment repair expense",null,{"v":5600,"d":"5,600"}]
[null," ",null,"Insurance' expense",null,{"v":9025,"d":"9,025"}]
[null," ",null,"Rent expense",null,{"v":5400,"d":"5,400"}]
[null," ",null,"Depreciation expense",null,{"v":9200,"d":"9,200"}," "]
[null," ",null,"license expense",null,{"v":1500,"d":"1,500"}," "]
[null," ",null,"Payroll taxes",null,{"v":11050,"d":"11,050"}," "]
[null," ",null,"Office supplies expense",null,{"v":7200,"d":"7,200"}," "]
[null," ",null,"Field supplies expense",null,{"v":10900,"d":"10,900"}," "]
[null," ",null,"Miscellaneous expenses",null,{"v":4700,"d":"4,700"}," "]
[null," ",null,"Total operating expenses",null," ",{"$f":"SUM(F187:F198)","v":{"v":320638,"d":"$320,638"}}]
[null," ",null,"Net operating profit",null," ",{"$f":"F185-G199","v":{"v":57362,"d":"57,362"}}]
[null," ",null,"Income taxes",null," ",{"v":8397,"d":"8,397"}]
[null," ",null,"Net profit",null," ",{"$f":"G200-G201","v":{"v":48965,"d":"$48,965"}}]
[null," ",null," ",null," "," "]
[null," ",null,"Quadrant Surveying & Engineering Company"]
[null," ",null,"Break-Even Analysis"]
[null," "]
[]
[null," ",null," ",null,"total fixed expenses"]
[null," ",null,"Break-even sales ="]
[]
[null," ",null," ",null,"1.00 - variable expenses expressed as percentage of sales"]
[null," ",null," ",null," "]
[null," ",null,"Total expenses",null,{"$f":"G199","v":{"v":320638,"d":"$320,638"}}," "]
[null," ",null,"Fixed",null,{"v":88122,"d":"88,122"}," "]
[null," ",null,"Variable",null,{"v":240913,"d":"240,913"}," "]
[null," ",null," ",null," "," "]
[null," ",null," ",null,{"$f":"F215","v":{"v":240913,"d":"240,913"}}]
[null," ","variable expenses as a % of sales ="]
[]
[null," ",null," ",null,{"$f":"F185","v":{"v":378000,"d":"378,000"}}]
[null," ",null," ",null," "," "]
[null," ",null,"=",null,{"$f":"F217/F220","v":{"v":0.6373359788359788,"d":"63.73%"}}," "]
[null," ",null," ",null," "," "]
[null," ",null," ",null,{"$f":"F214","v":{"v":88122,"d":"88,122"}}]
[null," ",null,"Break-even sales="]
[]
[null," ",null," ",null,"1.00 - 0.06373"]
[null," ",null," ",null," "," "]
[null," ",null,"Break-even sales=",null,{"$f":"F224/(1-F222)","v":{"v":242985.22835863355,"d":"$242,985"}}," "]
[null," ",null," ",null," "," "]
[null," ",null," ",null," "," "]
[null," "]
[]
[null,"Projected Cash Budget"]
[]
[]
[null," "]
[null,"Cash Receipts","Jan","Feb","Mar","Apr","May","June","July","Aug"]
[null,"SALES COLLECTIONS:",{"v":20000,"d":"20,000"},{"v":25000,"d":"25,000"},{"v":28000,"d":"28,000"},{"v":33000,"d":"33,000"},{"v":47000,"d":"47,000"},{"v":54000,"d":"54,000"},{"v":58000,"d":"58,000"},{"v":55000,"d":"55,000"}]
[null,"20% same month",null,null,{"v":5600,"d":"5,600"},{"v":6600,"d":"6,600"},{"v":9400,"d":"9,400"},{"v":10800,"d":"10,800"},{"v":11600,"d":"11,600"},{"v":11000,"d":"11,000"}]
[null,"60% first month after sale",null,null,{"v":15000,"d":"15,000"},{"v":16800,"d":"16,800"},{"v":19800,"d":"19,800"},{"v":28200,"d":"28,200"},{"v":32400,"d":"32,400"},{"v":34800,"d":"34,800"}]
[null,"18% second month after sale",null,null,{"v":3600,"d":"3,600"},{"v":4500,"d":"4,500"},{"v":5040,"d":"5,040"},{"v":5940,"d":"5,940"},8260,{"v":9720,"d":"9,720"}]
[null,"Other cash receipts",null,null,250,50,380,160,400,100]
[null,"TOTAL CASH RECEIPTS",null,null,{"$f":"SUM(E240:E243)","v":{"v":24450,"d":"24,450"}},{"v":27950,"d":"27,950"},{"v":34620,"d":"34,620"},{"v":45100,"d":"45,100"},{"v":52660,"d":"52,660"},{"v":55620,"d":"55,620"}]
[null,"CASH DISBURSEMENTS:"]
[null,"Wages"," "," ",{"v":15680,"d":"15,680"},{"v":18480,"d":"18,480"},{"v":26320,"d":"26,320"},{"v":30240,"d":"30,240"},{"v":32480,"d":"32,480"},{"v":31147,"d":"31,147"}]
[null,"Taxes"," "," "," "," "," "," "," "," "]
[null,null,"Payroll"," ",532,628,987,{"v":1011,"d":"1,011"},{"v":1375,"d":"1,375"},{"v":1163,"d":"1,163"}]
[null,null,"Property"," ",0,0,400,0,0,0]
[null,"Transportation"," "," ",790,840,{"v":1380,"d":"1,380"},{"v":1525,"d":"1,525"},{"v":1780,"d":"1,780"},{"v":1645,"d":"1,645"}]
[null,"Repairs & maintenance",null,null,375,450,575,625,700,675]
[null,"Field supplies",null,null,650,800,{"v":1050,"d":"1,050"},{"v":1240,"d":"1,240"},{"v":1500,"d":"1,500"},{"v":1375,"d":"1,375"}]
[null,"Rent"," "," ",500,500,500,500,500,500]
[null,"Utilities"," "," ",100,110,130,140,150,140]
[null,"Telephone (including yellow",null,null,450,575,800,950,{"v":1075,"d":"1,075"},990]
[null,"Entertainment",null,null,200,200,200,200,200,200]
[null,"Insurance",null,null," "," "," "," "," "," "]
[null,null,"Malpractice",null,0,{"v":9000,"d":"9,000"},0,0,0,0]
[null,null,"Tenant's"," ",0,0,{"v":1500,"d":"1,500"},0,0,0]
[null,null,"Auto"," ",0,0,0,500,0,0]
[null,"Licenses"," "," ",0,0,0,1500,0,0]
[null,"Miscellaneous",null,null,210,340,425,490,510,500]
[null,"TOTAL CASH DISBURSEMENTS",null,null,{"$f":"SUM(E246:E262)","v":{"v":19487,"d":"19,487"}},{"v":31923,"d":"31,923"},{"v":34267,"d":"34,267"},{"v":38921,"d":"38,921"},{"v":40270,"d":"40,270"},{"v":38335,"d":"38,335"}]
[null," ",null,null," "," "," "," "," "," "]
[null,"END OF MONTH BALANCE",null,null," "," "," "," "," "," "]
[null,"Beginning cash balance",null,null,{"v":5000,"d":"5,000"},{"v":9963,"d":"9,963"},{"v":5990,"d":"5,990"},{"v":6343,"d":"6,343"},{"v":12522,"d":"12,522"},{"v":25112,"d":"25,112"}]
[null,"+ cash receipts",null,null,{"$f":"E244","v":{"v":24450,"d":"24,450"}},{"v":27950,"d":"27,950"},{"v":34620,"d":"34,620"},{"v":45100,"d":"45,100"},{"v":52660,"d":"52,660"},{"v":55620,"d":"55,620"}]
[null,"- cash disbursements",null,null,{"$f":"E263","v":{"v":19487,"d":"19,487"}},{"v":31923,"d":"31,923"},{"v":34267,"d":"34,267"},{"v":38921,"d":"38,921"},{"v":40270,"d":"40,270"},{"v":38335,"d":"38,335"}]
[null," ",null,null," "," "," "," "," "," "]
[null,"CASH END OF THE MONTH",null,null,{"$f":"E267-E268+E266","v":{"v":9963,"d":"9,963"}},{"v":5990,"d":"5,990"},{"v":6343,"d":"6,343"},{"v":12522,"d":"12,522"},{"v":24912,"d":"24,912"},{"v":42397,"d":"42,397"}]
[null,"(REPAYMENT)",null,null,0,0,0,0,0,0]
[null,"or",null,null," "," "," "," "," "," "]
[null,"(BORROWING)",null,null,0,0,0,0,0,0]
[null," ",null,null," "," "," "," "," "," "]
[null,"CASH END OF THE MONTH",null,null,{"$f":"SUM(E270:E273)","v":{"v":9963,"d":"$9,963"}},{"v":5990,"d":"$5,990"},{"v":6343,"d":"$6,343"},{"v":12522,"d":"$12,522"},{"v":24912,"d":"$24,912"},{"v":42397,"d":"$42,397"}]
[null,"Minimum Cash Balance = $5,000",null,null," "," "," "," "," "," "]
[null," "]
[]
[null,"Pro Forma Income Statement"]
[]
[]
[null,"Net sales",{"v":480000,"d":"$480,000"}]
[null,"Operating expenses:"," "]
[null,"Labor expense",{"v":272000,"d":"$272,000"}]
[null,"Gas expense",{"v":30305,"d":"30,305"}]
[null,"Telephone expense",{"v":10650,"d":"10,650"}]
[null,"Equipment repair expense",{"v":6500,"d":"6,500"}]
[null,"Insurance expense",{"v":11000,"d":"11,000"}]
[null,"Rent expense",{"v":6000,"d":"6,000"}]
[null,"Depreciation expense",{"v":10000,"d":"10,000"}]
[null,"License expense",{"v":1500,"d":"1,500"}]
[null,"Payroll expense",{"v":12750,"d":"12,750"}]
[null,"Office supplies expense",{"v":7400,"d":"7,400"}]
[null,"Field supplies expense",{"v":11200,"d":"11,200"}]
[null,"Miscellaneous expenses",{"v":5100,"d":"5,100"}]
[null,"Total operating expenses",{"$f":"SUM(C284:C295)","v":{"v":384405,"d":"$384,405"}}]
[null,"Net operating profit",{"$f":"C282-C296","v":{"v":95595,"d":"95,595"}}]
[null,"Income taxes",{"v":13995,"d":"13,995"}]
[null,"Net profit",{"$f":"C297-C298","v":{"v":81600,"d":"$81,600"}}]
[null," "]
[]
[null," "," "]
[null,"STRATEGIC ACTION PLAN"]
[null,"Goals, Objectives, and Strategies"]
[null,"The principals of Quadrant recognize the importance of quality management in successfully meeting their competition. To focus the firm's activities, the principals define its mission: \"To meet the spectrum of surveying and engineering needs of private landowners, large tract owners, financial institutions, attorneys, realtors, and timber companies with high-quality service, rapid turnaround, and unparalleled professionalism, at a profit.\""]
[]
[null,"The overall mission of Quadrant is more clearly defined by dissecting it into the following objectives:"]
[]
[null,"To boost annual sales to $480,000."]
[null,"To increase market share from 31 percent to 36 percent of the local market."]
[null,"To obtain a contract for another golf course."]
[null,"To increase by 10% the number of engineering jobs performed for local towns and districts (e.g., water and sewage systems design)."]
[null,"To improve profit margin from 13 percent to 17 percent."]
[]
[null,"To obtain these objectives, Quadrant will employ a business strategy designed to exploit the four key factors for success in the surveying business-to maintain: (1) a prompt turnaround time on jobs; (2) a professional image with the clientele; (3) a continuous relationship with \"return customers\"; and (4) a healthy customer mix to ensure a steady flow of work. The following key points illustrate this strategy:"]
[]
[null,"To utilize equipment offering the latest technological advances."]
[null,"To train employees in implementing advanced survey techniques into their work."]
[null,"To provide the opportunity for clients to consult with project managers (or principals, if desired) on all projects."]
[null,"To keep the customer informed of the job's progress on a timely basis."]
[null,"To \"crack the engineering market\" by obtaining small jobs with cities, districts, and subdivisions."]
[null,"To increase the number of government contracts bid on."]
[null,"To acquire and to develop \"regional accounts\"-clients with large land holdings (e.g., large timber companies)."]
[]
[null,"loan purpose: To purchase a Zeiss total station with data storage and transfer capabilities that will facilitate taking angular and distance measurements in the field and performing survey computations."]
[]
[null,"Amount requested: $25,000 (see attached vendor's estimate)"]
[]
[null,"Terms: One year and no prepayment penalty."]
[]
[null,"Interest rate: Prime"]
[]
[null,"Collateral: Personal guarantees of principals' title to Zeiss total station."]
[]
[null,"Repayment: Quadrant's ability to repay is illustrated on the accompanying proforma financial statements. The cash budget projected for the upcoming year shows the company will be able to repay the loan within one year. Benefits accruing from the purchase of this EDM equipment include the ability to:"]
[]
[null,"Reduce the number of field personnel by one-third."]
[null,"Reduce office personnel by the immediate transferring field data to the home office via telephone."]
[null,"Minimize the number of return trips to the job site, a significant cost of doing business."]
[null,"Improve productivity by performing more jobs in less time."]
[null,"Improve the firm's professional image with its clientele by employing the latest, most advanced equipment."]
[null,"Obtain golf course that requires a level accuracy attainable only with EDM devices."]