You are required to download  The image That I attached in this question in which you can see last 5 years Financial Progress Of company Assume the unlevered beta of the company is 1.5 for all 5 years Tax Rate 35% Assume Total Liabilities shown on balance sheet as Total Debt Requirements: Calculate the Levered Beta of assigned company for last 5 years.  Plot the graph of the results.  Interpret the change in Beta over the past 5 years  Comment in the industry outlook the company is operating.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question
You are required to download  The image That I attached in this question in which you can see last 5 years Financial Progress Of company
Assume
the unlevered beta of the company is 1.5 for all 5 years
Tax Rate 35%
Assume Total Liabilities shown on balance sheet as Total Debt
Requirements:
Calculate the Levered Beta of assigned company for last 5 years. 
Plot the graph of the results. 
Interpret the change in Beta over the past 5 years 
Comment in the industry outlook the company is operating.
2021
2020
2019
2018
2017
$ 19,179,617 $ 20,638,354 $ 19,862,302 $ 18,262,610 $ 13,639,451
$
19,318 $
Property, Plant and Equipment
Right Of use Assets
49,377
----
----
----
$
1,197 $
100 $
2,736 $
100 $
Intangible Assets
885 $
2,565 $
3,903
Other non Current Assets
100 $
100 $
100
$ 22,519,623 $ 22,172,184 $ 19,896,904 $ 17,327,314 $ 12,727,641
$ 41,719,543 $ 42,861,212 $ 39,762,042 $ 35,592,589 $ 26,371,095
$ 18,887,640 $ 12,725,815 $ 12,878,270 $ 11,825,008 $
Current Assets
Total Assets
Shareholder equity
8,554,247
Non Current liabilities
$
6,474,761 $
6,568,651 $
8,597,759 $
8,476,513 $
5,101,271
$
1,462,435 $
$
Long Term Financing
1,487,634 $
909,943 $
1,201,679 $
1,197,073
6,796,345 $ 11,520,404 $ 10,191,219 $
8,098,362 $ 10,558,708 $
$ 41,719,543 $ 42,861,212 $ 39,762,042 $ 35,592,589 $ 26,371,095
$ 69,796,240 $ 48,081,937 $ 57,484,354 $ 49,159,626 $ 34,822,276
$ (56,304,367) $ (43,869,080) $ (51,035,302) $ (41,528,466) $ (28,916,159)
$ 13,491,873 $
Short term borrowing
8,462,310 $
5,039,236
Other Current Liabilities
$
7,184,851 $
5,627,079 $
6,479,268
Total Equity and Liabilities
Sales-Net
Cost of Sales
Gross Profit
4,212,857 $
6,449,052 $
7,631,160 $
5,906,117
Administrative, Selling and Distribution $ (1,424,515) $ ( 1,157,145) $
(334,257) $
(986,231) $
(533,801) $
39,413 $
(719,689) $
(661,595) $
92,552 $
(548,670)
Other Operating Expense
$ (1,276,659)$
(424,951)
Other Operating Income
$
315,833 $
35,523 $
131,778
$ 11,106,532 $
$
Operating Profit Before Finance Cost
2,756,978 $
4,968,433 $
6,342,428 $
5,064,274
(811,931) $ (2,314,807) $ (1,289,315) $
$ 10,294,601 $
$ (2,828,270) $
$
(539,116) $
5,803,312 $
Finance Cost
(455,500)
442,171 $
52,680 $ (1,014,745) $ (1,438,354) $ (1,564,752)
Profit Before Taxation
3,679,118 $
4,608,774
Taxation
Profit Before Taxation
7,466,331 $
494,851 $
2,664,373 $
4,364,958 $
3,044,022
Transcribed Image Text:2021 2020 2019 2018 2017 $ 19,179,617 $ 20,638,354 $ 19,862,302 $ 18,262,610 $ 13,639,451 $ 19,318 $ Property, Plant and Equipment Right Of use Assets 49,377 ---- ---- ---- $ 1,197 $ 100 $ 2,736 $ 100 $ Intangible Assets 885 $ 2,565 $ 3,903 Other non Current Assets 100 $ 100 $ 100 $ 22,519,623 $ 22,172,184 $ 19,896,904 $ 17,327,314 $ 12,727,641 $ 41,719,543 $ 42,861,212 $ 39,762,042 $ 35,592,589 $ 26,371,095 $ 18,887,640 $ 12,725,815 $ 12,878,270 $ 11,825,008 $ Current Assets Total Assets Shareholder equity 8,554,247 Non Current liabilities $ 6,474,761 $ 6,568,651 $ 8,597,759 $ 8,476,513 $ 5,101,271 $ 1,462,435 $ $ Long Term Financing 1,487,634 $ 909,943 $ 1,201,679 $ 1,197,073 6,796,345 $ 11,520,404 $ 10,191,219 $ 8,098,362 $ 10,558,708 $ $ 41,719,543 $ 42,861,212 $ 39,762,042 $ 35,592,589 $ 26,371,095 $ 69,796,240 $ 48,081,937 $ 57,484,354 $ 49,159,626 $ 34,822,276 $ (56,304,367) $ (43,869,080) $ (51,035,302) $ (41,528,466) $ (28,916,159) $ 13,491,873 $ Short term borrowing 8,462,310 $ 5,039,236 Other Current Liabilities $ 7,184,851 $ 5,627,079 $ 6,479,268 Total Equity and Liabilities Sales-Net Cost of Sales Gross Profit 4,212,857 $ 6,449,052 $ 7,631,160 $ 5,906,117 Administrative, Selling and Distribution $ (1,424,515) $ ( 1,157,145) $ (334,257) $ (986,231) $ (533,801) $ 39,413 $ (719,689) $ (661,595) $ 92,552 $ (548,670) Other Operating Expense $ (1,276,659)$ (424,951) Other Operating Income $ 315,833 $ 35,523 $ 131,778 $ 11,106,532 $ $ Operating Profit Before Finance Cost 2,756,978 $ 4,968,433 $ 6,342,428 $ 5,064,274 (811,931) $ (2,314,807) $ (1,289,315) $ $ 10,294,601 $ $ (2,828,270) $ $ (539,116) $ 5,803,312 $ Finance Cost (455,500) 442,171 $ 52,680 $ (1,014,745) $ (1,438,354) $ (1,564,752) Profit Before Taxation 3,679,118 $ 4,608,774 Taxation Profit Before Taxation 7,466,331 $ 494,851 $ 2,664,373 $ 4,364,958 $ 3,044,022
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Forecasting Financial Statement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education