Calculate the NPV of each project. (Use the NPV function in Excel to solve this problem.) Which of the two projects would you fund if the decision is based only on financial information and you could only choose one of the projects? Omega Alpha Year Inflow YO 0 Y1 0 Outflow 207,000 110,000 Netflow Year Inflow Outflow Netflow (207,000) YO 0 217,000 (217,000) (110,000) Y1 7,000 190,000 (183,000) Y2 150,000 0 150,000 Y2 150,000 0 150,000 Y3 220,000 30,000 190,000 Y3 220,000 30,000 190,000 Y4 161,000 0 161,000 Y4 191,000 0 191,000 Y5 205,000 48,000 157,000 Y5 205,000 38,000 167,000 Y6 197,000 0 197,000 Y6 197,000 0 197,000 Y7 100,000 30,000 70,000 Y7 100,000 30,000 70,000 Total 1,033,000 425,000 608,000 Total 1,070,000 505,000 565,000 The NPV for Omega is The NPV for Alpha is The better project is
Q: A portfolio consists of securities as follows: Security Beta Units Average buying price (RM) Current…
A: Portfolio:In the realm of finance, a portfolio represents a collection of financial assets owned by…
Q: Cost of equity and Pre-tax cost of debt of Company Z is 15% 9.2 % respectively. Company pays tax at…
A: Weighted average cost of capital is popularly known as WACC. A company funds its operations through…
Q: Suppose you just bought an annuity with 10 annual payments of $16,500 at a discount rate of 13.75…
A: The objective of the question is to calculate the present value of an annuity under different…
Q: Suppose that the current spot exchange rate is €1.72 per £ and the one-year forward exchange rate is…
A: The objective of this question is to understand the concept of covered interest arbitrage and how it…
Q: A mortgage of $38,000 is repaid by making payments of $270 at the end of each month for 13 years.…
A: The nominal annual rate of interest is the base interest rate for a loan or investment that is…
Q: Jordan purchased 400 shares of GE at $16 per share. The price has dropped to $11 and he is…
A: Stocks or shares represent ownership in a company or organization which entitles the investors to a…
Q: A not for profit, 501 (c)(3) organization has $800,000 in assets, anEBIT of $100,000. The current…
A: Answer: Profit: $65,400 ROE: 10.22% Explanation:Profit after Taxes and Interest (PAT)Calculate…
Q: Question 6 What is the cost of debt for Red Brick Inc. if its debt consists of 5-year bonds rated…
A: The cost of debt refers to the profit the company provides on average to all its debtholders. It is…
Q: Your firm spends $469,000 per year in regular maintenance of its equipment. Due to the economic…
A: IRR refers to the internal rate of return at which the net present value is zero. It is the…
Q: In September 2008, the IRS changed tax laws to allow banks to utilize the tax loss carryforwards of…
A: The tax shield provided by carryforwards refers to the reduction in a company's taxable income…
Q: Over the past five years, a stock returned -2.73 percent, 14.66 percent, 15.19 percent, 3.43…
A: The question deals with the concept of variance, a statistical measure used in finance to quantify…
Q: 18 A company has a machine which will continue to function for the next five years, but gradually…
A: The objective of this question is to calculate the net present value (NPV) of the proposal to…
Q: Wendell's Donut Shoppe is investigating the purchase of an $42,700 donut-making machine with a…
A: As per the guidelines, the solution for the first three subparts will be provided. If you want the…
Q: Assume that you contribute $150 per month to a retirement plan for 20 year Then you can increase the…
A: Retirement plan refers to an amount that is being invested at every period for the purpose of…
Q: You borrow $155,000; the annual loan payments are $12, 490.89 for 30 years. What interes rate are…
A: Borrowed amount = $155,000Annual loan payment = $12,490.89Number of years = 30 Years
Q: Evaluate the arbitrage opportunity with the triangular arbitrage methods for the following currency…
A: The objective of the question is to evaluate the arbitrage opportunity with the triangular arbitrage…
Q: Jonas borrowed $8,000 on a 60-day 10% note. Jonas paid $4,000 toward the note on day 40. On day 50,…
A: The objective of the question is to calculate the adjusted balance of Jonas's loan after the first…
Q: A project that provides annual cash flows of $12,600 for 12 years costs $65,000 today. At what rate…
A: If the rate of interest is equal to the IRR of the investment and at that rate we will be…
Q: Suppose an Investor, Erik, is offered the Investment opportunities described in the table below.…
A: The objective of the question is to understand the investment preferences of two investors, Erik and…
Q: FS) is evaluati a capital budgeting roject lat costs $75,00 PHFS's required rate of return is 14…
A: Capital budgeting is a financial process used by companies to evaluate and make decisions about…
Q: Dizzy Inc. wishes to issue new bonds but is uncertain how the market would set the yield to…
A: Compound = Semiannually = 2Time = t = 20 * 2 = 40Semiannually Coupon Rate = c = 3.5%Face Value = fv…
Q: We are examining a new project. We expect to sell 8,500 units per year at $175 net cash flow apiece…
A: NPV is one of the capital budgeting instruments that can be used where the investor can determine…
Q: 4. Assume that you have two projects (A and B) the life of the two proposals with the respective net…
A: Capital budgeting is the process of evaluating various investment proposals on grounds of financial…
Q: Waltz Corporation's 20-year bonds were issued 12 years ago. The bonds have a face value of $1,000…
A: Maturity period at the time of issue: 20 yearsNumber of years since the issue: 12 yearsCoupon rate:…
Q: Please help with a discussion on question #2. The base country is Nevis and the countries trading to…
A: For your discussion on question #2 regarding the main foreign currencies that will be used in the…
Q: Horror Movies Co.'s preferred stock pays a dividend of $5.05 per quarter, and it sells for $103.00…
A: Effective annual rate of return is the interest rate paid on a loan that is adjusted for compounding…
Q: So($/€) Exchange Rate $ 1.45 = € 1.00 F360($/€) $ 1.48 = € 1.00 Interest Rate APR i$ 4% i€ 3% you…
A: Money has time value and due to which value of money will not be same tomorrow and value will change…
Q: Given the information below for HooYah! Corporation, compute the expected share price at the end of…
A: The P/E Ratio is a valuation metric that evaluates a company by comparing its current stock price…
Q: Navarre Energy Research specializes in developing and commercializing new products. It is organized…
A: Economic value added is a measurement of residual income/economic profit over and above of required…
Q: Hyacinth Macaw invests 45% of her funds in stock I and the balance in stock J. The standard…
A: Proportion invested in I = 45%Standard deviation of I = 17%Standard deviation of J = 30%To find:…
Q: Problem 6-6 (Algo) Consider the following table: Scenario Probability Stock Fund Rate of Return Bond…
A: An investor would wish to analyze how two investment's returns move in coordination with each other…
Q: You find the following corporate bond quotes. To calculate the number of years until maturity,…
A: Bond price refers to the market value of a bond, which is influenced by factors such as interest…
Q: mashed Pumpkins Company paid $112 in dividends and $547 in interest over the past year. The company…
A: EBIT (Earnings Before Interest and Taxes) is a financial metric that represents a company's…
Q: How do you find yeild to call?
A: Yield to call is a financial term used to calculate the annual return on a callable bond if it's…
Q: 3. (a) Debt is 20% of assets for an organization. Total assets are$10,000. The tax rate is 40%. The…
A: (a) Debt at 20% of AssetsCalculate Debt and Equity:Debt = 20% * $10,000 = $2,000Equity = $10,000 -…
Q: Tom Scott is the owner, president, and primary salesperson for Scott Manufacturing. Because of this,…
A: Given:EBIT for a 40-hour week: $555,000EBIT for a 50-hour week: $635,000Company's worth: $3.25…
Q: You've collected the following information from your favorite financial website. 52-Week Price Hi…
A: Assuming that the growth rate is constant and lower than the required return, we can use the…
Q: igital Organics (DO) has the opportunity to invest $1.03 million now (t = 0) and expects after - tax…
A: Adjusted Present Value (APV) refers to a valuation approach that takes into account how financing…
Q: Problem 6-30 Credit Risk (LO4 a. Many years ago, Castles in the Sand Incorporated issued bonds at…
A: Face value = $1,000Coupon rate = 5.6%Years to maturity = 5 yearsYTM = 13%Investors will receive only…
Q: For each of the following annuities, calculate the annual cash flow: Note: Do not round intermediate…
A: PMT formula or excel "PMT" function can be used to solve this problem. PMT formula is enumerated…
Q: Zoombie Brewery is considering a project with estimated operating income of $40M per year. The…
A: The cost of capital for APV method will be the WACC using the levered equity cost along with the…
Q: Assume a face value of $1,000.) If the bond has a yield to maturity of 9.7% 1 year from now, what…
A: Purchasing a bond entails making a loan to the issuer, which could be the government or a business.…
Q: Stock A has an expected return of 13.52 percent. Stock B has an expected return of 9.24 percent.…
A: The concept in question is based on the Capital Asset Pricing Model (CAPM), a finance theory used to…
Q: The owner's of a small manufacturing concern have hired a manager to run the company with the…
A: Profitability goals refer to the financial objectives set by a company to achieve and maintain a…
Q: King, Incorporated, has debt outstanding with a face value of $5.4 million. The value of the firm if…
A: financial distress cost refers to cost which is incurred for eliminating the amount of debt that…
Q: A corporation identifies an investment opportunity that will yield end of year cash flows of $35,000…
A: Initial Investment = $150,000Year 1 cash flow = $35,000Year 2 cash flow = $35,000Year 3 cash flow =…
Q: An office building has three floors of rentable space with a single tenant on each floor. The first…
A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…
Q: Your firm has a WACC of 16.25%. The cost of equity is 20% and the firm's bonds yield 7.9%. The tax…
A: Debt equity ratio refers to the financial percentage where the ratio defines the amount of debt…
Q: a constant 15 percent growth rate thereafter. What is the dividend yield and capital gains yield for…
A: The dividend yield is similar to the interest you receive on savings accounts, but you invest in…
Q: $1,500; Baby Camels Inc. had the following data for the year ending 12/31/12: Net income = EBIT…
A: Return on Invested Capital ( ROIC ) is a financial metric used to evaluate the efficiency and…
Step by step
Solved in 1 steps
- A2. (PaybackandNPV)Threeprojectshavethecashflowsgivenhere.Thecostofcapitalis10%. a. Calculate the paybacks for all three projects. Rank the projects from best to worst based on their paybacks. Calculate the NPVs for all three projects. Rank the projects from best to worst based on their NPVs c. Why are these two sets of rankings different? YEAR 0 1 2 3 4 5Project 1 −10 4 3 2 1 5 Project 2 −10 1 2 3 4 5 Project 3 −10 4 3 2 1 10Use the information for the question(s) below. Project A - 10,000 Project B Time 0 - 10,000 Time 1 5,000 4,000 Time 2 4,000 3,000 Time 3 3,000 10,000 If WiseGuy Inc. uses IRR rule to choose projects, which of the projects (Project A or Project B) will rank highest? OA. Project A OB. Project B OC. Project A and Project B have the same ranking OD. Cannot calculate a payback period without a discount rate.Use the information provided to answer the questions.Use the information provided below to calculate the following. Where applicable, use the present value tables provided in APPENDICES1. Calculate the Net Present Value of each project (with amounts rounded off to the nearest Rand).Use your answers to recommend the project that should be chosen. Motivateyour choice.
- Use the information provided to answer the questions.Use the information provided below to calculate the following. Where applicable, use the presentvalue tables provided in APPENDICES 1 and 2 that appear after QUESTION 5. 5.1.3 Calculate the Net Present Value of each project (with amounts rounded off to the nearest Rand). 5.1.4 Use your answers from question 5.1.3 to recommend the project that should be chosen. Motivateyour choice. INFORMATION Zeda Enterprises has the option to invest in machinery in projects A and B but finance is only available to invest inone of them. You are given the following projected data:Project A Project BInitial cost R300 000 R300 000Scrap value R40 000 0Depreciation per year R52 000 R60 000Net profitYear 1 R20 000Year 2 R30 000Year 3 R50 000Year 4 R60 000Year 5 R10 000Net cash flowsYear 1 R90 000Year 2 R90 000Year 3 R90 000Year 4 R90 000Year 5 R90 000 Additional informationThe discount rate used by the company is 12%.Crane Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $164,000 $180,500 $204,000 Annual net income: Year 1 14,420 18,540 27,810 2 14,420 17,510 23,690 14,420 16,480 21,630 4 14,420 12,360 13,390 14,420 9,270 12,360 Total $72,100 $74,160 $98,880 Depreciation is computed by the straight-line method with no salvage value. The company's cost of capital is 15%. (Assume that cash flows occur evenly throughout the year.) Click here to view the factor table. Compute the cash payback period for each project. (Round answers to 2 decimal places, e.g. 10.50.) Project Bono years Project Edge years Project Clayton yearsSuppose x1, x2, and x3 are binary variables that are equal to 1 if the corresponding project (1, 2, or 3) is selected and 0 if the corresponding project is not selected. Also, suppose that y1, y2, and y3 are variables that indicate the amount of money invested in the projects (projects can only be invested in if they are selected). The maximum investment is $2000 for project 1, $4000 for project 2, and $6000 for project 3. Which of the following constraints is needed for this problem? x3 ≤ 6000y3 6000x3 ≤ y3 6000y3 ≤ x3 y3 ≤ 6000x3
- Suppose that you could invest in the following projects but have only $24,480 to invest. Which projects would you choose? Project Cost NPV w $ 7,970 $ 3,000 x 10,990 7,530 y 8,500 4,280 z 6,750 3,890 You should invest in project(s)?A financial analyst is evaluating the following projects, which are mutually exclusive, meaning that only one of them can be chosen. Based on financial theory and the NPV criterion, which one of these projects should be chosen over the other three? Time A C D -26,000 -7,200 -14,500 -19,600 8,100 11,900 8,100 2,360 8.600 1,150 10,000 2,120 5,700 800 11,100 11,00O0 4,200 850 1,130 9,800 12,480 9,700 830 11,600 Discount 13.9% 13.9% 13.9% 13.9% Rate O Project A O Project B O Project C O Project D O12 345Whispering Winds Company is considering a long-term investment project called ZIP. ZIP will require an investment of $130,000. It will have a useful life of four years and no salvage value. Annual cash inflows would increase by $81,000, and annual cash outflows would increase by $40,500. In addition, the company's required rate of return is 10% Click here to view the factor table (a) Calculate the net present value on this project. (If the answer is negative, use either a negative sign preceding the number eg-5,275 or parentheses es. (5,275), For calculation purposes, use 5 decimal places as displayed in the factor table provided, eg. 1.25124 and final answer to O decimal places, eg. 5,275) Net present value $ Identify whether the project should be accepted or rejected. The project should be (b) Q Search 458 PM
- Suppose you would like to invest your money for your future. You have three choices of funding agencies namely, FA 1, FA 2, and FA 3. Based on the given data below, compute for the future interest of each funding agency. What would you choose? Explain your answer. (Kindly explain your answer and put a step-by-step formula. I can't understand excel)Crane Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $164,000 $180,500 $204,000 Annual net income: Year 1 14,420 18,540 27,810 2 14,420 17,510 23,690 3 14,420 16,480 21,630 4 14,420 12,360 13,390 5 14,420 9,270 12,360 Total $72,100 $74,160 $98,880 Depreciation is computed by the straight-line method with no salvage value. The company's cost of capital is 15%. (Assume that cash flows occur evenly throughout the year.)a) the NPV for project "standard" is $19,972,824.09. (round to the nearest cent) The NPV for project "custom" is $ ??? (round to the nearest cent). How do I find the calculation for this?