❖ Problem 1 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 8.5%. The study period needs to be exactly 5 years and each year should have at least one unique cash flow that is different from the cash flows over the other years. Your answer should contain a table showing the cash flows for each year and a graphical representation of the cash flows (cash-flow diagram).

❖ Problem 1 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 8.5%. The study period needs to be exactly 5 years and each year should have at least one unique cash flow that is different from the cash flows over the other years. Your answer should contain a table showing the cash flows for each year and a graphical representation of the cash flows (cash-flow diagram).

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter12: Capital Investment Analysis

Section: Chapter Questions

Problem 4CMA: Foster Manufacturing is analyzing a capital investment project that is forecast to produce the...

See similar textbooks

Similar questions

solve the problem given in the image.
Use Microsoft Excel to assess the internal rate of return for an IT initiative. Suppose the initial investment is $60,000. The returns on investment in dollars for the following 5 years are (a) $10,000, (b) $12,000, (c) $15,000, (d) $21,000, and (e) $26,000. Use the IRR function to compute the internal rate of return after 2, 4, and 5 years. Next, assume that the loan for the initial $60,000 is at 8 percent and you are earning 16 percent on the annual returns. Use the MIRR function to calculate the internal rate of return. Required: 1. What is the Internal Rate of Return after 2 years? -46% -20% -1% -10% Required: 2. What is the Internal Rate of Return after 4 years? -46% -20% -1% 10% Required: 3. What is the Internal Rate of Return after 5 years? 10% 16% 8% 20%
Below 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,000
Foster Manufacturing is analyzing a capital investment project that is forecast to produce the following cash flows and net income: The payback period of this project will be: a. 2.5 years. b. 2.6 years. c. 3.0 years. d. 3.3 years.
May I ask for an explanation and supporting solution in 2 Decimal place to the problem for a better understanding. Thank you!
Draw a cash flow diagram of any investment that has both of the following properties: 1. The investment has a 4-year life. 2. The investment has a 10%/yr internal rate of return.
A firm is evaluating a project with the following cash flows. At a required return of 11 percent, what is the project's NPV? What if the required return is 24 percent? Input area: Required Return Required Return Year 0 Year 1 Year 2 Year 3 Output area: es es es es NPV at 11% NPV at 24% Մ $ $ 11% 24% (Use cells A6 to B11 from the given information to complete this question. You must use the built Excel function to answer this question.) (41,000) 20,000 23,000 14,000
Please see attached:
I need the manual excel formula as well as the FV Excel Function. C. Suppose you save $2,800 a year for 43 years into an investment account that earn 8.5% return, how much will you have at the end of the periods? Formula $ ??? Excel Functon $1,066,616.08
(Click on the following icon in order to copy its contents into a spreadsheet.) Year 1 Year 2 Year 3 Year 0 -$50 -$101 $26 $20 $22 $22 $39 $49 Project A B Year 4 $16 $62 You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): a. What are the IRRs of the two projects? b. If your discount rate is 5.2%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently?
Assume that an investment is forecasted to produce the following cash flows: a 10% probability of $1475; a 50% probability of $2893; and a 40% probability of $3831. What is the expected amount of cash flow this investment will produce? Instruction: Type ONLY your numerical answer in the unit of dollars
You are a project manager for your company and you are faced with five potential projects that you can invest in. Free cash flow projections and additional relevant data are given for each project in the table below. Assume that there are no cash flows after year 3. Assume that you can only take each project once and that you can only choose one project. Which project would you invest in? Select the best answer. Project Project A Project B Project C Project D Project E O I. Project A II. Project B III. Project C IV. Project D O V. Project E FCF Forecasts by Year (in $1,000) 0 2 1 500 (400) (400) (300) (250) (300) 75 60 75 135 115 175 3 650 210 190 200 Interest Rate (EAR) 8.0% 10.0% 10.0% 12.0% 12.0% IRR 25.00% 17.57% 15.92% 17.81% 19.96%