Question

In: Finance

Problem 3 – Capital Budgeting This is where an MS Excel model might come in handy....

Problem 3 – Capital Budgeting

This is where an MS Excel model might come in handy.

Remember to use a very clear title and heading including your name on the page if you submit a separate MS Excel file. Follow the format I used in the examples that I sent out in the capital budgeting teaching notes document.


Mumford Company is planning an upgrade to its warehouse. The upgrade involves computerizing many of the material handling activities. The cost of the upgrade is expected to be $2,800,000. The equipment falls into the 7 year IRS depreciation category (straight line method full year depreciation every year) and is expected to provide annual cash cost (primarily labor related) savings totaling $750,000 for each year over the next 8 years. Mumford is in the 30% tax bracket and has decided to use a 12% hurdle rate, as a first pass, to calculate the Net Present Value and begin to examine the financial viability of the proposed project. At the end of years 3 and 6 a software upgrade costing $50,000 (each year) will be made. These expenditures are fully tax deductible in the years paid. Years 3 and 6.

1. Prepare a well organized schedule that concludes with the calculation of the expected NPV from this project. Be sure that your schedule is well organized.
2. Is the Internal Rate of Return on the Project more or less than the 12% Hurdle Rate?

Solutions

Expert Solution

1. NPV at the hurdle rate of 12%= $313,017.26

2. IRR= 15.19% which is more than the 12% hurdle rate.

Schedule of ca;lculation of NPV and IRR as follows:


Related Solutions

Capital Budgeting Problem: Fatbiking (Excel Project) A Nordic ski area is considering purchase of 5 Fatbikes...
Capital Budgeting Problem: Fatbiking (Excel Project) A Nordic ski area is considering purchase of 5 Fatbikes to diversify its winter offerings given the variable snow conditions in the Northeast. Consider the following: 1. The life of the project is 5 years since the ski area’s land lease ends in 5 years. 2. The cost of the Fatbikes is $1,500 per bike. It will cost an additional $100 per bike to repaint with colors and logo of the Nordic area. 3....
Consider the following expansion capital budgeting problem. A capital budgeting decision is being considered that would...
Consider the following expansion capital budgeting problem. A capital budgeting decision is being considered that would involve an expansion and simultaneous replacement of old equipment. The project is expected to have a 6 year life for the firm. This project will replace some existing equipment which currently has a book value (BV) of $200k and an estimated market salvage value of $375k. The new project will require new equipment costing $2000k, which will be depreciated straight-line to a book value...
How might the capital budgeting activities of a nonprofit organization be different from the capital spending...
How might the capital budgeting activities of a nonprofit organization be different from the capital spending decisions of a company?
Using the goal seeking feature in Ms excel demonstrate a scenario where an employee earns a...
Using the goal seeking feature in Ms excel demonstrate a scenario where an employee earns a basic salary of 50000 KSH. The overtime payrate per hour is 2500 KSH. The total overtime amount =hours worked x payrate per hour. The total gross pay = basicpay+overtime overtime amount. The Tax payable = 30% of the gross pay. The netpay = grosspay-tax payable i) Enter the date in a worksheet to computer the net pay if the overtime hrs are 15 ii)...
How might the Capital Budgeting process change when the firm faces a dollar limit on capital...
How might the Capital Budgeting process change when the firm faces a dollar limit on capital investment projects? Provide an argument for why NPV is a superior capital budgeting technique over the IRR.
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...
Will nation states ever come to the point where the process of capital accumulation will be...
Will nation states ever come to the point where the process of capital accumulation will be devoured of violence
Solve the following LP problem using the Solver in MS Excel. A farmer wants to customize...
Solve the following LP problem using the Solver in MS Excel. A farmer wants to customize his fertilizer for his current crop. He can buy plant food mix A and plant food mix B. Each cubic yard of food A contains 20 pounds of phosphoric acid, 30 pounds of nitrogen and 5 pounds of potash. Each cubic yard of food B contains 10 pounds of phosphoric acid, 30 pounds of nitrogen and 10 pounds of potash. He requires a minimum...
Discuss the capital budgeting model, including the process used, as well as the implications for the...
Discuss the capital budgeting model, including the process used, as well as the implications for the decision-making process. Describe the implications of a positive, negative, and zero NPV. In your opinion, which parties are most directly impacted by a corporation initiating a positive NPV project? Explain. Compare this technique with at least three other analysis techniques. Consider the purpose, strengths, and limitations of each technique as well as strategies for capitalizing on each analysis.
Create an Excel spreadsheet in which you use capital budgeting tools to determine the quality of...
Create an Excel spreadsheet in which you use capital budgeting tools to determine the quality of 3 proposed investment projects, as well as a 6-8 page report that analyzes your computations and recommends the project that will bring the most value to the company. I have completed the excel portion of this question Scenario You work as a finance manager for Drill Tech, Inc., a mid-sized manufacturing company located in Minnesota. Three capital project requests were identified as potential projects...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT