I need to know how to do this in Excel please include formulas The following table tracks the main components of working capital over the life of a four year project 2010 2011 2012 2013 2014 Accounts receivable 0 172,000 247,000 212,000 0 Inventory 86,000 141,000 141,000 106,000 0 Accounts payable 30,500 55,500 61,000 40,500 0 Calculate net working capital and the cash inflows and outflows due to investment in working capital (Leave no cells blank be certain to enter 0 wherever required Negative amounts should be indicated by a minus sign ) 2010 2011 2012 2013 2014 Working capital Cash flows

The Answer is in the image, click to view ...

Question: **I need to know how to do this in Excel - please include formulas. The following table tracks the main components of working capital over

**I need to know how to do this in Excel - please include formulas.

The following table tracks the main components of working capital over the life of a four-year project.

	2010	2011	2012	2013	2014
Accounts receivable	0	172,000	247,000	212,000	0
Inventory	86,000	141,000	141,000	106,000	0
Accounts payable	30,500	55,500	61,000	40,500	0

Calculate net working capital and the cash inflows and outflows due to investment in working capital.(Leave no cells blank - be certain to enter 0 wherever required. Negative amounts should be indicated by a minus sign.)

	2010	2011	2012	2013	2014
Working capital
Cash flows

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

In a marginal tax rate system, as tax payers make increasing amounts of money, the tax rate they pay on every extra unit of income increases incrementally as their income passes certain cutoffs (...

See page 129- 137 on attachment for more details there are five steps to the project. Step 1: Create the loan amortization schedule for the property. Step 2: Create the depreciation schedule. Step 3:...

Problem 6-9 Working capital The following table tracks the main components of working capital over the life of a four-year project. 2019 2023 Accounts receivable Inventory Accounts payable 78,000...

The following table tracks the main components of working capital over the life of a four-year project. Accounts receivable Inventory Accounts payable Net working capital Cash flows 2021 2021 0...

The following table tracks the main components of working capital over the life of a four - year project. Calculate net working capital and the cash inflows and outflows due to investment in working...

Please find attached question. The questions must be answered using the excel format. Please let me know if you need further clarifications. Case Green Valley Medical Center (GVMC) This case is a...

Hi, I need help with the attached Excel spreadsheet. There are multiple questions across the different tabs. Please do not claim this unless you have read the questions and you are positive you can...

I need help with the 3 questions in the excel file attached on Capital Budgeting. I also attached the case study for reference. Any help would be greatly appreciated! HBSP Product Number TCG 3 THE...

ANSWER IN EXCEL The following table tracks the main components of working capital over the life of a four-year project. 2019 2020 2021 2022 2023 Accounts receivable 0 152,000 227,000 192,000 0...

PLEASE ANSWER ALL QUESTIONS. (ALL ANSWERS WITH OUT A GREEN CHECK ARE WRONG) #1 #2 #3 The following table tracks the main components of working capital over the life of a four-year project. Calculate...

Hi all, Can someone please answer this question. Please, list all steps! Thanks! The following table tracks the main components of working capital over the life of a four-year project. 2016 2017 2018...

a) Discuss relevance of industrial psychology to management of human resources. (10 mks) b) Explain theories of workplace motivation and how they can be used to improve employee performance. (5 mks)...

By the transfer of electrons, illustrate the formation of bond in magnesium chloride and identify the ions present in this compound. (ii) Ionic compounds are solids. Give reasons. (iii) With the help...

Item 8 5 points Item 8 With Dutch auction underwriting: Multiple Choice all bidders receive at least a portion of the quantity for which they bid. all successful bidders pay the same price per share....

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.