Gulf United is an IT Solutions firm based in Silicon Valley, USA. The company want to improve their IT solution business by improving their bigdata and supercomputers. In doing so, the company can be ether upgrade the original version or replace with new version. Gulf United will acquire bigdata and supercomputers by using the most efficient way. Gulf United is in the 40% tax bracket and cost of capital of 10% The conditions of the upgrade the original version or replace with the new version for bigdata facilities and supercomputers are as follows: Vopred the original version: Initial cost of old big data $ 150,000 Annual depreciation of $15.000 The old big data facilities were purchased 5 years ago The current book value of old bigdata $ 75,000 The salvage value of old bigdata (toduyl S 95.000 The salvage value in 5 years $ 20,000 Replace with the new version: Initial cost of new bigdata = $250,000 Its anticipated to have 5 years life The salvage value in 5 years = 50 Cost savings per year = $ 75,000 per year The company will use 3-years MACRS depreciation TABLE: MARSH Answer the following questions (Note: kindly show All the necessary steps/calculations. LESS mark will be given if you falled to show the step/calculations Page 7 of 9 a Calculate the depreciation expense for new bigdata (1-Yr 5) using MACRS method [2 marks) . Calculate the projected net income (Y.1-W.5)2 marks] Find the after tax salvage value of old big data in Yr. (1 mark) d. Calculate incremental net capital spending in Yo (1 mark) Find the after tax salvage value of old big data in W. (1 mark) t Calculate the operating cash flows (OCF) from Yr 1-Yr 52 marks) Calculate the total cash flow for cash flow from assets CFFA) from YO-Y512 marks) Calculate the NPV and I you may we financial calculator) (2 marks] What is your advice to Gulf United? Should they replace bigdata with the new version? (1 mark) Explain the concept of incremental cash flows and stand-alone principle! (2 marks] Gulf United is an IT solutions firm based in Silicon Valley, USA. The company want to improve their IT solution business by improving their bigdata and supercomputers. In doing so, the company can be either upgrade the original version or replace with new version. Gulf United will acquire bigdata and supercomputers by using the most efficient way. Gulf United is in the 40% tax bracket and cost of capital of 10%. The conditions of the upgrade the original version or replace with the new version for bigdata facilities and supercomputers are as follows: Upgrade the original version: Initial cost of old big data = $ 150,000 Annual depreciation of $ 15,000 The old big data facilities were purchased 5 years ago The current book value of old bigdata = $ 75,000 The salvage value of old bigdata (today) = $ 95,000 The salvage value in 5 years = $ 20,000 Replace with the new version: Initial cost of new bigdata = $ 250,000 Its anticipated to have 5 years life The salvage value in 5 years = $0 Cost savings per year = $ 75,000 per year The company will use 3-years MACRS depreciation. TABLE 1 MACRS Hall Your Convention Depreciation Rate for Recovery Period Year 1 2 3 4 5 . 3 Year 333 44.45 14.81 741 5 Year 20.00 3200 19.20 SOON 10 V TODON 1800 14.40 20 M 7504 7219 667) 2449 17.40 1240 8.99 19 11.5 922 737 655 62 50 590 591 50 591 590 522 4200 11 5461 5.90 15 16 17 8889 21 2231 Answer the following questions (Note: kindly show ALL the necessary steps/calculations. LESS mark will be given if you failed to show the steps/calculations) a. Calculate the depreciation expense for new bigdata (Yr.1 - Yr.5) using MACRS method (2 marks) b. Calculate the projected net income (Yr.1 - Yr.5) (2 marks) C. Find the after-tax salvage value of old big data in Yr. (1 mark) d. Calculate incremental net capital spending in Yr.0 (1 mark) e. Find the after-tax salvage value of old big data in Yr.5 (1 mark) f. Calculate the operating cash flows (OCF) from Yr.1 - Yr.5 (2 marks) 8. Calculate the total cash flow (or cash flow from assets CFFA) from Yr.O - Yr.5 (2 marks) h. Calculate the NPV and IRR (you may use financial calculator) (2 marks) i. What is your advice to Gulf United? Should they replace bigdata with the new version? (1 mark) j. Explain the concept of incremental cash flows and stand-alone principle! (2 marks)
