Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your firm is considering adding a new assembly line to increase the production of a manufactured good. Given the following information, what is the estimated

Your firm is considering adding a new assembly line to increase the production of a manufactured good. Given the following information, what is the estimated project cash flow from this new assembly line? Express your answer in whole numbers. For example, if you calculate an answer of 8.36 your answer should be 8 and NOT 8.36 or 8.4

Current Values Projected Values
Revenues 108,727 139,821
Cost of Goods Sold 65,686 84,411
Operating Expenses (not including depreciation) 21,837 26,769
Depreciation 5,064 6,338
Taxes 4,746 5,689
Current Assets 28,218 34,766
Fixed Assets 128,992 132,414
Current Liabilities 20,778 29,066
Long-term Debt 37,778 44,406

answer is -1526, how do you do that in excel? full tutorial pls

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Essential Nonprofit Fundraising Handbook

Authors: Michael A. Sand, Linda Lysakowski

1st Edition

1601630727, 978-1601630728

More Books

Students also viewed these Finance questions

Question

Some income from capital is taxed twice. Explain.

Answered: 1 week ago