File Home Insert Page Layout Formulas Data Review View N17 Book 1 - Excel Tell me what you want to do... Sign in Share A B C D F F G H K M 1 Units Sold 61,000.00 2 Sale Price $ 3 Cost per Unit $ 280.00 112.00 4 5 Cost of Equipment $ 8,700,000.00 6 Rental Cost $ 3,300,000.00 7 8 Tax Rate 9 Cost of Capital 10 11 Year 12 Revenue 13 Variable Cost 14 Rent 15 Depreciation 16 EBT 17 Tax 18 Net Income 19 20 Accounts Payable 21 Accounts Receivables 22 Net Working Capital 34% 10.50% 0 23 Change in Net Working Capital 24 Recovery of NWC $ (8,700,000.00) 1 2 3 5 6 $ 17,080,000.00 $17,080,000.00 $17,080,000.00 $ 17,080,000.00 $17,080,000.00 $17,080,000.00 $17,080,000.00 $ 8,662,000.00 $ 8,662,000.00 $ 8,662,000.00 $8,662,000.00 $ 8,662,000.00 $8,662,000.00 $ 8,662,000.00 $ 3,300,000.00 $ 3,300,000.00 $ 3,300,000.00 $3,300,000.00 $ 3,300,000.00 $3,300,000.00 $3,300,000.00 $ 1,242,857.14 $ 1,242,857.14 $ 1,242,857.14 $ 1,242,857.14 $ 1,242,857.14 $ 1,242,857.14 $ 1,242,857.14 $ 3,875,142.86 $ 3,875,142.86 $ 3,875,142.86 $ 3,875,142.86 $ 3,875,142.86 $ 3,875,142.86 $ 3,875,142.86 $ 1,317,548.57 $ 1,317,548.57 $ 1,317,548.57 $ 1,317,548.57 $ 1,317,548.57 $ 1,317,548.57 $ 1,317,548.57 $ 2,557,594.29 $ 2,557,591.29 $ 2,557,594.29 $ 2,557,594.29 $ 2,557,594.29 $ 2,557,591.29 $ 2,557,591.29 $ 1,385,920.00 $ 1,385,920.00 $ 1,385,920.00 $ 1,385,920.00 $ 1,385,920.00 $ 1,385,920.00 $ 1,385,920.00 $ 3,757,600.00 $ 3,757,600.00 $ 3,757,600.00 $ 3,757,600.00 $ 3,757,600.00 $ 3,757,600.00 $ 3,757,600.00 $ 2,371,680.00 $ 2,371,680.00 $ 2,371,680.00 $ 2,371,680.00 $ 2,371,680.00 $2,371,680.00 $ 2,371,680.00 $ (2,371,680.00) $ $ $ $ $ $ $ 2,371,680.00 25 Capital Expenditure 26 Add Back Depreciation 27 Net Cash Flow 28 NPV $ 2,557,594.29 $ 2,557,594.29 $ 2,557,594.29 $ 2,557,594.29 $ 2,557,594.29 $2,557,594.29 $ 2,557,594.29 $ (8,700,000.00) $ 2,743,508.57 $ 5,115,188.57 $ 5,115,188.57 $ 5,115,188.57 $ 5,115,188.57 $ 5,115,188.57 $ 7,486,868.57 $ 2,941,162.36 29 30 31 Sheet14 Sheet15 Sheet16 Sheet17 Ready 7 + 89%