I cannot seem to get my statements to balance in section 5.0. I dont seem to know where I am missing the mark.

BUSN278 Budgeting and Forecasting Template Instructions Use this spreadsheet structure to lay out the various sections of your project. The purpose of this spreadsheet is to make it easy for your professor to locate the various sections of your project. Please don't alter the worksheet tabs or titles. After you finish your calculations in this spreadsheet, you will have to create a written report where you take screenshots from this spreadsheet and put them in the Budget Proposal Template, along with necessary explanations. Detailed instructions for how to write the report are found in the Budget Proposal Template, a Word document. Sales Forecast Market Capture Total number of families Market share to capture Targeted number of families Average number of family members Average number of visits per week Total number of customers per week - assuming 15% of target visits 10000 25% 2500 4 1 1500 Year 1 Month January February March April May June July August September October November December Totals Capacity Tables Chairs Maximum Capacity 20 4 80 Potential Sales Average cost per meal Average cost per family Average cost of tokens/family $7.00 $28.00 $4.00 Growth Rate of 4% Meals Tokens Totals 2015 $542,990.00 $77,570.00 $620,560.00 2016 $564,709.60 $80,672.80 $645,382.40 2017 $587,297.98 $83,899.71 $671,197.70 2018 $610,789.90 $87,255.70 $698,045.60 2019 $635,221.50 $90,745.93 $725,967.43 Customers Food Sales 6000 $42,000.00 6000 $42,000.00 6000 $42,000.00 6500 $45,500.00 6500 $45,500.00 6500 $45,500.00 6750 $47,250.00 6500 $45,500.00 7000 $49,000.00 6570 $45,990.00 6750 $47,250.00 6500 $45,500.00 77570 $542,990.00 Year2 Month January February March April May June July August September October November December Totals Food Sales Tokens $43,680.00 $6,240.00 $43,680.00 $6,240.00 $43,680.00 $6,240.00 $47,320.00 $6,760.00 $47,320.00 $6,760.00 $47,320.00 $6,760.00 $49,140.00 $7,020.00 $47,320.00 $6,760.00 $50,960.00 $7,280.00 $47,829.60 $6,832.80 $49,140.00 $7,020.00 $47,320.00 $6,760.00 $564,709.60 $80,672.80 Tokens $6,000.00 $6,000.00 $6,000.00 $6,500.00 $6,500.00 $6,500.00 $6,750.00 $6,500.00 $7,000.00 $6,570.00 $6,750.00 $6,500.00 $77,570.00 Year 3 Month January February March April May June July August September October November December Totals $48,000.00 $48,000.00 $48,000.00 $52,000.00 $52,000.00 $52,000.00 $54,000.00 $52,000.00 $56,000.00 $52,560.00 $54,000.00 $52,000.00 $620,560.00 Food Sales Tokens $45,427.20 $6,489.60 $45,427.20 $6,489.60 $45,427.20 $6,489.60 $49,212.80 $7,030.40 $49,212.80 $7,030.40 $49,212.80 $7,030.40 $51,105.60 $7,300.80 $49,212.80 $7,030.40 $52,998.40 $7,571.20 $49,742.78 $7,106.11 $51,105.60 $7,300.80 $49,212.80 $7,030.40 $587,297.98 $83,899.71 Year 4 Month January February March April May June July August September October November December Food Sales Tokens $47,244.29 $6,749.18 $47,244.29 $6,749.18 $47,244.29 $6,749.18 $51,181.31 $7,311.62 $51,181.31 $7,311.62 $51,181.31 $7,311.62 $53,149.82 $7,592.83 $51,181.31 $7,311.62 $55,118.34 $7,874.05 $51,732.50 $7,390.36 $53,149.82 $7,592.83 $51,181.31 $7,311.62 $610,789.90 $87,255.70 Year 5 Month January February March April May June July August September October November December Food Sales Tokens $49,134.06 $7,019.15 $49,134.06 $7,019.15 $49,134.06 $7,019.15 $53,228.56 $7,604.08 $53,228.56 $7,604.08 $53,228.56 $7,604.08 $55,275.82 $7,896.55 $53,228.56 $7,604.08 $57,323.07 $8,189.01 $53,801.80 $7,685.97 $55,275.82 $7,896.55 $53,228.56 $7,604.08 $635,221.50 $90,745.93 Capital Expenditure Budget Item Registeration and Licenses Facility Renovations Soda Fountain Bar Double Pizza Oven Salad Bar Commercial Refrigerator Cash Register Video Game Machines Office Desk Laptop for Office Staff Microwave Staff Cupboard Staff Refrigerator Tables Chairs Busing Cart Equipment Handling (Bulk) Flatware Cups Dishes Commercial Dishwasher Total Costs Unit Cost $130.00 $15,000.00 $1,299.00 $16,300.00 $1,121.60 $5,506.70 $1,399.00 $1,295.00 $170.99 $299.00 $144.99 $69.86 $133.20 $249.00 $59.00 $63.34 $850.00 $2.84 $99.99 $51.74 $3,720.00 Quantity 1 1 1 1 1 1 2 6 1 1 1 1 1 20 80 1 1 36 4 6 1 Total Cost $130.00 $15,000.00 $1,299.00 $16,300.00 $1,121.60 $5,506.70 $2,798.00 $7,770.00 $170.99 $299.00 $144.99 $69.86 $133.20 $4,980.00 $4,720.00 $63.34 $850.00 $102.24 $399.96 $310.44 $3,720.00 $65,889.32 Useful Depreciation Depreciation Life Method 15 5 5 5 5 5 5 10 4 5 10 5 10 10 5 5 10 10 10 5 Straight Straight Straight Straight Straight Straight Straight Straight Straight Straight Straight Straight Straight Straight Straight Straight Straight Straight Straight Straight Line Line Line Line Line Line Line Line Line Line Line Line Line Line Line Line Line Line Line Line $1,000.00 $259.80 $3,260.00 $224.32 $1,101.34 $559.60 $1,554.00 $17.10 $74.75 $29.00 $6.99 $26.64 $498.00 $472.00 $12.67 $170.00 $10.22 $40.00 $31.04 $744.00 $10,091.47 Year 1 $14,000.00 $1,039.20 $13,040.00 $897.28 $4,405.36 $2,238.40 $6,216.00 $153.89 $224.25 $115.99 $62.87 $106.56 $4,482.00 $4,248.00 $50.67 $680.00 $92.02 $359.96 $279.40 $2,976.00 Year 2 $13,000.00 $779.40 $9,780.00 $672.96 $3,304.02 $1,678.80 $4,662.00 $136.79 $149.50 $86.99 $55.89 $79.92 $3,984.00 $3,776.00 $38.00 $510.00 $81.79 $319.97 $248.35 $2,232.00 Year 3 $12,000.00 $519.60 $6,520.00 $448.64 $2,202.68 $1,119.20 $3,108.00 $119.69 $74.75 $58.00 $48.90 $53.28 $3,486.00 $3,304.00 $25.34 $340.00 $71.57 $279.97 $217.31 $1,488.00 Year 4 $11,000.00 $259.80 $3,260.00 $224.32 $1,101.34 $559.60 $1,554.00 $102.59 $0.00 $29.00 $41.92 $26.64 $2,988.00 $2,832.00 $12.67 $170.00 $61.34 $239.98 $186.26 $744.00 Year 5 $10,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $85.50 ($74.75) $0.00 $34.93 $0.00 $2,490.00 $2,360.00 $0.00 $0.00 $51.12 $199.98 $155.22 $0.00 Source Florida State Department of Corportations Data provided http://www.sodadispenserdepot.com/pics/sodadispenser172.htm?gclid=Cj0KEQjwkIurBRDwoZfi1bGCxocBEiQAmcs-ehl0IEZ64-ljfrzGpsT7SaZW9jbMCihTl70QuyYQaDcaAoNW8P8HAQ http://www.zesco.com/Marsal-MB-42-Stacked-Pizza-Oven-Double-Deck-Brick-Lined-pz267D011.htm http://www.zesco.com/Carlisle-6606-Six-6-Ft.-Six-Star-Food-Salad-Bar-pz561D061.htm http://www.zesco.com/Kolpak-8X12LF-8-x-12-Walk-In-Cooler-Box-Less-Floor-pz397A007LF.htm https://posguys.com/pos-kit_5/Aldelo-POS-Restaurant-Kit_1220/ALD-KIT_1070875/?src=GB&kpid=1070875&gclid=Cj0KEQjwkIurBRDwoZfi1bGCxocBEiQAmcs-ekE2TMTwHbEArlhGADh0PtRHn6177ggmaNhYjj666X8aArQv8P8HAQ http://coinopstore.com/store/0/6/Multigame-Cocktail-Arcade.html http://www.officedepot.com/a/products/517896/Realspace-Lake-Point-L-Desk-29/ http://www.dell.com/us/p/inspiron-15-3551-laptop/pd?ref=PD_Family http://www.officedepot.com/a/products/1534987/Oster-14-Cu-Ft-Digital-Microwave/ http://www.walmart.com/ip/8206253?wmlspartner=wlpa&selectedSellerId=0&adid=22222222227001194489&wl0=&wl1=g&wl2=c&wl3=40876486112&wl4=&wl5=pla&wl6=78767956712&veh=sem http://www.walmart.com/ip/Haier-4.52-cu-ft-Refrigerator-Black/35033013 http://www.modernlinefurniture.com/modern-furniture-bar-table-c70w1.html http://www.modernlinefurniture.com/modern-furniture-diningchair-model-f37.html http://www.webstaurantstore.com/choice-42-x-20-x-38-gray-3-shelf-utility-bussing-cart/109CARTBLGGY.html http://www.webstaurantstore.com/search/metal-pizza-pans.html http://www.webstaurantstore.com/windsor-flatware-stainless-steel-dinner-knife-12-pack/602383DKN.html http://www.webstaurantstore.com/get-7716-1-cl-16-oz-clear-plastic-stackable-textured-bell-soda-glass-72-case/37577161.html http://www.webstaurantstore.com/carlisle-kl20502-kingline-5-1-2-white-bread-and-butter-plate-48-case/271KL205WH.html http://www.foodservicewarehouse.com/jet-tech/f-18dp/p3740.aspx?utm_medium=cpc&utm_term=Jet-Tech-F-18DP&utm_campaign=Undercounter-Dishwashers&utm_source=googlepla&source=googleps&utm_content=googlepla|mkwid|t3JBUpXr|pcrid|48649849850|pkw||pmt||pdv|c| Cashflows Year 1 Start Up Cash Sales Credit Sales Loan Total Inflows COGS Advertising Payroll Insurance Health Benefits Rent Utilities Credit Card Fees Interest Loan Repayment Total Outflows $200,000.00 $200,000.00 $- Net Cash Flows January $6,000.00 $42,000.00 February $6,000.00 $42,000.00 March $6,000.00 $42,000.00 April $6,500.00 $45,500.00 May $6,500.00 $45,500.00 July $6,750.00 $47,250.00 August September $6,500.00 $7,000.00 $45,500.00 $49,000.00 October $6,570.00 $45,990.00 November $6,750.00 $47,250.00 December Year End Total $6,500.00 $77,570.00 $45,500.00 $542,990.00 $48,000.00 $48,000.00 $48,000.00 $52,000.00 $52,000.00 $54,000.00 $52,000.00 $56,000.00 $52,560.00 $54,000.00 $52,000.00 $620,560.00 $24,000.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,050.00 $500.00 $881.16 $43,100.49 $24,000.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,050.00 $497.80 $883.36 $43,100.49 $24,000.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,050.00 $495.59 $885.57 $43,100.49 $26,000.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,137.50 $493.37 $887.79 $45,187.99 $26,000.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,137.50 $491.16 $890.00 $45,187.99 $27,000.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,181.25 $486.70 $894.46 $46,231.74 $26,000.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,137.50 $484.46 $896.70 $45,187.99 $28,000.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,225.00 $482.22 $898.94 $47,275.49 $26,280.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,149.75 $479.97 $901.19 $45,480.24 $27,000.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,181.25 $477.72 $903.44 $46,231.74 $26,000.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,137.50 $475.46 $905.70 $45,187.99 $310,280.00 $2,400.00 $127,232.00 $1,000.00 $15,400.00 $48,000.00 $6,000.00 $13,574.75 $5,853.38 $10,720.54 $540,460.67 $6,812.01 $6,812.01 $80,099.33 $4,899.51 $4,899.51 $4,899.51 $6,812.01 $6,812.01 $7,768.26 $8,724.51 $7,079.76 $7,768.26 Cash Sales Credit Sales Total Inflows January $6,240.00 $43,680.00 $49,920.00 February $6,240.00 $43,680.00 $49,920.00 March $6,240.00 $43,680.00 $49,920.00 April $6,760.00 $47,320.00 $54,080.00 May $6,760.00 $47,320.00 $54,080.00 July $7,020.00 $49,140.00 $56,160.00 August September $6,760.00 $7,280.00 $47,320.00 $50,960.00 $54,080.00 $58,240.00 October $6,832.80 $47,829.60 $54,662.40 November $7,020.00 $49,140.00 $56,160.00 December Year End Total $6,760.00 $80,672.80 $47,320.00 $564,709.60 $54,080.00 $645,382.40 COGS Advertising Payroll Insurance Health Benefits Rent Utilities Credit Card Fees Interest Loan Repayment Total Outflows $24,960.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,092.00 $473.20 $907.96 $44,102.49 $24,960.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,092.00 $470.93 $910.23 $44,102.49 $24,960.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,092.00 $468.65 $912.51 $44,102.49 $27,040.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,183.00 $466.37 $914.79 $46,273.49 $27,040.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,183.00 $464.08 $917.08 $46,273.49 $28,080.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,228.50 $459.49 $921.67 $47,358.99 $27,040.00 $29,120.00 $200.00 $200.00 $10,602.67 $10,602.67 $83.33 $83.33 $1,283.33 $1,283.33 $4,000.00 $4,000.00 $500.00 $500.00 $1,183.00 $1,274.00 $457.19 $454.88 $923.97 $926.28 $46,273.49 $48,444.49 $27,331.20 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,195.74 $452.56 $928.60 $46,577.43 $28,080.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,228.50 $450.24 $930.92 $47,358.99 $27,040.00 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,183.00 $447.92 $933.24 $46,273.49 $322,691.20 $2,400.00 $127,232.00 $1,000.00 $15,400.00 $48,000.00 $6,000.00 $14,117.74 $5,527.30 $11,046.62 $553,414.86 $7,806.51 $91,967.54 Year 2 Start Up Net Cash Flows $5,817.51 $5,817.51 $5,817.51 $7,806.51 $7,806.51 $8,801.01 $9,795.51 $8,084.97 $8,801.01 Cash Sales Credit Sales Total Inflows January $6,489.60 $45,427.20 $51,916.80 February $6,489.60 $45,427.20 $51,916.80 March $6,489.60 $45,427.20 $51,916.80 April $7,030.40 $49,212.80 $56,243.20 May $7,030.40 $49,212.80 $56,243.20 July $7,300.80 $51,105.60 $58,406.40 August September $7,030.40 $7,571.20 $49,212.80 $52,998.40 $56,243.20 $60,569.60 $7,806.51 October $7,106.11 $49,742.78 $56,848.90 November $7,300.80 $51,105.60 $58,406.40 December Year End Total $7,030.40 $83,899.71 $49,212.80 $587,297.98 $56,243.20 $671,197.70 COGS Advertising Payroll Insurance Health Benefits Rent Utilities Credit Card Fees Interest Loan Repayment Total Outflows $25,958.40 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,135.68 $445.58 $935.58 $45,144.57 $25,958.40 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,135.68 $443.24 $937.92 $45,144.57 $25,958.40 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,135.68 $440.90 $940.26 $45,144.57 $28,121.60 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,230.32 $438.55 $942.61 $47,402.41 $28,121.60 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,230.32 $436.19 $944.97 $47,402.41 $29,203.20 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,277.64 $431.46 $949.70 $48,531.33 $28,121.60 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,230.32 $429.09 $952.07 $47,402.41 $30,284.80 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,324.96 $426.71 $954.45 $49,660.25 $28,424.45 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,243.57 $424.32 $956.84 $47,718.51 $29,203.20 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,277.64 $421.93 $959.23 $48,531.33 $28,121.60 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,230.32 $419.53 $961.63 $47,402.41 $335,598.85 $2,400.00 $127,232.00 $1,000.00 $15,400.00 $48,000.00 $6,000.00 $14,682.45 $5,191.33 $11,382.59 $566,887.22 $8,840.79 $8,840.79 $104,310.48 Year 3 Start Up Net Cash Flows $6,772.23 $6,772.23 $6,772.23 $8,840.79 $8,840.79 $9,875.07 $10,909.35 $9,130.39 $9,875.07 Cash Sales Credit Sales Total Inflows January $6,749.18 $47,244.29 $53,993.47 February $6,749.18 $47,244.29 $53,993.47 March $6,749.18 $47,244.29 $53,993.47 April $7,311.62 $51,181.31 $58,492.93 May $7,311.62 $51,181.31 $58,492.93 July $7,592.83 $53,149.82 $60,742.66 August September $7,311.62 $7,874.05 $51,181.31 $55,118.34 $58,492.93 $62,992.38 October $7,390.36 $51,732.50 $59,122.85 November $7,592.83 $53,149.82 $60,742.66 December Year End Total $7,311.62 $87,255.70 $51,181.31 $610,789.90 $58,492.93 $698,045.60 COGS Advertising Payroll Insurance Health Benefits Rent Utilities Credit Card Fees Interest Loan Repayment Total Outflows $26,996.74 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,181.11 $417.13 $964.03 $46,228.34 $26,996.74 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,181.11 $414.72 $966.44 $46,228.34 $26,996.74 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,181.11 $412.30 $968.86 $46,228.34 $29,246.46 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,279.53 $409.88 $971.28 $48,576.49 $29,246.46 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,279.53 $407.45 $973.71 $48,576.49 $30,371.33 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,328.75 $402.57 $978.59 $49,750.57 $29,246.46 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,279.53 $400.13 $981.03 $48,576.49 $31,496.19 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,377.96 $397.68 $983.48 $50,924.64 $29,561.43 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,293.31 $395.22 $985.94 $48,905.23 $30,371.33 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,328.75 $392.75 $988.41 $49,750.57 $29,246.46 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,279.53 $390.28 $990.88 $48,576.49 $349,022.80 $2,400.00 $127,232.00 $1,000.00 $15,400.00 $48,000.00 $6,000.00 $15,269.75 $4,845.12 $11,728.80 $580,898.47 $9,916.44 $9,916.44 $117,147.13 Year 4 Start Up Net Cash Flows $7,765.14 $7,765.14 $7,765.14 $9,916.44 $9,916.44 $10,992.09 $12,067.74 $10,217.62 $10,992.09 Cash Sales Credit Sales Total Inflows January $7,019.15 $49,134.06 $56,153.21 February $7,019.15 $49,134.06 $56,153.21 March $7,019.15 $49,134.06 $56,153.21 April $7,604.08 $53,228.56 $60,832.65 May $7,604.08 $53,228.56 $60,832.65 July $7,896.55 $55,275.82 $63,172.36 August September $7,604.08 $8,189.01 $53,228.56 $57,323.07 $60,832.65 $65,512.08 October $7,685.97 $53,801.80 $61,487.77 November $7,896.55 $55,275.82 $63,172.36 December Year End Total $7,604.08 $90,745.93 $53,228.56 $635,221.50 $60,832.65 $725,967.43 COGS Advertising Payroll Insurance Health Benefits Rent Utilities Credit Card Fees Interest Loan Repayment Total Outflows $28,076.61 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,228.35 $387.80 $993.36 $47,355.45 $28,076.61 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,228.35 $385.32 $995.84 $47,355.45 $28,076.61 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,228.35 $382.83 $998.33 $47,355.45 $30,416.32 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,330.71 $380.33 $1,000.83 $49,797.53 $30,416.32 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,330.71 $377.83 $1,003.33 $49,797.53 $31,586.18 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,381.90 $372.81 $1,008.35 $51,018.57 $30,416.32 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,330.71 $370.29 $1,010.87 $49,797.53 $32,756.04 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,433.08 $367.76 $1,013.40 $52,239.61 $30,743.88 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,345.04 $365.23 $1,015.93 $50,139.42 $31,586.18 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,381.90 $362.69 $1,018.47 $51,018.57 $30,416.32 $200.00 $10,602.67 $83.33 $1,283.33 $4,000.00 $500.00 $1,330.71 $360.14 $1,021.02 $49,797.53 $362,983.71 $2,400.00 $127,232.00 $1,000.00 $15,400.00 $48,000.00 $6,000.00 $15,880.54 $4,488.35 $12,085.57 $595,470.17 $8,797.76 $8,797.76 $8,797.76 $11,035.12 $11,035.12 $12,153.79 $11,035.12 $13,272.47 $11,348.34 $12,153.79 $11,035.12 $130,497.26 Year 5 Start Up Net Cash Flows Net Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 $80,099.33 $91,967.54 $104,310.48 $117,147.13 $130,497.26 Payroll $45,000.00 $32,000.00 $50,232.00 $127,232.00 $10,602.67 Amount Given - Manager Assistant Manager 3 Employees Annual Amount Amount per pay period on a biweekly schedule Assumed Based on assumptions above Assumed Assumed Assumed Based on provided information at 2.5% Site used to calculate loan amortization http://www.calculator.net/loan-calculator.html?cloanamount=200000&cloanterm=15&cloantermmonth=0&cinterestrate=3&ccompound=monthly&cpayback=month&x=61&y=16 Based on loan amount of 200,000 for 10 years at 4% NPV Analysis Year 1 2 3 4 5 PV of Cash Flows Original Investment Net Present Value Net Annual Cash Discount Factor Present Value Flows 10% $80,099.33 0.9091 $72,818.30 $91,967.54 0.8264 $76,001.98 $104,310.48 0.7513 $78,368.46 $117,147.13 0.683 $80,011.49 $130,497.26 0.6209 $81,025.75 $388,225.98 ($200,000.00) $188,225.98 Internal Rate of Return Accounting Rate of Return Year Cost Year Cost Rate IRR Net Annual Cash Flow ($200,000.00) 1 $80,099.33 2 $91,967.54 3 $104,310.48 4 $117,147.13 5 $130,497.26 10% 39% Rate Net Annual Cash Flow ($200,000.00) 1 $80,099.33 2 $91,967.54 3 $104,310.48 4 $117,147.13 5 $130,497.26 10% Average Net Annual Cash Flows ARR 37% $104,804.35 Payback Period Year Investment 0 1 2 3 4 5 Net Annual Cash Flow Cumulative Net Cash Flow $200,000.00 $80,099.33 $91,967.54 $104,310.48 $117,147.13 $130,497.26 $80,099.33 $172,066.87 $276,377.35 $393,524.48 $524,021.74 Pro-Forma Income Statement Sales Cost of Goods Sold Gross Profit Year 1 $620,560.00 $310,280.00 $310,280.00 Year 2 $645,382.40 $322,691.20 $322,691.20 Year 3 $671,197.70 $335,598.85 $335,598.85 Year 4 $698,045.60 $349,022.80 $349,022.80 Year 5 $725,967.43 $362,983.71 $362,983.72 Operating Expenses: Rent Utilities Wages Insurance Credit Card Fees Depreciation Expense Advertising Employee Benefits Total Operating Expenses $48,000.00 $6,000.00 $127,232.00 $1,000.00 $13,574.75 $10,091.47 $2,400.00 $15,400.00 $223,698.22 $48,000.00 $6,000.00 $127,232.00 $1,000.00 $14,117.74 $10,091.47 $2,400.00 $15,400.00 $224,241.21 $48,000.00 $6,000.00 $127,232.00 $1,000.00 $14,682.45 $10,091.47 $2,400.00 $15,400.00 $224,805.92 $48,000.00 $6,000.00 $127,232.00 $1,000.00 $15,269.75 $10,016.72 $2,400.00 $15,400.00 $225,318.47 $48,000.00 $6,000.00 $127,232.00 $1,000.00 $15,880.54 $2,075.32 $2,400.00 $15,400.00 $217,987.86 $86,581.78 $5,853.38 $80,728.40 $24,218.52 $56,509.88 $98,449.99 $5,527.30 $92,922.69 $27,876.81 $65,045.88 $110,792.93 $5,191.33 $105,601.60 $31,680.48 $73,921.12 $123,704.33 $4,845.12 $118,859.21 $35,657.76 $83,201.45 $144,995.86 $4,488.35 $140,507.51 $42,152.25 $98,355.26 Operating Income Interest Income Before Taxes Income Taxes Net Income Pro-Forma Balance Sheet Year 1 Assets Cash Equipment Less Accumulated Depreciation Total Assets Year 2 Year 3 Year 4 Year 5 $80,099.33 $65,889.32 $(10,091.47) $135,897.18 $276,377.35 $65,889.32 $(30,274.41) $311,992.26 $393,524.48 $65,889.32 $(40,066.88) $419,346.92 $524,021.74 $65,889.32 $(42,142.20) $547,768.86 $24,182.52 Liabilities and Owners Equity Income Taxes Payable Payroll Payable Insurance Payable Interest Payable Total Current Liablities $172,066.87 $65,889.32 $(20,182.94) $217,773.25 $27,876.81 $31,680.48 $35,657.76 $42,152.25 $24,182.52 $27,876.81 $31,680.48 $35,657.76 $42,152.25 Long Term Liabilities Notes Payable Total Long Term Liabilities $200,000.00 $200,000.00 $189,279.46 $189,279.46 $178,232.84 $178,232.84 $166,850.25 $166,850.25 $155,121.45 $155,121.45 Retained Earnings Total Liablities and Owners Equity $10,387.36 $234,569.88 $75,433.24 $292,589.51 $149,354.36 $359,267.68 $232,555.81 $435,063.82 80099.33 91967.54 104310.4784 117147.134336 130497.256509 $330,911.07 $528,184.77 Pro-Forma Cash Flow Year 1 Cash Flows from Operating Activities Cash Received from Customers Cash Payments for Merchandise Cash Payments for Interest Cash Payments for Income Taxes Cash Payments for Payroll Cash Payments for Operating Expenses Net Cash Flows from Operating Activities $232,710.00 $5,853.38 $4,451.72 $127,232.00 $54,000.00 Cash Flows From Investing Activities Equipment Purchase Net Cash Flows from Investing Activities Cash Flows from Financing Activities Cash Received from Loan Cash Payments on Principal of Loan Net Cash Flows from Financing Activities $424,247.10 $196,312.90 $(65,889.32) $200,000.00 $(10,720.54) Net Increase (Decrease) in Cash Beginning Cash Balance Ending Cash Balance Year 2 $620,560.00 Year 3 $645,382.40 $242,018.40 $5,527.30 $27,876.81 $127,232.00 $54,000.00 $456,654.51 $188,727.89 $$(65,889.32) Year 4 $251,699.14 $5,191.33 $31,680.48 $127,232.00 $54,000.00 $469,802.95 $201,394.75 $$- $$(11,046.62) Year 5 $671,197.70 $698,045.60 $261,767.10 $4,845.12 $35,657.76 $127,232.00 $54,000.00 $483,501.98 $214,543.62 $$- $$(11,382.59) $725,967.43 $272,237.78 $4,488.35 $42,152.25 $127,232.00 $54,000.00 $500,110.38 $225,857.05 $$- $$(11,728.80) $$$(12,085.57) $189,279.46 $(11,046.62) $(11,382.59) $(11,728.80) $(12,085.57) $319,703.04 $$319,703.04 $177,681.27 $319,703.04 $497,384.31 $190,012.16 $697,384.31 $887,396.47 $202,814.82 $1,087,396.47 $1,290,211.29 $213,771.48 $1,490,211.29 $1,703,982.77