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
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