Question

In: Finance

Below is selected financial data on Peter Parker Insect Control Company.

Net profit margin: 8.6%

COGS $3,700,000

Addition to retained earnings: $115,000

Current ratio: 2.5

Price-earnings ratio: 15.2

Current liabilities: $400,000

Fixed asset turnover: 1.5

Gross margin: 26%

Equity multiplier: 1.75

Common shares: 650,000

Determine the following (show all calculations):

a. Fixed assets (2 points) - round to nearest $

b. Total assets (2 points) - round to nearest $

c. Total liabilities (2 points) - round to nearest $

d. Return on equity (2 points) - use 2 decimals

e. Share price (2 points) - use 2 decimals

Expert Solution

Answer to Part a:
Gross Margin = (Sales – COGS) / Sales
0.26 = (Sales - $3,700,000) / Sales
0.26 * Sales = Sales - $3,700,000
$3,700,000 = 0.74* Sales
Sales = $5,000,000

Fixed Assets Turnover = Sales / Fixed Assets
1.5 = $5,000,000 / Fixed Assets
Fixed Assets = $3,333,333

Answer to Part b:
Current Ratio = Current Assets / Current Liabilities
2.5 = Current Assets / $400,000
Current Assets = $1,000,000

Total Assets = Current Assets + Fixed Assets
Total Assets = $1,000,000 + $3,333,333
Total Assets = $4,333,333

Answer to Part c:
Equity Multiplier = Total Assets / Total Equity
1.75 = $4,333,333 / Total Equity
Total Equity = $2,476,190

Total Assets = Total Liabilities + Total Equity
$4,333,333 = Total Liabilities + $2,476,190
Total Liabilities = $1,857,143

Answer to Part d:
Net Profit Margin = Net Income / Sales
0.086 = Net Income / $5,000,000
Net Income = $430,000

Return on Equity = Net Income / Equity * 100
Return on Equity = $430,000 / $2,476,190 * 100
Return on Equity = 17.37%

Answer to Part e:
Earnings per Share = Net Income / Shares Outstanding
Earnings per Share = $430,000 / 650,000
Earnings per Share = $0.66

Price-Earnings Ratio = Share Price per Share / Earnings per Share
15.2 = Share Price per Share / $0.66
Share Price per Share = $10.03

jeff jeffy answered 2 years ago

Below is selected financial data on Peter Parker Insect Control Company. Net profit margin: 14.15% COGS &

Below is selected financial data on Peter Parker Insect Control Company. Net profit margin: 14.15% COGS $4,000,000 Addition to retained earnings: $435,400 Current ratio: 1.9 Price-earnings ratio: 12 Current liabilities: $480,000 Fixed asset turnover: 1.6 Gross margin: 22% Equity multiplier: 1.95 Common shares: 125,000 Determine the following (show all calculations): a. Fixed assets (2 points)- round to nearest $ b. Total assets (2 points)- round to nearest $ c. Total liabilities (2 points)- round to nearest $ d. Return on...

Below is selected financial data on Peter Parker Insect Control Company. Net profit margin: 8.6% COGS...

Below is selected financial data on Peter Parker Insect Control Company. Net profit margin: 8.6% COGS $3,700,000 Addition to retained earnings: $115,000 Current ratio: 2.5 Price-earnings ratio: 15.2 Current liabilities: $400,000 Fixed asset turnover: 1.5 Gross margin: 26% Equity multiplier: 1.75 Common shares: 650,000 Determine the following (show all calculations): a. Fixed assets (2 points) - round to nearest $ b. Total assets (2 points) - round to nearest $ c. Total liabilities (2 points) - round to nearest $...

Parker Company produces mathematical and financial calculators and operates at capacity. Data related to the two...

Parker Company produces mathematical and financial calculators and operates at capacity. Data related to the two products are presented here: Mathematical Financial Annual production in units 50,000 100,000 Direct material costs $150,000 $300,000 Direct manufacturing labor costs $ 50,000 $100,000 Direct manufacturing labor-hours 2,500 5,000 Machine-hours 25,000 50,000 Number of production runs 50 50 Inspection hours 1,000 500 Total manufacturing overhead costs are as follows: Total Machining costs $375,000 Setup costs $120,000 Inspection costs $105,000 1. Choose a cost driver for each overhead...

Shown below are selected data from the financial statements of planet Company, a retain lighting store

Shown below are selected data from the financial statements of planet Company, a retain lighting store.From the Balance Sheet:Cash................................................................................................... $ 40,000Accounts receivable........................................................................... 165,000Inventory............................................................................................ 215,000Plant assets (net of accumulated depreciation).................................. 600,000Current liabilities............................................................................... 185,000Total stockholders’ equity................................................................. 400,000Total assets........................................................................................ 1,200,000From the Income Statement:Net sales............................................................................................. $2,000,000Cost of goods sold............................................................................. 1,600,000Operating expenses............................................................................ 300,000Interest expense................................................................................. 75,000Income taxes expense........................................................................ 5,000Net income......................................................................................... 20,000From the Statement of Cash Flows:Net cash provided by operating activities(including interest paid of $68,000)............................................... $ 42,000Net cash used in investing activities.................................................. (49,000)Financing activities:Amounts borrowed................................................. $...

Below is selected financial information from the financial statements of company A and company B. Both...

Below is selected financial information from the financial statements of company A and company B. Both company A and company B started their business on 1/1/2019. Company A Company B current assets on 12/31/2019 100 8,000 total assets on 12/31/2019 11,000 28,000 current liability on 12/31/2019 200 4,000 total liability on 12/31/2019 4,000 18,000 sales revenue on 12/31/2019 4,500 20,000 Cost of goods sold for year 2019 1,000 16,000 interest expense for year 2019 400 1,000 net income for year...

Reproduced below are selected financial data at the end of Year 6 and forecasts for the...

Reproduced below are selected financial data at the end of Year 6 and forecasts for the end of Year 7 for AlMasa Company: Account Year 6 Year 7 (Forecast) Cash $42,000 ? Accounts receivable 90,000 ? Inventory 38,400 $90,000 Fixed assets 120,000 120,000 Accumulated depreciation 25,800 30,000 Accounts payable 78,000 146,400 Notes payable 21,000 18,000 Accrued taxes 10,800 0 Capital stock 120,000 120,000 Additional forecast estimates for Year 7: Sales $495,000 Net Income $12,000 Cost of sales 55% of sales...

Selected financial data from the June 30 year-end statements of Safford Company are given below: Total...

Selected financial data from the June 30 year-end statements of Safford Company are given below: Total assets $ 5,700,000 Long-term debt (11% interest rate) $730,000 Total stockholders’ equity $ 2,400,000 Interest paid on long-term debt $80,300 Net income $470,000 Total assets at the beginning of the year were $5,500,000; total stockholders’ equity was $2,200,000. The company’s tax rate is 40%. Required: 1. Compute the return on total assets. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be...

Selected financial statement data (in $ thousands) for KRJ Enterprises are listed below, calculate the interest...

Selected financial statement data (in $ thousands) for KRJ Enterprises are listed below, calculate the interest coverage ratio. Present your answer rounded to two decimal places. e.g. 20.00. Sales $10,183 Cost of goods sold 5,676 Cash operating expenses 1,844 Depreciation expense 497 Interest expense 174 Tax expense 213 Footnotes report that $240 of lease expenses are included in cash operating expenses, $26 of interest expenditures were capitalized during the year, and $538 of debt was repaid during the year.

Selected data from the financial statements of KRJ Manufacturing are presented below. Calculate the return on...

Selected data from the financial statements of KRJ Manufacturing are presented below. Calculate the return on assets for the year, presenting your answer in percentage terms, rounded to two decimal places. e.g. 20.00%. Sales $117,358 Gross profits $51,639 Operating profits (EBIT) $32,879 Earnings before taxes (EBT) $25,389 Net profits $24,739 Tax expense 8,000 Depreciation expense $13,207 Total assets, beg of year $80,302 Total assets, end of year $99,082 Total equity, beg of year $46,237 Total equity, end of year $53,675...

Selected financial data for Changretta Inc. and Solomon Ltd. (in $ thousands) are presented below. Changretta...

Selected financial data for Changretta Inc. and Solomon Ltd. (in $ thousands) are presented below. Changretta Inc. Solomon Ltd. Statement of Comprehensive Income (Loss) Total revenue $36,755 $36,333 Cost of sales 18,930 26,136 Gross profit 17,825 10,197 Operating expenses 17,110 8,076 Profit from operations 715 2,121 Interest expense (revenue) (36 ) 535 Other expenses 153 - Other non-operating income 351 436 Profit before income tax 949 2,022 Income tax expense 325 627 Profit $624 $1,395 Changretta Inc. Solomon Ltd. Balance...