PLEASE PROVIDE EXCEL SOLTIONConsider the following EOY cash flows for two mutually exclusive types of microscope for a geoscience lab (one must bechosen, assume that annual benefits of both types are similar). The MARR is 5% per year.Microscope A Microscope BCapital investmentAnnual expensesUseful lifeMarket value at end of useful life$60,000$85,000$1,400$1,50018 years$12,00012 years$0a. Determine which alternative should be selected if the repeatability assumption applies.b. Determine which alternative should be selected if the analysis period is 18 years, the repeatability assumption does notapply, and a microscope can be leased (i.e. borrowed) for $10,000 per year after the useful life of either microscope isover.

Annual worth is calculated over one life cycle of the asset and is usually used to compare the…

Answered: Consider the following EOY cash flows…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Two mutually exclusive altenatives are being considered for the environmental protection equipment at a petroleum refinery. One of these alternatives must be selected. The firm's MARR is 20% per year. The estimated cash flows for each alternative are as follows: Market value(at end of useful life) $4,000 $6,000 Annual Саpital investment Useful expenses 4,000 life(years) 5 Alternative A S20,000 Alternative B Assume the study period is shortened to five years. The market value of alternative B after five years is estimated to be $12,000. Which alternative would you select using NPW-C? (Draw the cash flow diagram and solve.) $30,000 2,000 10
company investment on a machine costing of P40,000 and has a life of 5 years. Yearly cash inflows are as follows: Year 1-P18,000; Year 2-P12,000; Year 3-P10,000; Year 4-P9,000; and Year 5-P6,000. Calculate Net present value at 10% and PI. Will the company accept or reject the project? Complete the table below. 2. A Year Cash flows PV Factor @10% PV 2. 4 Total PV Less-investment Net Present Value PI=
The Butler-Perkins Company (BPC) must decide between two mutually exclusive projects. Each costs $7,000 and has an expected life of 3 years. Annual project cash flows begin 1 year after the initial investment and are subject to the following probability distributions: Project A Project B Probability Cash Flows Probability Cash Flows 0.2 $6,250 0.2 $0 0.6 $7,000 0.6 $7,000 0.2 $7,750 0.2 $19,000 BPC has decided to evaluate the riskier project at 12% and the less-risky project at 10%. a. What is each project's expected annual cash flow? Round your answers to two decimal places. Project A: $ Project B: $ Project B's standard deviation (σB) is $6,131.88 and its coefficient of variation (CVB) is 0.77. What are the values of (σA) and (CVA)? Round your answers to two decimal places. σA = $ CVA = b. Based on the risk-adjusted NPVs, which project should BPC choose? c. If you knew that Project B's cash flows were negatively correlated with the firm's other cash flow, but Project A's cash flows…
A company is investigating two production options of the manufactured switches that have the estimated cash flows shown. Which orne should be selected on the basis of a present worth analysis at 10% per year? In-house Contract First cost, P Annual cost, P per year Annual income, P per year 3,000,000 400,000 1,400,000 200,000 0: 200,000 3,100,000 Salvage value, P Life, years 5
A company must purchase a new machine to increase production. The machine will cost $50,000 to purchase. The following are the remaining cash flows of the machine and its probabilities. The machine is supposed to be used for 6 years and the MARR is 10%. Annual Cost Annual Revenue Calculate the Present Worth. Probability .2 .6 .2 .6 .4 Outcome $3,000 $4,500 $5,500 $35,000 $40,000
Central Mass Ambulance Service can purchase a new ambulance for $200,000 that will provide an annual net cash flow of $50,000 per year for five years. The salvage value of the ambulance will be $25,000. Assume the ambulance is sold at the end of year 5. Calculate the NPV of the ambulance if the required rate of return is 9%. (Round your answer to the nearest $1.) A) $(10,731) B) $10,731 C) $(5,517) D) $5,517
Consider the following cash flows on two mutually exclusive projects for the Bahama Recreation Corporation (BRC). Both projects require an annual return of 14 percent. Year Deepwater Fishing 0 -$955,000 1 375,000 2 514,000 3 425,000 New Submarine Ride 1,860,000 910,000 805,000 760,000 a-1. Compute the IRR for both projects. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Deepwater Fishing Submarine Ride % %
Harris Corporation has provided the following data concerning an investment project that it is considering: Initial investment Annual cash flow Salvage value at the end of the project Expected life of the project Discount rate $ 160,000 $ 54,000 $ 11,000 O $67,000 O $160,516 O $516 O $(5,776) 4 15 per year years % Use Exhibit 7B-1 and Exhibit 7B-2, to determine the appropriate discount factor(s) using the tables provided. The net present value of the project is closest to:
OF CO Cum Oriole Company is considering two capital investment proposals. Estimates regarding each project are provided below: Initial investment Annual net income Net annual cash inflow Estimated useful life Salvage value Periods 5 Project Soup $400000 48000 124000 5 years 0 The company requires a 10% rate of return on all new investments. Present Value of an Annuity of 1 10% 12% 9% 62%. 12.0%, 24% Ⓒ31,0% 11% 3.89 3.791 3.696 3.605 4.486 4.355 4.231 4.111 The annual rate of return for Project Soup is Project Nuts $600000 64000 155000 6 years 0
1. Two mutually exclusive alternatives requiring different investments are being considered. The life of all two alternatives is estimated to be 20 years with no salvage value. The MARR that is considered is acceptable is 12%. The cash flows representing these two alternatives are as follows: Investment cost Net income per year Alternative A $100,000 $15,000 Alternative B $60,000 $11,000 Find the investment that should be selected using IRR on incremental investment (use PW formula).
he cash flows associated with a public works project in Buffalo, New York, are shown. Use the modified B/C ratio at a discount rate of 5% per year to determine the economic justification. First cost, $ 30,000,000 AW of benefits, $/year 7,700,000 AW of disbenefits, $/year 1,700,000 M&O costs, $/year 1,525,000 Life of project, years 30 The modified B/C ratio is . The project is economically (Click to select) justified not justified .
The Butler-Perkins Company (BPC) must decide between two mutually exclusive projects. Each project has an initial after-tax cash outflow of $6,500 and has an expected life of 3 years. Annual project after-tax cash flows begin 1 year after the initial investment and are subject to the following probability distributions: Project A Project B Probability Cash Flows Probability Cash Flows 0.2 $6,250 0.2 $ 0.6 6,500 0.6 6,500 0.2 6,750 0.2 19,000 BPC has decided to evaluate the riskier project at 11% and the less-risky project at 8%. a. What is each project's expected annual after-tax cash flow? Round your answers to the nearest cent. Project A: $ Project B: Project B's standard deviation (OB) is $6,185 and its coefficient of variation (CVB) is 0.80. What are the values of gg and CVA? Do not round intermediate calculations. Round your answer for standard deviation to the nearest cent and for coefficient of variation to two decimal places. OA: $ CVA:

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS