Consider an investment where the cash flows are: – $946.21 at time t = 0 (negative since this is your initial investment) $377 at time t= 1 in years $204 at time t = 2 in years $499 at time t = 3 in years (a) Use Excel's "Solver" to find the internal rate of return (IRR) of this investment. Take a screen shot showing Solver open with your entries for the function clearly visible. Paste the screen shot into an application (like Paint), and save it as a (.png) file. Upload your screenshot below. (b) What is the value of IRR found by Solver?
Q: You need to estimate the value of Laputa Aviation. You have the following forecasts (in millions of…
A: Here,Weight of Equity60%Weight of Debt40%Cost of Equity17%Cost of Debt8%Tax Rate30%After Tax Cost of…
Q: CFo CF1 i = 12% CF2 CF3 CF4 CF5
A: MIRR is modified form of IRR in which it is assumed that reinvestment is done on the basis of cost…
Q: You have $56,000. You put 24% of your money in a stock with an expected return of 12%, $32,000 in a…
A: Expected return of portfolio is computed as follows:-Rp = Rp = Expected return of portfolioRi =…
Q: Bailey, Inc., is considering buying a new gang punch that would allow them to produce circuit boards…
A: NPV is also known as Net Present Value.. It is a capital budgeting technique which helps in decision…
Q: Portage Bay Enterprises has $1 million in excess cash, no debt, and is expected to have free cash…
A: Stock price refers to the price at which the shares are bought and sold by the investors in the…
Q: The payback method helps firms establish and identify a maximum acceptable payback period that helps…
A: When the time taken by the investment to get back the initial cost out of its own cash flows is…
Q: Yoo, Incorporated, has arranged a line of credit that allows it to borrow up to $42 million at any…
A: Interest paid refers to an amount that is paid by the borrower to the lender on the loan amount at…
Q: The company has 81,000 bonds with a 30-year life outstanding, with 15 years untilmaturity. The bonds…
A: The objective of the question is to calculate the costs of the individual capital components,…
Q: Calculate the convexity of a 4-year annuity-immediate with payments of $100, $100, $200, and $300.…
A: COnvexity refers to the relationship between the duration and interest rate of bond describing the…
Q: Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital…
A: MIRR stands for modified internal rate of return. MIRR is used to evaluate if a project is…
Q: Portia Grant is an employee who is paid monthly. For the month of January of the current year, she…
A: Gross earnings$8260Less: DeductionsSocial security tax$512.12= $8260*6.2%Medicare tax$119.77=…
Q: Harvey's Industrial Plumbing Supply's target capital structure consists of 40% debt and 60% equity.…
A: The residual dividend policy:When a company follows a residual policy, it usually meets the capital…
Q: Market price Outstanding units Book value Cost of capital Equity $30.00 120,000 $3,000,000 15%…
A: WACC is the cost of capital and is the weighted cost of equity ,weighted cost of debt and weighted…
Q: Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.)…
A: Amortization is to divide loan into equal payments that carry the payment for loan and payment for…
Q: firm is in the 25% marginal tax bracket. 1. If the firmis fully equity-financed, what is its value?…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: An investor requires an effective return of at least 20 % per year. Find the minimum annual nominal…
A: According to bartleby guidelines , if question involves multiple sub parts , then 1st sub 3 parts…
Q: Which one of the following statements is true of E-commerce? Question 13Answer a. It involves the…
A: The objective of the question is to identify the correct statement about E-commerce among the given…
Q: Oxford Company has limited funds available for investment and must ration the funds among four…
A: Net Present Value (NPV): Positive NPV indicates project viability; choose projects with higher NPV…
Q: a. Lenovo company's bond pays 7% coupon rate. The coupon is paid semiannually, and the bond has 20…
A: Compound = Semiannually = 2Coupon Rate = c = 7 / 2 = 3.5%Time = t = 20 * 2 = 40Yield to Maturity = r…
Q: Your client has $103,000 invested in stock A. She would like to build a two-stock portfolio by…
A: Expected return refers to the rate of return that is being earned by investors over the amount of…
Q: Larsons Inc. shows the following capital accounts before a 10% stock dividend. Common stock…
A: Ans. A) After a 10% stock dividend, the common stock will increase by 10% while the capital in…
Q: What is the future value on December 31, Year 11, of 20 cash flows of $15,000 with the first cash…
A: Compound = Semiannually = 2Number of Payment = n = 20Cash Flow = cf = $15,000Interest Rate = r = 10…
Q: Suppose your firm is seeking a three-year, amortizing $400,000 loan with annual payments, and your…
A: Compensating balance refers to the minimum balance needs to be maintained in the bank savings…
Q: What would be your future account value if you invested $175 each month into a growth mutual fund…
A: Solution:-When an equal amount is saved each period at end of period, it is called ordinary…
Q: Market Values of Capital• The company has 81,000 bonds with a 30-year life outstanding, with 15…
A: The objective of the question is to calculate the Weighted Average Cost of Capital (WACC) for the…
Q: A project has annual cash flows of $4,500 for the next 10 years and then $9,000 each year for the…
A: Net Present Value or NPV refers to the capital budgeting technique used for evaluating the…
Q: 3. Understanding the IRR and NPV The net present value (NPV) and internal rate f return (IRR)…
A: Capital budgeting process is used to evaluate the profitability of the projects using time value of…
Q: You have a portfolio consisting of four stocks (A, B, C, and D). You invest $2,000 in Stock A,…
A: Total portfolio value is calculated belowWeight of each stock is calculated below
Q: (Related to Checkpoint 7.1) (Expected rate of return and risk) B. J. Gautney Enterprises is…
A: Investment expected return=ΣProbability * Return.
Q: You are saving for retirement. To live comfortably, you decide you will need to save $4 million by…
A: Future Value = fv = $4 millionInterest Rate = r = 3%Time = t = 65 - 34 = 31
Q: Suppose Johnson & Johnson and Walgreen Boots Alliance have expected returns and volatilities shown…
A: Expected returnStandard deviationsInvestment amountJohnson & Johnson7.2%14.8%$10,000.00Walgreens…
Q: Information on four investment proposals is given below: Investment required Present value of cash…
A: The profitability index is used to determine the attractiveness of an investment. It is computed by…
Q: Date 1 Mo 3 Mo N/A 5.87 5.50 NIA 5.69 5.44 NIA 5.37 5.20 4.77 Look at the yields for 01/02/01 in the…
A: An illustration of the interest rates or yields on financial instruments with varying maturities at…
Q: Suppose that all investors have the disposition effect. A new stock has just been issued at a price…
A: Stock Valuation:Stock valuation involves analyzing various financial metrics, such as earnings, cash…
Q: Peaceful Cruises wants to build a new cruise ship that has an initial investment of $300 million. It…
A: Note : As per guideline we can solve only one question at a time so kindly post the other questions…
Q: A fund manager owns a portfolio of 10 stocks. Explain how the manager can reduce the systematic risk…
A: A fund manager seeking to reduce the systematic risk of a portfolio can employ futures contracts on…
Q: Duo Corporation is evaluating a project with the following cash flows. The company uses a discount…
A: Here,YearCash flows0 $-15,400.001 YearCash flows0 $-15,400.001 $ 6,500.002 $ 7,700.003 $…
Q: Gifts For All has projected sales for next year of: Q1 Q2 Q3 Sales $ 25,400 $ 27,600 $ 34,000 Q4 $…
A: Payment to suppliers for Q2 = Q2 sales* purchase % of next quarter sales* accounts Payable period…
Q: A company currently has earnings (Eo) of $5.00 and a dividend (Do) of $0.50. The firm's current…
A: The return on equity assesses a company's profitability in relation to the equity of its owners. It…
Q: Compute the interest paid on a 30-year mortgage for $216,427 if the annual interest rate is 3.8
A: Payment per period can be calculated using PMT function in excel.PMT(rate, nper, pv, [fv],…
Q: Question 4 When a firm purchases shares directly from a major shareholder it is also known as a(n) O…
A: The correct answer to the question is "targeted repurchase".Targeted repurchase is used to avoid…
Q: Which of the following portfolios should a risk averse investor choose? Portfolio Name σ(rP) Sharpe…
A: A risk averse investor looks to minimize risk and maximize the returns.Lower Standard deviation…
Q: If you are planning an acquisition that is motivated by trying to acquire expertise, you are…
A: In the context of strategic business acquisitions centered on expertise, the primary objective is…
Q: 2. (30%) Antonio & Raquel (A&R) wedding planners are considering the purchase of a luxurious…
A: IRR is also known as Internal rate of Return. It is a capital budgeting technique which helps in…
Q: You are interested in buying the preferred stock of a bank that pays a dividend of $1.65 every…
A: Value of stock is calculated by following formula:-Value of stock =
Q: What is the beta for ABC's stock. Please round to the nearest 100th (ex. X.XX) O 1.10 0.98 1.19 1.25
A: The beta is a metric of an investment portfolio's overall volatility or systematic risk relative to…
Q: Your division is considering two projects with the following cash flows (in millions): 0 1 2 3…
A: Internal Rate of Return or IRR refers to the percentage of return an investment generates with the…
Q: What is the modified duration for a three-year, semi-annual pay, $1,000 par value, 8.00% coupon bond…
A: Duration of bond shows the weighted period required to recover all cash flow from bond and shows the…
Q: 2.When comparing two projects with different lives, why do you compute an annuity with an equivalent…
A: Net present value (NPV) is the difference between the present value of cash inflows and the present…
Q: cullumber, inc has a bond issue maturing in seven years that is paying a coupon rate of 7.5 percent…
A: A bond is a kind of debt security issued by the government and private companies to the public for…
Step by step
Solved in 4 steps with 3 images
- For the following incremental cash flow series, use a spreadsheet to find all rate of return values between 0% and 100%.1. If you perform a NPV analysis on a perspective investment using a "d" = 15% and: a. the NPV Is < 0, what can you tell me about the investment's IRR (time adjusted rate of return)? b. the NPV is > 0, what can you tell me about the investment's IRR (time adjusted rate of return)? c. the NPV is= 0, what can you tell me about the investment's IRR (time adjusted rate of return)? 2. We presume in Investment analysis that the payback method of evaluation is a better measure of.................than it is a measure of...................... We also think less of the payback method because it sometimes ignores the............., ..................of an investment since the................. the oftentimes occurs after the payback period has lapsed. 3. Please explain why we oftentimes equate EBITDA (earnings before subtracting] interest, taxes, depreciation & amortization) with NOI (net operating income) in examining business' profitability. Why don't…Assume that an investment is expected to generate the following returns: a 10% chance of a $1,400 return, a 50% chance of a $6,600 return, and a 40% chance of a $1,500 return. What is the expected rate of return on this investment? Note: The solution must be displayed on an Excel sheet using Excel functions such as =PV(...) and =FV(...) etc.
- Tick all those statements that are correct. The internal rate of return (IRR) generated by a positive cash flow stream of n payments a. is always smaller or equal than +1 O b. is always bigger or equal than -1 O C. can be 17 for a suitable cashflow O d. is always given by the solution of a quadratic equation can be -2 for a suitable cashflow e.Reset the Data Section of the CAPBUD2 worksheet to the original values. In requirement 4, you assessed the sensitivity of the investment’s internal rate of return to changes in some of the input data. This was done in a trial-and-error fashion. Click the Chart sheet tab. Presented on the screen is a graphical analysis of the sensitivity of the internal rate of return to changes in annual cash flows. To demonstrate the usefulness of such a chart, note the ease with which you are able to answer the following questions that might be of interest to the owner: What annual cash flow (approximately) is required to: earn 0% rate of return? _______________ earn 10% rate of return? _______________ earn over 20% rate of return? _______________ Approximately, how much is the rate of return reduced for each drop of $10,000 annual cash flow? When the assignment is complete, close the file without saving it again. Worksheet. The CAPBUD2 worksheet handles only cash inflows that are even in amount each year. Many capital projects generate uneven cash inflows. Suppose that the new store had expected cash earnings of $80,000 per year for the first two years, $140,000 for the next four years, and $220,000 for the last four years. The new store will generate the same total cash return ($1,600,000) as in the original problem, but the timing of the cash flows is different. Alter the CAPBUD2 worksheet so that the NPV and IRR calculations can be made whether there are even or uneven cash flows. When done, preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as CAPBUDT. Hint: One suggestion is to label column F in the scratch pad as Uneven cash flows. Enter the uneven cash flows for each year. Modify FORMULA3 to include these cash flows. Modify the formulas in the range E30 to E39 to include the new data. Then set cell E10 (estimated Annual Net Cash Inflow) to zero. When you have even cash flows, use cell E10 and set column F in the scratch pad to zeros. If you have uneven cash flows, set cell E10 to zero and fill in column F in the scratch pad. Note that this solution causes garbage to come out in cells E15 and E16 because those formulas were not altered. Check figure for uneven cash flows: NPV (cell E17), $68,674. Chart. Using the CAPBUD2 file, develop a chart just like the one used in requirement 6 to show the sensitivity of net present value to changes in cost of the investment amount from $440,000 to $500,000 (use $10,000 increments). Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as CAPBUD2. Print the chart.Determine the present value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) Determine the present value of the following single amounts. Note: Use tables, Excel, or a financial calculator. Round your final answers to nearest whole dollar amount. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) 1. 2. 3. 4. Future Amount $ 25,000 $ 19,000 $ 30,000 $ 45,000 ¡= 6% 10% 12% 11% n = 11 14 29 10 Present Value
- Monty Company manufactures automobile components for the worldwide market. The company has three large production facilities in Virginia, New Jersey, and California, which have been operating for many years. Brett Harker, vice president of production, believes it is time to upgrade operations by implementing computer-integrated manufacturing (CIM) at one of the plants. Brett has asked corporate controller Connie Carson to gather information about the costs and benefits of implementing CIM. Carson has gathered the following data: Initial equipment cost $ 7,400,000 Working capital required at start-up $ 600,000 Salvage value of existing equipment 2$ 107,400 Annual operating cost savings $ 1,202,880 Salvage value of new equipment at end of its useful life $ 286,400 Working capital released at end of its useful life $ 600,000 Useful life of equipment 10 years Monty Company uses a 12% discount rate. Click here to view the factor table.Capital asset pricing model (CAPM) For the asset shown in the following table, use the capital asset pricing model to find the required return. (Click on the icon here O in order to copy the contents of the data table below into a spreadsheet.) ne Risk-free Market rate, R return, rm Beta, b nts 4% 0.7 1% The required return for the asset is %. (Round to two decimal places.) eТext edia Librai ial Calculat er Resource Enter your answer in the answer box and then click Check Answer. Check Answer mic Study ules Clear All All parts showing 10: DExercise(14); ools > This course (Introduction to Finance (FIN-101-D02) Distance Spring 2021) is hased on Zutter/Smart Princinles of Managerial Finance Rrief Re 4/13 O Type here to search insertPlease calculate CAPM of Asset J with the following information: where, kj = required return on asset j, Rf = risk-free rate of return, (6%) bj = beta coefficient for asset j, (1.75) %3D Rm = market return. (10%) The equation for CAPM is kj = Rf + [bj x (Rm - Rf)] kj = Solve for required return on asset j (kj is CAPM) Please be detailed when answering and show all work, thank you.
- nd the present value of the following ordinary annuities. (Notes: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in many situations, to see how changes in input variables affect the output variable. Also, note that you can leave values in the TVM register, switch to Begin Mode, press PV, and find the PV of the annuity due.) Do not round intermediate calculations. Round your answers to the nearest cent. $600 per year for 10 years at 12%. $ $300 per year for 5 years at 6%. $ $600 per year for 5 years at 0%. $ Now rework parts a, b, and c assuming that payments are made at the beginning of each year; that is, they are annuities due. Present value of $600…Can you have an investment with DCFRR > MARR, but NPV $0 (calculating NPV with iTyM=MARR)? Can you have an investment with DCFRR < MARR, and NPV < $0 (calculating NPV with iTyM=MARR)?P 9-2 Investment Scenarios (LO 9-3) Arkansas Best Freightways is considering a purchase of three different potential trucks but is uncertain of the cash inflows associated with the following investment scenarios. Year Year 0 (today) Year 1 Year 2 Year 3 Year 4 Buy new truck Increased profits Increased profits Increased profits Increased profits Investment 1 (85,000) 25,000 25,000 25,000 25,000 Investment 2 (105,000) 20,000 30,000 40,000 50,000 Investment 3 (125,000) 40,000 30,000 20,000 10,000