BUS.WK8,6
docx
keyboard_arrow_up
School
Colorado State University, Global Campus *
*We aren’t endorsed by this school
Course
5440
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
2
Uploaded by MagistrateWren2087
Problem 14.8 (LO3) Comparing Bell and Gangway Financial information for Bell and Gangway (two computer manufacturers) follows: Bell Gangway Year Ended Year Ended Year Ended Year Ended (in millions) 12/31/2020 12/31/2019 12/31/2020 12/31/2019 Sales $61,133 $57,420 $8,922 $8,457 Cost of sales 49,462 47,904 7,316 6,951 Gross margin $11,671 $ 9,516 §1,606 $1,506 Inventory $ 1,180 S 660 S 400 s 351 Required a. Compare Bell and Gangway in terms of their percentage changes in sales and gross margin. b. Compare Bell and Gangway in (erms of their gross Margin percentages. ¢. Compare Bell and Gangway in terms of inventory turnover and days' sales in inventory d. . In your opinion, which firm has had better financial performance? Support your answer using your calculations in parts a, b, and c. Problem 12.3 (LO2) Return on Investment Consider the following information for McKinley and Son: 12/31/2020 12/31/2021 Total assets $55,000,000 $62,000,000 Noninterest-bearing current liabilities 1,100,000 1,320,000 Net income 3,300,000 3,400,000 Interest expense 726,000 770,000 Tax rate 20% 20% Required a. Calculate ROI for 2020 and 2021. Round ROI to four decimal places. b. While income has increased in fiscal 2021, is it clear that the company’s performance has improved?
TP Problem 14.6 (L03) Analyzing Financial Ratios and Cash Flows Venture Auto Parts is chain of 40 stores offerng a full ine of auto parts and supplics to consumers and independent auto repair shops. Danny’s Brake and Mufler has over 90 storesin the cities serviced by Venture. Recently, Danny Morton. the founder of Danny s Brake and Muler,was approached by Venture with an ineresting offe. Venture Veants to be the sole supplicr of mufflcrs and brake part to Danny's. In exchange, Venture wil invest | in technology to monitor Danny's inventory levels and make timely deliveries o all locations. Venture ' fasserts thatthie el willea to lower part prices and greater inventory turnover for Danny's. I 0 s e o negation, Dasny's chetsountans, Sass Wikon, was ssigred the task of analyzing the confidential audited financial statements of Venture. As part of her work, Sarah | | calculated the following ratios and obtained Venture's statement o cash flows for iscal 2021 Lo | | Fiscal 2021 Fiscal 2020 | Cartentratio 165 155 Quickratio om 050 I Inventory tarnover 10 s& Debt o cquity 300 23 B ‘Times interest carned 110 20 | Venture Auto Parts Statement of Cash Flows Year Ended December 31,2021 | Cash Provided from Operations | Netcamings s 900000 | Reconclsion ofnet carings o nc cash provided by aperstions: Deprecition and amortization 500000 Increase in receivables (3500000) Increasein merchandie inventories (1100000) | ey s | Increas i income taxes payable 100000 Net cash provided by operations 6100000 Cash flows from investing actvities Purchase of Dundee Stores Purchase of property Net cash used in investing activities Cash flows from financing activities Proceeds from long-term borrowings Net cash provided by financing activities Increase fn cash and cash equivalents Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year Required Based on thislimited information, would you recommend that Danny pursue the deal with Venture?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
2021
2022
2023
Year
Forsen Computing
Net Credit Sales
$1,557,200
1,855,310
2,165,170
Ending Accounts
Receivable
$398,000
414,400
500,780
1. Compute the accounts receivable turnover ratios and the number of days' sales in receivables
ratios for 2022 and 2023 (round answers to two decimal places)
What do the outcomes tell a potential investor about Vortex Computing if industry average for
accounts receivable turnover ratio is 4 times and days' sales in receivables ratio is 85 days?
94%
See 2 Edito
arrow_forward
Need help with this question solution general accounting
arrow_forward
29
arrow_forward
Hi experts please answer the financial accounting question
arrow_forward
Sales (in millions)
TVs
5
4
3
2
1
0
Computers
Phones
2017
2.8
1.2
4.5
PREVIOUS
2018
2.5
1.1
4.8
-TVs -
In which year were total sales the worst across all products?
Please select a single option below
2019
3.3
0.9
5.5
Axis Title
Computers - Phones
9 of 12
2020
3.8
1.5
5.1
2021
3.4
1.7
5.7
NEXT
arrow_forward
Hello tutor solve this question
arrow_forward
Kmu
arrow_forward
Please solve this question general accounting
arrow_forward
Need help with this financial accounting question not use ai
arrow_forward
Not use ai please given answer financial accounting
arrow_forward
Solvency and Profitability Trend Analysis
(Picture is attached and this is the only one I got wrong, what did I do wrong?)
Addai Company has provided the following comparative information:
20Y8
20Y7
20Y6
20Y5
20Y4
Net income
$273,406
$367,976
$631,176
$884,000
$800,000
Interest expense
616,047
572,003
528,165
495,000
440,000
Income tax expense
31,749
53,560
106,720
160,000
200,000
Total assets (ending balance)
4,417,178
4,124,350
3,732,443
3,338,500
2,750,000
Total stockholders’ equity (ending balance)
3,706,557
3,433,152
3,065,176
2,434,000
1,550,000
Average total assets
4,270,764
3,928,396
3,535,472
3,044,250
2,475,000
Average total stockholders' equity
3,569,855
3,249,164
2,749,588
1,992,000
1,150,000
You have been asked to evaluate the historical performance of the company over the last five years.
Selected industry ratios have remained relatively steady at the following…
arrow_forward
answer plz
arrow_forward
financial Accounting question
arrow_forward
Solve this question and accounting question
arrow_forward
Solvency and Profitability Trend Analysis
(Part A is the only one I got incorrect, let me know what the correct answers are)
Addai Company has provided the following comparative information:
20Y8
20Y7
20Y6
20Y5
20Y4
Net income
$273,406
$367,976
$631,176
$884,000
$800,000
Interest expense
616,047
572,003
528,165
495,000
440,000
Income tax expense
31,749
53,560
106,720
160,000
200,000
Total assets (ending balance)
4,417,178
4,124,350
3,732,443
3,338,500
2,750,000
Total stockholders’ equity (ending balance)
3,706,557
3,433,152
3,065,176
2,434,000
1,550,000
Average total assets
4,270,764
3,928,396
3,535,472
3,044,250
2,475,000
Average total stockholders' equity
3,569,855
3,249,164
2,749,588
1,992,000
1,150,000
You have been asked to evaluate the historical performance of the company over the last five years.
Selected industry ratios have remained relatively steady at the…
arrow_forward
Sub. Cost account
arrow_forward
Hello please provide solution
arrow_forward
Sh3
arrow_forward
Need answer the financial accounting question please answer do fast
arrow_forward
Hi expert please give me answer general accounting question
arrow_forward
Calculate the profit margin (net income or net profit/total sales)for Rock Castle construction for this fiscal year. What’s the percentage
arrow_forward
Question Content Area
Accounts Receivable Analysis
Xavier Stores Company and Lestrade Stores Inc. are large retail department stores. Both companies offer credit to their customers through their own credit card operations. Information from the financial statements for both companies for two recent years is as follows (in millions):
Xavier
Lestrade
Sales
$8,500,000
$4,585,000
Credit card receivables-beginning
820,000
600,000
Credit card receviables-ending
880,000
710,000
a. Determine the (1) accounts receivable turnover and (2) the number of days' sales in receivables for both companies. Round your calculations and answers to one decimal place. Assume 365 days a year.
Xavier
Lestrade
1. Accounts receivable turnover
fill in the blank 1
fill in the blank 2
2. Number of days' sales in receivables
fill in the blank 3
days
fill in the blank 4
days
b. Fill in the blank: Xavier's accounts receivable turnover is much 1)_____ than Lestrade's. The…
arrow_forward
Solve
arrow_forward
General Accounting solve please
arrow_forward
Please answer A,B,C
Required information
Problem 14-15 (Algo) Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6]
Skip to question
[The following information applies to the questions displayed below.]
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows:
Lydex CompanyComparative Balance Sheet
This Year
Last Year
Assets
Current assets:
Cash
$ 860,000
$ 1,100,000
Marketable securities
0
300,000
Accounts receivable, net
2,300,000
1,400,000
Inventory
3,500,000
2,000,000
Prepaid expenses
240,000
180,000
Total current assets
6,900,000
4,980,000
Plant and equipment, net
9,320,000
8,950,000
Total assets
$ 16,220,000
$ 13,930,000
Liabilities and…
arrow_forward
Get correct answer general accounting
arrow_forward
Segment analysis for a service company
Charles Schwab Corporation (SCHW) is one of the more innovative brokerage and financial service companies in the United States. The company recently provided information about its major business segments as follows (in millions):
InvestorServices
AdvisorServices
Revenues
$5,411
$2,067
Operating income
2,031
962
Depreciation
180
54
a. The segment serves the retail customer, you and me. These are the brokerage, Internet, and mutual fund services used by individual Investors. The segment includes the same services provided for financial institutions, such as banks, mutual fund managers, insurance companies, and pension plan administrators.
b. Indicate whether the following costs are a “Variable Cost” or a “Fixed Cost” in the “Investor Services” segment.
1. Commissions to brokers 2. Fees paid to exchanges for executing trades 3. Depreciation on brokerage offices 4. Transaction fees incurred by Schwab mutual funds…
arrow_forward
what formula can I use to recreate this table in excel?
arrow_forward
Particulars
Procter & Gamble
Colgate-Palmolive
Net Sales 2018
66832
15544
Accounts Receivables 2018
4686
1400
Accounts Receivables 2017
4594
1480
Average Receivables
(4686+4594)/2 = 4640
(1400+1480)/2 = 1440
Accounts Receivables Turnover Ratio = Net Credit Sales ÷ Average Receivables
66832/4640 = 14.40
15544/1440 = 10.79
DSO = Accounts Receivables ÷ Net Credit Sales × 365
14.40/66832 = 25.34
10.79/15544 = 33.81
A) Identify and discuss a potential explanation for the difference between these competitors’ Accounts receivable ratios
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Related Questions
- 2021 2022 2023 Year Forsen Computing Net Credit Sales $1,557,200 1,855,310 2,165,170 Ending Accounts Receivable $398,000 414,400 500,780 1. Compute the accounts receivable turnover ratios and the number of days' sales in receivables ratios for 2022 and 2023 (round answers to two decimal places) What do the outcomes tell a potential investor about Vortex Computing if industry average for accounts receivable turnover ratio is 4 times and days' sales in receivables ratio is 85 days? 94% See 2 Editoarrow_forwardNeed help with this question solution general accountingarrow_forward29arrow_forward
- Hi experts please answer the financial accounting questionarrow_forwardSales (in millions) TVs 5 4 3 2 1 0 Computers Phones 2017 2.8 1.2 4.5 PREVIOUS 2018 2.5 1.1 4.8 -TVs - In which year were total sales the worst across all products? Please select a single option below 2019 3.3 0.9 5.5 Axis Title Computers - Phones 9 of 12 2020 3.8 1.5 5.1 2021 3.4 1.7 5.7 NEXTarrow_forwardHello tutor solve this questionarrow_forward
- Not use ai please given answer financial accountingarrow_forwardSolvency and Profitability Trend Analysis (Picture is attached and this is the only one I got wrong, what did I do wrong?) Addai Company has provided the following comparative information: 20Y8 20Y7 20Y6 20Y5 20Y4 Net income $273,406 $367,976 $631,176 $884,000 $800,000 Interest expense 616,047 572,003 528,165 495,000 440,000 Income tax expense 31,749 53,560 106,720 160,000 200,000 Total assets (ending balance) 4,417,178 4,124,350 3,732,443 3,338,500 2,750,000 Total stockholders’ equity (ending balance) 3,706,557 3,433,152 3,065,176 2,434,000 1,550,000 Average total assets 4,270,764 3,928,396 3,535,472 3,044,250 2,475,000 Average total stockholders' equity 3,569,855 3,249,164 2,749,588 1,992,000 1,150,000 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following…arrow_forwardanswer plzarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning