Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer with spreadsheet formulas 1 a) CMS Foods Inc. has the following balance sheet. How much net operating working capital does the firm have?

image text in transcribed

Please answer with spreadsheet formulas

1 a) CMS Foods Inc. has the following balance sheet. How much net operating working capital does the firm have? (5 pts) 2 3 Cash $1,000 Accounts payable $2,000 4 Accounts receivable 6500 Accruals 3500 5 Inventory 5500 Notes payable 3500 6 Current assets ? Current liabilities? 7 Net fixed assets 10,000 Long-term debt 6000 8 Common equity 3000 9 Retained earnings 5000 10 Total assets $23,000 Total liab. & equit? 11 12 NWC= 13 14 15 16 17 18 19 b) Markham Inc. recently reported the following data. 20 5 pts 21 ($ million) 22 Operating Incom $27.50 23 Depreciation $12.00 24 Tax rate 40% 25 Toal Capital Exp $5.00 26 NWC investment $1.00 27 FCF= 28 29

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

Valuation Measuring and managing the values of companies

Authors: Mckinsey, Tim Koller, Marc Goedhart, David Wessel

5th edition

978-0470424650, 9780470889930, 470424656, 470889934, 978-047042470

More Books

Students also viewed these Finance questions