Corporation is considering two possible investments and needs your help in determining which will be the better financial option. Perform the necessary calculations using Microsoft Excel so that maximum precision can be obtained. (Unless indicated otherwise, enter your answers rounded to the nearest whole dollar/input code: 0). Investment Option "North" This potential investment is a little more risky and longer term, so it has a minimum rate of return of 17.60%. This investment would require an initial outlay of cash to purchase a piece of equipment for $131,000, and at the end of the 8- year life of this investment is expected to have a salvage value of $39,300. For each year of this investment, net annual cash inflows are expected to be $29,500. 1. How much is the present value of the purchase of equipment? 2. How much is the present value of the salvage value? 3. How much is the present value of the annual cash inflows? 4. How much is the Net Present Value? 5. What is the value of the Present Value Index? (round to the nearest thousandths place/input code: 0.000) GA tA

Corporation is considering two possible investments and needs your help in determining which will be the better financial option. Perform the necessary calculations using Microsoft Excel so that maximum precision can be obtained. (Unless indicated otherwise, enter your answers rounded to the nearest whole dollar/input code: 0). Investment Option "North" This potential investment is a little more risky and longer term, so it has a minimum rate of return of 17.60%. This investment would require an initial outlay of cash to purchase a piece of equipment for $131,000, and at the end of the 8- year life of this investment is expected to have a salvage value of $39,300. For each year of this investment, net annual cash inflows are expected to be $29,500. 1. How much is the present value of the purchase of equipment? 2. How much is the present value of the salvage value? 3. How much is the present value of the annual cash inflows? 4. How much is the Net Present Value? 5. What is the value of the Present Value Index? (round to the nearest thousandths place/input code: 0.000) GA tA

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

I think the payback periods are correct, I just need the different cash flows of each year + the final question at the bottom. Thank you.
YOU ARE A FINANCIAL ANALYST FOR A COMPANY THAT IS CONSIDERING A NEW PROJECT. IF THE PROJECT IS ACCEPTED, IT WILL USE A FRACTION OF A STORAGE FACILITY THAT THE COMPANY ALREADY OWNS BUT CURRENTLY DOES NOT USE. THE PROJECT IS EXPECTED TO LAST 10 YEARS, AND THE ANNUAL DISCOUNT RATE IS 10% (COMPOUNDED ANNUALLY). YOU RESEARCH THE POSSIBILITIES, AND FIND THAT THE ENTIRE STORAGE FACILITY CAN BE SOLD FOR €100,000 AND A SMALLER (BUT BIG ENOUGH) FACILITY CAN BE ACQUIRED FOR €40,000. THE BOOK VALUE OF THE EXISTING FACILITY IS €60,000, AND BOTH THE EXISITING AND THE NEW FACILITIES (IF IT IS ACQUIRED) WOULD BE DEPRECIATED STRAIGHT LINE OVER 10 YEARS (DOWN TO A ZERO BOOK VALUE). THE CORPORATE TAX RATE IS 40%. DISCUSS WHAT IS THE OPPORTUNITY COST OF USING THE EXISTING STORAGE CAPACITY?
What is the value of the abandonment option (in millions), in the question below? Round your answer to two decimal places... Sunshine Smoothies Company (SSC) manufactures and distributes smoothies.It is considering the introduction of a "weight loss" smoothie.The project would require a $4 million investment outlay today (t = 0).The after-tax cash flows would depend on whether the weight loss smoothie is well received by consumers.There is a 30% chance that demand will be good, in which case the project will produce after-tax cash flows of $2 million at the end of each of the next 3 years.There is a 70% chance that demand will be poor, in which case the after-tax cash flows will be $1 million for 3 years.The project is riskier than the firm's other projects, so it has a WACC of 12%.The firm will know if the project is successful after receiving first year's cash flows.After receiving the first year's cash flows it will have the option to abandon the project.If the firm decides to…
Your friend offers you an investment opportunity. If you give him $1,200 today, his project will provide you with the following cash flows in Years 1-4: $100, $200, $600, $550. You required 10% return on investments of this risk level. Alternatively, you can invest your $1,200 in the money market fund at 4% today. Which of the two options is a better investment opportunity? Q4. There are two different ways to answers the question (both lead to the same conclusion). Show the complete formula (not the calculator shortcuts) with all the necessary terms that you would use to solve the problem as if you didn't have a financial calculator on hand. Q5. Circle the better investment opportunity: Friend's project / Money market fund
ZLIK Inc is considering methods by which to evaluate a multi-year project that requires a large $55 million investment. Assuming the project has conventional cash flows, under which conditions would the project be an acceptable investment for ZLIK? Select all that apply. A) NPV < 0 B) NPV > 0 C) IRR > firm's required return D) IRR < firm's required return E) Profitability Index > 1.0 F) Profitability Index < 1.0
An investor has two prototypes for invention, A and B, and needs the same amount of loan L for each. It is expected that either one of these prototypes will take a year to develop and will yield a reward of either RA or 0 for prototype A and either RB or 0 for prototype B. The probabilities of positive payoff are given by Prob(RA)=PA Prob (RB) =PB And these probabilities are known to the bank. The bank will only lend if the expected repayment at the end of the year generates a yield of i. If the prototype given a 0 reward, then the bank receive no repayment. Assuming risk neutrality on the part of the bank, explain why the repayments when either prototype is a success are given by (1+i) LPA, (1+i) LPB for A, B respectively. If the loan were granted, show that the expected payoff for the inventor after the bank has been repaid is given by PARA-(1+i) LPBRB-(1+i)L for A, B respectively. Under what conditions…
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Consider an investment that pays off $700 or $1,400 per $1,000 invested with equal probability. Suppose you have $1,000 but are willing to borrow to increase your expected return. What would happen to the expected value and standard deviation of the investment if you borrowed an additional $1,000 and invested a total of $2,000? What if you borrowed $2,000 to invest a total of $3,000? Instructions: Complete the table below to answer the questions above. Enter your responses as whole numbers and enter percentage values as percentages not decimals (i.e., 23% not 0.23). Enter a negative sign (-) to indicate a negative number if necessary. Invest $1,000 Invest $2,000 Invest $3,000 Expected Value $ 1050 1200 $ $ 1300 Percentage 20 % 30 % 40 % Standard Deviation 300 600 900 Expected Return N/A Doubled Tripled
Adam Andler Corp is analyzing an average-risk project, and the following data have been developed. Unit sales will be constant, but the sales price should increase with inflation. Fixed costs will also be constant, but variable costs should rise with inflation. The project should last for 3 years. This is just one of many projects for the firm, so any losses on this project can be used to offset gains on other firm projects. What is the project's expected NPV? Do not round the intermediate calculations and round the final answer to the nearest whole number. WACC or cost of capital Net investment cost (depreciable basis) The salvage value of its equipment No other fixed assets will be acquired for following years The company will require an increase in net working capital at the $10,000 beginning The company will liquidate all working capital at the end of the project -10,000 Units sold (constant through years) 60,000 $30.00 $50,000 $17.00 Average price per unit, Year 1 Fixed operating…
Suppose you are considering building a factory that produces turbo jets. Price of a turbo jet right now is $200. Next year the price could go up to $220 or go down to $180 or stay at $200 with equal probabilities. The price then remains fixed for a long time. (This assumption makes this cash flow risky). This will be your revenue. Cost of factory is $300 and it can be built right away since you have infrastructure in place. WACC is 30%. Cost of debt is 10%. You have the option to wait one year and see whether the price goes up or down and then invest only if price is above $180? What is the NPV? 414.22 167.52 312.82 566.67

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

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

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