ATTENTION BEFORE TAKING THE QUESTION READ!! I have posted a finance case that requires deeply finance skills so,I encourage you taking a deep look at the case before accepting it !! It need deeply excel calculations and critical thinking please don't take it unless you are sure from your skills, I am gonna claim my money back for any miss calculation or work that i am not happy with. I am paying 45 dollars to get good work remember. Required things are: calculations that have to be done on excel sheet number 1 and the short memo

Case: You are a team of financial analysts of the Gadget Division of The FGM Corporation, the largest multinational a production of a new voice-activated electronic device - Universal Direction Assistance (UDA). This upgradeabl directions and real time traffic reports that guide automobile drivers in choosing the preferred route to their d geographical information and real time traffic report (where technology is available) that are translated into th comprehensive market analysis on the potential demand for this device was conducted last year at a cost of $ According to the results of the market analysis, the expected annual sale volumes of UDA are 1.8M units for th expected to be $600 for the first two years, and then fall to $450, due to the introduction of similar devices by growth rate for unit production costs are expected to be 4% per year over the remaining life of the project . In addition, the implementation of the project demands current assets to be set at 12% of the annual sale re UDA will increase the sales volume of cars and trucks that leads to an increase in the annual after-tax cash flow The production line for UDA will be set up in a vacant plant that was built by FGM at a cost of $30M twenty ye termination of this project for $12M in four years. The machinery for producing UDA has an invoice price of $1 classified in the MACR 3-year class for depreciation purpose. The 5 machinery is expected to have zero salvage be 15%. The estimated marginal tax rate of The FGM Corporation is 30%. I need the answer for the following question after performing the calcu Question: Write a short memo to the Director of the Gadget Division, Mr. Ben Black, to present your tea Be sure to address the following questions on your memo. 1. In light of the appropriate objective of a firm, what would you recommend on the UDA Project basing on th 2. Would your recommendation be changed if the unit price of the UDA only falls to $550 upon the entrance o price falls to $350 after two years? Why? 3. What would be your recommendation on this UDA Project if there is 75% chance that the base scenario (i.e only falls to $550 after two years) will occur, and 5% chance that the pessimistic scenario (i.e., unit price falls t e largest multinational automobile manufacturer in the world. You are asked to evaluate a project proposal regarding the (UDA). This upgradeable device, which incorporates the most advanced computer and satellite wireless technology, provide referred route to their destinations. This device can be used in any country with specialized software that contains local hat are translated into the chosen language of the driver. UDA will be sold as an option for the FGM cars and trucks. A d last year at a cost of $10M. DA are 1.8M units for the first two years, and drop to 1.5M units for the final two years of this 4-year project. Unit prices are on of similar devices by competitors, afterwards. Unit production costs are estimated at $500 in the first year of the project ng life of the project 2% of the annual sale revenues, and current liabilities to be set at 8% of the annual production costs. Besides, the introductio nnual after-tax cash flow of FGM by $21M. cost of $30M twenty years ago. This fully depreciated plant has a current market value of $20M, and is expected to be sold as an invoice price of $120M, and its modification costs another $15M. The machinery has an economic life of 4 years, and ted to have zero salvage value at the termination of the project. The cost of capital (or discount rate) for this project is assum rming the calculations on excel on sheet number 2 ack, to present your team's analysis and conclusions. UDA Project basing on the (base) scenario described above? Why? 550 upon the entrance of competitive products after two years into this project? What would be your recommendation if th at the base scenario (i.e., unit price falls to $450 after two years) will occur, 20% chance that the optimistic scenario (i.e., un rio (i.e., unit price falls to $350 after two years) will occur? Why? oposal regarding the ess technology, provides that contains local ars and trucks. A r project. Unit prices are first year of the project. The Besides, the introduction of d is expected to be sold at the mic life of 4 years, and is for this project is assumed to r recommendation if the unit mistic scenario (i.e., unit price Gadget Division - UDA Proposal Machinery Costs ($) $ 120,000,000 Modification Costs ($) $ 15,000,000 Plant & Properties Opportunity Costs ($) $ 20,000,000 Salvage Value - Plant ($) $ 12,000,000 Salvage Value - Machinery ($) 0 Cost of Capital (%) 15% Tax Rate (%) 30% Positive side effect Operating Cash Flow ($) $ Probability 21,000,000 NPV 75% 20% 5% Base Scenario Optimistic Scenario Pessimistic Scenario BASE SCENARIO (Most Common Approach for OCF) Initial Cash outflow ($) $ 149,000,000 YEAR 1 Annual Sales Volume (units) 1,800,000 Unit Price ($) $ 600.00 Unit Production Costs ($) $ 500.00 Incremental Revenues ($) Incremental Costs ($) Depreciation ($) EBIT ($) Taxes ($) INCREMENTAL OPERATING CASH FLOWS, OCF ($) POSITIVE SIDE EFFECT OPERATING CASH FLOW ($) Net Working Capital ($) $ - CHANGE in NET WORKING CAPITAL ($) TERMINAL CASH FLOW ($) INCREMENTAL CASH FLOW TO PROJECT $ NET PRESENT VALUE, NPV ($) (149,000,000) OPTIMISTIC SCENARIO (Most Common Approach for OCF) Initial Cash outflow ($) YEAR 1 Annual Sales Volume (units) Unit Price ($) Unit Production Costs ($) Incremental Revenues ($) Incremental Costs ($) Depreciation ($) EBIT ($) Taxes ($) INCREMENTAL OPERATING CASH FLOWS, OCF ($) POSITIVE SIDE EFFECT OPERATING CASH FLOW ($) Net Working Capital ($) $ - INCREMENTAL CASH FLOW TO PROJECT $ - CHANGE in NET WORKING CAPITAL ($) TERMINAL CASH FLOW ($) NET PRESENT VALUE, NPV ($) $0.00 PESSIMISTIC SCENARIO (Most Common Approach for OCF) Initial Cash outflow ($) YEAR 1 Annual Sales Volume (units) Unit Price ($) Unit Production Costs ($) Incremental Revenues ($) Incremental Costs ($) Depreciation ($) EBIT ($) Taxes ($) INCREMENTAL OPERATING CASH FLOWS, OCF ($) POSITIVE SIDE EFFECT OPERATING CASH FLOW ($) Net Working Capital ($) CHANGE in NET WORKING CAPITAL ($) $ - TERMINAL CASH FLOW ($) INCREMENTAL CASH FLOW TO PROJECT $ NET PRESENT VALUE, NPV ($) - Depreciation Depreciation Book Rate Expenses ($) Value ($) 33.33% $ 44,995,500 $ 90,004,500 44.45% $ 60,007,500 $ 29,997,000 14.81% $ 19,993,500 $ 10,003,500 7.41% $ 10,003,500 0 Depreciable Costs $ 135,000,000 Expected NPV YEAR 2 YEAR 3 1,800,000 YEAR 4 1,500,000 1,500,000 $ 600.00 $ 450.00 $ 450.00 $ 520.00 $ 540.80 $ 562.43 YEAR 2 YEAR 3 YEAR 4 YEAR 2 YEAR 3 YEAR 4