Please do this in excel and show work.
Also the numbers are in the millions.
Formulas:-
Please do this in excel and show work. Also the numbers are in the millions. =...
Elmdale Enterprises is deciding whether to expand its production facilities. Although long-term cash flows are difficult to estimate, management has projected the following cash flows for the first two years (in millions of dollars): Yoar 2 D 152.1 Revenues COGS and Operating Expenses (other than depreciation) Depreciation Increase in Net Working Capital Capital Expenditures Marginal Corporate Tax Rate Year 1 128.4 40.8 20.7 2.7 25.8 35% 55.9 25.3 8.8 39.6 35% a. What are the incremental earnings for this project...
Need help with this finance question. Both part a and b Elmdale Enterprises is deciding whether to expand its production facilities. Although long-term cash flows are difficult to estimate, management has projected the following cash flows for the first two years (in millions of dollars): 2 Year 1 124.3 45.7 29.5 2.4 26.8 35% Year 2 167.8 63.3 37.9 Revenues COGS and Operating Expenses (other than depreciation) Depreciation Increase in Net Working Capital Capital Expenditures Marginal Corporate Tax Rate 8.6...
Elmdale Enterprises is deciding whether to expand its production facilities. Although long-term cash flows are difficult to estimate, management has projected the following cash flows for the first two years (in millions of dollars): Year 1 118.1 46.9 28.7 Revenues COGS and Operating expenses (other than depreciation) Depreciation Increase in working capital Capital expenditures Corporate tax rate Year 2 156.8 50.9 38.2 8.7 40.8 20% 3.7 28.3 20% a. What are the incremental earnings for this project for years 1...
deciding whether to expand its production facilities. Although long-term cash flows are difficult to estimate, management has projected the following cash flows for the first two years (in millions of Elmdale Enterprises dollars) Year 1 Year 2 160.7 64.7 Revenues 111.8 COGS and Operating expenses (other than depreciation) Depreciation Increase in working capital Capital expenditures Corporate tax rate 43.7 28.3 33.3 5.1 8.5 34.1 44.2 20 % 20% a. What are the incremental eamings for this project for years 1...
Elmdale Enterprises is deciding whether to expand its production facilities. Although long-term cash flows are difficult to estimate, management has projected the following cash flows for the first two years (in millions of dollars): Year 1 Year 2 Revenues 112.3112.3 153.8153.8 COGS and Operating expenses (other than depreciation) 49.649.6 55.555.5 Depreciation 29.729.7 37.437.4 Increase in working capital 5.45.4 8.38.3 Capital expenditures 28.328.3 40.240.2 Corporate tax rate 20 %20% 20 %20% a. What are the incremental earnings for this project...
Question 2 You work for Apple. After toiling away on $10.7 million worth of prototypes, you have finally produced your answer to Google Glasses: iGlasses (the name alone is genius). iGlasses will instantly transport the wearer into the world as Apple wants him to experience it: iTunes with the blink of an eye and apps that can be activated just by looking at them. You think that these will sell for five years until the next big thing comes along...
Please show me the whole numbers also before rounding them so I can see thank you! NEW PROJECT ANALYSIS You must evaluate a proposal to buy a new milling machine. The base price is $197,000, and shipping and installation costs would add another $9,000. The machine falls into the MACRS 3-year class, and would be sold after 3 years for $118,200. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The machine would require a $4,000 increase in net...
You work for Apple. After toiling away on $10.2 million worth of prototypes, you have finally produced your answer to Google Glasses: Glasses (the name alone is genius). Glasses will instantly transport the wearer into the world as Apple wants him to experience it: iTunes with the wink of an eye and apps that can be activated just by looking at them. You think that these will sell for five years until the next big thing comes along (or until...
Stanley Industries is evaluating a proposal to expand its current distribution facilities. Management has projected that the project will produce the following additional cash flows for the first two years (in millions) Year Revenues Operating Expense 1200 1400 450525 240 280 Depreciation Increase in working capital 60 Capital expenditures Marginal corporate tax rate 30% 70 350 30% 300 Note 1: the incremental EBIT from the project refers to the additional (incremental) cash flows in each year as given in the...
PLEASE NOTE- there is also a Year 6 column that is not reflected in my screen shots (they were cut off). Please take Year 6 into account when providing guidance. Thank you At times firms will need to decide if they want to continue to use their current equipment or replace the equipment with newer equipment. The company will need to do replacement analysis to determine which option is the best financial decision for the company. Price Co. is considering...