Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 10% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) Pool Spa IRR Pool Spa $ (160,000) $ (105,000) % % 40,000 56,000 80,295 90,400 65,000 32,000 50,000 66,000 72,000 24,000
Q: The dean of the School of Fine Arts is trying to decide whether to purchase a copy machine to place…
A: Variables in the question:Incremental cash inflows per year=$19500n=3 yearsSalvage value=NilRequired…
Q: 1.Is the volatility index derived from the options of the constituent stocks of the S & P 500 index?…
A: Financial products known as derivatives derive their value from the price of an index or underlying…
Q: Candew Corp. buys on 5/20, net 90 days. What is the nominal cost of interest if Candew does not take…
A: Nominal Cost of Interest= (Discount / (1- Discount)) * (360 days/(Full payment days - Discount…
Q: Using the data in the table to the right, calculate the return for investing in the stock from…
A: In this question, we are required to determine the percentage return for the entire period.
Q: Problem about net present value Initial cost: $500,000 Annual energy saving: 100,000 kWh Present…
A: Making decisions about capital budgeting entails assessing and choosing capital expenditures or…
Q: After Shipra got a job, the first thing she bought was a new car. She took out an amortized loan for…
A: First we need to calculate the yearly paymentsYearly payments can be calculated by using the excel…
Q: 10. Casey purchases a $2800 engagement ring. It has a 7% sales tax and a 10% excise tax. Casey does…
A: Cost of the ring = $2800Sales tax = 7%Excise tax = 10%Discount code= $100
Q: Stock J has a beta of 1.37 and an expected return of 14.01%. Stock K has a beta of .92 and an…
A: Beta of portfolio.Bp = (Bj * Wj)+(Bk*Wk)whereBp = beta of portfolioBj = beta of stock JBk = beta of…
Q: Julie wants to create a $5,000 portfolio. She also wants to invest as much as possible in a…
A: Beta-Beta is a measure of systematic risk.A value of beta above 1- It means that the stock or…
Q: A couple will retire in 50 years, they plan to spend about 000 a year (in current dollars) in…
A: Annual savings refers to an amount that is kept aside or invested in some plan for the purpose of…
Q: At the beginning of 2007 (the year the iPhone was introduced), Apple's beta was 1.3 and the…
A: Beta: 1.3Risk free rate: 4.5%Beginning price: $82.72Closing price: $193.19Market risk premium: 6.3%
Q: You are given the following information for Smashville, Inc. Cost of goods sold: Investment income:…
A: Price-book ratio is a variable that is obtained by the latest value per share in the market divided…
Q: The Moonlight Mile Corporation wants to issue $1,000,000 of new bonds. Their bonds will have a…
A: Price / Present Value can be calculated using PV function in excelPV (rate, nper, pmt, [Fv],…
Q: Ganon Inc. is evaluating a proposal to replace its HID (high intensity discharge) lighting with LED…
A: Making decisions about capital budgeting entails assessing and choosing capital expenditures or…
Q: You need to estimate the value of Laputa Aviation. You have the following forecasts (in millions of…
A: Here,Weight of Equity50%Weight of Debt50%Cost of Equity16%Cost of Debt7%Tax Rate30%Year1234EBITDA $…
Q: Kindly show the workings for step 3.
A: The capital structure represents the proportional composition of the different sources of capital in…
Q: A new electronic process monitor costs $990,000. This cost could be depreciated at 30% per year…
A: NPV is the capital budgeting technique that an investor can use for determining the feasibility of…
Q: a. The range of S is $100 while that of P is $80 across the two states. What is the hedge ratio of…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: Witten Entertainment is considering buying a machine that costs $562,000. The machine will be…
A: NPV is also known as Net Present Value.. It is a capital budgeting technique which helps in decision…
Q: Turtle Co. has a total debt ratio of 0.78. The company is considering building a new plant for $75…
A: Flotation costs are the expenses incurred by the company when raising new capital, these costs…
Q: Express the level payment amount of the second perpetuity, P, as a function of the annual effective…
A: Effective interest rate for a perpetuity paying every two years, r = (1 + i)2 - 1Effective interest…
Q: You are given the following information concerning options on a particular stock: Stock price=…
A: a) Intrinsic value of the call option= Current price - exercise price= $83-$80Intrinsic value of the…
Q: Q1. Based on the information just given, what will be Robert’s forecast of PAMC’s growth rate? a.…
A: As per Gordan's dividend growth model (DDM), the dividend is relevant and it affects the price of…
Q: Problem 7-8 Dividend Discount Model (LO2) Rework Table 7.4 for horizon years 1, 2, 3, and 10,…
A: Dividend in year 1 = $3Growth rate = 6%Required rate = 12%
Q: The Columbia Consumer Products Co. has issued perpetua value. The firm pays a quarterly dividend of…
A: The price of a perpetual preferred stock can be calculated using the following formula:
Q: 1. What is the project NPV? 2. What is the estimated Internal Rate of Return (IRR) of the project?…
A: Capital budgeting is a financial process that businesses and organizations use to evaluate and…
Q: Walsh Company is considering three independent. projects, each of which requires a $3 million…
A: ParticularsCost of capitalIRRInvestment costProject H (High risk)17%18%$3,000,000.00Project M…
Q: An owner of the ATRIUM Tower Office Building is currently negotiating a five-year lease with ACME…
A: Base rent: $11 PSFStep-up: $1 PSF per year, starting from year 2Lease term: 5 yearsDiscount rate:…
Q: Your firm purchased an equipment from a British company. Total cost was £50,000 (in 30 days). The…
A: Determining the maximum (or minimum) strike price for the option, you will want to choose a strike…
Q: OwenInc has a current stock price of $14.30 and is expected to pay a $0.70 dividend in one year. If…
A: We need to use equation below to calculate stock price after 1 year.P1 = P0(1+r) -D1P0 = current…
Q: What are the portfolio weights for a portfolio that has 195 shares of stock A that sell for $96 per…
A: Portfolio weights refer to the proportional composition of the constituents, it is computed by…
Q: If I have a Return on Equity of -25,530%, how do I interpret that? My professor is looking for an…
A: ROE is a profitability metric. Essentially it is a measure of a given company’s annual net income…
Q: 15. (Singular) Suppose there are two stocks that are uncorrelated. Each of these has of 1, and there…
A: Giventwo uncorrelated stocks with variance of 1 and expected returns of r1 and r2, respectively,…
Q: ABC Limited Company is looking to invest in a project. The cost of that project is $60,000 and the…
A: YearsCash inflowsCash outflows0 (Initial…
Q: Problem Boatler Used Cadillac Company requires $810,000 in financing over the next two years. The…
A: Interest Cost = Amount Borrowed * Interest rate % * Number of years
Q: O Stock X has a 9.0% expected return, a beta coefficient of 0.7, and a 40% standard deviation of…
A: ParticularsStock XStock YExpected return9%12%Beta0.701.10Standard deviation40%30.0%Risk-free…
Q: PE fund Red Llama buys a company (with no existing debt or cash) for $500 million, at a purchase…
A: Earnings before interest tax depreciation and amortization commonly referred to as EBITDA is the…
Q: 1. Compute the net present value of Project A Note: Enter negative values with a minus sign. Round…
A: Net present value is determined by deducting the initial investment from the current value of cash…
Q: A company is considering a new venture that requires an upfront investment of $500,000. The project…
A: IRR is also known as Internal rate of Return. It is a capital budgeting technique which helps in…
Q: 9. Nanette Davis' home is assessed at $250,000. If the tax rate is 4.95 mills, what is the tax on…
A: Assessed value of the home = $250000Tax rate = 4.95 mills
Q: Tartan Industries Currently has total capital equal to $10 million, has zero clebt, is in the 25%…
A: Stock price:The share price refers to the value at which a single share of a company’s stock is…
Q: down by 25%. The continuously compounded risk - free interest rate is 5%. Calculate the price of an…
A: An option is an agreement between two parties granting one the opportunity to buy or sell a security…
Q: Assume the total cost of a university education will be $90,000 when your child enters university in…
A: Compound = Monthly = 12Future Value = fv = $90,000Time = t = 6 * 12 = 72Present Value = pv = $55,000
Q: Your friend will sell you his coffee shop for $475,000, with "seller financing," at a 9.0% nominal…
A: The lump-sum amount which is termed as last payment and is done at the end of the loan period is…
Q: Sheridan's Fish House can produce and sell only one of the following two products: Fried catfish…
A: In this question, we are required to determine the total contribution margin if the most profitable…
Q: The expected return from a portfolio of securities is the average of the expected returns of the…
A: Risk and return are fundamental concepts in finance that are closely linked and form the basis for…
Q: an increase in IBM's stock price would the call price. [ Select] an increase in the strike price…
A: IBM's Stock Price:Higher stock price increases the probability that call option will be in money.Due…
Q: Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate…
A: Net Present Value (NPV) assesses the profitability of an investment by calculating the present value…
Q: Charleston Water System issued 10-year bonds 4 years ago with a coupon rate of 7.5%. The bonds are…
A: Compound = Semiannually = 2Time = t = (10 - 4) * 2 = 12Coupon rate = c = 7.5 / 2 = 3.75%Quoted Price…
Q: a) An individual wishes to accumulate $1,700,000 in 20 years. If he wants to deposit a certain…
A: Future value is the amount of deposit done and amount of interest accumulated over the period of…
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
- Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 10% return from its investments. Initial investment Net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 Pool Spa IRR Pool $ (177,000) % % 41,700 57,700 81,995 92,100 66,700 Compute the internal rate of return for each of the projects using excel functions. Note: Round your answers to 2 decimal places. Spa $ (122,000) 33,700 51,700 67,700 73,700 25,700X-treme Vitamin Company is considering two Investments, both of which cost $14,000. The cash flows are as follows: Tear Project A Project B $16,000 $14,000 5,000 9,000 2 3 6.000 4,000 Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. a-1. Calculate the payback period for Project A and Project B. (Round your answers to 2 decimal places.) Project A Project B Payback Period year(s) year(s) a-2. Which of the two projects should be chosen based on the payback method? O Project A O Project B b-1. Calculate the net present value for Project A and Project B. Assume a cost of capital of 8 percent. (Do not round intermediate calculations and round your final answers to 2 decimal places.) Project A Project B Net Present ValueX-treme Vitamin Company is considering two investments, both of which cost $20,000. The cash flows are as follows: Year Project A Project B 1 $ 23,000 $ 20,000 2 10,000 9,000 3 10,000 15,000 Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. a-1. Calculate the payback period for Project A and Project B. (Round your answers to 2 decimal places.) project A 0.87 years project B 1 year b-1. Calculate the net present value for Project A and Project B. Assume a cost of capital of 8 percent. (Do not round intermediate calculations and round your final answers to 2 decimal places.)
- X-treme Vitamin Company is considering two investments, both of which cost $34,000. The cash flows are as follows: $ 36,000 Project B $ 34,000 16,000 18,000 16,000 10,000 Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. a-1. Calculate the payback period for Project A and Project B. Note: Round your answers to 2 decimal places. Year Project A 1 2 3 Project A Project B a-2. Which of the two projects should be chosen based on the payback method? Project A O Project B Payback Period year(s) year(s) b-1. Calculate the net present value for Project A and Project B. Assume a cost of capital of 12 percent. Note: Do not round intermediate calculations and round your final answers to 2 decimal places. Project A Project B Net Present ValueBelow are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT A B It is requested Initial investment. $25,000 $22,000 Cash flows year 1 1. Determine the internal rate of return. 2. Determine the present value. $7,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. 3. Determine the recovery period. 4. Define which is the most viable project. Year 2 cash flows $15,000 $8,000 Year 3 cash flows $18,000 $12,000Cash Payback Period, Net Present Value Method, and Analysis Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows: Plant Expansion Retail Store Expansion Year 1 2 3 4 5 Total Year 1 2 Each project requires an investment of $294,000. A rate of 15% has been selected for the net present value analysis. Present Value of $1 at Compound Interest 6% 10% 12% 15% 20% 0.893 0.870 0.833 0.797 0.756 0.694 3 4 5 $162,000 132,000 114,000 103,000 33,000 $544,000 6 7 8 9 10 Required: 0.909 0.826 $135,000 159,000 109,000 76,000 65,000 $544,000 0.943 0.890 0.840 0.751 0.792 0.683 0.747 0.621 0.705 0.564 0.665 0.627 0.592 0.558 0.712 0.658 0.636 0.572 0.567 0.497 0.507 0.432 0.513 0.452 0.376 0.467 0.404 0.327 0.424 0.361 0.284 0.386 0.322 0.247 1a. Compute the cash payback period for each project. Cash Payback Period 0.579 0.482 0.402 0.335 0.279 0.233 0.194 0.162 Plant Expansion Retail Store Expansion 1b. Compute the net present value.…
- Dock Company is considering a capital investment in machinery: E (Click the icon to view the data.) 8. Calculate the payback. 9. Calculate the ARR. Round the percentage to two decimal places. 10. Based on your answers to the above questions, should Dock invest in the machinery? 8. Calculate the payback. Payback years - X Data Table Initial investment $ 1,500,000 Residual value 350,000 Expected annual net cash inflows 500,000 Expected useful life 4 years Required rate of return 9% Print DoneThe internal rate of return method is used by Testerman Construction Co. in analyzing a capital expenditure proposal that involves an investment of $143,920 and annual net cash flows of $35,000 for each of the six years of its useful life. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Determine the internal rate of return for the proposal. %X-treme Vitamin Company is considering two investments, both of which cost $10,000. The cash flows are as follows: NOTE: you must show your work for ALL steps for full credit. Year Proj A Proj B 1 $ 12,000.00 $10,000.00 2 $8,000.00 $6,000.00 3 $ 6,000.00 $16,000.00 a. Which of the two projects should be chosen based on the payback method b. Which of the two projects should be chosen based on the net present value method? Assume a cost of capital of 10 percent. c. Should a firm normally have more confidence in answer a or answer b.
- Dogwood Company is considering a capital investment in machinery: (Click the icon to view the data.) 8. Calculate the payback. 9. Calculate the ARR. Round the percentage to two decimal places. 10. Based on your answers to the above questions, should Dogwood invest in the machinery? 8. Calculate the payback. Amount invested Expected annual net cash inflow Payback 1,500,000 24 500,000 3 years 9. Calculate the ARR. Round the percentage to two decimal places. Average annual operating income Average amount invested ARR Data Table Initial investment $ 1,500,000 Residual value 350,000 Expected annual net cash inflows 500,000 Expected useful life 4 years Required rate of return 15%X-treme Vitamin Company is considering two investments, both of which cost $10,000. The cash flows are as follows: Year Project A Project B 1 $ 12,000 $ 10,000 2 8,000 6,000 3 6,000 16,000 Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. a-1. Calculate the payback period for Project A and Project B. b-1. Calculate the net present value for Project A and Project B. Assume a cost of capital of 10 percent.Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?