Consider an investor's choice of a farm unit in the Corn Belt, one in the California Central Valley, or the one in the Great Plains region. An investor added these three assets in one portfolio. The portfolio composed of equal proportions of the three investments. Use the information in the table below to answer the questions that follows (show all your work for partial credits). Corn Belt (1) r₁=0.14 01-0.08 Weight in Portfolio W₁=0.3 Correlation Among Investment 1 and 2 (012) = 0.30 1 and 3 (13) = -0.40 2 and 3 (023) = 0.50 Exp. Return Std. Dev. Investment Alternatives Central Valley (2) r₂=0.12 O2=0.05 W2=0.4 Great Plains (3) r3=0.07 03=0.01 W3=0.3 Portfolio Data for Financial Servicing Analysis Under Risk a. Calculate the expected return of the portfolio.

Consider an investor's choice of a farm unit in the Corn Belt, one in the California Central Valley, or the one in the Great Plains region. An investor added these three assets in one portfolio. The portfolio composed of equal proportions of the three investments. Use the information in the table below to answer the questions that follows (show all your work for partial credits). Corn Belt (1) r₁=0.14 01-0.08 Weight in Portfolio W₁=0.3 Correlation Among Investment 1 and 2 (012) = 0.30 1 and 3 (13) = -0.40 2 and 3 (023) = 0.50 Exp. Return Std. Dev. Investment Alternatives Central Valley (2) r₂=0.12 O2=0.05 W2=0.4 Great Plains (3) r3=0.07 03=0.01 W3=0.3 Portfolio Data for Financial Servicing Analysis Under Risk a. Calculate the expected return of the portfolio.

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter10: The Basics Of Capital Budgeting: Evaluating Cash Flows

Section: Chapter Questions

Problem 23SP: Start with the partial model in the file Ch10 P23 Build a Model.xlsx on the textbooks Web site....

See similar textbooks

Similar questions

Question 5 Investment products have different probabilities of success. A businessman wishes to invest in two different products, A and B. The following table shows the probability distributions, where P(a, b) represents the probability of success of the ith investment of A and the ih investment of B, for the values (in thousands of GH¢) for A and B invested in 4 different years. Base on this information: (a) (b) (c) A B P(a,b) 3 6 0.3 2 4 0.2 5 3 0.4 1 2 0.1 Which of the investments has a better return and why? Which of the investments is relatively less risky and why? What type of association exists between the two investment options A and B? Interpret your results.
Two investments have the following pattern of expected returns: Investnent A Year 1 $5, 100 Year 2 $10,100 Year 3 Year 4 Year 4 (Sale) $121,000 STCF $12,100 $15,100 Investment B Year 1 $2,100 Year 2 $4,100 Year 3 $1,100 Year 4 Year 4 (Sale) $181,000 BTCF $5,100 Investment A requires an outlay of $111,000 and Investment B requires an outlay of $121,000. Required: a. What is the BTIRR on each investment? b. If the BTIRR were partitioned based on BTCF, and BTCF, what proportions of the BTIRR would be represented by each? c. Which investment would be preferable?
Module 02 Written Assiqnment Application of Future Value and Present Value.xlsx - OpenOffice Calc File Edit View Insert Format Iools Data Window Help ABC 《的, ABC Verdana 10 В I U 三開 % 0 □ A B G H I 1. Assume an investment of $2,000 today. Calculate the FV of the investment according to eac 6. 7 a. 6 percent compounded annually 8 9. Rate 6% 10 Nper PMT 12 11 12 PV $2,000.00 $0.00 13 FV 14 15 b. 8 percent compounded annually 16 17 Rate 8% 18 Nper 12 19 PMT 20 PV $2,000.00 21 FV 22 23 c. 10 percent compounded annually 24 25 Rate 10% 26 Nper 12 27 PMT 28 PV $2,000.00 29 FV 30 31 d. 10 percent compounded semiannually 32 Rate K Future Value Present Value 33 10% STD Sheet 1/2 PageStyle Future Value
Solving for Unknown Variables for Different Investments Solve for the unknown variables in each of the four separate investment scenarios. Assume interest is compounded annually in each case. Round final answer to the nearest whole number or percentage point. Use a negative sign only for an amount related to PV. Investment 1 Investment 2 Investment 3 Investment 4 RATE Answer 7% 4% 6% NPER 4 Answer 12 10 PV $(14,500) $(63,800) Answer $(237,800) FV $23,200 $101,500 $52,200 Answer
ata table K Fabulous Fabricators needs to decide how to allocate space in its prod year. It is considering the following contracts: E a. What are the profitability indexes of the projed Data Table b. What should Fabulous Fabricators do? a. What are the profitability indexes of the projects? The profitability index for contract A is *** Contract A B C ck on the following icon in order to copy its contents into a spreadsheet.) Use of Facility 100% 60% 40% NPV $1.98 million $1.02 million $1.53 million (Round to two decimal places
Q2 Your investment client has been offered the following two mutually exclusive investments: Year Investment A Investment B 0 (400,000) (450,000) 1 75,000 60,000 2 75,000 60,000 3 100,000 125,000 4 100,000 125,000 5 100,000 125,000 6 140,000 125,000 (i) Calculate the Payback period and the…
You have been given the following return data, on three assets-A, B, and C-over the period 2021-2024. Using these assets, you have isolated three investment alternatives: a. Calculate the average portfolio return for each of the three alternatives. b. Calculate the standard deviation of returns for each of the three alternatives. c. On the basis of your findings in parts a and b, which of the three investment alternatives would you recommend? Why? OCTOB a. Calculate the portfolio return over the 4-year period for each of the 3 alternatives. Alternative 1: 7.00% (Round to two decimal places.) Alternative 2: 7.00% (Round to two decimal places) Alternative 3: 7.00% (Round to two decimal places.) b. Calculate the standard deviation of returns over the 4-year period for each of the 3 alternatives. Alternative 1: % (Round to three decimal places)
Tom Alexander has an opportunity to purchase any of the investments shown in the following table Investment Price Single cash inflow Year of Receipt A $18,000 $30,000 5 B $600 $3,000 20 C $3,500 $10,000 10 D $1,000 $15,000 40 The purchase price, the amount of the single cash inflow, and its year of receipt are given for each investment. Which purchase recommendations would you make, assuming that Tom can earn 10% on his investments? The present value of Investment A is $ The present value of Investment B is $ The present value of Investment C is $ The present value of Investment D is $ Which purchase recommendations would you make, assuming that Tom can earn 10% on his investments? A.Investment B B.Investments A and C C.Investments B and C D.Investment D
Exercise 3-11 (Algo) Compare investment alternatives LO 3-2 Your friend has two investment opportunities that she is considering and has asked for your advice regarding how she should proceed. One will have an 10.0% rate of return on an investment of $540; the other will have a 14.0% rate of return on an investment of $760. She would like to take advantage of the higher-yielding investment but has only $540 available. Required: What is the maximum rate of interest that your friend should be willing to pay to borrow the $220 needed to take advantage of the higher yield? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Maximum rate of interest % 4 27
According to Wald's criterion, which investment is decided by looking at the profitability of three investments such as S1, S2 and S3 in the following economic environments? Ekonomik Durumlar S1 S2 S3Canlı Ekonomik Durum 13 6 7Normal Ekonomik Durum 10 9 8Durgun Ekonomik Durum 7 14 4Resesyon Durumu 8 7 15 Economic Conditions S1 S2 S3 Vivid Economic Situation 13 6 7 Normal Economic Condition 10 9 8 Stagnant Economic Condition 7 14 4 Recession Condition 8 7 15
es The four people below have the following investments. Invested Amount $ 11,800 14,800 21,800 17,800 Jerry Elaine George Kramer Req 1A Interest Rate Required: 1-a. Calculate the future value at the end of three years. (FV of $1, PV of $1, FVA of $1, and PVA of $1) 1-b. Who has the greatest investment accumulation? Req 1B Jerry Elaine George Kramer 12% 8 7 9 Complete this question by entering your answers in the tabs below. Compounding Quarterly Semiannually Future Value Annually Annually Calculate the future value at the end of three years. Note: Use Excel or a financial calculator. Round your answers to 2 decimal places. 2
Instruction: Use the table below to acquire information and answer the following questions. Please do not use signs like Rs., $, % etc in your answer. If you calculate percentage as 10.23% than answer must write like 10.23 only (do not write like 10.23% or 0.1023) Year 0 1 2 3 4 Cash flows −$950 $525 $485 $445 $405 Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's discounted payback in years? Answer should correct up to 2 decimal places. Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's net present value? Ms ABC is considering an opportunity of a new investment that has the following cash flow and weighted average cos of capital is 13 percent. What is the project's profitability index? Answer should correct up to 2…