Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate External Financing Needed (EFN) using this data *Using Excel is fine, just explain how* 2014 2013 2012 Shares Outstanding $ 3,848.69 $ 3,944.44 $
Calculate External Financing Needed (EFN) using this data *Using Excel is fine, just explain how*
| 2014 | 2013 | 2012 | |
| Shares Outstanding | $ 3,848.69 | $ 3,944.44 | $ 3,812.66 |
| Cash | $ 10,757.00 | $ 14,468.00 | $ 15,659.00 |
| Marketable Securities | $ 20,393.00 | $ 22,100.00 | $ 20,284.00 |
| Receivables | $ 11,708.00 | $ 9,828.00 | $ 10,828.00 |
| Inventory | $ 7,866.00 | $ 7,708.00 | $ 7,362.00 |
| Raw Materials | $ 3,822.00 | $ 3,613.00 | $ 3,697.00 |
| Work In Progress | - | - | - |
| Finished Goods | $ 5,022.00 | $ 5,058.00 | $ 4,614.00 |
| Notes Receivable | $ 81,111.00 | $ 77,481.00 | $ 71,510.00 |
| Other Current Assets | - | - | $ 15,185.00 |
| Total Current Assets | $ 131,835.00 | $ 131,585.00 | $ 140,828.00 |
| Property Plant And Equipment | $ 59,260.00 | $ 59,092.00 | $ 57,777.00 |
| Accumulated Depreciation | $ 29,134.00 | $ 31,476.00 | $ 32,835.00 |
| Net Property Plant And Equipment | $ 30,126.00 | $ 27,616.00 | $ 24,942.00 |
| Investment And Advances | $ 26,574.00 | $ 23,663.00 | $ 19,697.00 |
| Other Non Current Assets | - | - | - |
| Deferred Charges | $ 13,639.00 | $ 13,315.00 | - |
| Intangibles | - | - | $ 87.00 |
| Deposits And Other Assets | $ 6,353.00 | $ 5,847.00 | $ 5,000.00 |
| Total Assets | $ 208,527.00 | $ 202,026.00 | $ 190,554.00 |
| Notes Payable | - | - | - |
| Accounts Payable | $ 20,035.00 | $ 19,531.00 | $ 19,308.00 |
| Current Portion Of Long Term Debt | - | - | - |
| Current Portion Of Capital Leases | - | - | - |
| Accrued Expenses | - | - | $ 49,407.00 |
| Income Taxes Payable | - | - | - |
| Other Current Liabilities | - | - | - |
| Total Current Liabilities | $ 20,035.00 | $ 19,531.00 | $ 68,715.00 |
| Mortgages | - | - | - |
| Deferred Charges Taxes Income | $ 570.00 | $ 598.00 | $ 470.00 |
| Convertible Debt | - | - | - |
| Long Term Debt | $ 119,171.00 | $ 114,688.00 | $ 105,058.00 |
| Non Current Capital Leases | - | - | - |
| Other Long Term Liabilities | $ 43,577.00 | $ 40,462.00 | - |
| Total Liabilities | $ 183,695.00 | $ 175,610.00 | $ 174,565.00 |
| Minority Interest | $ 342.00 | $ 331.00 | $ 322.00 |
| Preferred Stock | - | - | - |
| Common Stock Net | $ 40.00 | $ 40.00 | $ 40.00 |
| Capital Surplus | $ 21,089.00 | $ 21,422.00 | $ 20,976.00 |
| Retained Earnings | $ 24,556.00 | $ 23,658.00 | $ 18,077.00 |
| Treasury Stock | $ 848.00 | $ 506.00 | $ 292.00 |
| Other Liabilities | $ (20,005.00) | $ (18,198.00) | $ (22,812.00) |
| Shareholders Equity | $ 24,832.00 | $ 26,416.00 | $ 15,989.00 |
| Total Liabilities And Shareholders Equity | $ 208,527.00 | $ 202,026.00 | $ 190,554.00 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Investments Analysis and Management
Authors: Charles P. Jones
12th edition
978-1118475904, 1118475909, 1118363299, 978-1118363294
