Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

38000 52000 56000 60000 84000 68000 68000 68000 58000 Units 42000 0.95 0.96 0.97 0.98 0.99 101 1.02 103 Unit Costs 181 1.94 1.98 1.32

image text in transcribed
image text in transcribed
38000 52000 56000 60000 84000 68000 68000 68000 58000 Units 42000 0.95 0.96 0.97 0.98 0.99 101 1.02 103 Unit Costs 181 1.94 1.98 1.32 1.95 1.99 203 2.07 212 Selling Price 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 New Project Exhibits Exhibits Revenue 84,960.00 5 94,120.00 $ 103/040.00 $ 112,900.00 $ 122,890.00 $ 132 600.00 $ 135,320.00 $ 138,040.00 $ 140,760.00 $ 144,180.00 Cost to Expand 57 817.0 Production Expenses 62,720100 $ 67-320.00 $ 68,000 00 $ 68,680.00 $ 69.360.00 $ 70,040.00 Interest Exp 136 Raw Materials 45,120 00 5 49,400.00 $ 23,760.00 $ 58,200.00 $ 3.00%% Manufacturing Overhead 3,600.00 $ 3,708.00 $ 8.819.24 $ 3,983 02 $ 4,051.93 $ 4.173.39 4,298 39 $ 4,427.35 4 960.37 4,697-18 2532.39 3 2.686.62 3 2 830.23 $ 2.935.74 2,31720 $ 2 387.03 5 2 608.37 3 2767.22 $ Depreciation 306 Maintenance Expense 2,250 00 40%% Exhibit : Labor Expense 18,640 00 $ 20,233.30 $ 22.842.40 $ 25,254.60 $ 28,174.90 $ 30.808.50 $ 31,969 60 $ 53,089.50 $ 34 246.60 $ 35,445.20 7.800 Selling General and Admin 6,626 08 5 7,341.30 $ 8,087.12 5 8,798 40 $ 9.584.64 $ 10.34280 $ 10,534.96 5 10,707.12 5 10.979.28 $ 11,244.48 98,84545 $ 107,063.67 $ 115 33305 $ 1 117,509 77 $ 149,730.32 $ 121 596.49 $ 124,362 60 NPV Discount 7.755 Total Operating Expense 76,236 80 s 83,000.16 $ 90,845.79 $ EBITDA 8,723 12 $ 14,119.94 $ 12 194.22 $ 14,19459 5 15,816.33 17 266.53 $ 17 810 23 $ 48,309.62 3 18 763.52 $ 19,797.40 Depreciation 4,000.00 5 4,000.00 $ 4,000.00 5 4,000.00 $ 4,000.00 $ 4,000.00 5 4,000.00 $ 4,000.00 $ 4,000.00 5 4,000.00 4,723 12 5 7,118.84 $ 8.194.21 $ 10,134 35 $ 11,816.33 $ 13 266.95 $ 13,310 23 5 14,309.62 5 14 763.32 $ 15.797.40 EBIT 4,480.82 5 4,490 82 $ 1,480.82 4,480.82 5 4,480 82 Flat Interest Expense 4,480 82 5 4,480.82 $ 4,480.82 4,420.82 5 4,480.82 $ 11,316.98 ERT 242 50 5 2,639.02 $ 3.713.39 5 5.673 73 $ 7,335.51 $ 8 786.13 5 9.32941 $ 9.828.90 $ 10 282.70 $ 4.113.08 5 4.526 63 96.92 5 1,035.61 1 483.30 5 2,269 49 $ 2,934.21 $ 3.51445 5 3,731 77 $ 5,931.20 $ Net Profit 145 38 5 1,593.A 2.228.04 $ 3,404 24 $ 4,401.31 $ 5.271.69 5,597 63 $ 5.897.28 $ 6 169.62 $ 6,789.95 4,000.00 5 4,000.00 Flat Add Depreciation 4,000.00 5 4,000.00 $ 4,000.00 5 4,000.00 $ 4,000100 $ 4,000.00 5 4,000.00 4,000.00 $ Total Cash Fl -37,817.0 $ 4,145 38 5 3,583.41 $ 6.278.04 $ 7,404.24 $ 8,401.31 $ 9.271.69 5 9.597 60 $ 9,897.28 5 10 169.62 $ 10,789.93 NEV IFF Q:6 Given all the optional scenarios, what recommendations would you make to Tucker regarding the expansion? Show the impact of adopting your recommendations in calculations on the sheet- You may combine any of the previous changes into this recommendation, but must include some response to the labor dispute. The INFV and IRR should reflect all implemented options. The recommendation should be thoroughly explained in at least a full paragraph and state clearly your recommendation for what Hansson should do

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Science The Art Of Modeling With Spreadsheets

Authors: Stephen G. Powell, Kenneth R. Baker

3rd Edition

0470530677, 978-0470530672

More Books

Students also viewed these Finance questions