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

Solutions

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 1 year ago

Next > < Previous

Related Solutions

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...

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

Q1. Use the below Scenario to draw the context and level-0 data flow diagrams that represent...

Q1. Use the below Scenario to draw the context and level-0 data flow diagrams that represent the video rental system. (30 points for context diagram, and 70 points for level-0 diagram) Note: Make sure you include all the appropriate external entities, Processes, Data Stores, and Data Flows. Customer and manager are dealing with a video rental store system. Every time the customer requests to rent a video, he/she needs to enter this request to the system, and the system stores...

ZAKI LLP is a networking entity. Required Using the data provided below Draw an A-O-A diagram...

ZAKI LLP is a networking entity. Required Using the data provided below Draw an A-O-A diagram based on normal times and identify the critical path, calculate the normal cost for the project. Determine the minimum project completion time with the least cost and calculate the percentage increase in costs. Use the network diagram in (a) above to construct a simple Gantt chart. Note: Time is in Weeks and Cost in USD. Activity Normal time Crash time Normal cost Crash cost...

Subjects