FIN_520_Critical_Thinking_Module_5
docx
School
Colorado State University, Global Campus *
*We aren’t endorsed by this school
Course
520
Subject
Accounting
Date
Feb 20, 2024
Type
docx
Pages
6
Uploaded by DeaconSkunkMaster1022
Module 5
Erin Mazzola
Colorado State University Global
FIN520: Financial Reporting and Analysis
Dr. John Halstead
January 21, 2023
Profitability Analysis Exercises and Problems
Do the assigned problems using Summer Peebles, Inc.'s condensed 2014 financial data below:
Assets
Current Assets
$ 250,000.00 Noncurrent Assets
1,750,000.00 Total Assets
$ 2,000,000.00 Liabilities and Equity
Current Liabilities
$ 200,000.00 Noncurrent Liabilities (8% Bonds)
675,000.00 Common Stockholders' Equity
1,125,000.00 Total Liabilities and Equity
$ 2,000,000.00 Additional Information:
* Net income for 2014 is
$ 157,500.00 * Income tax rate is
50%
* Amounts for total assets and shareholders' equity are the same for 2013 and 2014.
* All assets and current liabilities are considered to be operating.
Determine Whether Keverage (from long-term debt) Benefits Rose's Shareholders
Since there are no preferred dividends to take into account, the return on common equity (ROCE) with leverage is 14.00%. This is calculated by dividing the net income of $157,500.00 reported for 2014 by the average equity held by common shareholders (Subramanyam, 2014). The average common shareholders' equity is identical to the $1,125,000.00 stated for 2014 common stockholders' equity because the 2013 and 2014 shareholders' equity were equivalent. Conversely, ROCE in the absence of leverage is 10.25 percent. The initial pretax profit was multiplied by the interest expenditure of $54,000.00 to arrive at a new pretax gain (without leverage) of $369,000.00 [315,000.00 + $54,000.00]. Net income (before deducting the 50% income tax) without leverage is $184,500. Additionally, since it is assumed that equity will be
used in place of the noncurrent liabilities (8% Bonds) in order to fund the net operating assets (NOA), the $675,000 is added to the $1,125,000.00 reported for 2014 common stockholder equity, making the total equity (without leverage) equal to $1,800,000. Based on the computed percentages, Summer Peebles, Inc. stockholders do profit from the long-term debt's leverage since its ROCE with leverage (14.00%) is higher than its ROCE without leverage (10.25%).
ROCE with Leverage
=
$ 157,500.00 =
14.00%
$ 1,125,000.00
Net income
$ 157,500.00
Income tax rate
50%
Pretax profit (with leverage)
$ 315,000.00
Interest Expense
54,000.00
Pretax profit (without leverage)
$ 369,000.00
Tax expense (without leverage)
184,500.00
Net income (without leverage)
$ 184,500.00
ROCE without Leverage
=
184,500.00 =
10.25%
1,800,000.00 Compute the NOPAT and RNOA
Effective tax rate
50%
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
NOPAT
=
Operating Profit * (1 - Effective tax rate) =
$ 184,500.00 The NOA utilized for the denominator below is equal to $1,800,000, which is the total assets of $2,000,000.00 minus the current liabilities of $200,000.00, since the numbers for total assets are identical for 2013 and 2014 and because all assets and current liabilities are regarded as operational.
RNOA
=
NOPAT
=
10.25%
Average net operating assets (NOA)
Demonstrate the Favorable Effect of Leverage Given the Disaggregation of ROCE
When broken down, the return of net operating assets (RNOA) in addition to the impact of economic leverage (LEV x Spread) equals ROCE, according to Subramanyam (2014). The following is a breakdown of the ROCE of 14.00% using this formula:
The net operating income post tax (NOPAT) split by the average NOA yields the RNOA of 10.25%, which is equivalent to the ROCE sans leverage. The average net financial obligation (NFO) of $675,000.00, which is the noncurrent liabilities (8% Bonds) split by the average equity of $1,125,000.00, yields an LEV of 0.60. Spread of 6.25% is computed by dividing the net financial expenditure (NFE) of $27,000 [$54,000 * 1 – 50%] by the average NFO of $675,000. This results in RNOA of 10.25% minus the net financial rate (NFR) of 4.00%.
The beneficial
impact of leverage is equivalent to 3.75%, that is the ROCE of 14% less the RNOA of 10.75%, since ROCE is bigger than RNOA. This indicates that by offering the 8% bonds to fund NOA, the firm was able to increase its ROCE.
ROCE
=
RNOA
+
(LEV
x Spread
)
=
10.25%
+
0.60
x
6.25%
=
14.00%
Favorable effect of leverage
3.75%
References:
Subramanyam, K. R. (2014). Financial statement analysis
(11
th
Ed.). New York, NY: McGraw-
Hill Education
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
Please give me true answer this financial accounting question
arrow_forward
Calculate the EFN, external financing needed.
arrow_forward
Hii expert please given correct answer financial accounting
arrow_forward
Need help with this question solution general accounting
arrow_forward
Please help with this question
arrow_forward
Previous
Nex
You are a financial Manager of Chevron Corp You need to assess the effectiveness of
working capital management.of the company for 2018 using the following data What is th
2018 Payable turnover?
2017 Accoun Receivable 15 353 000
2018 Account Receivable 15,050 000
2017 Inventory = 5 585 000
2018 Inventory = 5 704.000
2017 Accounts Payable = 14 565.000
2018 Accounts Payable = 13 953 000
2017 Sales = 134 674 000
2018 Sales = 158 902.000
2017 Cost of Sales = 96 114.000
2018 Cost of Sales = 113 997 000
2017 Purchases = 95 114 000
2018 Purchases
123 435.000
arrow_forward
CHAPTER 18 Financial Analysis: The Big Picture
Exercises
Instructions
Prepare a statement of comprehensive income, beginning with income from continuing operations.
re horizontal analysis.
E18.3 (LO 2) Here is financial information for Glitter Inc.
December 31, 2020
December 31, 2019
Excel
$ 90,000
350,000
65,000
$106,000
400,000
99,000
122,000
130,000
155,000
Current assets
Plant assets (nct)
Current liabilities
Long-term liabilities
Common stock, $1 par
Retained earnings
90,000
115,000
170,000
Instructions
Prepare a schedule showing a horizontal analysis for 2020, using 2019 as the base year.
pare vertical analysis.
E18.4 (LO 2) Operating data for Joshua Corporation are presented below.
2020
2019
Excel
$600,000
$800,000
520,000
120,000
60,000
30,000
70,000
Sales revenuc
408,000
Cost of goods sold
Selling expenses
Administrative expenses
72,000
48,000
24,000
48,000
Income tax expense
Net income
Instructions
Prepare a schedule showing a vertical analysis for 2020 and 2019.
E18.5 (LO 2)…
arrow_forward
Financial Accounting Question Solve Please
arrow_forward
provide reasons for the attached calculated ratios using GSK 2023 annual report and provide non-financail performance analysis examples for GSK 2023.
arrow_forward
Need Help Completing Terminology Matching
arrow_forward
Calculate net profit margin of the year 2019 and 2020
arrow_forward
Calculate gross profit ratio for the year 2018 and 2019
arrow_forward
Calculate ROA solution general accounting question
arrow_forward
Data needed: SFP Asset section
1. Cash 16.3%
2. AR 6.3%
3. Short term investment 0.2%
4. Inventory 2.2%
5. Prepaid expenses 0.4%
6. PPE 74.7%
Data needed: SFP Liabilities and OE
section.
1. Current liab 16%
2. Non-current liab 34.2%
3. OE 49.9%
Data needed: SCI
1. COGS 38.6%
2. Selling and admin exp 6.8%
3. Interest exp 0.1%
4. Income tax exp 0.5%
5. Net income 54%
arrow_forward
REQUIREMENTS
1. Recommendation for company A
2. Conclusion for company A
arrow_forward
Can you help me with accounting questions
arrow_forward
Hello tutor solve this problem and accounting question
arrow_forward
d. Calculate the Efficiency ratio which includes the sales to total assets ratio, operating return on assets,
return on assets, ROA Model, return on equity, and ROE Model
arrow_forward
Solve this question accounting
arrow_forward
Back to Assignment
Attempts 0
Keep the Highest 0/1
18. Problem 12-02 (Projected Operating Assets)
eBook
Projected Operating Assets
Berman & Jaccor Corporation's current sales and partial balance sheet are shown below.
This year
Sales
$1,000
Balance Sheet: Assets
Cash
$ 150
Short-term investments
$ 95
Accounts receivable
$ 200
Inventories
$ 300
Total current assets
$ 745
Net fixed assets
Total assets
$ 500
$1,245
Sales are expected to grow by 14% next year. Assuming no change in operations from this year to next year, what are the projected total operating assets? Do not round
intermediate calculations. Round your answer to the nearest dollar.
Grade it Now
Save & Continue
Continue without saving
arrow_forward
Hardev
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Related Questions
- Need help with this question solution general accountingarrow_forwardPlease help with this questionarrow_forwardPrevious Nex You are a financial Manager of Chevron Corp You need to assess the effectiveness of working capital management.of the company for 2018 using the following data What is th 2018 Payable turnover? 2017 Accoun Receivable 15 353 000 2018 Account Receivable 15,050 000 2017 Inventory = 5 585 000 2018 Inventory = 5 704.000 2017 Accounts Payable = 14 565.000 2018 Accounts Payable = 13 953 000 2017 Sales = 134 674 000 2018 Sales = 158 902.000 2017 Cost of Sales = 96 114.000 2018 Cost of Sales = 113 997 000 2017 Purchases = 95 114 000 2018 Purchases 123 435.000arrow_forward
- CHAPTER 18 Financial Analysis: The Big Picture Exercises Instructions Prepare a statement of comprehensive income, beginning with income from continuing operations. re horizontal analysis. E18.3 (LO 2) Here is financial information for Glitter Inc. December 31, 2020 December 31, 2019 Excel $ 90,000 350,000 65,000 $106,000 400,000 99,000 122,000 130,000 155,000 Current assets Plant assets (nct) Current liabilities Long-term liabilities Common stock, $1 par Retained earnings 90,000 115,000 170,000 Instructions Prepare a schedule showing a horizontal analysis for 2020, using 2019 as the base year. pare vertical analysis. E18.4 (LO 2) Operating data for Joshua Corporation are presented below. 2020 2019 Excel $600,000 $800,000 520,000 120,000 60,000 30,000 70,000 Sales revenuc 408,000 Cost of goods sold Selling expenses Administrative expenses 72,000 48,000 24,000 48,000 Income tax expense Net income Instructions Prepare a schedule showing a vertical analysis for 2020 and 2019. E18.5 (LO 2)…arrow_forwardFinancial Accounting Question Solve Pleasearrow_forwardprovide reasons for the attached calculated ratios using GSK 2023 annual report and provide non-financail performance analysis examples for GSK 2023.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning