Purchase Solution

Creating a NPV & IRR Spreadsheet

Not what you're looking for?

Ask Custom Question

Suppose you own a concession stand that sells hot dogs, peanuts, popcorn, and beer at a ball park. You have three years left on the contract with the ball park, and you do not expect it to be renewed.
Long lines limit sales and profits. You have developed four different proposals to reduce the lines and increase profits.

The first proposal is to renovate by adding another window. The second is to update the equipment at the existing windows. These two renovation projects are not mutually exclusive; you could take both projects. The third and fourth proposals involve abandoning the existing stand. The third proposal is to build a new stand. The fourth proposal is to rent a larger stall in the ball park. This option would involve $1,000 in up-front investment for new signs and equipment installation; the incremental cash flows shown in later years are net of lease payments.
You have decided that a 15% discount rate is appropriate for this type of investment. The incremental cash flows associated with each of the proposals are:

Incremental Cash Flows
Project Investment Year 1 Year 2 Year 3
Add a new window -$75,000 44,000 44,000 44,000
Update existing equipment -50,000 23,000 23,000 23,000
Build a new stand -125,000 70,000 70,000 70,000
Rent a larger stand -1,000 12,000 13,000 14,000

• Using the internal rate of return rule (IRR), which proposal(s) do you recommend?
• Using the net present value rule (NPV), which proposal(s) do you recommend?
• How do you explain any differences between the IRR and NPV rankings? Which rule is better?

Purchase this Solution
Solution Summary

The solution provides an excel file that allows you to input cash flows and other variables to determine NPV or IRR.

Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Motivation

This tests some key elements of major motivation theories.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

View More Free Quizzes
Related BrainMass Solutions

  • IRR calculations and NPV

    140729 IRR calculations and NPV Make a spreadsheet document that contains the IRR calculations.

  • Calculating Net Value Present and IRR

    Find the NPV, IRR and MIRR of each the projects with a cost of capital of 5%, 10%, and 12%. 2. Determine the payback period of each project. 3.

  • NPV & Payback & IRR

    483755 NPV & Payback & IRR Based on the numbers in the spreadsheet (see attachment): What would the IRR be if NPV was 0? (for both the equity case and the leveraged case)? And the Discounted Payback would be for how many years?

  • Cash Flows for Two Mutually Exclusive Projects: NPV versus IRR

    23809 Cash Flows for Two Mutually Exclusive Projects: NPV versus IRR Here are the cash flows for two mutally exclusive projects: Project A: Co : -20,000 C1: +8,000 C2: +8000 C3: +8000 Project B: C0: -20,000 C1: 0 C2: 0 C3: +25,000 a

  • Calculate NPV, IRR, maximum cost of capital

    Using the internal rate of return (IRR) method and their requirements, determine whether Billy and Mandy should undertake the investment. Use Attached NPV IRR spreadsheet. Both problems should be on one page of one excel spreadsheet.

  • Accounting: Capital budgeting and Decision Making

    A Word document and Excel spreadsheet are attached.

  • Compute NPV and IRR

    The solution explains how to calculate the compute NPV and IRR for Rondo's new project

  • Calculating NPV and IRR parameters in the given case

    564341 Calculating NPV and IRR parameters in the given case Using a spreadsheet program like Excel, calculate the NPV and IRR of the following scenario: Cost (Year 0): 10,000. Year 1 Return: 3,000. Year 2 Return: 3,000. Year 3 Return: 5,000.

  • Concepts of Present Value and Application

    The NPV is computed using the following function (in cell H1): 1.10*npv(0.10,A1..F1) (a) Insert the numbers of the example in an Excel spreadsheet, insert the 'functions' and verify that you indeed obtain the same IRR of 13.453% and NPV at 10% of

View More Related Solutions