Question

In: Finance

Consider Fisher & Company’s financial data as follows (unit: millions of dollars except ratio and time...

Consider Fisher & Company’s financial data as follows (unit: millions of dollars except ratio and time figures):

Cash and marketable securities

$100

Fixed assets

$280

Sales

$1,200

Net income

$358

Inventory

$180

Current ratio

3.2

Average collection periods

45 days

Average common equity

$500

  1. Find Fisher’s accounts receivable
  2. Calculate the amount of current assets
  3. Determine the amount of current liabilities
  4. Determine the amount of total assets
  5. Calculate the amount of the long-term debt
  6. Calculate the net profit margin

Solutions

Expert Solution

A) - Average collection period = (Average Receivables/Net sales)*365

45 = (Average Receivables/$1200 million)*365

Average Receivables = $ 147.9452 million

B) - Current Assets = Average Receivables + Cash and marketable securities + Inventory

= $ 147.9452 million + $100 million + $180 million

= $ 427.9452 million

C)- Current Ratio = Current Assets/Current Liabilities

3.20 = $ 427.9452 million/Current Liabilities

Current Liabilities = $ 133.7329 million

D)- Total Assets = Current Assets + Fixed Assets

= $427.9452 million + $ 280 million

= $ 707.9452 million

E). Total Assets = Total Liabilities & Equities

Total Liabilities & Equities = Current Liabilities + Long Term Debt + Average common Equity

$ 707.9452 million = $ 133.7329 million + Long Term Debt + $ 500 million

Long Term Debt = $ 74.2123 million

F). Net Profit Margin = Net Income/Sales

= $358 m/$1200 m

= 29.83%

If you need any clarification, you can ask in comments.     

If you like my answer, then please up-vote as it will be motivating


Related Solutions

Debt-to-Equity Ratio The following financial data is from Hi-Tech Instruments' financial statements (thousands of dollars, except...
Debt-to-Equity Ratio The following financial data is from Hi-Tech Instruments' financial statements (thousands of dollars, except earnings per share.) 2016 Sales revenue $210,000 Cost of goods sold 125,000 Net income 9,300 Dividends 2,600 Earnings per share 4.65 Hi-Tech Instruments, Inc. Balance Sheet (Thousands of Dollars) Dec. 31, 2016 Dec. 31, 2015 Assets Cash $19,300 $18,000 Accounts receivable (net) 45,000 41,000 Inventory 39,500 43,700 Total current assets 103,800 102,700 Plant assets (net) 52,600 50,500 Other assets 15,600 13,800 Total assets $172,000...
6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014...
6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014 2015 2016 2018 2019 Revenue: 30 32 34 35 39 39 45 Let the year 2010 be the base year with x=0. a) Model the data with a linear function using the points in years 2010 and 2019. Round computed values to 2 decimal places. Also, using your model predict the revenue in the year 2021 accurate to 3 decimal places. b) Set up...
Consider the following data on the estimated cost (in millions of dollars) resulting from traffic congestion...
Consider the following data on the estimated cost (in millions of dollars) resulting from traffic congestion for different urban areas. The following are the data for the 13 largest U.S. urban areas. Urban Area Total Cost (millions of dollars) New York 16 Los Angeles 13 Chicago 7 Washington, D.C. 5 Houston 5 Dallas, Fort Worth 4 Detroit 4 Miami 4 Phoenix 4 Philadelphia 4 San Francisco 3 Boston 3 Atlanta 3 (a) Calculate the mean and standard deviation for this...
Selected financial data for Surf City and Paradise Falls are as follows: ($ in millions) Surf...
Selected financial data for Surf City and Paradise Falls are as follows: ($ in millions) Surf City Paradise Falls 2018 2017 2018 2017   Total assets $ 16,133 $ 14,922 $ 33,296 $ 34,121   Total liabilities 9,720 8,195   13,938 14,188   Total stockholders’ equity 6,413 6,727 19,358 19,933   Sales revenue $ 6,503 $ 14,616   Interest expense 318 408   Tax expense 44   Net income 568 2,324 1-a. Calculate the debt to equity ratio for Surf City and Paradise Falls for the most recent...
Selected financial data for Bahama Bay and Caribbean Key are as follows: ($ in millions) Bahama...
Selected financial data for Bahama Bay and Caribbean Key are as follows: ($ in millions) Bahama Bay Caribbean Key 2018 2017 2018 2017   Total assets $ 9,883 $ 9,802 $ 9,083 $ 9,122   Total liabilities 8,172 7,636 7,613 7,603   Total stockholders’ equity 1,711 2,166 1,470 1,519   Sales revenue $ 5,997 $ 12,969   Interest expense 237 181   Tax expense 85 359   Net income 347 380 Selected financial data for Bahama Bay and Caribbean Key are as follows: ($ in millions) Bahama...
Consider the following data ( in millions of dollars): Year Real DI Real C 0 1900...
Consider the following data ( in millions of dollars): Year Real DI Real C 0 1900 1839 1 2000 1935 2 1700 1647 For now, assume that no other variable ( besides disposable income) that could affect real consumption has changed between Year 0, Year 1, and Year 2. a.) Draw the general shape of the consumption function. b.) Solve for the marginal propensity to consume ( show your work). c.) What is the slope of this consumption function (...
Consider the following 2016 data for Newark Hospital (in millions of dollars) Simple Budget Flexible Budget...
Consider the following 2016 data for Newark Hospital (in millions of dollars) Simple Budget Flexible Budget Actual Results Revenues $4.7 $4.8 $4.5 Costs 4.1 4.1 4.2 Profit 0.6 0.7 0.3 a. Calculate and interpret the two profit variances b. Calculate and interpret the two revenue variances. c. Calculate and interpret the two cost variances. d. how are the variances related Answer a-d.
Royal Corp’s financial information (in millions, except for Dividends) for Problems 2 and 3:                           &nbsp
Royal Corp’s financial information (in millions, except for Dividends) for Problems 2 and 3:                                                          2019                2018 Accounts Payable                                            $ 7,000           $ 6,780 Accounts Receivable                                           5,000               4,685 Additional Paid-in Capital                                  4,000               4,000 Cash                                                                    8,577               5,654 Common Stock                                                   3,107               3,107           Cost of Goods Sold                                        48,464           47,594 Depreciation                                                        1,315               1,244           Dividends per share                                              1.53                 1.28 Goodwill                                                         18,051           19,121 Interest Expense                                                  1,200               1,100 Inventory                                                            8,871          ...
Royal Corp’s financial information (in millions, except for Dividends) for Problems 2 and 3:                           &nbsp
Royal Corp’s financial information (in millions, except for Dividends) for Problems 2 and 3:                                                          2019                2018 Accounts Payable                                            $ 7,000           $ 6,780 Accounts Receivable                                           5,000               4,685 Additional Paid-in Capital                                  4,000               4,000 Cash                                                                    8,577               5,654 Common Stock                                                   3,107               3,107           Cost of Goods Sold                                        48,464           47,594 Depreciation                                                        1,315               1,244           Dividends per share                                              1.53                 1.28 Goodwill                                                         18,051           19,121 Interest Expense                                                  1,200               1,100 Inventory                                                            8,871          ...
Royal Corp’s financial information (in millions, except for Dividends) for Problems 2 and 3:                           &nbsp
Royal Corp’s financial information (in millions, except for Dividends) for Problems 2 and 3:                                                          2019                2018 Accounts Payable                                           $  7,000           $  6,780 Accounts Receivable                                          5,000               4,685 Additional Paid-in Capital                                  4,000               4,000 Cash                                                                    8,577               5,654 Common Stock                                                   3,107               3,107            Cost of Goods Sold                                           48,464             47,594 Depreciation                                                       1,315               1,244            Dividends per share                                              1.53                 1.28 Goodwill                                                           18,051             19,121 Interest Expense                                                 1,200               1,100 Inventory                                                            8,871               8,101 Long-Term Debt                                                     ?                      ?   Net Property, Plant & Equipment                    26,500             25,311 Notes Payable                                                     4,200               3,770 Research & Development Expense                    1,847               1,747 Retained Earnings                                                   ?                23,045            Revenue                                                            61,200             59,000 Selling General & Admin Expense                    3,200               3,024 Shares Outstanding                                             1,170               1,280 Treasury Stock                                                   (6,500)           (4,200)                                      Tax Rate = 30% Note that a reduction in Goodwill would be similar to Depreciation Expense in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT