part 3 4 solution needed YearNet cashflows0-575,0001£125,0002£248,0003£176,0004£146,000 Task 7Supera Ltd are looking to invest in a new 4 year project with an initial outlay of£575,000. The project is in a line of business where Supera Ltd. has limited previousexperience. All cash inflows occur at the end of each year.YearNet cashflows0(575,000)1£125,0002£248,0003£176,0004£146,000i)Calculate the IRR of the project by discounting the cashflows by 4% and 8% andthen applying the IRR formula - perform your workings on excel includingformulas. A copy of the data above is provided in the "Task 7 - Data" tab of theExcel file "MBF Summative data.xlsx". There is also a present value table on thelast tab of the same excel file.Check your answer using the IRR function in exceliii)Supera Ltd has a set hurdle rate of 7.5% for projects. Assess whether or not itshould accept the project based on your calculations and other informationprovided.iv)Explain one advantage and one disadvantage of the IRR technique of investmentappraisal.

Internal Rate of Return: It is the rate at which the net present value of an investment or project…

iii) Supera Ltd has a set hurdle rate of 7.5% for projects. Assess whether or not it should accept the project based on your calculations and other information provided. iv) Explain one advantage and one disadvantage of the IRR technique of investment appraisal.

iii) Supera Ltd has a set hurdle rate of 7.5% for projects. Assess whether or not it should accept the project based on your calculations and other information provided. iv) Explain one advantage and one disadvantage of the IRR technique of investment appraisal.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Q: O Question 4 What is the future value of the following cash flow stream at a rate of 7.5%? Years:…

A: Solution:When an amount is invested somewhere, it earns interest on it.The amount initially invested…

Q: (IRR of an uneven cash flow stream) Microwave Oven Programming, Inc. is considering the construction…

A: IRR is the rate at which present value of cash inflows will be equal to initial cost.

Q: Consider the following information: 2024 2023 Cash $500,000 $200,000 Accounts receivable 900, 000…

A: The balance sheet represents the Financial position of the business with assets and liabilities on a…

Q: answer

A: Formula to calculate NPV is: NPV = Cash flow/(1+i)^n - Initial investment IRR is NPV becomes 0…

Q: A project is estimated to cost $273,840 and provide annual net cash inflows of $60,000 for 7 years.…

A: Internal rate of return method:-The internal rate of return is the discount rate at which the net…

Q: Reno Company is considering a project that has the following cash flow data. What is the project's…

A: IRR stands for the internal rate of return. It is an important capital budgeting tool. IRR is the…

Q: The present value of an investmnet with three year-end cash flows of $100,000, $150,000, $200,000…

A: Capital budgeting is one of the important technique used in finance. It helps in identifying and…

Q: Question 2 The following information relates to three possible capital expenditure projects. Because…

A: Net Present Value- The net present value demonstrates its applicability in capital budgeting. It…

Q: Problem 5-5 Calculating IRR A firm has a project with the following cash flows: Year 0 1 2 3 Cash…

A: Internal rate of return (IRR) is the rate at which present value of future cash flows will be equal…

Q: Year 0 1 2 3 4 01 5 6 7 8 9 10 Net Cash Outflows Amount Invested $ 4,600,000 Net Cash Inflows Annual…

A: Payback period is the time taken to recover the initial investment. It is one of the popular capital…

Q: What is the project's MIRR? r = 10.00% 0 -$875 Year Cash flows O a. 22.51% O b. 11.75% O c. 17.21% O…

A: YearsCash Flows0($875)1$3002$3203$3404$360Rate10%Required:Modified Internal Rate of Return =?

Q: Question 14 Simms Corp, is considering a project that has the following cash flow data. What is the…

A: IRR is the internal rate of return on a project that equates the present value of project's expected…

Q: 3. 2. Year Cash Inflows $400,000 300,000 200,000 4 100,000 5. 200,000 What is the NPV of the…

A: Net Present Value is the difference between the current value of cash inflow and cash outflow for a…

Q: Park Company is considering an investment of $36,500 that provides net cash flows of $11,200…

A: Initial Investment = i = $36,500Cash Flow = cf = $11,200

Q: Project A B C D Investment Required $ 200,000 $ 152,000 $ 100,000 $ 170,000 Present value of Cash…

A: Profitability index = (present value of cash inflows )/Initial investment Net present value is…

Q: MIRR A project has the following cash flows: 0 1 2 3 4 5 $500 $202 -$X $196 $350 $451 ▸ Details This…

A: MIRR is a financial metric used to evaluate an investment's profitability by considering both the…

Q: Problem 11.12 (IRR and NPV) Problem Walk-Through A company is analyzing two mutually exclusive…

A: Net present value(NPV) is the difference between present value of all cash inflows and initial…

Q: nabled: Exam 5 Saved Assume that an investment provides the following cash inflows over a three-year…

A: The table that will be used here is the PV of $1 table. PV of cash flow of a year = cash flow amount…

Q: The present value of the cash flow stream is $ (Round to the nearest cent.)

A: Present Value: It is the present worth of the future cash flow stream or the future sum of money.…

Q: ces Problem 6-1 Present Value and Multiple Cash Flows [LO1] Mendez Company has identified an…

A: Present value is the discounted value all the future cash flows to the present using appropriate…

Q: To estimate the future value of a resource, the World Bank and most businesses use _____. a. a…

A: When weighing the decision to undertake a project with long-term benefits versus one with short-term…

Q: What is the IRR for the following project if its initial after-tax cost is $5,000,000 and is…

A: In the field of financial analysis, a statistic known as the internal rate of return (IRR) is used…

Q: Question 23 What is the future value of the following cash flow stream at a rate of 8%? Do not round…

A: CF year 1 = CF1 = 1,350 CF year 2 = CF2 = 3,750CF year 3 = CF3 = 4,500CF year 4 = CF4 = 6,250Rate =…

Q: this is Capital budgeting tools ch 12 p 25 build a model

A: Answer:(d).Understanding the Crossover Rate: The crossover rate is the discount rate at which the…

Q: None

A: Formula used to calculate the present value is PV of Incremental CFs = $3200 + [ $1040/(1+0.14)] +…

Q: QUESTION B2 The potential cash flows from a project over a 5-year period is as presented below. The…

A: Internal rate of return refers to the percentage of return expected from the operation of the…

Q: 6 points Save 0 million and A's present value of net cash flows after tax is $245 million, Project B…

A: Projects Initial outlay (Million $) PV of net cash flows after tax (Million $) Net Present Value…

Q: Perez Company is considering an investment of $26,945 that provides net cash flows of $8,500…

A: Internal Rate of Return: In the field of financial analysis, a statistic known as the internal rate…

Q: QUESTION 19 Simkins Renovations Inc. is considering a project that has the following cash flow data.…

A: Step 1: Calculation of the Internal rate of return (IRR): Therefore, The internal rate of return…

Q: Year Cashflow Rat2 @ 12% 0 -15600 1 6800 2 8000…

A: Discounting Approach or time-adjusted approach determines the present value of all future cash flows…

Q: question 11 What is the present value of investment A, B, and C at an annual discount rate of 24…

Q: If the cost of capital (discount rate) is 10%, which project(s) do you invest in and why? OA.…

A: Capital budgeting is a process used by the companies to use its limited resources to get the best…

Q: Cash Flow Project M Project N Project O Year 1 $500,000 $700,000 $1,100,000 Year 2 $500,000 $700,000…

A: The given problem can be solved using IRR and MIRR function in excel.

Q: Incremental Analysis A1 A2 -$1,000 -$5,000 1 $2,000 $7,000 IRR 100% 40% PW(10%) $818 $1,364 R-122…

A: Since you have posted a multiple question therefore, we will be solving the first question only.…

Q: The following are the cash flows of two projects: Year 0 1234 Project A $ (380) 210 210 210 210…

A: Payback period is the duration of time by which the initially invested capital will be fully…

Q: The Merriweather Printing Company is trying to decide on the merits of constructing a new publishing…

A: IRR stands for Internal Rate of Return, which is a financial metric used to estimate the potential…

Q: Year 0 1 2 3 Project A -$50,000 $24,200 $16,800 $46,500 Project B -$45,000 $39,000 $18,000 $18,000…

A: Capital budgeting refers to the process of analyzing, evaluating, and selecting the potentially…

Question

part 3 4 solution needed

Year	Net cashflows
0	-575,000
1	£125,000
2	£248,000
3	£176,000
4	£146,000

Task 7
Supera Ltd are looking to invest in a new 4 year project with an initial outlay of
£575,000. The project is in a line of business where Supera Ltd. has limited previous
experience. All cash inflows occur at the end of each year.
Year
Net cashflows
0
(575,000)
1
£125,000
2
£248,000
3
£176,000
4
£146,000
i)
Calculate the IRR of the project by discounting the cashflows by 4% and 8% and
then applying the IRR formula - perform your workings on excel including
formulas. A copy of the data above is provided in the "Task 7 - Data" tab of the
Excel file "MBF Summative data.xlsx". There is also a present value table on the
last tab of the same excel file.
Check your answer using the IRR function in excel
iii)
Supera Ltd has a set hurdle rate of 7.5% for projects. Assess whether or not it
should accept the project based on your calculations and other information
provided.
iv)
Explain one advantage and one disadvantage of the IRR technique of investment
appraisal.

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

Step 2

Step 3

Step 4

Step by step

Solved in 4 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

Initial Outlay Cash Flow in Period 1 2 3 4 $4,000,000 $1,546,170 $1,546,170 $1,546,170 $1,546,170 The Internal Rate of Return (IRR) =? A) 10%. B) 18%. C) 20%. D) 24%.
Your company has a project available with the following cash flows: Year 0 1 2345 Cash Flow -$80,900 21,600 25,200 31,000 26,100 20,000 If the required return is 15 percent, should the project be accepted based on the IRR?
ces Year 0 1 Cash Flow (A) -$430,000 41,500 2 64,500 3 81,500 4 545,000 Cash Flow (B). -$ 42,500 20,900 12,800 21,100 17,900 The required return on these investments is 10 percent. a. What is the payback period for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. b. What is the NPV for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. c. What is the IRR for each project? Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e. d. What is the profitability index for each project? Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161. e. Based on your answers in (a) through (d), which project will you finally choose? a. Project A Project B b. Project A Project B years years Q Search < Prev 5 of 5 Next L
Question 2 The following information relates to three possible capital expenditure projects. Because of capital rationing, only one project can be accepted: Project Q P R Initial cost £250,000 £210,000 £190,000 4 5 £17,500 £12,000 £ £ End of year 175,000 90,000 60,000 70,000 70,000 65,000 3 65,000 55,000 70,000 4 60,000 80,000 75,000 5 55,000 80000 The company estimates its cost of capital is 14 per cent. Required: Calculate a) The payback period for each project. b) The accounting rate of return for each project. c) The net present value of each proiect. d) Which project should be accepted - give reasons. e) Explain the factors management would need to consider, in addition to the financial factors, before making a final decision on a project. Expected life (years) 5 Scrap value expected £20,000 Expected cash inflows £ 2
Ashvinbhai
Financial Management CH 11 HW Please show work, thank you. Question 9
Question content area top Part 1 (Present value of annuities and complex cash flows) You are given three investment alternatives to analyze. The cash flows from these three investments are as follows: Investment End of Year A B C 1 $ 16,000 $ 21,000 2 16,000 3 16,000 4 16,000 5 16,000 $ 16,000 6 16,000 63,000 7 16,000 8 16,000 9 16,000 10 16,000 21,000 (Click on the icon in order to copy its contents into a spreadsheet.) Assuming an annual discount rate of 19 percent, find the present value of each investment. Question content area bottom Part 1 a. What is the present value of investment A at an annual discount rate of 19 percent? $enter your response here (Round…
Problem 5-29 Calculating Incremental Cash Flows Darin Clay, the CFO of MakeMoney.com, has to decide between the following two projects: Year Project Million Project Billion 0123 -$2,500 0-290 -$10 0+1,050 1.090 1.850 1,850 2,900 The expected rate of return for either of the two projects is 13 percent. What is the range of initial investment (0) for which Project Billion is more financially attractive than Project Million? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Initial investment less than

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS