Question: Construct an Excel spreadsheet to answer the questions in Problem 8-39 as given below: 8-39 Calculating NPV and IRR Using Excel. Mountain Hardware would like

Construct an Excel spreadsheet to answer the questions in Problem 8-39 as given below: 8-39

Calculating NPV and IRR Using Excel. Mountain Hardware would like to expand into a new warehouse at a cost of $500,000. The warehouse is expected to have a life of 20 years, and a salvage value of $100,000. Annual costs for maintenance, insurance, and other cash expenses will total $60,000. Annual net cash receipts resulting from this expansion are predicted to be $115,000. The company's required rate of return is 12 percent Required:

a. Use Excel to calculate the net present value and internal rate of return in a format similar to the Computer Application spreadsheet shown in the chapter.

b. Should the company purchase the warehouse? Explain.

Step by Step Solution

★★★★★

3.46 Rating (149 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a NPV 78740 Calculation of IRR NPV at 12 78740 NPV at ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Use a financial calculator or an Excel spreadsheet to estimate the yield each of the following investments. Initial Future End of Investment nvestment ( Value ()Year 1,000 10,000 400 3,000 5,500...

Use a financial calculator or an Excel spreadsheet to estimate the yield for each of the following investments. Investment Initial Investment $8,500 $9,500 Endof Year Income ($) 2,500 2,500 2,500...

Use the table below to answer the questions that follow: a. If this table reflects the supply of and demands for tickets to a particular World Cup soccer game, what is the stadium capacity? b. If the...

3. Construct an Excel spreadsheet to answer the questions in Problem 8-39 as given below: 8-39 Calculating NPV and IRR Using Excel. Mountain Hardware would like to expand into a new warehouse at a...

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

Hi, I need help with the attached Excel spreadsheet. There are multiple questions across the different tabs. Please do not claim this unless you have read the questions and you are positive you can...

ATC 14-1 (Pg. 686) 1.(Follow the cash) In a narrative format, answer the questions posed in the case. 2.What is meant by "presentation of financial statement information in common-size amounts rather...

35. Net Present Value Analysis. Wood Products Company would like to purchase a computerized wood lathe for $100,000. The machine is expected to have a life of 5 years, and a salvage value of $5,000....

The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy generating firm, who needs to present his recommendation to the company Board regarding a proposed investment in a new...

Stocks and Bitcoin historically have a ____ correlation in the long term. A. positive B. negative This makes Stocks and Bitcoin _____ investments to include in a portfolio. A. poor B. good

Differentiate 3sin(9x+2x)

Compute the derivative f(x)=(x-a)(x-b)

The following fact pattern applies to questions 1 and 2. Brigid entered into a contract with L. Marcus Marine ("LMM") to perform repairs and updates to her sailboat for $15,000. The work was to be...

An SLA manager compares the usage of a system against: Question 1Select one: a. A pay-per-use measurement repository b. An SLA monitor agent c. A quality-of-service measurement repository d. A...

On November 1, 2015, Archangle Services issues $200,000 of 10 year bonds with a stated rate of 3% The bonds were solid at discount for $191,000 and make semiannual payments on August 31 and October...

Hardin Services Co. experienced the following events in 2016: 1. Provided services on account. 2. Collected cash for accounts receivable. 3. Attempted to collect an account and, when unsuccessful,...

Table 3.5 presents a computer spreadsheet for estimating R&E Sup-plies external financing required for 2015. The text mentions that with modifications to the equations for equity and net sales, the...

Your firm is considering the acquisition of a very promising technology company. One executive argues against the move, pointing out that because the technology company is presently losing money, the...

Suppose in Figure 5.3 that the stock prices of target firms in acquisitions responded to acquisition announcements over a three-day period rather than almost instantly. a. Would you describe such an...

We wish to time installing new shingles on our house. To start* we will try to time driving one nail into a shingle. Assume that the shingle is already in place. You have squatted on your roof facing...

What are Voronoi polygons and when should they be used?

A worker-machine operation was found to involve 3.3 minutes of machine time per cycle. In the course of 40 cycles of a stopwatch time study, the workers time loading and unloading the machine...