Homework 3 Solutions (1)

xlsx

School

University of Texas, Dallas *

*We aren’t endorsed by this school

Course

4337

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

6

Uploaded by AmbassadorLobster4056

Report
PROBLEM 6-10 Given: ($ billions) Net Property, Plant and Equipment (200 $ 3.507 Less: Depreciation Expense (2009) 0.727 Plus: Capex (2009) $ 0.72 Net Property, Plant and Equipment (200 $ 3.500 Solution: The firm spent $720 million on new PP&E (Capital Expenditures) in 2014.
Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output
PROBLEM 6-11 Given: In Millions of $ 2015 2014 2013 2012 Cash & Equivalents $ 807,926 $ 560,960 $ 617,866 $ 658,255 Short Term Investments 178,994 197,408 182,442 614,513 Cash and Short Term Investments 986,920 758,368 800,308 1,272,768 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 4,292,257 4,367,807 4,409,733 4,223,010 Solution a: Operating Current Assets 3,484,331 3,806,847 3,791,867 3,564,755 Operating Current Liabilities 2,017,224 2,502,959 2,487,123 2,280,050 Operating Net Working Capital 1,467,107 1,303,888 1,304,744 1,284,705 Solution b: Change in Operating Net Working Capita 163,219 (856) 20,039 Solution c: Hildebrand experienced a sizeable increase in its need for operating net working capital in 2015 which required the firm to come up with $163,219 to finance. In 2014 the firm actually generated excess operating net working capital thereby producing a cash inflow of $856.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output
PROBLEM 6-14 Given Firm free cash flows (years 1 - 5) $ 80 Cost of capital 12% Terminal value multiple of cash flow (year 5) 5 Solution a: Present value of cash flows for years 1-5 $ 288.38 Solution b: Present value of the terminal value in year 5 $226.97 Solution c: Enterprise Value = PV of interim cash flows + PV of Terminal Value $ 515.35
Solution Legend = Value given in problem = Formula/Calculation/Analysis required million = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help