Question
In: Finance
Problem 3-35 Using ratios to construct financial statements [LO3-2] The following information is from Harrelson Inc.'s,...
Problem 3-35 Using ratios to construct financial statements [LO3-2]
The following information is from Harrelson Inc.'s, financial
statements. Sales (all credit) were $25.20 million for last
year.
| Sales to total assets | 1.40 | times |
| Total debt to total assets | 35 | % |
| Current ratio | 2.80 | times |
| Inventory turnover | 6 | times |
| Average collection period | 20 | days |
| Fixed asset turnover | 5 | times |
Complete the balance sheet: (Use a 360-day year. Do not
round intermediate calculations. Input your answers in millions
rounded to 2 decimal places.)
$ in millions $ in millions
Cash _________________ Current Debt _____________
accounts receivable_________ Long-term debt__________
Inventory______________ Total Debt _________
Total Current Assets ___________
Fixed assets______________ Equity _______________
Total Assets ________________ Total Debt and stockholder's equity___________
Solutions
Expert Solution
Ans:
(i) Sales / total assets = 1.4
25.2 / total assets = 1.4
(ii) total assets = 25.2 / 1.4
= $ 18 million
total debt to total assets = 35%
total debt = 35% * total assets
= 35% * 18 million
= 6.3 million
Total assets - total debt = equity
18 - 6.3 = 11.7 = Equity
(iii) fixed assets turnover = 5
Net sales / net fixed assets = 5
25.2 / 5 = net fixed assets
net fixed assets = 5.04 million
(iv) Total current assets = total assets - fixed assets
= 18 million - 5.04 million
= 12.96 million
current ratio = current assets / current liabilities
2.8 = 12.96 / current liabilities
current liabilities = 12.96 / 2.8
= 4,628,571
(v) inventory turnover ratio = net sales / average inventory
6 = 25.2 / inventory
inventory = 4.2 million
(vi) average collection period = 20 days
360 / net sales * average accounts receivable = 20
360 / 20 = net sales / account receivable
account receivable = 25.2 / 18
= 1.4 million
current asset = cash + inventory + account receivable
12.96 = cash + 4.2 + 1.4
cash = 12.96 - 4.2 - 1.4
= 7.36 million
(vii) Total debt - current liabilities = long term debt
6,300,000 - 4,628,571 = 1,671,429
| Cash | 7360000 | Current Debt | 4628571 |
| account receivable | 1400000 | Long term debt | 1671429 |
| inventory | 4200000 | Total debt | 6300000 |
| Total current assets | 12960000 | Equity | 11700000 |
| Fixed assets | 5040000 | ||
| Total assets | 18000000 | Total debt and Equity | 18000000 |
jeff jeffy answered 1 year agoRelated Solutions
Problem 3-36 Comparing all the ratios [LO3-2] Using the financial statements for the Snider Corporation, calculate...
Problem 3-36 Comparing all the ratios [LO3-2]
Using the financial statements for the Snider Corporation,
calculate the 13 basic ratios found in the
chapter.
SNIDER CORPORATION
Balance Sheet
December 31, 20X1
Assets
Current assets:
Cash
$
53,000
Marketable securities
26,400
Accounts receivable (net)
235,000
Inventory
257,000
Total current assets
$
571,400
Investments
65,100
Plant and equipment.
$699,000
Less: Accumulated depreciation
222,000
Net plant and equipment
477,000
Total assets
$
1,113,500
Liabilities and Stockholders' Equity
Current liabilities:
Accounts payable
$...
Problem 3-15 (Algo) Journal Entries; T-Accounts; Financial Statements [LO3-1, LO3-2, LO3-3, LO3-4] Froya Fabrikker A/S of...
Problem 3-15 (Algo) Journal Entries; T-Accounts; Financial
Statements [LO3-1, LO3-2, LO3-3, LO3-4]
Froya Fabrikker A/S of Bergen, Norway, is a small company that
manufactures specialty heavy equipment for use in North Sea oil
fields. The company uses a job-order costing system that applies
manufacturing overhead cost to jobs on the basis of direct
labor-hours. Its predetermined overhead rate was based on a cost
formula that estimated $373,700 of manufacturing overhead for an
estimated allocation base of 1,010 direct labor-hours. The...
Problem 3-15 Journal Entries; T-Accounts; Financial Statements [LO3-1, LO3-2, LO3-3, LO3-4] Froya Fabrikker A/S of Bergen,...
Problem 3-15 Journal Entries; T-Accounts; Financial Statements
[LO3-1, LO3-2, LO3-3, LO3-4]
Froya Fabrikker A/S of Bergen, Norway, is a small company that
manufactures specialty heavy equipment for use in North Sea oil
fields. The company uses a job-order costing system that applies
manufacturing overhead cost to jobs on the basis of direct
labor-hours. Its predetermined overhead rate was based on a cost
formula that estimated $350,000 of manufacturing overhead for an
estimated allocation base of 1,000 direct labor-hours. The
following...
Problem 3-15 Journal Entries; T-Accounts; Financial Statements [LO3-1, LO3-2, LO3-3, LO3-4] Froya Fabrikker A/S of Bergen,...
Problem 3-15 Journal Entries; T-Accounts; Financial Statements
[LO3-1, LO3-2, LO3-3, LO3-4]
Froya Fabrikker A/S of Bergen, Norway, is a small company that
manufactures specialty heavy equipment for use in North Sea oil
fields. The company uses a job-order costing system that applies
manufacturing overhead cost to jobs on the basis of direct
labor-hours. Its predetermined overhead rate was based on a cost
formula that estimated $380,000 of manufacturing overhead for an
estimated allocation base of 1,000 direct labor-hours. The
following...
Problem 4-7 Financial Ratios (LO3) Here are simplified financial statements for Phone Corporation in a recent...
Problem 4-7 Financial Ratios (LO3)
Here are simplified financial statements for Phone Corporation
in a recent year:
INCOME
STATEMENT
(Figures in $
millions)
Net sales
$
12,600
Cost of goods sold
3,760
Other expenses
4,127
Depreciation
2,338
Earnings before interest and taxes (EBIT)
$
2,375
Interest expense
655
Income before tax
$
1,720
Taxes (at 35%)
602
Net income
$
1,118
Dividends
$
816
BALANCE SHEET
(Figures in $ millions)
End of Year
Start of Year
Assets
Cash and...
Assigning a Long-Term Debt Rating Using Financial Ratios Refer to the information below from Nordstrom Inc.’s...
Assigning a Long-Term Debt Rating Using Financial
Ratios
Refer to the information below from Nordstrom Inc.’s 2016
financial statements. Use the information to answer the
requirements ($ millions).
Sales
$15,093
Depreciation expense
578
Tax expense
394
Interest expense, gross
171
Earnings from continuing operations (Net income)
685
EBITA
1,256
Cash
613
Average total assets
9,470
Total debt
2,908
Noncurrent deferred tax liabilities
391
Noncontrolling interest
0
Equity
871
Dividends paid
1,185
Cash from operating activities
2,451
a. Compute the following...
Assigning a Long-Term Debt Rating Using Financial Ratios Refer to the information below from Nordstrom Inc.’s...
Assigning a Long-Term Debt Rating Using Financial Ratios
Refer to the information below from Nordstrom Inc.’s 2016
financial statements. Use the information to answer the
requirements ($ millions).
Sales
$16,983
Depreciation expense
626
Tax expense
442
Interest expense, gross
219
Earnings from continuing operations (Net income)
896
EBITA
1,611
Cash
661
Average total assets
11,360
Total debt
3,167
Noncurrent deferred tax liabilities
554
Noncontrolling interest
0
Equity
871
Dividends paid
1,185
Cash from operating activities
2,451
a. Compute the following...
1.Chapter 2 covers financial ratios. Financial ratios are calculated from a company's financial statements, and they...
1.Chapter 2 covers financial ratios. Financial ratios are
calculated from a company's financial statements, and they can be
used to determine how well a company is performing. Discuss in
detail, the difference between a performance measure and a
performance referent and provide a complete example of each.
2.Identify and discuss 5 different financial ratios, show how
they are calculated (formula and data sources), and what the ratios
seek to identify.
Market value ratios Ratios are mostly calculated using data drawn from the financial statements of a...
Market value ratios
Ratios are mostly calculated using data drawn from the financial
statements of a firm. However, another group of ratios, called
market value ratios, relate to a firm’s observable market value,
stock prices, and book values, integrating information from both
the market and the firm’s financial statements.
Consider the case of Cold Goose Metal Works Inc.:
Cold Goose Metal Works Inc. just reported earnings after tax
(also called net income) of $95,000,000 and a current stock price
of...
The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $37.80 million for...
The following information is from Harrelson Inc.'s, financial
statements. Sales (all credit) were $37.80 million for last
year.
Sales to total
assets
2.10
times
Total debt to total assets
30
%
Current ratio
2.60
times
Inventory turnover
5
times
Average collection period
10
days
Fixed asset turnover
5
times
Complete the balance sheet: (Use a 360-day year. Do not
round intermediate calculations. Input your answers in millions
rounded to 2 decimal places.)
$ in millions
$ in millions
Cash...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- How does process evaluation and continuous improvement effect project management and the critical path? Apply "Real-World"...
- A student stands at the edge of a cliff and throws a stone horizontally over the...
- Limestone (CaCO3(s)) is fed into a kiln and converted into quicklime (CaO(s)) via the following reaction:...
- 1. Write chemical reactions for both DNA polymerization activity and 3'-->5' exonuclease activity of a DNA...
- [AP Bio] Light wavelength significance for photosynthesis? I am writing an analysis based on a theoretical...
- C++ program Reference: while loop, if....else, for loop, the % operator MARTIAN BOOLEAN MULTIPLICATION OBJECTIVE: To...
- In a spray dryer operation, milk powder with a moisture content of 4 %wt is produced...
ADVERTISEMENT