BUSINESS How to Develop and Use a Budget ANNUAL YEAR-END NUMBERS - FROM INCOME STATEMENTS A Category INCOME: Product Sales Service/Install. Sales Service Charges Other Sales Total - All Sales COST OF SALES (COS): Product Sales Service/other COS -All Sales GROSS MARGIN: GM % EXPENSES: Rent Utilities Phone Internet Marketing Wages Payroll taxes Benefits Insurance Vehicle expenses Depreciation Other Total-all Expenses Net Income Net Income % 110,000 120,000 100,000 140,000 140,000 160,000 10,000 6,000 12,000 8,000 266,000 70,000 85,000 133,333 10,000 6,667 190,000 13,000 9,000 300,000 250,000 352,000 75,000 90,000 62,500 75,000 85,000 120,000 135,000 112,500 147,000 45.00% 45.00% 41.76% 26,000 3,800 3,500 4,200 7,500 48,000 3,840 3,800 4,100 21,000 3,000 500 4.47% 4.47% 129,240 17,760 5.05% 24,000 3,600 3,400 4,000 7,000 45,000 3,600 3,500 4,000 20,000 3,000 500 121,600 13,400 20,000 3,000 2,833 3,333 5,800 37,500 3,000 2,917 3,333 16,687 2,500 417 101,320 11,180 154,000 224,200 14,950 9,720 402,870 95,000 130,000 155,000 165,000 137,500 205,000 225,000 111,000 41.73% 177,870 44.15% 22,000 3,400 3,200 3,800 6,700 43,000 3,440 3,200 3,800 19,000 2,500 350 114,390 -3,390 -1.27% 28,000 4,000 3,800 4,400 10,000 70,000 5,600 4,000 4,300 26,000 3,200 600 163,900 13,970 3.47% 110.00% 41.35% 3.76% 2.26% 40.00% 118.00% 52.63% 53.33% 115.00% 108.00% 4.00% 2.67% 39.77% 38.23% 53.98% 55.65% 3.69% 2.56% 3.71% 2.41% 14.45% 100.00% 100.00% 100.00% 100.00% 118.00% 26.32% 25.00% 108.00% 31.95% 9.76% 30,870 2.39% 110.00% 106.00% 108.50% 104.75% 133.00% 145.80% 145.80% 105.25% 105.00% 123.75% 106.50% 120.00% 8.27% 8.00% 1.28% 1.20% 1.20% 1.13% 1.43% 1.33% 2.52% 16.17% 1.29% 1.20% 1.43% 1.33% 7.14% 0.94% 2.33% 15.00% 1.20% 1.17% 24.15% 58.27% 55.00% 41.73% 23.58% 30.00% 34.09% 32.27% 58.24% 41.76% 45.00% 55.85% 44.15% B 2017 - Year End ANNUAL YEAR-END NUMBERS C D 2018 - Year End 2019-YTD Oct. (10 months) E Projected 2019 Year End F Budget 2020 G 2020 Budget, as a % of 2019 Projected Year End Base Year 2017 2018 Year End Projected 2019 Year End Budget 2020 H PERCENT OF TOTAL - ALL SALES I J K 7.39% 1.08% 0.99% 1.19% 2.13% 13.64% 6.95% 0.99% 0.94% 1.09% 2.48% 17.38% 1.09% 1.39% 1.08% 1.16% 6.67% 5.97% 1.00% 26.82% 43.00% 40.53% (3,790) -1.58% -1.27% 4.47% 0.85% 0.99% 1.07% 6.45% 0.79% 0.13% 0.17% 0.14% 0.15% 36.72% 5.05% Figure 1. Create your own version of this spreadsheet using your own numbers and income statement categories. 22 KEYNOTES FEBRUARY 2020 WWW.ALOA.ORG 40.68% 3.47%
Keynotes February 2020
| Title Name |
Pages |
Delete |
Url |
| Empty |
Ai generated response may be inaccurate.
Search Text Block
Page #page_num
#doc_title
Hi $receivername|$receiveremail,
$sendername|$senderemail wrote these comments for you:
$message
$sendername|$senderemail would like for you to view the following digital edition.
Please click on the page below to be directed to the digital edition:
$thumbnail$pagenum
$link$pagenum
Your form submission was a success.
Downloading PDF
Generating your PDF, please wait...
This process might take longer please wait
