Dimovelis Foivos Prokopios - Excel (Product Activation Failed) F Sign in Share Comma 23 Conditional Formal as Bad Formatting Table" Normal 22 Good Normal Neutral Insert Delete Formal AutoSum Fill- Clear- T P Sort & Find & Filter Select Number Styles Cells Editing File Home Insert Page Layout Formulas Data Review View Tell me what you want to do... Cut Calibri 11 - A A Wrap Text General Copy Paste BIU- = = = ** Merge & Center -% Formal Painter Clipboard Font Alignment A23 A B C E F G H 1 Andrea Inc. decides to get into the business of producing tables for 2 offices. To do that they need to buy a machine that cuts and laminates 3 the wood. The units of tables to be sold if this project is undertaken is 4 5 Units to be sold 6 Year 1 1.000 Year 2 Year 3 Year 4 Year 5 1.200 1.300 1.100 900 Year 6 800 J K L M N 7 They have two choices of machines, Machine A costs $50,000 and Machine B costs $62,000. Machine B creates a better looking product using the same materials 8 Both machines have a useful life of 6 years. Machine A's salvage value is $5,000 and Machine's B salvage value is $6,000. 9 The price of the tables if they choose Machine A will be $74 and if they choose Machine B it will be $80. All sales are done in cash 10 Costs related to these sales are $60 per table (no matter which machine). These costs are paid in cash 11 In both cases the working capital needed is $8000. And it is released at the end of 6 years. 12 Both machines are depreciated using the straight-line method and the company pays 10% tax on its net income. 13 The discount rate is 14%. 14 Required: 15 a. Construct the cash flow time-line. What is the net present value of each project? In which one they should invest? 16 b. What is the net present value of each project? In which one they should invest? 17 c. What is the Internal Rate of Return of each project? In which one they invest according to IRR? 18 d. Calculate the Payback Period of this investment to the nearest month. In which one they should invest according to this method? 19 e. In which Machine should they invest considering all methods, express your opinion. 20 f. Discuss the advantages and disadvantages of each of the 3 methods above. Points 32 12 11 13 7 15 21 Problem 1 | Problem 2 Problem 3 Ready 537 X 19C. . EL 11/5/2022 + 140%