*How to get free Cash flow?

1. John estimates that the cost of starting up a stand will be as follows:

Purchase of retail kiosk (mobile retail food outlet) $500,000

Specialized kitchen equipment $50,000

Installation of the kitchen equipment $10,000

Furniture and fittings $50,000

Are OP) De Capta Budgeting Lice - Excel Search - A Lou HengruitH Fic Home Insert Page Layout Formula: Data REICH View Hep Share Comments C33 X H 1 L M M N 0 P 0.00 C 1.00 5.00 109500.00 547500.00 100000.00 155000.00 D 2.00 7.50 131400.00 985500.00 100000.00 1.55000.00 3.00 11.25 157680.00 1773900.00 100000.00 155000.00 F 4.00 16.88 189216.00 3193020.00 100000.00 155000.00 G 5.00 25.31 227059.20 5747436.00 100000.00 155000.00 802500.00 1240500.00 2028900.00 3448020.00 6002436.00 A 1 Years 2 Price per unit 3 No of units 4 Total Sale of Burpers s Drinks 6 Other food sales 7 & Total Sales (Gross sales) 9 10 Cost of Raw materials: 11 Burgers 12 Total Raw material for the burgers 1.3 Drinks 14 Other food supplies 15 Nonfood supplies 16 17 Total Cost of goods sold 18 19 Gross Profit 20 21 Kitchen and service staff zz License and rent costs 23 Depreciation 24 Earnings before tax 25 20 Tax 35% 27 78 Net Income 2.00 219000.00 38400.00 58900.00 50200.00 2.20 28900.00 38400.00 58900.00 50200.00 2.42 381585.60 38400,00 58900.00 50200.00 2.66 503697.99 38400.00 58900.00 50200.00 2.93 661871.75 38400,00 58900.00 50200.00 366500.00 436580.00 529095.60 651192.99 812374.75 436000.00 803920.00 1499814.40 2796827.01 5190061.25 200000.00 150000.00 62000.00 24000.00 200000.00 150000.00 62000.00 391920.00 200000.00 150000.00 62000.00 1087814.40 200000.00 150000.00 62000.00 2384827.01 200000.00 150000.00 62000.00 4778061.25 8400.00 137172.00 380735.04 834689.45 1672321.44 15600.00 254748.00 707079.36 1550137.56 3105739.91 62000.00 62000.00 62000.00 62000.00 62000.00 30 Plus: Depreciation 31 Purchase of relail kiosk 3 Free Cash Flow 34 as Cost of capital 10% 36 PV of CES 37 NPVISum of all PVS) 1.00 0.91 0.62 0.75 0.68 0.62 1,2 Model & Calculation of NPV 3NPV at various values 4 Goal seek-quantity 5 Goal seek price . Ener