- Initial investment = $3,905,000 Expense = $5, 580,000 (first year) - Income = $6,480,000 (first year) develop a forecasted 10 years - cash flow in excel in order to find - payback period - NPV Use a minimum expected return rate 10%, inflation rate 3%, and tax rate 20% . Give comments on your analysis result and recommendation on this investment

- Initial investment = $3,905,000 Expense = $5, 580,000 (first year) - Income = $6,480,000 (first year) develop a forecasted 10 years - cash flow in excel in order to find - payback period - NPV Use a minimum expected return rate 10%, inflation rate 3%, and tax rate 20% . Give comments on your analysis result and recommendation on this investment

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

Similar questions

c. A company is planning to invest in a project over a 5-year period, but wants to know its financial implications. It expects the cash in-flow return on the investment to steadily increase over the 5 years. Using the information below, help determine the Total Net Cash Flows, the Net Present Value and the estimated Payback Period. Note: Estimate the payback period to the nearest year. Discount Rate 12% Investment Project Initial Investment Year 1 Year 2 Year 3 Year 4 Year 5 Cash Flow $ $ $ $ $ $ Total Net Cash Flow (5,000) 800 ? 900 ? 1,500 ? 1,800 ? 3,200 NPV of investment Estimated Payback Period
I need help finding the Profitability index for each project (D) using Excel
Regarding the proposed investments, XYZ INC. gathers the following data: a cash cost of 13,000, net annual cash flows of 45,000, and a present value factor of 5.40 rounded for cash inflows over a ten-year period. Find out all the relevant details that will be important when choosing an investment. Please let me know whether you think our firm should receive an investment based on the following information:
Cannonier, In., has identified an investment project with the following cash flows: Year Cash Flow 1 $1,050 2 1,280 3 1,500 4 2,240 If the discount rate is 7 percent, what is the future value of these cash flows in Year 4?
Connor Corporation is considering two projects (see below). For your analysis, ass rate of return of 10%. Based on your analysis, which is the best choice? Initial Investment Cash Flow Year 1 PV NPV Profitability Index IRR Project A -465,000 510,000 463,636.364 ($1,363.64) $1.00 ANSWER 10% Project B -700,000 You can change the i 850,000 772,727.273
Assume a project has cash flows of -$54,300, $18,200, $37,300, and $14,300 for Years 0 to 3, respectively. What is the profitability index given a required return of 12.6 percent? 1.02 .95 .98 1.06 ☐ 1.00
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
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
Dixon Sisters has a project with the after-tax cash flows shown below. The required return (cost of capital) on the investment is 10%. Compute the: Payback b. Discounted payback c. NPV d. Profitability index e. IRR MIRR YEAR 0 1 2 3 4 Cash flow −70,000 30,000 30,000 30,000 20,000
Use Excel to calculate the solutions to the following problems. Your worksheet will be graded on accuracy, dynamic calculations, and presentation of solutions (should be well organized with variables clearly labeled). 1. What is the future value in 30 years of $5,000 invested today at 8.0%? 2. What is the present value of $1,000,000 received 6 years from today if the appropriate discount rate is 4.0%? 3. What is the present value of ordinary annuity of $400 per year for 8 years if the discount rate is 10.0%? 4. What is the future value of an annuity due of $500 deposited per month into account paying 12.0% annually for 25 years?
Use the Modified IRR (MIRR) method to determine the rate of return of a project that has the following cash flow diagram. The investment rate is 15% and the borrowing rate is 12%. g = 20% $3 $3 $3 $3 years 11 3. 4 6. 7 8 9 10 $2 S2 $2 $2
Use the NPV method to determine whether Kyler Products should invest in the following projects: Project A: Costs $280,000 and offers seven annual net cash inflows of $52,000. Kyler Products requires an annual return of 12% on investments of this nature. Project B: Costs $385,000 and offers 9 annual net cash inflows of $75,000. Kyler Products demands an annual return of 10% on investments of this nature. (Click the icon to view Present Value of $1 table.) (Click the icon to view Present Value of Ordinary Annuity of $1 table.) Read the requirements. Project B: Years 1-9 0 Project A Project B Present value of annuity Investment Net present value of Project B Requirement 2. What is the maximum acceptable price to pay for each project? Maximum Project A Project B Net Cash Inflow Acceptable Price Annuity PV Factor (i=10%, n=9) Requirement 3. What is the profitability index of each project? (Round to two decimal places, X.XX.) Select the formula, then enter the amounts to calculate the…

SEE MORE QUESTIONS

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