View the step-by-step solution to:

PROBLEM 6-11 Solution Legend Given: In Millions of $ Cash & Equivalents Short Term Investments Cash and Short Term Investments Accounts...

Hildebrand Corp. had the following current asset and current liability account balances for 2007 thought 2010 (please see the attached Excel document). Use the attached Excel document to show your work and:

A) Compute Hildebrand's operating new working capital for 2007-2010
B) What are the annual changes in operation net working capital for the sample period?
C) Analyze the firm's need for additional capital to support its need for operating working capital.

PROBLEM 6-11 Solution Legend = Value given in problem Given: = Formula/Calculation/Analysis required In Millions of $ 2010 2009 2008 2007 = Qualitative analysis or Short answer required Cash & Equivalents $807,926 $560,960 $617,866 $658,255 = Goal Seek or Solver cell Short Term Investments 178,994 197,408 182,442 614,513 = Crystal Ball Input Cash and Short Term Investments 986,920 758,368 800,308 1,272,768 = Crystal Ball Output Accounts Receivable 2,028,060 2,365,823 2,341,609 2,302,447 Inventories 1,456,271 1,441,024 1,450,258 1,262,308 Total Current Assets 4,471,251 4,565,215 4,592,175 4,837,523 Accounts Payable 1,138,770 1,601,413 1,584,959 1,416,367 Accrued Expenses 878,454 901,546 902,164 863,683 Notes Payable/Short Term Debt 1,038,633 789,285 979,675 821,126 Current Port. of LT Debt 531,635 386,879 303,214 248,028 Total Current Liabilities $3,587,492 $3,679,123 $3,770,012 $3,349,204 Solution a: Operating Current Assets Operating Current Liabilities Operating Net Working Capital Solution b: Change in Operating Net Working Capital Solution c:
Background image of page 1
Sign up to view the entire interaction

Top Answer

Hi please find... View the full answer

8498691.xls

PROBLEM 6-11 Solution Legend Given:
In Millions of $
Cash & Equivalents
Short Term Investments
Cash and Short Term Investments
Accounts Receivable
Inventories
Total Current Assets
Accounts...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online