Vikas

NPV and IRR Analysis

SUBDOMAIN 319.1 - ACCOUNTING & FINANCE
SUBDOMAIN 319.2 - INFORMATION TECHNOLOGY
Competency 319.1.3 Capital Budgeting Analysis - The graduate correctly applies time value of money techniques and techniques that ignore present value for capital investment decisions.
Competency 319.2.1 Technology Tools - The graduate uses information technology tools for specified business purposes.
Competency 319.2.5 Information Management - The graduate selects appropriate technology applications to manage information and make decisions in given situations.
Objectives:
319.1.3-01: Calculate net present value based on a given set of facts.
319.1.3-02: Apply the results of a net present value calculation to a given decision situation.
319.1.3-03: Calculate internal rate of return based on a given set of facts.
319.1.3-04: Apply the results of an internal rate of return calculation to a given decision situation.
319.1.3-05: Calculate the period of time required to recoup the money expended for new equipment in a given situation.
319.1.3-06: Calculate the accounting rate of return based on a given set of facts.
319.1.3-07: Explain the relationship of the accounting rate of return to the internal rate of return for the same capital investment alternative.
319.1.3-08: Calculate net cash flow in a given situation.
319.1.3-09: Explain the impact of depreciation on net cash flow.
319.1.3-10: Explain the role of the weighted average cost of capital in capital budgeting analysis.
319.2.1-04: Produce a computer-based presentation on a business topic.
319.2.5-05: Demonstrate the appropriate use of specified software application in a given situation.
Introduction:
Person K supplements income from a professional practice by investing in start-up and other business opportunities that meet specific investment criteria. K operates all of these extra business activities as a single limited liability company and utilizes discounted cash flow analysis as a primary tool for evaluating each potential investment. There is an opportunity to purchase the patent for a newly invented gardening tool that K would manufacture and sell on a wholesale basis. K has asked you to prepare an analysis of this investment opportunity and make a recommendation regarding the course of action to take.
Given:
Person K plans to retire from professional practice and cease all business activities nine years from now. The plan for the garden tool is to produce and sell it for eight years and then sell the patent and production rights to a national company. K has negotiated a tentative lease on a building that is well suited for this manufacturing process. The building must be remodeled to meet manufacturing needs, and then it must be restored to its original configuration at the end of the eight-year lease. At that time K will be able to sell some of the non-specialized equipment (e.g., forklifts) for small salvage values.
• Building remodeling and new equipment purchases will require a front-end investment of $2,700,000.
• An additional $210,000 in working capital will be required for business operations.
• Estimated annual cash receipts from tool sales are predicted at $3,200,000 per year for the first three years, $3,600,000 per year for years 4 through 6, and $3,800,000 during the last two years of operation.
• Estimated cash expenses for materials, salaries, supplies, utilities, and other cash expenses are projected at $2,500,000 per year for the first three years, $2,800,000 per year for years 4 through 6, and $3,200,000 per year for the last two years.
• The remodeling and equipment costs will be capitalized and depreciated over the eight-year period at the rate of $330,000 per year.
• Realizable salvage value from disposing of the equipment at the end of eight years is estimated at approximately $60,000.
• The cost of restoring the building to its original configuration at that time is estimated at $120,000.
• The working capital tied up in this project will become available for other types of investments at the end of the eight-year period.
Person K has asked you to assume a combined federal and state income tax rate of 30% throughout the life of the project and a 12% applicable weighted average cost of capital.
Task:
A. Complete the attached “Capital Budgeting Template” by doing the following:
1. Calculate the net cash flow that should be used for each year in the discounted cash flow analysis.
2. Calculate the net present value (NPV) of this project using a discount rate equal to the company- weighted average cost of capital. Round all dollar amounts to the nearest whole dollar.
3. Calculate the expected yield on the project using the discounted cash flow internal rate of return (IRR) method. Round all dollar amounts to the nearest whole dollar.
4. Calculate the accounting rate of return for this project.
5. Calculate the unadjusted payback period. State your answers in years and months.
B. Prepare a computer-based presentation in which you do the following:
1. Identify what the correct net cash flow for the second year would be if all cash expenses were as described in the scenario but there were no depreciation expense.
a. Explain the impact of depreciation on net cash flow for the second year.
2. Based upon your NPV analysis in part A2, make a recommendation to Person K regarding what decision to make.
a. Explain why this is an appropriate action.
3. Based upon your IRR analysis in part A3, make a recommendation to Person K regarding what decision to make.
a. Explain why this is an appropriate action.
4. Explain why the accounting rate of return on this project is different from the internal rate of return for the same capital investment.
5. Explain the relative significance of the unadjusted payback period in this decision situation.
6. Explain how the weighted average cost of capital should be used in capital budgeting analysis when utilizing the NPV method.
7. Explain how the weighted average cost of capital should be used in capital budgeting analysis when utilizing the IRR method.
C. If you choose to use outside sources, include all in-text citations and references in APA format.
Note: Please save word-processing documents as *.rtf (Rich Text Format) files.
Note: For definitions of terms commonly used in the rubric, see the attached Rubric Terms.
Note: When using outside sources to support ideas and elements in a paper or project, the submission MUST include APA formatted in-text citations with a corresponding reference list for any direct quotes or paraphrasing. It is not necessary to list sources that were consulted if they have not been quoted or paraphrased in the text of the paper or project.

Business Management Assignment Help, Business Management Homework help, Business Management Study Help, Business Management Course Help
Answered
Other / Other
01 Feb 2016

Answers (1)

  1. Vikas

    NPV and IRR Analysis

    The calculated IRR of the project is 13.31%. On the other side, the discoun ****** ******
    To see full answer buy this answer.
    Answer Attachments

    2 attachments —

    • img
      Capital Budgeting.ppt
    • img
      Capital_Budgeting.xls

Report As Dispute

Share Your Feedback

Give Review : A+ A B C D F