how much is the discounted payback period for the new phone project (in years)?
do not round in-between calculations
round the final profolio value to two decimals.
please refer the last 4 photos
Eapers egestue RAD Miring 3.4.500.000 16.800.000 0905 20.000 K Ya 100.000 14.20 150.000 105.000 00000 Year 2 10000 2. 65.000 50.000 Deprecate Sales of old shore Los 17.94 wart 30.000 Mohon Uw hone Footer $575 12 16.000.000 SEPE Phone Revised me opone Uncophone 1235 115 21 NOE NWEB Rem Ou Are o produto 3200 ales New TEA BOTO wa 3 w MARO WIP TE NIVE CAL . Thep ERI Tas DES 14 OD KREME they OCT 19 OS ETC .. e In Hai W ( Hugo UNE 15 DC T BV AIN NEVE we 19 Equipment Salvage value R&D Marketing study $ 49,500,000 $ 6,800,000 $ 950,000 $ 250,000 Sales (units) Depreciation rate Sales of old phone (units) Lost sales (units) Year 1 160,000 14.29% 95.000 30.000 Year 2 170,000 24.49% 65,000 30,000 Year 3 130,000 17.49% Year 4 105,000 12.49% Year 5 80.000 8.93% Price of new phone Unit cost of new phone Fixed costs (per year) $ 575 $ 245 $ 6,900,000 $ 435 $ 235 $ 155 Price of old phone Revised price of old phone Unit cost of old phone Tax rate NWC percentage Required retum 21% 20% 12% Old phone price reduction $ 200 Year 3 74,750,000 Year 4 60,375,000 Year 5 46.000.000 New phone sales Lost sales Lost rev. Net sales Sales Year 2 97750.000 (13.050.000) (7,000,000) $77.700.000 Year! 92.000.000 (13.050.000) (13.000.000) $65.950,000 $74,750,000 $60,375.000 $46.000.000 Year 2 39,200.000 (4,650,000) $34,550.000 Variable Costs (VC) Year 2 41.650.000 (4.650.000) $37.000.000 Year 3 31.850.000 Year 4 25.725.000 New phone costs Lost sales Net VC Years 19.500.000 531 850.000 $25725.000 $19.000 DOO Net Sales Net Variable Costs Fixed costs Dep Year $65.950.000 34 550,000 6.900.000 7073.550 Operating Cash Flow Year 2 Year $77,700.000 $74,750,000 370.000 31,850.000 6.).000 6,6X0,000 12.122.550 8.657.550 Yar 4 560,375,000 25.725.000 6.900.000 6,182.350 213750 Year 3 $16.000.000 19.000.000 6.420,000 42010 SIS.09.0.50 K Net Sales Net Variable Costs Fixed costs Dep EBT The NI Dep OCF Operating Cash Flow Year / Year 2 Year $65.950.000 577.700.000 $74,750,000 34 350,000 37.000.000 31,850.00 6.900.000 6,900.000 6.900.000 7.073,550 12.122.550 8.657,550 517426450 521,677450 $27.342450 3.659.355 4.352,265 5,741,915 513,766,896 $17,125,186 $21,600.336 7.073350 12.122.550 8,657350 520 840446 $29,247,736 $30.258086 Yeart 560.375.000 25,725.000 6.900.000 6.182.550 $21567.450 4 $29,165 S173.286 6.182.550 $23.220.336 Year $46.000.000 19.000.000 6.900.000 +4420350 515,079.650 3.166.727 SIT 912934 4420,150 $16.333274 Changes in Net Working Capital Year / Year 2 0 13190000 13.190.000 15 540.000 $13.12.000 $2.250.000 Yours 1207.000 Bee NWC End NWC Changes in NWC Your 15540000 14.950.000 (5590,000) Year 1495000 12.075 000 (52.875000) 1812.075.000 Net Capital Spending BV of Equipment 51140 Year! Year 2 Yor Tar Iar 49.500.00 Equipment TSVqipe Net Capital Spending 2012 0713 38 50 30 SO H.300.000 D E F G H ATSV Equipment Net Capital Spending - 1 7,091,125 (57.691.185 $49,500,000 SO SO SO 50 Free Cash Flow Year / 20.8.40.446 Year 2 29.247,736 Year 3 30,258,086 Year 4 23.22.836 (49,500,000) OCF NCS Changes in NWC FCF Year 16,333,274 7,891,125 12.075.00 536.099 398 (13.190JXO) $7,650446 (2.350.000) $26,897,736 590,000 $30,848,086 28750 $26.095 836 (549.5000) Payback period PI IRR NPV 2.48 1.76 3426 $37,798.666 Input Area: 2 L- Equipment Salvage value R&D Marketing study 549,500,000 $ 6,800,000 $ 950,000 $ 250,000 Sales (units) Depreciation rate Sales of old phone (units) Lost sales (units) Year 1 160,000 14.29% 95,000 30,000 Year 2 170,000 24.49% 65,000 30,000 Year 3 130,000 17.49% Year 4 105,000 12.49% Year 5 80,000 8.80% Price of new phone Unit cost of now phone Fixed costs (per year) 3575 $ 245 $6,900,000 Price of old phone Revised price of old phone Unit cost of old phone $435 $ 235 $ 155 Tax rate NWC percentage Required return 21% 20% 12% Output Area: E 1 1 K Old phone price reduction $ 200 New phone sales Lost sales Sales Year 2 97,750,00 (130500) 7.000.000) $77.700.000 Year 74,750,000 Your 4 60375.000 Year! 92.000.000 (13.050.000) (13.000.000) 565 950.000 Year 5 46.000 ( Lost rev. Net sales $74.750.000 560.375 54600000 Xor Year 31.250.000 Variable Costs (VC) Year 2 41.650.000 (6.650.000 $37.000.000 Year / 39.2000 (4.650.00K) $34.550.000 Yard 25,725.000 New phone costs Lost sales Net VC 19,00 SL850.000 $25.725000 519.000.000 Yrar OOOXF95 Year! 565 950 14,350,000 6.900.000 Net Sales Net Variable Costs Fixed costs Dep ERT DOWOSKIE Operating Cash Flow Yhar 2 Yow 577,700.000 574,750.00 17.000.000 6,900700 0.000000 12.122,550 8.657550 521677450 527,42450 4.332.265 517.135.15 $21.10.16 12.122.350 457350 OSSELUE Year 0,375.000 25,72500 6.900.000 6,18230 521 567 450 4.529,160 5121,186 IN40 19.00 0.000 4430,150 51509SO 1,166,722 31191224 150 S16 INC'S 517A26450 3.659.355 $13,706 702,350 TK IN Dep P! Now H Two Beg NWC End NWC Changes in NWC Changes in Net Working Capital Year 2 0 13190000 13.190.000 15540.000 $13.190.000 $2.350.000 Year 15540000 14,950.000 (55) Year 14950000 12.075.000 (52.875.000 Thors 12075000 0 (512075 Net Capital Spending Trar 11.043450 BV of Equipment Year 2 Year! Yrar Thar Har 49.500.000 7.891,135 Equipment ATSV Equipment Net Capital Spending 0 SO 30 SO $49.500.000 Mars Free Cash Flow Year! 20X40446 0 Year 2 29.247746 Year 10. Yard 20,230 KM (49.500.000 OCH NCS Changes in NWC FCF (13.190000) $7A50 446 TM1.135 12. So 3M 30 5 SLO XAN ON 12.150.00 52697716 275 526.000 (549 SOKO Payback period PI 248 1.70 1442 5179 TRR NPV Eapers egestue RAD Miring 3.4.500.000 16.800.000 0905 20.000 K Ya 100.000 14.20 150.000 105.000 00000 Year 2 10000 2. 65.000 50.000 Deprecate Sales of old shore Los 17.94 wart 30.000 Mohon Uw hone Footer $575 12 16.000.000 SEPE Phone Revised me opone Uncophone 1235 115 21 NOE NWEB Rem Ou Are o produto 3200 ales New TEA BOTO wa 3 w MARO WIP TE NIVE CAL . Thep ERI Tas DES 14 OD KREME they OCT 19 OS ETC .. e In Hai W ( Hugo UNE 15 DC T BV AIN NEVE we 19 Equipment Salvage value R&D Marketing study $ 49,500,000 $ 6,800,000 $ 950,000 $ 250,000 Sales (units) Depreciation rate Sales of old phone (units) Lost sales (units) Year 1 160,000 14.29% 95.000 30.000 Year 2 170,000 24.49% 65,000 30,000 Year 3 130,000 17.49% Year 4 105,000 12.49% Year 5 80.000 8.93% Price of new phone Unit cost of new phone Fixed costs (per year) $ 575 $ 245 $ 6,900,000 $ 435 $ 235 $ 155 Price of old phone Revised price of old phone Unit cost of old phone Tax rate NWC percentage Required retum 21% 20% 12% Old phone price reduction $ 200 Year 3 74,750,000 Year 4 60,375,000 Year 5 46.000.000 New phone sales Lost sales Lost rev. Net sales Sales Year 2 97750.000 (13.050.000) (7,000,000) $77.700.000 Year! 92.000.000 (13.050.000) (13.000.000) $65.950,000 $74,750,000 $60,375.000 $46.000.000 Year 2 39,200.000 (4,650,000) $34,550.000 Variable Costs (VC) Year 2 41.650.000 (4.650.000) $37.000.000 Year 3 31.850.000 Year 4 25.725.000 New phone costs Lost sales Net VC Years 19.500.000 531 850.000 $25725.000 $19.000 DOO Net Sales Net Variable Costs Fixed costs Dep Year $65.950.000 34 550,000 6.900.000 7073.550 Operating Cash Flow Year 2 Year $77,700.000 $74,750,000 370.000 31,850.000 6.).000 6,6X0,000 12.122.550 8.657.550 Yar 4 560,375,000 25.725.000 6.900.000 6,182.350 213750 Year 3 $16.000.000 19.000.000 6.420,000 42010 SIS.09.0.50 K Net Sales Net Variable Costs Fixed costs Dep EBT The NI Dep OCF Operating Cash Flow Year / Year 2 Year $65.950.000 577.700.000 $74,750,000 34 350,000 37.000.000 31,850.00 6.900.000 6,900.000 6.900.000 7.073,550 12.122.550 8.657,550 517426450 521,677450 $27.342450 3.659.355 4.352,265 5,741,915 513,766,896 $17,125,186 $21,600.336 7.073350 12.122.550 8,657350 520 840446 $29,247,736 $30.258086 Yeart 560.375.000 25,725.000 6.900.000 6.182.550 $21567.450 4 $29,165 S173.286 6.182.550 $23.220.336 Year $46.000.000 19.000.000 6.900.000 +4420350 515,079.650 3.166.727 SIT 912934 4420,150 $16.333274 Changes in Net Working Capital Year / Year 2 0 13190000 13.190.000 15 540.000 $13.12.000 $2.250.000 Yours 1207.000 Bee NWC End NWC Changes in NWC Your 15540000 14.950.000 (5590,000) Year 1495000 12.075 000 (52.875000) 1812.075.000 Net Capital Spending BV of Equipment 51140 Year! Year 2 Yor Tar Iar 49.500.00 Equipment TSVqipe Net Capital Spending 2012 0713 38 50 30 SO H.300.000 D E F G H ATSV Equipment Net Capital Spending - 1 7,091,125 (57.691.185 $49,500,000 SO SO SO 50 Free Cash Flow Year / 20.8.40.446 Year 2 29.247,736 Year 3 30,258,086 Year 4 23.22.836 (49,500,000) OCF NCS Changes in NWC FCF Year 16,333,274 7,891,125 12.075.00 536.099 398 (13.190JXO) $7,650446 (2.350.000) $26,897,736 590,000 $30,848,086 28750 $26.095 836 (549.5000) Payback period PI IRR NPV 2.48 1.76 3426 $37,798.666 Input Area: 2 L- Equipment Salvage value R&D Marketing study 549,500,000 $ 6,800,000 $ 950,000 $ 250,000 Sales (units) Depreciation rate Sales of old phone (units) Lost sales (units) Year 1 160,000 14.29% 95,000 30,000 Year 2 170,000 24.49% 65,000 30,000 Year 3 130,000 17.49% Year 4 105,000 12.49% Year 5 80,000 8.80% Price of new phone Unit cost of now phone Fixed costs (per year) 3575 $ 245 $6,900,000 Price of old phone Revised price of old phone Unit cost of old phone $435 $ 235 $ 155 Tax rate NWC percentage Required return 21% 20% 12% Output Area: E 1 1 K Old phone price reduction $ 200 New phone sales Lost sales Sales Year 2 97,750,00 (130500) 7.000.000) $77.700.000 Year 74,750,000 Your 4 60375.000 Year! 92.000.000 (13.050.000) (13.000.000) 565 950.000 Year 5 46.000 ( Lost rev. Net sales $74.750.000 560.375 54600000 Xor Year 31.250.000 Variable Costs (VC) Year 2 41.650.000 (6.650.000 $37.000.000 Year / 39.2000 (4.650.00K) $34.550.000 Yard 25,725.000 New phone costs Lost sales Net VC 19,00 SL850.000 $25.725000 519.000.000 Yrar OOOXF95 Year! 565 950 14,350,000 6.900.000 Net Sales Net Variable Costs Fixed costs Dep ERT DOWOSKIE Operating Cash Flow Yhar 2 Yow 577,700.000 574,750.00 17.000.000 6,900700 0.000000 12.122,550 8.657550 521677450 527,42450 4.332.265 517.135.15 $21.10.16 12.122.350 457350 OSSELUE Year 0,375.000 25,72500 6.900.000 6,18230 521 567 450 4.529,160 5121,186 IN40 19.00 0.000 4430,150 51509SO 1,166,722 31191224 150 S16 INC'S 517A26450 3.659.355 $13,706 702,350 TK IN Dep P! Now H Two Beg NWC End NWC Changes in NWC Changes in Net Working Capital Year 2 0 13190000 13.190.000 15540.000 $13.190.000 $2.350.000 Year 15540000 14,950.000 (55) Year 14950000 12.075.000 (52.875.000 Thors 12075000 0 (512075 Net Capital Spending Trar 11.043450 BV of Equipment Year 2 Year! Yrar Thar Har 49.500.000 7.891,135 Equipment ATSV Equipment Net Capital Spending 0 SO 30 SO $49.500.000 Mars Free Cash Flow Year! 20X40446 0 Year 2 29.247746 Year 10. Yard 20,230 KM (49.500.000 OCH NCS Changes in NWC FCF (13.190000) $7A50 446 TM1.135 12. So 3M 30 5 SLO XAN ON 12.150.00 52697716 275 526.000 (549 SOKO Payback period PI 248 1.70 1442 5179 TRR NPV
