More clearly here is the project file You can get the data h

More clearly here is the project file, You can get the data here: Link (https://files.fm/u/2mv7ppbd#_)

Estimate the Project NPV. (Show the calculation sure)

Recommend to proceed with the investment or not ?

2009 2010 2011 2012 2014 2015 2016 2017 2018 Revenue Projectionn Total Capacity (000\'s) Capacity Utilization Unit Volume Selling Price Per Unit - Growing at Revenue 80,000 80,000 80,000 80,000 80,000 0,000 80,000 80,000 80,000 80,000 85.0% 600% enn 70.0% 750% 80.0% 85.0% 85.0% 85.0% 85.0% 650% 48,000 52,000 56,000 60,000 64,000 68,000 68,000 68,000 68,000 68,000 1.84 1.88 1.92 195 199 2.03 2.0 2.12 84,960 93,881 103,124 112,700 122,618 132,887 135,545 138,256 141,021 143,841 20% Production Costs: Raw Materials Per Unit Growing at 1% Manufacturing Overhead Growing at Maintenance Expense Growing at 0.95 1.00 1.0% 3.0% 3.0% 0.94 3,600 2.250 2.318 2.387 2A59 2.532 2,608 2,687 2767 2,850 2.936 3,708 3,819 3,934 4,052 4,173 4,299 4,428 4,560 4,697 Salaried Labor Cost Managers Average Annual Fully Loaded Cost Total Salaried Labor Cost 171.4 1836 190.0 196 23. 2107 218.1 177.4 160.0 640.0 165.6 662.4 1,0284 1,064.4 1,468.8 1,520.2 1,573.4 1,628.5 1,685.5 1,744.5 3.5% Hourly Labor Cost: Average Fully Loaded Hourly Cost Hours Per Year Cost Per Hourly Employee Number of Hourly Workers Total Hourly Labor Cost (000\'s) 3.5% 20.00 20.70 21.42 22.17 22.95 23.75 24.59 25.45 27.26 2,000 2000 2000 2000 000 02000 2000 200 2000 40,000 41,400 42,849 44,349 45,901 47,507 9,170 50,891 52,672 54,516 18,000.0 19,570.9 21,814.0 24,190.2 26,706.0 29,368.2 30,396.1 31,460.0 32,561.1 33,700.7 18,640.0 20,233.3 22,842.4 25,254.6 28,174.8 30,888.5 31,969.6 33,088.5 34,246.6 35,445.2 509 582 618 Total Labor Cost 78% 7.8% 78% 78% 78% 78% 7.8% 7.8% 7.8% 7.8% Selling, General & Administrative/Revenue Capital Assumptions: 47.6x Days Sales Outstanding Days Sales Inventory Days Payable Outstanding 47.6x 37.6x 34.2x 47.6x 37.6x 34.2x 47.6x 37.6x 47.6x 37.6x 34.2x 47.6x 37.6x 47.6x 37.6x 34.2x 47.6x 37.6x 34.2x 34.2x 47.6x 37.6x 47.6x 37.6x 34.2x

Solution

Particulars

2009

2010

2011

2012

2013

Volume

48000.00

52000.00

56000.00

60000.00

64000.00

Revenue

84960.00

93881.00

103124.00

112700.00

122618.00

Raw material prod cost

45120.00

49400.00

53760.00

58200.00

62720.00

Manufacturing Overhead

3600.00

3708.00

3819.00

3934.00

4052.00

Maintenance Exp

2250.00

2318.00

2387.00

2459.00

2532.00

Manager\'s Salary

640.00

662.40

1028.40

1064.40

1468.80

Labour cost

18000.00

19570.90

21814.00

24190.20

26706.00

SGA

6626.88

7322.72

8043.67

8790.60

9564.20

Net revenue

8723.12

10898.98

12271.93

14061.80

15575.00

Increase in working capital

5570.80

1704.70

1773.31

1844.52

1917.86

Net cashflow

3152.32

9194.28

10498.62

12217.28

13657.14

Particulars

2014

2015

2016

2017

2018

Volume

68000.00

68000.00

68000.00

68000.00

68000.00

Revenue

132887.00

135545.00

138256.00

141021.00

143841.00

Raw material prod cost

67320.00

68000.00

68680.00

69360.00

70040.00

Manufacturing Overhead

4173.00

4299.00

4428.00

4560.00

4697.00

Maintenance Exp

2608.00

2687.00

2767.00

2850.00

2936.00

Manager\'s Salary

1520.20

1573.40

1628.50

1685.50

1744.50

Labour cost

29368.20

30396.10

31460.00

32561.10

33700.70

SGA

10365.19

10572.51

10783.97

10999.64

11219.60

Net revenue

17532.41

18016.99

18508.53

19004.76

19503.20

Increase in working capital

1993.33

564.46

577.00

589.78

602.80

Net cashflow

15539.08

17452.53

17931.53

18414.98

18900.40

Particulars	2009	2010	2011	2012	2013
Volume	48000.00	52000.00	56000.00	60000.00	64000.00
Revenue	84960.00	93881.00	103124.00	112700.00	122618.00
Raw material prod cost	45120.00	49400.00	53760.00	58200.00	62720.00
Manufacturing Overhead	3600.00	3708.00	3819.00	3934.00	4052.00
Maintenance Exp	2250.00	2318.00	2387.00	2459.00	2532.00
Manager\'s Salary	640.00	662.40	1028.40	1064.40	1468.80
Labour cost	18000.00	19570.90	21814.00	24190.20	26706.00
SGA	6626.88	7322.72	8043.67	8790.60	9564.20
Net revenue	8723.12	10898.98	12271.93	14061.80	15575.00
Increase in working capital	5570.80	1704.70	1773.31	1844.52	1917.86
Net cashflow	3152.32	9194.28	10498.62	12217.28	13657.14