FIN 3010 quiz Financial Modelling Answers
.docx
keyboard_arrow_up
School
Humber College *
*We aren’t endorsed by this school
Course
3010
Subject
Finance
Date
Apr 3, 2024
Type
docx
Pages
4
Uploaded by ProfProton14956
Financial Statement Analysis: FIN 3010 Quiz: Financial Statement Modelling Answers
1.
B is correct.
Operating (EBIT) margin is a pre-tax profitability measure that can be useful in the peer comparison of companies in countries with different tax structures. Archway’s two main competitors are located in different countries with significantly different tax structures; therefore,
a pre-tax measure is better than an after-tax measure, such as ROIC. The current ratio is a liquidity measure, not a profitability measure.
2
A is correct.
Porter’s five forces framework in Exhibit 1 describes an industry with high barriers
to entry, high customer switching costs (suggesting a low threat of substitutes), and a specialized product (suggesting low bargaining power of buyers). Furthermore, the primary production inputs from the large group of suppliers are considered basic commodities (suggesting low bargaining power of suppliers). These favorable industry characteristics will likely enable Archway to pass along price increases and generate above-average returns on invested capital.
3
A is correct.
The current favorable characteristics of the industry (high barriers to entry, low bargaining power of suppliers and buyers, low threat of substitutes), coupled with Archway’s dominant market share position, will likely lead to Archway’s profit margins being at least equal to or greater than current levels over the forecast horizon.
4
C is correct.
The calculation of Archway’s gross profit margin for 2020, which reflects the industry-wide 8% inflation on COGS, is calculated as follows:
Revenue growth
1.85%
COGS increase
4.76%
Forecasted revenue (Base revenue = 100)
101.85
Forecasted COGS (Base COGS = 30)
31.43
Forecasted gross profit
70.42
Forecasted gross profit margin
69.14%
Revenue growth = (1 + Price increase for revenue) × (1 + Volume growth) – 1= (1.05) × (0.97) –
1= 1.85%.COGS increase = (1 + Price increase for COGS) × (1 + Volume growth) – 1= (1.08) × (0.97) – 1= 4.76%.Forecasted revenue = Base revenue × Revenue growth increase= 100 × 1.0185= 101.85.Forecasted COGS = Base COGS × COGS increase= 30 × 1.0476= 31.43.Forecasted gross profit = Forecasted revenue – Forecasted COGS= 101.85 – 31.43= 70.42.Forecasted gross profit margin = Forecasted gross profit/Forecasted revenue= 70.42/101.85= 69.14%.
5
C is correct.
French is using a bottom-up approach to forecast Archway’s working capital accounts by using the company’s historical efficiency ratios to project future performance.
6
C is correct.
If the future growth or profitability of a company is likely to be lower than the historical average (in this case, because of a potential technological development), then the target
multiple should reflect a discount to the historical multiple to reflect this difference in growth and/or profitability. If a multiple is used to derive the terminal value of a company, the choice of the multiple should be consistent with the long-run expectations for growth and required return. French tells Wright he believes that such a technological development could have an adverse impact on Archway beyond the forecast horizon.
7. B is correct.
Forecasting a single scenario would not be appropriate given the high degree of uncertainty and range of potential outcomes for companies in this industry.
8
C is correct.
Economies of scale are a situation in which average costs decrease with increasing sales volume. Chrome’s gross margins have been increasing with net sales. Gross margins that increase with sales levels provide evidence of economies of scale, assuming that higher levels of sales reflect increased unit sales. Gross margin more directly reflects the cost of sales than does profit margin.
Metric
2017
2018
2019
Net sales
$46.8
$50.5
$53.9
Gross profit
28.6
32.1
35.1
Gross margin (gross profit/net sales)
61.11%
63.56
%
65.12%
9
A is correct.
A bottom-up approach for developing inputs to equity valuation models begins at the level of the individual company or a unit within the company. By modeling net sales using the average annual growth rate, Candidate A is using a bottom-up approach. B and C are incorrect because both Candidate B and Candidate C are using a top-down approach, which begins at the level of the overall economy.
10
B is correct.
A top-down approach usually begins at the level of the overall economy. Candidate
B assumes industry sales will grow at the same rate as nominal GDP but that Chrome will have a
2-percentage-point decline in market share. A and C are incorrect because Candidate B is not using any elements of a bottom-up approach; therefore, a hybrid approach is not being employed
11
C is correct.
Candidate C assumes that the 2020 gross margin will increase by 20 bps from 2019
and that net sales will grow at 50 bps slower than nominal GDP (nominal GDP = Real GDP +
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 Questions
What is the meaning of each financial ratio?
arrow_forward
Please provide type solution fast i will rate for sure
arrow_forward
Q.1. You are an investment analyst domiciled in Country Z
doing a cross-country comparison of the financial
performance of two manufacturing companies in the
pharmaceuticals industry. Both companies, X and Y (located
in Countries X and Y), have similar expected sales of $600
million. Country X has a corporate income tax. Country Y
has no income tax but relies on indirect taxes. Selected data
for companies X and Y are as follows:
Соmpaпy X
Соmpany Y
Pretax income
$120 million
$72 million
Return on sales
12.0%
12.0%
Required: Determine which company promises to have the
better financial performance? What tax considerations might
affect your conclusions?
arrow_forward
HI. PLease help me with this one. You may use excel if you want. Thank you! :)
arrow_forward
A firm's market-to-book ratio might be greater than 1.0 due to accounting reasons. An example of an accounting reason that would cause the market-to-book ratio to increase is
a. straight-line methods of depreciation.
b. using LIFO versus FIFO for inventory.
c. level 1 fair values.
d. off-balance-sheet assets arising from investments in successful research and development programs that are expensed according to conservative accounting principles.
arrow_forward
EBITDA is one indicator of a firm's financial performance and is used as aproxy for the earning potential of a firm.1) Explain why EBITDA can be used to analyze and compare profitability amongfirms in different industries and even in different countries. 2) Explain what is the EV multiple. And then explain why it is analogous to thepayback period in finance or managerial accounting
arrow_forward
Please see the attached graph for questions below.
What is the difference between the two companies on this ratio? What is a plausible explanation as to why they would differ? Is one company clearly different than the other?
Are there economic or end-market influences that explain why the ratios differ? What might they be?
Over time, is each company’s overall financial performance improving, declining, or is something strange going on?
Do you think evaluating financial statements is a good idea? What do you regard as some of the shortcomings of financial ratio analysis?
arrow_forward
Give typing answer with explanation and conclusion
_____ 2.) A company has a tax burden ratio of 0.4, a compound leverage factor of 0.6, a return on sales of 0.9, a leverage ratio of 0.7, and an asset turnover of 0.3. What is the ROE for the company?
A.) 2.90%
B.) 4.54%
C.) 6.48%
D.) 11.4%
E.) None of the above
arrow_forward
When converting dollar amounts on our financial statements to percentages for vertical analysis, what is it that makes this an easier way to compare companies to each other?
A
It provides a way for outside stakeholders to understand the numbers better in an easier format
B
It forces us to look closer at our financial statements to ensure we don't have missing amounts
C
It allows us to compare things based on growth or decline easier than comparing dollar amounts that could be vastly different values
D
It allows the analysis of numbers too large to comprehend by most stakeholders
arrow_forward
TRUE OR FALSE
Horizontal analysis is possible for both an income statement and a statement of financial position.
Financial analysis is primarily a matter of making relevant mechanical computations.
It is possible that a decrease in gross profit rate may be offset by a decrease in expenses, thus resulting in an increase in net income.
On a, common-size income statement, net income is given an equivalent of 100%
Short-term creditors generally are more concerned with vertical analysis than with horizontal analysis.
Percentage changes are usually computed by using the latest figure as a base.
Industry standards tend to place the performance of a company in a more meaningful perspective.
The peso amount of change during an accounting period for an item appearing in financial statements is less significant than the change measured as a percentage.
An increase in sales volume generally is accompanied by a proportionate increase in net income.
Common-size financial statements show peso…
arrow_forward
Give typing answer with explanation and conclusion
Which of the following is false?
A) All else constant, if a firm can decrease its operating costs, then return on equity will decrease.
B) Ratios that measure how efficiently a firm manages its assets and operations to generate net income are referred to as profitability ratios.
C) The portion of net income that a firm reinvests in itself is called the retention ratio.
D) If DJ's has total assets of $300,000, net fixed assets of $120,000, and the average daily operating costs of $3,000, then its value of the interval measure is 60 days.
arrow_forward
Please Need Correct answer
arrow_forward
(a) – Explain the concept of Tax Deduction in WACC. Does this tax deduction make debt finance Cheaper Then Equity Finance?
(b) – Compare Dividend Valuation Model with Capital Asset Pricing Model in the context of calculating cost of equity? Can use of these two methods result in differing values of business?
arrow_forward
A)Calculate the following ratios: • Return on Capital Employed (ROCE) • Current Ratio • Gearing Ratio • Price/Earnings (P/E) Ratio
B) Based on the above ratios explain, which company George H. and James W. should invest in and discuss the limitations of your analysis.
arrow_forward
None
arrow_forward
I need help with questions 1-4
arrow_forward
Answer the following question in essay.
What do you understand by current ratio? What are it uses? What are its
limitations?
Ratio analysis is widely used as a tool of financial analysis, yet it suffers from
various limitations. Explain.
How can solvency of a firm be measured?
What you understand by Liquidity ratios? Discuss their significance.
Page 1
Module PSFM08 MANAGERIAL ACOUNTING WITH FINANCIAL ANALYSIS AND REPORTING
Explain the importance of profitability ratio. How they are worked out?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Related Questions
- What is the meaning of each financial ratio?arrow_forwardPlease provide type solution fast i will rate for surearrow_forwardQ.1. You are an investment analyst domiciled in Country Z doing a cross-country comparison of the financial performance of two manufacturing companies in the pharmaceuticals industry. Both companies, X and Y (located in Countries X and Y), have similar expected sales of $600 million. Country X has a corporate income tax. Country Y has no income tax but relies on indirect taxes. Selected data for companies X and Y are as follows: Соmpaпy X Соmpany Y Pretax income $120 million $72 million Return on sales 12.0% 12.0% Required: Determine which company promises to have the better financial performance? What tax considerations might affect your conclusions?arrow_forward
- HI. PLease help me with this one. You may use excel if you want. Thank you! :)arrow_forwardA firm's market-to-book ratio might be greater than 1.0 due to accounting reasons. An example of an accounting reason that would cause the market-to-book ratio to increase is a. straight-line methods of depreciation. b. using LIFO versus FIFO for inventory. c. level 1 fair values. d. off-balance-sheet assets arising from investments in successful research and development programs that are expensed according to conservative accounting principles.arrow_forwardEBITDA is one indicator of a firm's financial performance and is used as aproxy for the earning potential of a firm.1) Explain why EBITDA can be used to analyze and compare profitability amongfirms in different industries and even in different countries. 2) Explain what is the EV multiple. And then explain why it is analogous to thepayback period in finance or managerial accountingarrow_forward
- Please see the attached graph for questions below. What is the difference between the two companies on this ratio? What is a plausible explanation as to why they would differ? Is one company clearly different than the other? Are there economic or end-market influences that explain why the ratios differ? What might they be? Over time, is each company’s overall financial performance improving, declining, or is something strange going on? Do you think evaluating financial statements is a good idea? What do you regard as some of the shortcomings of financial ratio analysis?arrow_forwardGive typing answer with explanation and conclusion _____ 2.) A company has a tax burden ratio of 0.4, a compound leverage factor of 0.6, a return on sales of 0.9, a leverage ratio of 0.7, and an asset turnover of 0.3. What is the ROE for the company? A.) 2.90% B.) 4.54% C.) 6.48% D.) 11.4% E.) None of the abovearrow_forwardWhen converting dollar amounts on our financial statements to percentages for vertical analysis, what is it that makes this an easier way to compare companies to each other? A It provides a way for outside stakeholders to understand the numbers better in an easier format B It forces us to look closer at our financial statements to ensure we don't have missing amounts C It allows us to compare things based on growth or decline easier than comparing dollar amounts that could be vastly different values D It allows the analysis of numbers too large to comprehend by most stakeholdersarrow_forward
- TRUE OR FALSE Horizontal analysis is possible for both an income statement and a statement of financial position. Financial analysis is primarily a matter of making relevant mechanical computations. It is possible that a decrease in gross profit rate may be offset by a decrease in expenses, thus resulting in an increase in net income. On a, common-size income statement, net income is given an equivalent of 100% Short-term creditors generally are more concerned with vertical analysis than with horizontal analysis. Percentage changes are usually computed by using the latest figure as a base. Industry standards tend to place the performance of a company in a more meaningful perspective. The peso amount of change during an accounting period for an item appearing in financial statements is less significant than the change measured as a percentage. An increase in sales volume generally is accompanied by a proportionate increase in net income. Common-size financial statements show peso…arrow_forwardGive typing answer with explanation and conclusion Which of the following is false? A) All else constant, if a firm can decrease its operating costs, then return on equity will decrease. B) Ratios that measure how efficiently a firm manages its assets and operations to generate net income are referred to as profitability ratios. C) The portion of net income that a firm reinvests in itself is called the retention ratio. D) If DJ's has total assets of $300,000, net fixed assets of $120,000, and the average daily operating costs of $3,000, then its value of the interval measure is 60 days.arrow_forwardPlease Need Correct answerarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning