a. Search Yahoo Finance or any other credible source to find the most recent income statement...
a. Search Yahoo Finance or any other credible source to find the most recent income statement and balance sheet of a major corporation. Provide these statements in the appropriate format. Perform a vertical analysis and comment on your finding. Perform a financial analysis incorporating debt ratio, debt to equity ratio, return on assets, return on equity, current ratio, quick ratio, inventory turnover, days in inventory, accounts receivable turnover, accounts receivable cycle in days, accounts payable turnover, accounts payable cycle in days, earnings per share (EPS), and price to earnings ratio (P/E). Comment on your finding. Present your work in detail and explain. Provide references for content. b. An individual obtains a car loan which pays $30,000. The loan will be paid off in 3 years, and payments are made monthly. Interest rate on the loan is 7%, and compounding is monthly. Find the amount of monthly payments to pay the loan off. Provide a complete amortization schedule of the loan (this will entail a long table containing 37 rows). Present your work in detail and explain. Provide references for content.
Homework Answers
(a) Vertical Analysis
![Income Statement For the Years Ending [Dec 31, 2018 and Dec 31, 2017] [ABC & Co.] 2018 % of net sales 100.00% 2017 % of net sales 100.00% Revenue 1,10,000 95,000 Sales revenue (Less sales returns and allowances) Service revenue Interest revenue Other revenue 70,000 12,000 18,000 2,10,000 63.64% 10.91% 16.36% 190.91% 62,000 15,000 21,500 1,93,500 65.26% 15.79% 22.63% 203.68% Total Revenues Expenses Advertising Bad debt Commissions Cost of goods sold Depreciation Employee benefits Furniture and equipment Insurance Interest expense Maintenance and repairs Office supplies Payroll taxes 1,000 520 1,452 65,000 2,500 8,500 14,500 750 4,200 1,250 1,120 2,250 0.91% 0.47% 1.32% 59.09% 227% 7 73% 13.18% 0.68% 3.82% 1.14% 1.02% 2.05% 1,000 458 3,650 63,000 1,500 6,500 8,000 750 5,200 320 1,470 3,658 1.05% 0.48% 3.84% 66.32% 1.58% 6.84% 8.42% 0.79% 5.47% 0.34% 1.55% 3.85%](http://img.homeworklib.com/questions/eda3b890-748e-11ea-8f90-dba87f97322c.png?x-oss-process=image/resize,w_560)
![Balance Sheet For the Years Ending [Dec 31, 2018 and Dec 31, 2017] [ABC & Co.] Assets Current Assets 2018 % of Total assets 2017 % of Total assets Cash Accounts receivable Inventory Prepaid expenses Short-term investments 11,874 25,114 15,200 230 1,600 54,018 9,856 12,546 12,500 125 1,600 36,627 16.83% 35.59% 18.19% 23.16% 23.07% 0.23% 2.95% 67.61% 21.54% 0.33% 227% Total current assets 76.55% Fixed (Long-Term) Assets Long-term investments Property, plant, and equipment (Less accumulated depreciation) Intangible assets 1,208 15,340 (2,500) 2,500 16,548 70,566 1.71% 21.74% 3.54% 3.54% 23.45% 100.00% 1,208 15,340 (1,500) 2,500 17,548 54,175 2.23% 28.32% 277% 4.61% 32.39% 100.00% Total fixed assets Total Assets](http://img.homeworklib.com/questions/ee7594f0-748e-11ea-86d7-6f758c6d464c.png?x-oss-process=image/resize,w_560)
(b) Loan Schedule
*Red cells in the below figures indicate formulas.
Add Answer to:
a. Search Yahoo Finance or any other credible source to find the
most recent income statement...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets $ 340 390 310 Current assets Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Plant and equipment, net Total assets $ 225 370 340 20 955 1,210 $2,165 1.060 1,340 $2,400 $ 310 50 $ 340 50 40 400 300 Liabilities and stockholders' Equity Current liabilities Accounts payable Accrued...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets $ $ 225 370 340 340 390 310 Current assets: Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Plant and equipment, net Total assets 20 955 1,210 $2,165 20 1,060 1,340 $2,400 $ $ 340 310 50 Liabilities and Stockholders' Equity Current liabilities: Accounts payable Accrued liabilities Notes payable,...
DuPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of...
DuPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $2 million sinking fund payment on its debt. The most recent industry average ratios and the firm's financial statements are as follows: Industry Average Ratios Current ratio 3.34x Fixed assets turnover 7.44x Debt-to-capital ratio 19.28% Total assets turnover 3.70x Times interest earned 35.45x Profit margin 12.64% EBITDA...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: Cash $ 170 $ 230 Accounts receivable, net 260 280 Inventory 230 200 Prepaid expenses 20 20 Total current assets 680 730 Plant and equipment, net 880 900 Total assets $ 1,560 $ 1,630 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 200 $ 230 Accrued liabilities 50...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: Cash $ 235 $ 360 Accounts receivable, net 390 410 Inventory 360 330 Prepaid expenses 20 20 Total current assets 1,005 1,120 Plant and equipment, net 1,270 1,420 Total assets $ 2,275 $ 2,540 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 330 $ 360 Accrued liabilities 50...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: Cash $ 235 $ 360 Accounts receivable, net 390 410 Inventory 360 330 Prepaid expenses 20 20 Total current assets 1,005 1,120 Plant and equipment, net 1,270 1,420 Total assets $ 2,275 $ 2,540 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 330 $ 360 Accrued liabilities 50...
Chapter 4 Analysis of Financial Statements 141 Barry Computer Company: Income Statement for Year Ended December...
Chapter 4 Analysis of Financial Statements 141 Barry Computer Company: Income Statement for Year Ended December 31, 2019 (in Thousands) Sales Cost of goods sold $1,607,500 Materials $717,000 Labor 453,000 Heat, light, and power 68,000 Indirect labor 113,000 Depreciation 41,500 1,392,500 Gross profit $ 215,000 Selling expenses 115,000 General and administrative expenses 30,000 Earnings before interest and taxes (EBIT) 70,000 Interest expense 21,000 Earnings before taxes (EBT) 49,000 Federal and state income taxes (25%) 12,250 Net income $ 36,750 Earnings...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: Cash $ 170 $ 230 Accounts receivable, net 260 280 Inventory 230 200 Prepaid expenses 20 20 Total current assets 680 730 Plant and equipment, net 880 900 Total assets $ 1,560 $ 1,630 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 200 $ 230 Accrued liabilities 50...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: Cash $ 205 $ 300 Accounts receivable, net 330 350 Inventory 300 270 Prepaid expenses 20 20 Total current assets 855 940 Plant and equipment, net 1,090 1,180 Total assets $ 1,945 $ 2,120 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 270 $ 300 Accrued liabilities 50...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: Cash $ 180 $ 250 Accounts receivable, net 280 300 Inventory 250 220 Prepaid expenses 20 20 Total current assets 730 790 Plant and equipment, net 940 980 Total assets $ 1,670 $ 1,770 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 220 $ 250 Accrued liabilities 50...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets $ 340 390 310 Current assets Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Plant and equipment, net Total assets $ 225 370 340 20 955 1,210 $2,165 1.060 1,340 $2,400 $ 310 50 $ 340 50 40 400 300 Liabilities and stockholders' Equity Current liabilities Accounts payable Accrued...
Hyrkas Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets $ $ 225 370 340 340 390 310 Current assets: Cash Accounts receivable, net Inventory Prepaid expenses Total current assets Plant and equipment, net Total assets 20 955 1,210 $2,165 20 1,060 1,340 $2,400 $ $ 340 310 50 Liabilities and Stockholders' Equity Current liabilities: Accounts payable Accrued liabilities Notes payable,...
Chapter 4 Analysis of Financial Statements 141 Barry Computer Company: Income Statement for Year Ended December 31, 2019 (in Thousands) Sales Cost of goods sold $1,607,500 Materials $717,000 Labor 453,000 Heat, light, and power 68,000 Indirect labor 113,000 Depreciation 41,500 1,392,500 Gross profit $ 215,000 Selling expenses 115,000 General and administrative expenses 30,000 Earnings before interest and taxes (EBIT) 70,000 Interest expense 21,000 Earnings before taxes (EBT) 49,000 Federal and state income taxes (25%) 12,250 Net income $ 36,750 Earnings...
Most questions answered within 3 hours.
-
The tires of a car make 61 revolutions as the car reduces its
speed uniformly from...
asked 8 minutes ago -
Peabody, Inc., sells fireworks. The company’s marketing director
developed the following cost of goods sold budget...
asked 12 minutes ago -
A signal transduction pathway includes the steps listed
below.
1. An inactive signal transduction molecule is...
asked 11 minutes ago -
1. The correlation coefficient determined for two variables has
a value of 0.89. Describe, in words,...
asked 17 minutes ago -
The following data relate to direct materials costs for
November:
Actual costs
4,700 pounds at $5.35...
asked 16 minutes ago -
Kyle, a 95.0 kg football player, leaps straight up into the air
(with no horizontal velocity)...
asked 40 minutes ago -
Which of the following is a measure of profitability?
A.
Quick (acid-test) ratio
B.
Net sales...
asked 42 minutes ago -
Find the total pressure exerted by 2 grams of ethane and 3 grams
of CO2 contained...
asked 44 minutes ago -
A fireman standing on a 5.2 m high ladder operates a water hose
with a round...
asked 40 minutes ago -
A cream formulation is studied for accelerated stability study.
Creaming was observed when formulation was tested...
asked 43 minutes ago -
A 1,150 lumen light bulb is placed 37 cm in front of a mirrored
wall, whose...
asked 53 minutes ago -
Given that z is a standard normal random variable, compute the
following probabilities (to 4 decimals)....
asked 59 minutes ago