Question: A B E F 1 Investment Decision Spreadsheet 2 3 Discount Rate 4 Project: 1 5 Initial cost: -5000 12% 2 3 4 5 6

A B E F 1 Investment Decision Spreadsheet 2 3 Discount

A B E F 1 Investment Decision Spreadsheet 2 3 Discount Rate 4 Project: 1 5 Initial cost: -5000 12% 2 3 4 5 6 5 -5000 -5000 -5000 -5000 -5000 6 Year 1 7 0 2500 -550 670 625 700 900 8 2 0 1700 -50 670 625 9 3 0 915 900 60 670 625 10 4 0 920 450 670 625 700 500 11 5 0 925 800 670 625 12 6 0 930 670 625 300 200 13 7 0 940 670 625 14 8 0 950 150 625 670 670 15 9 0 960 1100 1350 1500 1625 1725 1810 1885 100 625 16 10 0 970 60 625 670 670 17 11 0 980 30 625 625 670 670 1935 625 670 625 1975 2000 670 5625 4 5 6 18 12 0 990 20 19 13 0 1000 10 20 14 0 1100 5 21 15 22000 -5000 5 22 Calculate for 1 2 3 23 Each Project: 24 NPV (at 12%) 25 26 IRR 27 28 MIRR (at 12%) 29 30 PI (at 12%) 31 Profitability Index = NPY/(absolute value of Initial Investment) 32 33 34 Crossover point calculation: 35 36 37 Project Rankings: 38 39 NPV Rankings 40 IRR Rankings 41 MIRR Rankings 42 Profitability Rankings 43 44 45 Why are there differences in ranking these projects? 46

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Finance Questions!

John, age 28, and Emily, age 27, have just had their first child, Lindsey. They have a combined income of $55,000 and rent a two-bedroom apartment. For the past several years, John and Emily have...

IRR Answer Options: IRR (B2:B6) , XIRR (B2,B3,B4,B5,B6) , MIRR (B2:B6) , IRR (b3:B6) MIRR Answer Options: MIRR( B4:B8, B2,B3) , MIRR (B2:B8) , IRR (B4:B8, B3, B2) , IRR(B2,B6) Consider the data from...

This is all part of one question. I'm really not sure how I set up the spreadsheet like Exhibit 14-8 and get the correct solutions. EXHIBIT 14-8 The Net Present Value Method-An Extended Example A B C...

Apple Hilly Farms Ned Hilly was an investment banker and worked in San Francisco at a large bank. As retirement got closer his wife, Sally, and him decided to spend their retirement up in the Sierra...

Adobe Acrobat Reader DC Tools ACCT 111 SME Proj 1 / 4 134% Apple Hilly Farms Ned Hilly was an investment banker and worked in San Francisco at a large bank. As retirement got closer his wife, Sally,...

Renting versus Owning The goal of this exercise is to compile all cash flows associated with each form of occupancy, and then calculate the rate of return that will be earned on the funds used to...

Please solve problem 6 using the data fron problem five resolver problem 6 on the same 8. projec mated from cash project? Year Il be $25 preciated 0 million 0 1 2 3 ments for a project Yar Revenge -...

1. Determine the payback period for an investment 2. Evaluate the acceptability of an investment project using the net present value method 3. Evaluate the acceptability of an investment project...

Need help with completing the Journal entries, consolidation entries and consolidation worksheet. Thank you in advance. AutoSave OFF ... Project 2 S21 Data and Answers (1) Q Home Insert Draw Page...

EXHIBIT 7-11 Product Margins-Activity-Based Costing A B C D E F 1 Product Margins-Activity-Based Costing 2 Standard Stanchions Custom Compass Housings 3 Sales $ 2,660,000 $ 540,000 4 Costs: 5 Direct...

The spreadsheet fragment below shows a net present value and internal rate of return calculation for a project: Use Data Table to do a sensitivity analysis on the NPV of the project, varying the...

With each A RnÃn we can associate n closed circular disks in the complex plan. The ith disk is centered at aij and has radius Each eigenvalue of A is contained in at least one of the disks. If...

On January 2, Burt asked Logan to loan him money against my diamond ring. Logan agreed to do so. To guard against intervening liens, Logan received permission to file a financing statement, and Burt...

Homework 4 General instruction: Do the following. Show all the necessary work to get full points. Print this page and sign the attestation below. Write your solutions on clean sheets of paper. If you...

Using transaction data to prepare a statement of cash flowsDirect method Store Company engaged in the following transactions during the 2011 accounting period. The beginning cash balance was $28,600...

Granger Service Company, Inc., was organized by Ted Granger and five other investors. The following activities occurred during the year: a. Received $70,000 cash from the investors; each was issued...

1. What are some strategic considerations in establishing a pay structure at Nutriment? 2. Should Jack suggest a pay policy to lead, lag or match the market? Explain your recommendation. 3. Explain...

What is the purpose for establishing pay ranges?

Outdoor Texas makes umbrellas, gazebos, and chaise lounges. The company uses a traditional overhead allocation scheme and assigns overhead to products at the rate of $ 30 per direct labor hour. The...

(T / F) With simulation, the model is repeated many times and the models output for each repetition is used to construct a statistical distribution of all the outcomes. This shows the average...

If you were Jennifer, what would be the first thing that you would do when joining the business? resource management activities, such as recruiting, selecting, training, and rewarding employees, are...

=+2. Using the same product (client), expand the brief into a longer one. Remember to describe your audience using the appropriate VALS, such as Belongers, Emulators, Achievers, and so on. (See...

=+6. Select the one that would work best for this client.