(show the calculations by excel ) The Zone Company is evaluating a capital expenditure proposal that...

(show the calculations by excel )

The Zone Company is evaluating a capital expenditure proposal that requires an initial investment of $3,650,000. The machine will improve productivity and thereby increases net after-tax cash inflows by $825,000 per year for 7 years. It will have no salvage value. The company requires a minimum rate of return of 10 percent on this type of capital investment. Required:

(A) Determine the net present value (NPV) of the investment proposal.

(B) Determine the proposal's internal rate of return, rounded to the nearest tenth of a percent.

(C) What is the estimated payback period for the proposed investment, under the assumption that cash inflows occur evenly throughout the year? Round your answer to 2 decimal places.

(D) What is the present value payback period for the proposed investment? Round your answer to 2 decimal places.

(E) What is the estimated accounting rate of return (on initial investment) for the proposed project? Round your answer to 1 decimal place.

Expert Solution

ekkarill92 answered 2 years ago

. Beckett, Inc. is evaluating a capital expenditure proposal that requires an initial investment of $1,200,000...

. Beckett, Inc. is evaluating a capital expenditure proposal that requires an initial investment of $1,200,000 and has predicted pre-tax cash inflows of $200,000 per year for 10 years. The new equipment will have no salvage value, but will replace an old piece of equipment valued on the books at $150,000 that can sell for $120,000. Beckett pays a tax rate of 20%, and has a required rate of return of 12% (PV of single value factor for 10 years...

Regarding Capital Expenditure Decisions, how does a manager go about evaluating an investment proposal? (from Ch...

Regarding Capital Expenditure Decisions, how does a manager go about evaluating an investment proposal? (from Ch 16 of Managerial Accounting: Creating Value in a Dynamic Business Environment (10th Edition)

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...

Chapter 3 P1: Stephen Company is evaluating a capital investment proposal for new office equipment for...

Chapter 3 P1: Stephen Company is evaluating a capital investment proposal for new office equipment for the current year. The initial investment would require the company to spend $50,000. The equipment would be depreciated on a straight line basis over five years with no salvage value. The company has estimated the before-tax annual cash inflow from the investment to be $15,000. The income tax rate is 40% and all taxes are paid in the year that the related cash flows...

NPV and IRR: Equal Annual Net Cash Inflows Apache Junction Company is evaluating a capital expenditure...

NPV and IRR: Equal Annual Net Cash Inflows Apache Junction Company is evaluating a capital expenditure proposal that requires an initial investment of $44,190, has predicted cash inflows of $9,000 per year for 13 years, and has no salvage value. (a) Using a discount rate of 16 percent, determine the net present value of the investment proposal. (Round to the nearest whole number.) $Answer (b) Determine the proposal's internal rate of return. Answer % (c) What discount rate would produce...

Create an Excel file to show the budgets and calculations for the questions below. Assume no...

Create an Excel file to show the budgets and calculations for the questions below. Assume no beginning or ending inventory. Ignore taxes. Analysis or explanations can be included in the Excel cells or in a textbox. Use contribution margin income statement formatting. HammerTime is preparing their 2019 budget. They want to look at static budgets and flexible budgets to determine which is best for them. They estimate sales/production will be between 2,000,000 and 4,000,000 boxes of nails per month. They...

Please show all calculations in MS Excel. No credit will be earned unless you show your...

Please show all calculations in MS Excel. No credit will be earned unless you show your calculations. Problem 1: CAPM: 5-Points: If the risk-free rate is 0.0200, the return of the market is 0.1350, and the beta is 1.18, what is the required rate of return of the stock using the CAPM equation? Please note that the return of the market is not the same as the market risk premium. Problem 2: Growth Rate: (Equation 9.11, page 373): 5-Points: If...

For Hershey Company (HSY) Two excel WACC (weighted average cost of capital) calculations, one using the...

For Hershey Company (HSY) Two excel WACC (weighted average cost of capital) calculations, one using the Cost of Equity from the SML (aka CAPM) Approach and another WACC calculation using the Dividend Growth Model Approach for Cost of Equity. Include a discussion explaining which Approach you prefer for WACC and why

Dickerson Co. is evaluating a project requiring a capital expenditure of $810,000. The project has an...

Dickerson Co. is evaluating a project requiring a capital expenditure of $810,000. The project has an estimated life of 4 years and no salvage value. The estimated net income and net cash flow from the project are as follows: Year Net Income Net Cash Flow 1 $75,000 $280,000 2 100,000 300,000 3 109,000 200,000 4 36,000 120,000 $320,000 $900,000 The company's minimum desired rate of return is 12%. The present value of $1 at compound interest of 12% for 1,...

Calculations must be done in Excel - Using the capital budgeting method of; Tax Effects, then...

Calculations must be done in Excel - Using the capital budgeting method of; Tax Effects, then Cash flows, then NPV. As the financial advisor to All Star Manufacturing you are evaluating the following new investment in a manufacturing project: - The project has a useful life of 12 years. Land costs $6m and is estimated to have a resale value of $10m at the completion of the project. Buildings cost $5m, with allowable depreciation of 10% pa reducing balance and...

Question