Recall that your company has $435,000 to allocate to the list of capital projects. Write a report explaining the options and your recommendations. Include in your report the considerations that factored into your decision.

AutoSave ON my v o... x Investment Proposal Analysis La Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 11 v AI Wrap Text v General Paste B I U v Na v Av Merge & Center v $ v % 9 K106 fx B D E F G H J - Payback v IRR 1 Plant 65 Virginia Beach; Virginia 71 Henderson; Nevada 72 Laredo; Texas 73 Chandler; Arizona 83 Boise; Idaho 84 Jersey ; New Jersey 86 Tulsa, Oklahoma 88 Charlotte, North Carolina 89 Bakersfield; California 90 Greensboro; North Carolina 92 Hialeah; Florida 93 Dallas, Texas 94 Durham; North Carolina 95 Houston; Texas 96 Aurora; Colorado 97 Cleveland; Ohio 98 Lubbock; Texas 99 Scottsdale; Arizona 100 Oakland; California 101 San Jose; California 102 Total 103 Initial Investmen (27,000) (27,000) (25,000) (33,000) (25,000) (26,000) (25,000) (26,000) (29,000) (26,000) (23,000) (20,000) (28,000) (23,000) (20,000) (22,000) (20,000) (20,000) (20,000) (20,000) (485,000) Yeal 15,000 20,000 20,000 19,000 17,000 18,000 16,000 15,000 17,000 12,000 14,000 15,000 19,000 16,000 16,000 19,000 19,000 19,000 19,000 19,000 Yeal 10,000 7,000 5,000 14,000 9,000 9,000 11,000 14,000 16,000 20,000 17,000 10,000 20,000 16,000 15,000 18,000 12,000 15,000 19,000 19,000 Yeal 15,000 16,000 13,000 19,000 19,000 10,000 18,000 18,000 8,000 18,000 7,000 20,000 4,000 13,000 15,000 5,000 2,000 14,000 17,000 1,000 Year 19,000 20,000 20,000 14,000 11,000 20,000 14,000 11,000 20,000 5,000 20,000 18,000 20,000 17,000 13,000 12,000 15,000 12,000 1,000 14,000 2.1 2.0 2.0 2.0 1.9 1.9 1.8 1.8 1.8 1.7 1.5 1.5 1.5 1.4 1.3 1.2 1.1 1.1 1.1 1.1 NPV -1 15226.7 18571.3 17007.4 15552.8 16174.8 15306.0 17937.8 16592.8 15465.1 15025.6 18928.1 25009.4 18597.5 22186.6 23398.7 18996.9 16131.4 24763.2 23353.1 20250.6 374476.0 38% 45% 45% 36% 44% 41% 46% 43% 39% 42% 50% 64% 46% 56% 66% 60% 57% 73% 77% 68%