Question
In: Finance
Forecast the balance sheet for Lambert Co. using the following projected information ($000). Round all projections...
Forecast the balance sheet for Lambert Co. using the following projected information ($000). Round all projections to the nearest thousand dollars.
| Sales | $10000 |
| Cash | $500 |
| Accruals | $50 |
| Gross Margin | 45% |
| Inventory Turns (based on COGS) | 7.0 |
| Total Asset Turnover | 1.25 |
| Current Ratio | 2.0 |
| Debt: Equity | 1:3 |
| ACP | 42 days |
| Assets | Liabilities | ||
| Cash | ? | A/P | ? |
| A/R | ? | Accruals | ? |
| Inventory | ? | C/L | ? |
| C/A | ? | Debt | ? |
| Net F/A | ? | Equity | ? |
| Total Assets | ? | Total L&E | ? |
Solutions
Expert Solution
| Assets | Amt in 000 | Liabilities | Amt in 000 | |
| Cash | 500 | A/P-note 8 | 1,168 | |
| A/R - note 2 | 1,151 | Accruals | 50 | |
| Inventory -note 3 | 786 | C/L-note 7 | 1,218 | |
| C/A -note 4 | 2,436 | Debt - note 9 | 1,695 | |
| Net F/A -note 5 | 5,564 | Equity - note 9 | 5,086 | |
| Total Assets - note 1 | 8,000 | Total L&E -note 6 | 8,000 | |
| Note -1 | Total asset = sales/asset = 1.25 | |||
| Asset = 10000/1.25 | $8,000 | |||
| Note 2 | AR = ACP*sales/365 | 1,151 | ||
| =42*10000/365 | ||||
| Note 3 | Inventory turnover = Cost of good sold/inventory = 7 | |||
| =(10000*0.55)/inventory = 7 | ||||
| inventory = 10000*0.55/7 | 786 | |||
| Note 4 | C/A = Cash+AR + inventory | 2,436 | ||
| Note 5 | Net fixed asset = Total asset - Current asset | 5,564 | ||
| =8000-2436 | ||||
| Note 6 | Total L&E = Total Asset = 8000 | |||
| Note 7 | Current ratio = 2 = Current asset / Current liablities | |||
| Current liabilities = Current asset / 2 = 2436/2 | 1,218 | |||
| Note 8 | Account payable = Current liablities - Accruals = 1218-50 | 1,168 | ||
| Note 9 | Total debt and equity = Total L&E - Current liablities = 8000-1218 | 6,782 | ||
| Debt/equity ratio = 1:3 | ||||
| Debt = 6832/4 | 1,695 | |||
| Equity = 6832*3/4 | 5,086 | |||
jeff jeffy answered 2 years agoRelated Solutions
Complete the following balance sheet using the information given. Round account balances to the nearest dollar....
Complete the following balance sheet using the information
given. Round account balances to the nearest dollar.
Balance Sheet
Income Statement
Cash
Sales (All Credit)
$40,000
Accounts receivable
Cost of goods sold
20,000
Inventory
Operating expenses
12,000
Net fixed assets
Interest expense
200
Total assets
Taxes
2 730
Net income
$5,070
Accounts payable
Short-term notes payable
$1,425
Ratios:
Long-term debt
Profit Margin =
12.675%
Common stock
$5,000
Return on Equity =
15%
Retained earnings
Quick Ratio =
1.2
Total Liabilities and...
A bank’s balance sheet information is shown below (in$000).On Balance Sheet ItemsFace Value...
A bank’s balance sheet information is shown below (in
$000).On Balance Sheet ItemsFace ValueCash$141,600Short-term government securities (<92 days)7,400Long-term government securities (>92 days)434,400Federal Reserve stock11,800Repos secured by federal agencies179,000Claims on U.S. depository institutions957,900Loans to foreign banks, OECD CRC rated 21,840,000General obligation municipals190,000Claims on or guaranteed by federal agencies28,500Municipal revenue bonds132,900Residential mortgages, category 1, loan-to-value ratio 75%7,000,000Commercial loans6,667,669Loans to sovereigns, OECD CRC rated 313,600Premises and equipment475,000Off Balance Sheet Items:Conversion Factor (%)Face ValueU.S. Government CounterpartyLoan commitments:<1 year20$3001–5 year501,140Standby letters of credit:Performance-related50200Direct-credit substitute100100U.S. Depository...
Specter Co. combines cash and cash equivalents on the balance sheet. Using the following information, determine...
Specter Co. combines cash and cash equivalents on the balance
sheet. Using the following information, determine the amount
reported on the year-end balance sheet for cash and cash
equivalents.
$7,000 cash deposit in checking account.
$28,000 bond investment due in 20 years.
$7,000 U.S. Treasury bill due in 1 month.
$400, 3-year loan to an employee.
$1,800 of currency and coins.
$700 of accounts receivable.
Checking account:
Bond investment:
U.S. Treasury bill:
Loan to an employee:
Currency and coins:
Accounts...
Forecast the Balance Sheet Following is the balance sheet for Medtronic PLC for the year ended...
Forecast the Balance Sheet
Following is the balance sheet for Medtronic PLC for the year
ended April 29, 2016.
Medtronic plc
Consolidated Balance
Sheets
($ millions)
Apr. 29, 2016
Apr. 24, 2015
Current assets
Cash and cash equivalents
$2,768
$4,843
Investments
9,758
14,637
Accounts receivable
5,562
5,112
Inventories
3,473
3,463
Tax assets
697
1,335
Prepaid expenses and other current assets
1,234
1,454
Total current assets
23,492
30,844
Property, plant, and equipment, net
4,841
4,699
Goodwill
41,500
40,530
Other intangible assets,...
Forecast the Balance Sheet Following is the balance sheet for Medtronic PLC for the year ended...
Forecast the Balance Sheet
Following is the balance sheet for Medtronic PLC for the year
ended April 29, 2016.
Medtronic plc
Consolidated Balance
Sheets
($ millions)
Apr. 29, 2016
Apr. 24, 2015
Current assets
Cash and cash equivalents
$2,988
$4,843
Investments
9,758
14,637
Accounts receivable
5,562
5,112
Inventories
3,473
3,463
Tax assets
697
1,335
Prepaid expenses and other current assets
1,234
1,454
Total current assets
23,712
30,844
Property, plant, and equipment, net
4,841
4,699
Goodwill
41,500
40,530
Other intangible assets,...
Forecast the Balance Sheet Following is the balance sheet for Medtronic PLC for the year ended...
Forecast the Balance Sheet
Following is the balance sheet for Medtronic PLC for the year
ended April 29, 2016.
Medtronic plc
Consolidated Balance
Sheets
($ millions)
Apr. 29, 2016
Apr. 24, 2015
Current assets
Cash and cash equivalents
$2,768
$4,843
Investments
9,758
14,637
Accounts receivable
5,562
5,112
Inventories
3,473
3,463
Tax assets
697
1,335
Prepaid expenses and other current assets
1,234
1,454
Total current assets
23,492
30,844
Property, plant, and equipment, net
4,841
4,699
Goodwill
41,500
40,530
Other intangible assets,...
Forecast the Balance Sheet Following is the balance sheet for Medtronic PLC for the year ended...
Forecast the Balance Sheet
Following is the balance sheet for Medtronic PLC for the year
ended April 29, 2016.
Medtronic plc
Consolidated Balance Sheets
($ millions)
Apr. 29, 2016
Apr. 24, 2015
Current assets
Cash and cash equivalents
$3,221
$4,843
Investments
9,758
14,637
Accounts receivable
5,562
5,112
Inventories
3,473
3,463
Tax assets
697
1,335
Prepaid expenses and other current assets
1,234
1,454
Total current assets
23,945
30,844
Property, plant, and equipment, net
4,841
4,699
Goodwill
41,500
40,530
Other intangible assets,...
Complete the following balance sheet using the information: &nbs
Complete the following balance sheet using the
information:
Cash
Accounts Receivables Inventory ________
Current Assets _________
Net Fixed Assets $1,000,000 _________
Total $1,300,000 =========
Current Ratio = 3.0
Inventory Turnover = 10.0
Debt Ratio = 30%
Accounts
Payables
$100,000
Long-term Debt
Total Liabilities
Common Equity
________
Total
$1,300,000
=========
Total Asset Turnover = 0.5
Average Collection Period = 45 days
Gross Profit Margin = 30%
Determine the amount of long-term debt for ABC Co. using the following balance sheet information: cash...
Determine the amount of long-term debt for ABC Co. using the
following balance sheet information: cash balance of $24,723,
accounts payable of $95,591, common stock of $401,194, retained
earnings of $500,129, inventory of $204,960, other assets equal to
$76,133, net plant and equipment of $707,654, short-term notes
payable of $30,000, and accounts receivable of $142,312.
Problem 5 – Using the data provided complete the following projected Balance Sheet for Mumford Inc....
Problem 5 –
Using the data provided complete the following
projected Balance Sheet for Mumford Inc. as of and for the year
ended December 31, 2020. Credit (and total) sales were $2,100,000.
(Type in your values)) The long term debt is all interest bearing.
The total stockholders’ equity is a combination of issued common
stock and retained
earnings.
Problem 5 is continued on the next page.
Total asset
turnover
2.4 times
Cash to total
assets
2%
Accounts receivable
turnover 8.0...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Assume that attributes with the same name in different relations represent the same domain and that...
- JAVA: Use existing Java Stack class to solve the "Balancing Symbols" problem. The symbols are (),...
- K-NN and Perceptron theory question If we don’t care about the size of the TRAINING SET...
- Make a C program that simulates time-sharing in the operating system. Please follow the instructions provided:...
- What are some current challenges faced by food companies in reducing food waste?
- Arthur buys $2,200.00 worth of stock. Six months later, the value of the stock has risen...
- The Following table is based on a time study for a metal working operation Obs (minutes...
ADVERTISEMENT