Question

In: Accounting

The following cash outlays are anticipated for a I-year project. Prepare a cumulative cash flow curve....

The following cash outlays are anticipated for a I-year project. Prepare a cumulative cash flow curve. (10 points)

January - $1.1 million; February - $600,000; March - $700,000; April - $1.4 million; May - $1.7 million; June - $2.0 million; July $2.1 million; August - $1.7 million; September - $1.0 million; October - $700,000; November - $400,000; December - $200,000

Solutions

Expert Solution

Cash plays a critical role in the successful operation of your business. A company uses cash to meet its financial obligations and pay its bills. Cash flow statement is used to track the inflows and outflows of cash to and from your business by activity and the net cash generated by those activities over a specific accounting period. Cash flow statement also shows the cumulative cash from the prior and current accounting period.

Cumulative Cash Flow

Add the net cash flows from operations, investing and financing. The total equals the net cash flow for the period. A positive number indicates that your company generated more cash than it spent; a negative number indicates it spent more than it generated. Add this to the prior period’s number -- typically shown as the beginning number on the bottom left of the cash flow statement -- to obtain the cumulative cash. For example, if your company begins the period with $50,000 in cash and generates $20,000 in net cash flow, the cumulative cash flow equals $70,000

The answer is prepared assuming all the months have a outflow since there is - before the numbers and July month has a positive since there is no - before it.

Month Cash Outlay Cumulative Cash
Jan -1.1 -1.1
Feb -0.6 -1.7
Mar -0.7 -2.4
Apr -1.4 -3.8
May -1.7 -5.5
Jun -2 -7.5
Jul 2.1 -5.4
Aug -1.7 -7.1
Sep -1 -8.1
Oct -0.7 -8.8
Nov -0.4 -9.2
Dec -0.2 -9.4

Cumulative Cash Flow Curve.


Related Solutions

Consider the following two mutually exclusive projects: Year Cash Flow (Project I) Cash Flow (Project II)...
Consider the following two mutually exclusive projects: Year Cash Flow (Project I) Cash Flow (Project II) 0 -$12,300 -$44,000 1 $1,800 $14,000 2 $6,000 $30,000 3 $2,000 $5,000 4 $5,000 $10,000 5 $7,000 $5,000 The required return is 10% for both projects. Assume that the internal rate of return (IRR) of Project I and Project II is 18% and 15%, respectively. a) Which project will you choose if you apply the NPV criterion? Why? b) Which project will you choose...
You are considering a project with the following cash​ flows: YEAR                      PROJECT CASH FLOW    ...
You are considering a project with the following cash​ flows: YEAR                      PROJECT CASH FLOW     0                         -60,000     1                         25,000     2                         25,000     3                         25,000     4                         25,000 If the appropriate discount rate is 11 ​percent, what is the​ project's discounted payback​ period in years?
Consider the following two projects: Project Year 0 Cash Flow Year 1 Cash Flow Year 2...
Consider the following two projects: Project Year 0 Cash Flow Year 1 Cash Flow Year 2 Cash Flow Year 3 Cash Flow Year 4 Cash Flow Discount Rate A -100 40 50 60 N/A .15 B -73 30 30 30 30 .15 Assume that projects A and B are mutually exclusive. The correct investment decision and the best rational for that decision is to: Group of answer choices a.invest in project A since NPVB < NPVA. b.invest in project B...
Gio's Restaurants is considering a project with the following expected cash​ flows: Year Project Cash Flow​...
Gio's Restaurants is considering a project with the following expected cash​ flows: Year Project Cash Flow​ (millions) 0 ​$(180​) 1 80 2 75 3 80 4 95 If the​ project's appropriate discount rate is 12 ​percent, what is the​ project's discounted payback​ period? The​ project's discounted payback period is ___ years.
Mega Dynamics is considering a project that has the following cash flows: Year Project Cash Flow...
Mega Dynamics is considering a project that has the following cash flows: Year Project Cash Flow 0 ? 1 $2,000 2 3,000 3 3,000 4 1,500 The project has an IRR of 17% . The firm's cost of capital is 11 percent. What is the project's net present value (NPV)?
There is a project with the following cash flows : Year Cash Flow 0 −$21,800 1...
There is a project with the following cash flows : Year Cash Flow 0 −$21,800 1 6,300 2 7,350 3 6,750 4 4,400 What is the payback period? Multiple Choice a. 4.00 years b. 3.32 years c. 3.74 years d. 3.56 years e. 2.79 years
There is a project with the following cash flows : Year Cash Flow 0 −$23,700 1...
There is a project with the following cash flows : Year Cash Flow 0 −$23,700 1 7,000 2 7,700 3 7,100 4 5,100 What is the payback period? Multiple Choice 2.73 years 4.00 years 3.81 years 3.63 years 3.37 years
consider a project with the following cash flow; Year cash flow shs '000' abandonment value shs...
consider a project with the following cash flow; Year cash flow shs '000' abandonment value shs '000' 0 (16,000) 1 7,000 ___________ 2 6,000 1,100 3 4,000 9,000 4 4,000 5,000 The cost of capital is 15% and re-investment rate is 20%. Required; i) Determine the optimal abandonment period.
The following information relates to a Corporation for the year ended 2014: Prepare the cash flow...
The following information relates to a Corporation for the year ended 2014: Prepare the cash flow statement in proper form Purchase of Treasury Stock $32,000 Depletion Expense $15,000 Cash from issuance of bonds payable $30,000 Net loss $25,000 Beginning short-term investments $12,000 Ending short-term investments $18,000 Purchase of a patent $33,000 Beginning accounts payable $103,000 Ending account payable $76,000 Beginning accounts receiavble $15,000 Ending accounts receivable $10,000 Beginning inventory $20,000 Ending inventory $11,000 Loss on sale of stock $12,000 Issued...
RAK Corp. is evaluating a project with the following cash flows:    Year Cash Flow 0...
RAK Corp. is evaluating a project with the following cash flows:    Year Cash Flow 0 –$ 28,600 1 10,800 2 13,500 3 15,400 4 12,500 5 – 9,000    The company uses a discount rate of 13 percent and a reinvestment rate of 6 percent on all of its projects.    Calculate the MIRR of the project using the discounting approach. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT