Olive Company is considering a project that is estimated to cost $279,000 and provide annual net cash flows of $66,023 for the next five years. Required: Calculate the internal rate of return for this project using Excel. Note: Round your answer to 2 decimal places. Internal Rate of Return

Olive Company is considering a project that is estimated to cost $279,000 and provide annual net cash flows of $66,023 for the next five years. Required: Calculate the internal rate of return for this project using Excel. Note: Round your answer to 2 decimal places. Internal Rate of Return

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 18EB: Garnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the...

See similar textbooks

Related questions

Q: a. Find the present values of the following cash flow streams at a 9% discount rate. Do not round…

A: Present value refers to the current value of the future expected ash flows discounted with given…

Q: sed on the interest rates and cash flows shown in the cash flow diagram, determine the alue of $X.…

A: In economic equivalent present value of cash inflows and present value of outflow must be equivalent…

Q: (Related to Checkpoint 5.4) (Present value) Sarah Wiggum would like to make a single investment and…

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

Q: Cost of common stock equity Ross Textiles wishes to measure its cost of common stock equity. The…

A: Dividends are payments a business gives to its stockholders as a means of sharing earnings. They are…

Q: Elijah took out a mortgage of $672,000 for a house and just made the 113th end of month payment.…

A: The monthly payments on the loan amount can be found by using the Excel sheet formula function PMT…

Q: Basic bond valuation Complex Systems has an outstanding issue of $1,000-par-value bonds with a 13% c…

A: Price of bond is the present value of coupon payments and plus present value of the face value of…

Q: Light emitting diode (LED) light bulbs have become required in recent years, but do they make…

A: The objective of this question is to determine the break-even cost per kilowatt-hour at which it…

Q: part b is incorrect. Can you rework it?

A: Here,Quarter Dividend is $1.50Growth Rate is 6.25%Required Return is 9%Quarterly Required Return is…

Q: Compute the amount of the monthly payment on a 5-year, $43,000 car loan with an annual interest rate…

A: Monthly payments can be defined as the part repayment of the loan which is structured such that the…

Q: The Cost of Debt and Flotation Costs. Suppose a company will issue new 25-year debt with a par value…

A: The after-tax cost of debt refers to the effective interest rate that a company pays on its debt…

Q: Suppose you want to purchase a patent which will give you $7000 a year forever and will grow at a…

A: Internal rate of return refers to the capacity of the asset or project to generate return on the…

Q: PC Shopping Network may upgrade its modem pool. It last upgraded 2 years ago, when it spent $115…

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

Q: Consider stock XX Coupon rate: 12,6% per year Yield to maturity: 9,5% per year Settlement date: 9…

A: Coupon bonds are financial instruments that, up to the bond's maturity date, provide the bondholder…

Q: 15. If the amount required is $10,000 after 5 years at 3% compounded monthly, what is the monthly…

A: Inorder to accumulate a given amount of money or equivalent to the given present value, periodic…

Q: Calculate the exponential three-month moving average for both stocks where two-thirds of the average…

A: A closing price represents the last transaction value at the end of a particular trading day. It…

Q: You want to retire at age 65. You decide to make a deposit to yourself at the end of each year into…

A: The Future Value of Annuity Payments refers to the value of a series of cash flows (payments or…

Q: Benson Company has an opportunity to purchase a forklift to use in its heavy equipment rental…

A: Payback period refers to the method of capital budgeting used for calculating the time consumed for…

Q: Your firm's preferred stock pays a dividend of $5.77 per year. The current price of the preferred…

A: Solution:Preference shares are the shares which get priority over common shareholders at the time of…

Q: Avicorp has a $10.9 million debt issue outstanding, with a 6.1% coupon rate. The debt has…

A: Debt refers to borrowings made by a company. A company has to pay periodic interest or coupon…

Q: The Fl Corporation's dividends per share are expected to grow indefinitely by 6% per year. a. If…

A: Here,Growth rate (g) is 6%Expected Dividend (D1) is $7.00Market Capitalization Rate (Ke) is 8%

Q: What is the duration of an 8% semi-annual payment one-year note that currently sells at par? Face…

A: Macaulay duration refers to the measurement of the weighted average time consumed to receive cash…

Q: Suppose you have taken out a $125,090 fully amortizing fixed rate mortgage loan that has a term of…

A: A mortgage refers to a covered loan that is borrowed for purchasing a property with the property…

Q: Miracle has a mortgage of $257,000 through her bank for property purchased. The loan is repaid by…

A: The given problem can be solved using =IPMT(rate, per, nper, pv, [fv], [type]) function in excel…

Q: Anushka and Benicio borrowed $47,000 at 7% compounded semi-annually as a second mortgage loan…

A: Loan amortization involves paying off a debt over time in equal installments. Part of each payment…

Q: No. Advertising Expenditure (x) Membership Subscriptions (y) 1 51 62 2 58 68…

A: The objective of the question is to forecast the 2024 membership using the moving average method.…

Q: You need to estimate the value of Laputa Aviation. You have the following forecasts (in millions of…

A: Weight of debt = 50%Weight of equity =50%Cost of debt = 10%Cost of equity = 19%Tax rate = 30%Year…

Q: eBook Ippose TRF = 3%, TM = 9%, and b; = 1.4. a. What is r, the required rate of return on Stock i?…

A: Risk-free rate =3%Rm=9%Beta = 1.4

Q: What is accounting make a list of sub subject

A: Meaning of accounting: It is the process of recording financial transaction of a firm, company or of…

Q: Find the size of each of 9 payments made at the end of each year into a 8% rate sinking fund which…

A: An annuity is used to fulfill a financial goal by making regular payments at a specific interest…

Q: As with most bonds, consider a bond with a face value of $1,000. The bond's maturity is 13 years,…

A: A bond refers to an instrument that is used to raise debt capital for the issuing company from…

Q: On June 1st, 2020, Coca Cola (KO) issued bonds for one billion dollars. The bonds have a par value…

A: The entire return received or lost on an investment throughout the course of its holding is known as…

Q: he $37.7 million lottery payment that you just won actually pays $2.9 million per year for 13 years.…

A: Present value is current value of future cash flow discounted at an appropriate discount rate; in…

Q: Explain the role of the main counterparties (sponsors) to a concession agreement under a Special…

A: The main counterparties or sponsors in a concession agreement under a Special Purpose Vehicle (SPV)…

Q: A bond with face value $400 and an annual coupon of $60 sells for $376. The bond has a yield to…

A: A discount bond is a bond that is issued for a price less than the face value of that bond. In the…

Q: Quantitative Problem: Beasley Industries' sales are expected to increase from $5 million in 2017 to…

A: For increase in sales there is need of increase in assets and liabilities for which there is need of…

Q: The following are the cash flows of two projects: Year Project A Project B $ (235) $ (235) 115 135…

A: YearsProject A' Cash FlowsProject B' Cash…

Q: Montclair Manufacturing is considering leasing some equipment. The annual lea payment would be…

A: Interest rate =8%Tax rate = 23%Number of years= 6 yearsAnnual lease payment =$825,000

Q: Practice questions for Assignment 6** 1. You own a TIPS bond that matures in 4 years. The bond makes…

A: TIPS is an acronym that stands for Treasury Inflation-Protected securities, It is a type of security…

Q: WACC Market value weights The market values and after-tax costs of various sources of capital used…

A: WACC or weighted average cost of capital is an important metric in finance. Essentially WACC is a…

Q: 12.28 Jay Olsen, a writer of novels, just has com- pleted a new thriller novel. A movie company and…

A: Expected monetary value (EMV) is a critical concept in decision theory and risk analysis,…

Q: You can afford a $450 per month car payment. You've found a 3 year loan at 4% interest. How big of a…

A: Solution:-When an amount is borrowed, it can either be repaid as a lump sum payment or in…

Q: The operating break-even sales level is not sensitive to which of the following variables? fixed…

A: Operating break even sales level-It is a point at which a company's total revenue equals its total…

Q: Required information [The following information applies to the questions displayed below] Cardinal…

A: Payback period is the time required to recover initial investment of the project.It is computed as…

Q: In order to fund your retirement, deposit of RM X can be made into an account today. This retirement…

A: Net present value refers to the method of capital budgeting used for estimating the viability of the…

Q: Suppose the following model describes changes in Company ABC’s sales: ∆ ABCt = 0.078 - 0.095(∆…

A: Mean-reverting refers to the tendency of a variable, such as a financial instrument's price or a…

Q: Probability 0.1 0.1 0.5 0.2 0.1 A (11%) 6 13 20 38 a. Calculate the expected rate of return, FB, for…

A: The expected return of stock A and stock B can be found by finding the sum of returns after…

Q: ou paid $725,000 for a duplex and financed 75% of the purchase price. Your forecasted cash flows for…

A: IRR is the internal rate of return and at this net present value is equal to zero and present value…

Q: Close Hendreeks 103 103 103 103 Strike Price Cost of contracts 100 100 100 100 Calls Expiration Vol.…

A: Closing Price of stock is 103Strike price is 100Total number of Call contract purchased are 50Expiry…

Q: Crypto Corp. is expected to pay a dividend of $5 per share at the end of year 1(D₁), and the…

A: Variables in the question:D1= $5 g=Growth=1%=0.01P0=Current price of the stock=$30

Q: Salvage value: You are involved with a project that is expected to last 50 years and have a salvage…

A: The realizable amount if an asset is disposed of in the market is known as the salvage value. The…

Question

am. 105.

Olive Company is considering a project that is estimated to cost $279,000 and provide annual net cash flows of $66,023 for the next
five years.
Required:
Calculate the internal rate of return for this project using Excel.
Note: Round your answer to 2 decimal places.
Internal Rate of Return

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: Concept of IRR

VIEW

Step 2: Calculation of IRR

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

There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment or $28.000 and is expected to generate the following cash flows: If the discount rate is 5% compute the NPV of each project and make a recommendation of the project to be chosen.
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?
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)?
Garnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the following cash flows over the next five years: $99,000, $88,000, $92,000. $87,000, and $72,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel. see Appendix C.
There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $35,000 and is expected to generate the following cash flows: If the discount rate is 12%, compute the NPV of each project.
There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $35,000 and is expected to generate the following cash flows: Use the information from the previous exercise to calculate the internal rate of return on both projects and make a recommendation on which one to accept. For further instructions on internal rate of return in Excel, see Appendix C.
Olive Company is considering a project that is estimated to cost $275,500 and provide annual net cash flows of $65,523 for the next five years. Required: What is the internal rate of return for this project? Note: Round your answer to 2 decimal places. Intermat Rate of Returi
Can you show me how this is done? Emily Company has a minimum required rate of return of 9%. It is considering investing in a project that costs $90,671 and is expected to generate cash inflows of $23,576 at the end of each year for three years. The profitability index for this project is Round your answer to 2 decimal places. Selected Answer: 65 Correct Answer: 0.66 ± 0.05
Find internal rate of return of a project with an initial cost of $43,000, expected net cash inflows of $9,550 per year for 8 years, and a cost of capital of 8.80%.Round your answer to two decimal places. For example, if your answer is $345.667 round as 345.67 and if your answer is .05718 or 5.718% round as 5.72.
There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $35,192 and is expected to generate the following cash flows: First Year Second Year Third Year Total Alpha Project $32,000 $22,000 $5,000 $59,000 Beta Project 7,000 23,000 29,047 59,047 A. Calculate the internal rate of return on both projects. Use the IRR spreadsheet function to calculate internal rate of return. Alpha Project % Beta Project % B. Make a recommendation on which one to accept.
There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $35,017 and is expected to generate the following cash flows: First Year Second Year Third Year Total Alpha Project $32,000 $22,000 $4,500 $58,500 Beta Project 8,000 24,000 27,106 59,106 A. Calculate the internal rate of return on both projects. Use the IRR spreadsheet function to calculate internal rate of return. Alpha Project fill in the blank 1% Beta Project fill in the blank 2% B. Make a recommendation on which one to accept. .
There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $34,665 and is expected to generate the following cash flows: First Year Second Year Third Year Total Alpha Project $31,500 $22,000 $4,500 $58,000 Beta Project 7,500 23,500 29,066 60,066 A. Calculate the internal rate of return on both projects. Use the IRR spreadsheet function to calculate internal rate of return. Alpha Project fill in the blank % Beta Project fill in the blank %