The chosen company is Microsoft.
Discount rate used 10%.
Your chosen company is looking to make a ten-year capital investment based on the following information: - The initial R\&D will be 3% of their average Total Liabilities over the last five years, split between Current Ye and Year 2 - To clarify: (Average Total Liabilities over the last 5 years) *.03, divided by 3 - Estimated Sales start in Year 3. Years 3 through 6 are equal to 5% of the Net Revenue in 2021. It then decreases by 15% in year 7 , and 5% in year 10 . Years 8 and 9 are equal to year 7. - Increase in Cost of Goods Sold is equal to 20% of Estimated Sales - Increase in General and Administrative expense of is equal to 10% of Cost of Goods Sold - Depreciation will be $5 millions annually, starting in Year 2 Part 1: Based on this information, create and analyze the project timeline which will include calculating Gross Revenue, Operating Income, EBIT, Income Tax (use 2021's percentage), and Net Income. Calculate the NPV, IRR, Payback Period, and Return on Investment for the project. Your chosen company is looking to make a ten-year capital investment based on the following information: - The initial R\&D will be 3% of their average Total Liabilities over the last five years, split between Current Ye and Year 2 - To clarify: (Average Total Liabilities over the last 5 years) *.03, divided by 3 - Estimated Sales start in Year 3. Years 3 through 6 are equal to 5% of the Net Revenue in 2021. It then decreases by 15% in year 7 , and 5% in year 10 . Years 8 and 9 are equal to year 7. - Increase in Cost of Goods Sold is equal to 20% of Estimated Sales - Increase in General and Administrative expense of is equal to 10% of Cost of Goods Sold - Depreciation will be $5 millions annually, starting in Year 2 Part 1: Based on this information, create and analyze the project timeline which will include calculating Gross Revenue, Operating Income, EBIT, Income Tax (use 2021's percentage), and Net Income. Calculate the NPV, IRR, Payback Period, and Return on Investment for the project