Question

In: Finance

Perform an incremental analysis of the two finalist projects using the data provided below. The company...

Perform an incremental analysis of the two finalist projects using the data provided below.

The company uses a MARR of 10% and depreciates its assets using 7-year MACRS. The company’s effective income tax rate is 25%.

Project 1: Milling machines Equipment cost: Two (2) machines that each cost $380,000 including trade-in allowance and sales tax. The total cost of the freight and handling is expected to be $25,000. The total cost to install the machines is $30,000. Total testing and startup costs to place the machines into service are estimated to be $32,000. Useful life: 8 years. It is estimated that the machines can be sold for a total of $105,000 at the end of the project.

Each machine requires one operator at a time at a rate of $32.00 per hour. The plant operates 4080 hours per year. Total maintenance labor costs are estimated to be 20% of operating hours at $22.00 per hour. Total annual direct materials are estimated at $290,000. Manufacturing overhead exclusive of depreciation is expected to be an additional $270,000 per year.

Revenues are expected to be $1,025,000 each year as a result of this project. The project would run for 8 years.

Project 2: Painting Line Equipment cost: $315,000 including trade-in allowance and sales tax. The total cost for freight and handling is expected to be $15,000. The total cost to install the line is $35,000. Testing and startup costs to place the line in service are estimated to be $24,000. Useful life: 8 years. It is estimated that the line can be sold for a total of $70,000 at the end of the project.

The line requires one operator at a time a rate of $30.00 per hour and one helper at a time at a rate of $19.75 per hour. The plant operates 4080 hours per year. Total annual direct materials are estimated at $150,000. Maintenance labor costs are estimated to be 20% of operating hours at $19.00 per hour. Manufacturing overhead exclusive of depreciation is expected to be $220,000 per year.

Revenues are expected to be $635,000 for the first year as a result of the project and are expected to increase by 2% each year throughout the project. The project would run for 8 years.

Solutions

Expert Solution

I have calculated the Present value of Cash Flow from both the project.

Project 2 has positive NPV and Project 1 has negative NPV. Please see the attached table for detail. As answer is long so I has to put image of of answer.


Related Solutions

Multivariate analysis Using the data provided, perform the following analysis: Determine the explanatory and response variables....
Multivariate analysis Using the data provided, perform the following analysis: Determine the explanatory and response variables. Run a multivariate regression analysis on all three variables. Interpret the results by answering the following questions: What is the calculated correlation coefficient? Do the sales figures correlate with the marketing expenditure and price? Comment on the coefficient of determination. What percentage of the response data can be explained by the explanatory variables? Determine the multiple regression line equation in the form: sales^ =...
Using the data provided, perform the steps below to complete the final project. On December 1,...
Using the data provided, perform the steps below to complete the final project. On December 1, 2019, SoccerBox Inc. started operations. The following transactions occurred during December 2019. NOTE: There are no beginning balances-this is a new company. Dec 1 Randol Espy invested $80,000 cash in the company for common stock. 2 SoccerBox purchased soccer equipment for $20,000 cash. 2 SoccerBox rented an old warehouse for $30,000 cash for the first year's (December 2019-November 2020) rent. 3 SoccerBox purchased $500...
Perform a scenario analysis with data provided Assume that your selected company is considering a potential...
Perform a scenario analysis with data provided Assume that your selected company is considering a potential project with a new product that is expected to sell for an average price of $30 per unit and the company expects it can sell 350,000 units per year at this price for a period of 4 years. Launching this project will require purchase of a $3,500,000 equipment that has residual value in four years of $500,000 and adding $ 1,000,000 in working capital...
Consider the following three alternatives. Using incremental IRR analysis, determine which of these projects is the...
Consider the following three alternatives. Using incremental IRR analysis, determine which of these projects is the most desirable. Your MARR is 11%. Each of these projects (A&B) will last for eight years. (2 points) Do nothing A B Capital investment $0 $100 $130 Annual revenues $0 $150 $130.78 Annual costs $0 $123.62 $92
Part 3: Risk analysis and project evaluation 3.1 Perform a scenario analysis on the data provided...
Part 3: Risk analysis and project evaluation 3.1 Perform a scenario analysis on the data provided Case Study: Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product that is expected to sell for an average price of $22 per unit and the company expects it can sell 650 000 unit per year at this price for a period of 4 years. Launching this project will require...
Question #11 – Regression Analysis Use the data provided to: Perform the “Tests to Check the...
Question #11 – Regression Analysis Use the data provided to: Perform the “Tests to Check the Validity of a Regression” Show both the calculated and critical values Estimate Y when X = 4 (round to 2 decimal places) Use a level of significance of 5% (α = .05). Clearly show the null and alternate hypothesis. Graphs are not required. X Y 3 14 7 26 6 23 4 17 7 28 5 20 8 29 2 11
Using the data below, perform a two-way ANOVA. Test the hypothesis of interaction at the 1%...
Using the data below, perform a two-way ANOVA. Test the hypothesis of interaction at the 1% level of significance. Also, use a 1% level of significance to test the null hypotheses of equal column and equal row means. Factor Level 1 Level 2 Level A 14 16 18 12 16 16 Level B 10 12 16 12 12 14
Company A and Company B are competitors. Using the data provided below, explain which stock is...
Company A and Company B are competitors. Using the data provided below, explain which stock is more attractively valued. Show your calculations to earn full credit. Data Company A Company B Stock price ($) 323.22 89.07 Share outstanding 567,885,369 776,367,881 Earnings per share ($, last year) 12.04 3.71 Earnings per share ($, forward estimate) 18.12 5.58 EBITDA ($billion, last year) 12.4 6.55 EBITDA ($billion, forward estimate) 15.8 8.79 Total debt ($billion) 11.88 11.14 Minority interest ($billion) 0.08 0.00 Cash &...
•Calculate the variance analysis for the information provided below using this problem and the formula provided...
•Calculate the variance analysis for the information provided below using this problem and the formula provided to you. Data: Budget Actual Variance Total Payroll Cost $65,600.00 $78,627.50 $13,027.50 Total Nursing Hours 1600 1850 250 Composite Hourly Pay Rate $30.00 $33.00 $3.00 Patient Days 350 375 25 Formulas to use in calculations for variance analysis: Step #1: Compute the Efficiency Variance. Budgeted nursing hours   / Budgeted patient days = HPPD Budgeted Actual nursing hours / Actual patient days = HPPD Actual...
Overview Respond to the discussion topic below with one or two paragraphs. Consider incremental analysis as...
Overview Respond to the discussion topic below with one or two paragraphs. Consider incremental analysis as one of several possible approaches to decision making. Discussion Requirements Post comments and explain, with examples, how decision making and analysis, with the tools from our course, may be of value to you and your future endeavors. Include specific examples such as a company seeking to increase profits would.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT