Draw a cash flow diagram on EXCEL using the data below Year Cash Flow 0 -5,000...

Draw a cash flow diagram on EXCEL using the data below

Year	Cash Flow
0	-5,000
1	1000
2	2000
3	3000
4	4000
5	-1000

Expert Solution

Please see the answer in the picture. I have assumed that thre is no discounting as the interest rate is not mentioned in the problem.

Rahul Sunny answered 3 years ago

Using a cash flow diagram draw a diagram for $10,000 invested now, and in 5 years...

Using a cash flow diagram draw a diagram for $10,000 invested now, and in 5 years it grows to $30,000.

Draw a cash flow diagram for a cash flow that starts at $1,000 at the end...

Draw a cash flow diagram for a cash flow that starts at $1,000 at the end of the first month and increases by $100 each month after that in perpetuity with an interest rate of 21% annual compounded monthly (Draw at least the first 5 months). What is the present value of this cash flow?

Draw the cash flow diagram for the following data. A company purchases a machine to make...

Draw the cash flow diagram for the following data. A company purchases a machine to make widgets for $10,000. the collect payment for their widgets at the end of the year in which they are delivered. At the end of 5 years the machine must be scrapped at which time its value is $0. The following is the net revenue generated by the widget machine. Year 1 - $2,500 Year 2 - $3,500 Year 3 - $2,250 Year 4 -...

Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero...

Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero at MARR = 7%. The study period needs to be exactly 18 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).

A hospital’s project has the following expected cash flows Year Cash flow 0 ($5,000) 1 $1,000...

A hospital’s project has the following expected cash flows Year Cash flow 0 ($5,000) 1 $1,000 2 $2,000 3 $3,000 If the cost of capital is 12%, should the project be undertaken? Show your calculations

Using the following free cash flow data: Year Cash Flow 2017 $4,000,000

Using the following free cash flow data: Year Cash Flow 2017 $4,000,000 2018 $4,400,000 Prepare a 10-year cash flow forecast based upon the rate of growth in cash flow between 2017 and 2018. Calculate the net present value of the forecasted cash flows assuming an immediate investment cost of $18,500,000 Please show your work so I can recreate in excel

Draw a 5-year cash flow diagram representing the following cash flows to build springs: (Chapter 2)...

Draw a 5-year cash flow diagram representing the following cash flows to build springs: (Chapter 2) Initial investment in plant and equipment $30K Annual maintenance: $5K after year 1 and increasing $1K per year after that Annual production costs – $10K/year Annual revenue - $50K/year 2. A company plans to design and build transport vehicles for the Marine Corps. The cost for the design is $15M. The cost for the test prototype is $3M. The cost to produce and test...

Software Engenninring 1. Draw a Level-0, a Level-1, a Level-2 Data Flow Diagram for an ATM...

Software Engenninring 1. Draw a Level-0, a Level-1, a Level-2 Data Flow Diagram for an ATM Machine System. 2. Draw a sequence diagram for one use-case as follows: Getting money from an ATM Treat each part of the ATM as a class/object: Money dispenser Screen Keypad Bank computer

you are analyzing a project and have this data : year : cash flow 0. :...

you are analyzing a project and have this data : year : cash flow 0. : -40,000 1 : 18,675 2 : 23,900 3. : 21,750 required rate of return = 13 % target payback = 2.0 years point:1+ 1.5 +1.5 + 2 compute following : a) pay back period b) discounted pay back period c) NPV D) IRR OF THIS PROJECT E) ACCEPT OR REJECT PROJECT

Draw Data Flow Diagrams for the following system. Starting with a context diagram, draw as many...

Draw Data Flow Diagrams for the following system. Starting with a context diagram, draw as many nested DFDs as you consider necessary to represent all of the details of the system described in the following narrative. Context diagram, Level-0, and Level 1 diagrams are required. You may choose to decompose to level-2, level-3, etc., if you think it’s necessary or if you would like to challenge yourself. Urban Life Club (ULC) is an innovative young firm that sells memberships to...

Question