Question

In: Accounting

Pleas use Excel®—showing all work and formulas (attach excel sheet please) Dwight Donovan, the president of...

Pleas use Excel®—showing all work and formulas (attach excel sheet please)

Dwight Donovan, the president of Donovan Enterprises is considering two investment opportunities. Because of limited resources he will be able to only invest in one of them. Project A is to purchase a machine that will enable factory automation; the machine is expected to have a useful life of four years and no salvage value. Project B supports a training program that will improve the skills of employees operating the current equipment. Initial cash expenditures for Project A are $400,000 and for Project B are $160,000. The annual expected cash inflows are $126,000 for Project A and $52,800 for Project B. Both investments are expected to provide cash flow benefits for the next four years. Donovan Enterprise desired rate of return is 8 percent.

Required A) Compute the net present value of each project. Which project should be adopted based on the net present value approach?

B) Compute the approximate internal rate of return of each project. Which one should be adopted based on the internal rate of return approach? Round your rates to six decimal points.

C)Compare the net present value approach with the internal rate of return approach.Which method is better in the given circumstances? Why?

Solutions

Expert Solution

a) Net Present value

The net present value of Project A is more than that of Project B hence Project A should be adopted

b) Internal rate of return

IRR calculated using excel

The formula for calculating IRR in excel is =IRR(cash flows) i.e.Year 0 to year 4

IRR calculated using alternative method

Internal rare of return is the discounting rate at which NPV is zero

Steps for calculating IRR under this method

a) Find the discounted cash inflows at any two rates (one rate should give values that are greater than the cash outflow and the another rate should give values that are lower than the cash outflow at year 0)

b) Use the formula

Discount rate that gives value greater than the cash outflow (i.e. 9% for A and 12% for B)

+

[ Discounted value of that point (i.e. 9% for A and 12% for B) - Cash outflows

/

Discounted value of that point (i.e. 9% for A and 12% for B) - discounted value of other point (i.e.10% fro A and 13% fro B) ]

As per IRR approach Project B should be selected, since the rate is higher than that of A

c) Comparison

Under the IRR method project B is beneficial to undertake whereas as per the NPV method project A is beneficial.

Project B would be more beneficial to undertake since there are only marginal differences between the other project with regard to NPV and at the same time this requires a substantially lesser investment than that of Project A

Since the discount rate used for NPV calculations are only estimates and the IRR method also doesn't take into account changing factors, everything depends on the management's decision of how much to invest and their appetite for risk taking.


Related Solutions

Please use excel and show all work and formulas. (I will give your work a like...
Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...
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...
Use Excel to complete the following question. You must submit/attach all work done in Excel in...
Use Excel to complete the following question. You must submit/attach all work done in Excel in order to receive full credit. 5. A health advocacy group conducted a study to determine if the nicotine content of a particular brand of cigarettes was equal to the advertised amount. The cigarette brand advertised that the average nicotine content per cigarette was 1.4 milligrams. The advocacy group randomly sampled 24 cigarettes. The nicotine level for each of the sampled cigarettes is given below....
***Excel is required to solve this problem. Please use excel and show all formulas used in...
***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any math done with formulas within cells. The Jackpots Dreams Cards Company is a card manufacturer. All direct materials and conversion costs are applied to all of Proball Trading Cards’ products at an even rate throughout the manufacturing process. For August, the beginning work in process inventory for the Finishing Department was 9,600 units that averaged 65 percent complete. Ending work in process inventory was...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any...
PLEASE UPLOAD EXCEL FILE OR A SCREENSHOT SHOWING FORMULAS Must be submitted in excel with any math done with formulas within cells. Electric Car Co (ECC). currently manufactures two different types of fully electronic cars in 2021. Type 8Y is a large SUV whereas Type 8W will be the fastest car in the world with 10 rocket thrusters. ECC has decided to use ABC costing instead of traditional costing. The 2021 budget to manufacture these new types include manufacturing overhead...
Please answer the following by hand showing all arithmatic and original formulas, please do not use...
Please answer the following by hand showing all arithmatic and original formulas, please do not use a graphic calculator. The province of Ontario is planning to construct a new hydropower plant to help make energy prices more affordable, as well as to support improved public health and environmental quality. The construction of the hydropower plant will start by the beginning of 2023 and will take 3 years at a cost of $200 million per year. The cost of maintenance and...
Please post answers in excel showing all formulas used. Refer to the gasoline sales time series...
Please post answers in excel showing all formulas used. Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 18 2 21 3 19 4 22 5 18 6 16 7 20 8 19 9 23 10 19 11 16 12 22 Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Week Sales 4-Week Moving Average 5-Week Moving Average 1 18 2 21 3...
PLEASE SHOW ALL WORK IN EXCEL. Use Bilingual sheet to answer this question. A national survey...
PLEASE SHOW ALL WORK IN EXCEL. Use Bilingual sheet to answer this question. A national survey of companies included a question that asked whether the company had at least one bilingual telephone operator. The sample results of 90 companies follow (Y denotes that the company does have at least one bilingual operator; N denotes that it does not). N N N N Y N Y N N Y N N N Y Y N N N N N Y N...
Please complete in Excel document with correct formulas and attach. Cost Classification: The Lee’s have provided...
Please complete in Excel document with correct formulas and attach. Cost Classification: The Lee’s have provided you with the following costs and relevant information that are assumed for year 20XY. A. Classify each of the costs (a. through j.) below under C. as a variable cost or a fixed cost. B. Explain the importance of distinguishing between variable and fixed costs. C. Prepare a budgeted income statement, assuming 600 units to be produced and sold, a per unit selling price...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT