Please answer this and kindly show the solution/computation and final answers using microsoft excel. I'll give you a like. Thank you! 6.A firm has a capital budget of $30,000 and is considering three possibleindependent projects. Project A has a present outlay of $12,000 andyields $4, 281 per annum for 5 years. Project B has a present outlay of$10,000 and yields $4,184 per annum for 5 years. Project C has a presentoutlay of $17,000 and yields $5,802 per annum for 10 years. Funds whichare not allocated to one of the projects can be placed in a bank depositwhere they will earn 15%.(a) Identify six combinations of project investments and a bank depositwhich exhaust the budget.(b) Which of the above combinations should the firm choose:(i)when the reinvestment rate is 15%?when the reinvestment rate is 20%?(ii)Explain your answer and show your calculations (spreadsheet printout isacceptable as long as entries are clearly labeled).Answer:To answer these questions it is probably best to compare future values after 10years, bearing in mind that projects with a 5-year life will have terminal valueafter 5 years which needs to compounded forward at the reinvestment rate (15%and 20%) to year 10, and the residual deposited in the bank is alwayscompounded over 10 years at a 15% interest rate.Future values are as follows:15%20%$130,876$152,092$137,652$158,387A+$18,000 in bankB+ $20,000 in bankC+$13,000 in bankA+B+$8,000 in bank$170,394$203,205$147,161$189,112B+C+$3,000 in bank$186,679$240,224A+C+$1,000 in bank.$179,904$233,929At a reinvestment rate of 15% or 20% the combination of projects B+C would bepreferred.

Capital budget= $30,000Present outlay of Project A= $12,000 Yields of Project A= $4, 281 per annum…

Answered: Please answer this and kindly show the…

Please answer this and kindly show the solution/computation and final answers using microsoft excel. I'll give you a like. Thank you!

Financial And Managerial Accounting

15th Edition

ISBN:9781337902663

Author:WARREN, Carl S.

Publisher:WARREN, Carl S.

Chapter26: Capital Investment Analysis

Section: Chapter Questions

Problem 3CMA

See similar textbooks

Related questions

Q: Two friends, Savvy Sally and Debtie Debbie, decide to make Saturday special and plan a fun family…

A: Assuming 52 weeks per year and Sally puts $100 in her account every other Saturday would make a…

Q: 1000$. The salvage value is 70,000$. Draw a CFD for the project and give the analysis of the project…

A: YearCash outflowCash inflowSalvage valueMaintenance costNet cash…

Q: Property owned by a person who dies intestate and without heirs will escheat to the A. city. B.…

A: Escheat is a legal process through which ownership of property reverts to the state when an…

Q: Create a forecast of the venture's financial performance for a shampoo brand

A: Creating a financial forecast for a shampoo brand involves estimating future revenues, expenses, and…

Q: Rapid Home Testing (RHT) is a publicly traded all-equity financed firm. RHT's cost of capital is…

A: "Since you have posted multiple questions with multiple sub-parts, we will provide the solution only…

Q: b. The salvage value of the machine is $750,000 five years from now. What is the present value of…

A: Present value refers to the current worth of the respective investment, it takes into account the…

Q: The credit card with the itemized billing statement below uses the average daily balance method to…

A: Credit cards are offered by financial institutions to customers to purchase certain items out of…

Q: Consider a 2-year bond whose par value is $1,000 and coupon rate is 4% per year, pay semi-annually.…

A: Duration of bond shows the weighted period required to receive all cash flow from bond and that…

Q: 34) Call options on ONB-listed stock options are

A: An option is an agreement between two parties granting one the opportunity to buy or sell a security…

Q: Julian and Julie are meeting with the Bank of Montreal. They know that the b ratios and they do not…

A: Total debt service is used in grant of mortgage loans and is the ratio of total monthly payment of…

Q: Total project value ($) Debt Option Loan-to-value Rate (%) Interest only period (years) Amortization…

A: Please note that the accurate calculations cannot be made as the required rate of return on the…

Q: Please describe NPV, IRR and their relationship. How do you evaluate each for making an…

A: “Since you have posted multiple questions with multiple sub parts, we will provide the solution only…

Q: Although a full liquidity analysis requires the use of a cash budget, the current and quick ratios…

A: Current or working capital ratio is a measure that depicts the short term liquidity position of a…

Q: The following table lists prices of Amazon options in January 2018 when Amazon stock was selling for…

A: Options are categorized into two major types as calls and puts where call provides a buying right to…

Q: Velcro Saddles is contemplating the acquisition of Skiers' Airbags Incorporated The values of the…

A: Net present value is computed by deducting the present value of cash outflows from the present value…

Q: f a stock's expected return as seen by the marginal investor exceeds his or her required return,…

A: Required rate of return is the minimum return that an investor expects from his investment. It is…

Q: You are considering opening a new plant. The plant will cost $100.7 million upfront and will take…

A: Capital budgeting refers to the concept used for estimating the viability of the project through…

Q: Which of the following interest rates will result in the highest amount of interest being charged?…

A: Effective Annual rate of interest(EAR) = wherei = nominal interest rate per annumn = number of…

Q: Required: a-1. What are the investment proportions in the minimum-variance portfolio of the two…

A: Risk and return are essential financial principles. The term “risk” refers to the uncertainty and…

Q: F 1.15 x e(0.0032 0.0134)×2 F-1.15 x e F _ 1.15 xe 0.0204x2 0.0408

A: e is here is euler's number and has value 2.71828

Q: Use the ERR method with e 10% per year to solve for a unique rate of return for the following…

A: Cash flow refers to the movement of money into and out of a business or financial system over a…

Q: A share of stock with a bela of 0.8 oumenity sells for $50 investors expect the stock to pay a year…

A: Expected Return = Risk free rate + Market risk premium * Beta

Q: Suppose that you are a fixed-income portfolio manager running a fully active managed fund. Which of…

A: You run a fully active managed fund as a fixed-income portfolio manager. This means that your…

Q: What is the clearing price for the following Treasury Auction, in which the US Treasury wants to…

A: Treasury bills, or T-bills, are short-term debt instruments issued by governments, with the U.S.…

Q: You inherited $300,750 and invested it at 6.25% per year. How much could you withdraw at the…

A: Withdrawal used to involve in the removing of the funds from the investment plans, savings plan,…

Q: The following table gives returns in four possible states of the world for two assets, a bond index…

A: Expected returnStock index expected return

Q: JDAR Enterprises needs someone to supply it with 156000 cartons of machine screws per year to…

A: Npv is also known as Net present Value. It is a capital budgeting techniques which helps in decision…

Q: You expect to receive $15,000 at graduation in three years. You plan on investing it at 13% until…

A: The concept of time value of money will be used here.As per the concept of time value of money the…

Q: Suppose Goodyear Tire and Rubber Company is considering divesting one of its manufacturing plants.…

A: Debt equity ratio = 2.6Weight of Equity = 2.6 / 3.6 = 72.22%Weight of Debt = 1-72.22 = 27.78%Before…

Q: A loan's quirky terms require the first payment to be made at the moment the money is lent. Payments…

A: Present-value is an estimate of the present-value of future cash values that may be received at a…

Q: The Meryl Corporation's common stock currently is selling at $100 per share, which represents a P/E…

A: P/E Ratio =10ROE =20%Debt ratio=60%stock price= $100no. of shares=100ROA=?

Q: A bond is purchased at a discount and will be accounted for under the amortized cost model. The…

A: a). The amortized cost model is used to spread the discount applied to the bond purchase over the…

Q: Find risk free rate and expected return of market portfolio based on the following information -…

A: Expected return (CAPM) = Rf+β*Rp.Rf = Risk free rate.Rp = Risk premium.

Q: A stock had returns of 14.83 percent, 19.47 percent, -17.19 percent, 12.59 percent, and 27.07…

A: Variance is the measure to explain the deviations of the individual return from the average…

Q: Ellen Quarles recently opened a savings account. If Ellen deposits $1000 and the amount compounded…

A: The amount deposited today will be more worth in future dates due to the amount of interest received…

Q: Consider a plot of land. You can construct an office building at a cost of $5m or a hotel at a cost…

A: Construction of office building:Initial investment = $5 millionNOIYear 1 = $240,000Year 2 =…

Q: Temporary Housing Services Incorporated (THSI) is considering a project that involves setting up a…

A: When making capital budgeting choices, firms and investors frequently utilize net present value…

Q: You found your dream house. It will cost you $300000 and you will put down $40000 as a down payment.…

A: Houses are a large ticket item. We do not have the cash to buy a house outright on a cash basis.…

Q: The Fitness Studio, Inc.'s, 2021 income statement lists the following income and expenses: EBITDA=…

A: EBIT = $777,500Interest expense = $116,000Taxes = $231,525No. of common shares outstanding = 100,000…

Q: n, Incorporated, declared a cash dividend of $40,500 in 2022 when the following stocks were…

Q: Samuel Samosir works for Peregrine Investments in Jakarta, Indonesia. He focuses his time and…

A: The objective of the question is to calculate the profit or loss Samuel would make if he buys call…

Q: BAK Corp. is considering purchasing one of two new diagnostic machines. Either machine would make it…

A: 1. Net Present value = Present value of cash inflows - Initial Investment2. Profitability Index =…

Q: My bank requires me to establish a four digit pin My bank requires me to establish a four digit…

A: Probability is a measure of the likelihood or chance that a specific event will occur and it is…

Q: Aram's beta is estimated to be about (Select the best choice below.)

A: Beta is a measure of a stock's volatility in relation to the market index. It helps investors assess…

Q: Use the same CMO as in the previous question and suppose that in month 10, the beginning balance on…

A: The answer you selected, 191,554, is correct. Here's how we can calculate it:Identify relevant…

Q: On Tuesday we had a quest speaker discuss his undergradaute experience and career path. Can you…

A: Zach Hudson majored in Business Administration while at Kennesaw State…

Q: TopCap Company is evaluating the purchase of another sewing machine that will be used to manufacture…

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Q: 1) Titiwangsa Corporation is using a computer where its original cost was RM25,000. The machine is…

A: The asset should generate positive NPV if it is feasible to accept and replace with the old machine.…

Q: There are two risky assets, and their volatilities are 8% (Asset 1) and 24% (Asset 2). Their return…

A: If two Assets (i.e Asset 1 and Asset 2) are perfectly negatively correlated i.e their return…

Q: You have the following probability distribution of returns for XYZ company. Calculate the expected…

A: r1=19%r2=8.5%r3=-18.0%p1=25%p2=50%p3=25%

Question

Please answer this and kindly show the solution/computation and final answers using microsoft excel. I'll give you a like. Thank you!

6.
A firm has a capital budget of $30,000 and is considering three possible
independent projects. Project A has a present outlay of $12,000 and
yields $4, 281 per annum for 5 years. Project B has a present outlay of
$10,000 and yields $4,184 per annum for 5 years. Project C has a present
outlay of $17,000 and yields $5,802 per annum for 10 years. Funds which
are not allocated to one of the projects can be placed in a bank deposit
where they will earn 15%.
(a) Identify six combinations of project investments and a bank deposit
which exhaust the budget.
(b) Which of the above combinations should the firm choose:
(i)
when the reinvestment rate is 15%?
when the reinvestment rate is 20%?
(ii)
Explain your answer and show your calculations (spreadsheet printout is
acceptable as long as entries are clearly labeled).
Answer:
To answer these questions it is probably best to compare future values after 10
years, bearing in mind that projects with a 5-year life will have terminal value
after 5 years which needs to compounded forward at the reinvestment rate (15%
and 20%) to year 10, and the residual deposited in the bank is always
compounded over 10 years at a 15% interest rate.
Future values are as follows:
15%
20%
$130,876
$152,092
$137,652
$158,387
A+$18,000 in bank
B+ $20,000 in bank
C+$13,000 in bank
A+B+$8,000 in bank
$170,394
$203,205
$147,161
$189,112
B+C+$3,000 in bank
$186,679
$240,224
A+C+$1,000 in bank.
$179,904
$233,929
At a reinvestment rate of 15% or 20% the combination of projects B+C would be
preferred.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Given

VIEW

Step 2: Calculation

VIEW

Solution

VIEW

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Jasmine Manufacturing is considering a project that will require an initial investment of $52,000 and is expected to generate future cash flows of $10,000 for years 1 through 3, $8,000 for years 4 and 5, and $2,000 for years 6 through 10. What is the payback period for this project?
Redbird Company is considering a project with an initial investment of $265,000 in new equipment that will yield annual net cash flows of $45,800 each year over its seven-year life. The companys minimum required rate of return is 8%. What is the internal rate of return? Should Redbird accept the project based on IRR?
Project Z has an initial investment of $81,670.00. The project is expected to have cash inflows of $26,478.00 at the end of each year for the next 14.0 years. The corporation has a WACC of 13.82%. Calculate the NPV for project Z.
Project Alpha requires an immediate investment of $16,000 and an additional investment of $12,000 in three years. Net returns are estimated to be $8,000 after two years, $24,000 after four years, and $18,000 after seven years. Project Omega requires an immediate investment of $8,000, an additional investment of $12,000 after two years and $8,000 after six years. Net returns are estimated to be $6,800 annually at the end of each year for seven years. The cost of capital is 10%. Required: Determine which project is preferable using the net present value criterion.
A capital budgeting project has a net investment of $550,000 and is expected to generate net cash flows of $200,000 annually for 7 years. What is the payback period? 5 years 25 years 55 years 75 years
An Investment project provides the cash flow inflows of $615 per year for 8 years. a) What is the project payback period if the initial cost is $1,750? X years. b) What is the project payback period if the initial cost is $3,400? X years. c) WHat is the project payback period if the initial cost is $5,100 X years.
What is the NPV of a project that costs $38,000 today and is expected to generate annual cash inflows of $9,000 for the next 7 years, followed by a final inflow of $15,000 in year 8. Cost of capital is 7.4%. Round to the nearest cent.
The company is considering two projects. The initial investment in the Project A and Bare $50,000 and $60,000 respectively. The Project A will generate annual cash flows of$26,000 for four years and the Project B will generate annual cash flows of $30,000 forfour years. What must be the required rate of return, so that the company will beindifferent between these two projects?(A)The required rate of return must be 21.86%.(B) The required rate of return must be 37.42%.(C)The required rate of return must be 34.90%.(D) The required rate of return must be 31.39%.
NPV Calculate the net present value (NPV) for the following 15-year projects. Comment on the acceptability of each. Assume that the firm has a cost of capital of 9%. A. Initial investment is $1,000,000; cash inflows are $150,000 per year. B. Initial investment is $2,500,000; cash inflows are $320,000 per year. C. Initial investment is $3,000,000; cash inflows are $365,000 per year.
11. Ace Inc. is evaluating two mutually exclusive projects-Project A and Project B. The initial cash outflow is $50,000 for each project. Project A results in cash inflows of $17,525 at the end of each of the next five years. Project B results in one cash inflow of $99,500 at the end of the fifth year. The required rate of return of Ace Inc. is 10 percent. Ace Inc. should invest in: a. Project B because it has no cash inflows in the first four years of its life. b. Project B because it has a positive net present value (NPV). c. Project A because it will yield cash every year for five years. d. Project A because it has a positive net present value (NPV). e. Project A because it has a higher net present value(NPV) than B.