Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Scenario 1 Ratio of price to book value should not exceed 22.5 If: Price/BV = 20--> Enterprise Value $20,407,410.61 $28,388,406.98 $15,194,283.04 Absurdly high valuations Price/BV

Scenario 1

Ratio of price to book value should not exceed 22.5
If: Price/BV = 20-->
Enterprise Value $20,407,410.61 $28,388,406.98 $15,194,283.04 Absurdly high valuations
Price/BV = 10-->
Enterprise Value $10,203,705.30 $14,194,203.49 $7,597,141.52 Not much more realistic
Factors for PBV
12.75 10.5 9 7.5
50% of total multiple 50% 50% 50% 50%
60% of total multiple 60% 60% 60% 60%
Full data set $3,902,917.28 $3,214,167.17 $2,755,000.43 $2,295,833.69
Post-2023 $5,429,282.83 $4,471,174.10 $3,832,434.94 $3,193,695.78
2023-2028 $2,905,906.63 $2,393,099.58 $2,051,228.21 $1,709,356.84
Range of valuations for PBV method:
Min $2,399,629
Average $3,179,508
Mid-range $4,151,805
Max $5,429,283
Since we have some actual performance data (2021 and 2022) and relatively short0range forecast for 2023, some investors will focus on post-2023 valuations.
Shorter term investors would focus on narrower range of estimates.

Scenario 2

Ratio of price to book value should not exceed 22.5
If: Price/BV = 20-->
Enterprise Value $13,885,942.95 $19,481,625.74 $10,248,605.03 Absurdly high valuations
Price/BV = 10-->
Enterprise Value $6,942,971.48 $9,740,812.87 $5,124,302.52 Not much more realistic
Factors for PBV
12.75 10.5 9 7.5
50% of total multiple 50% 50% 50% 50%
60% of total multiple 60% 60% 60% 60%
Full data set $2,655,686.59 $2,187,036.02 $1,874,602.30 $1,562,168.58
Post-2023 $3,725,860.92 $3,068,356.05 $2,630,019.47 $2,191,682.90
2023-2028 $1,960,045.71 $1,614,155.29 $1,383,561.68 $1,152,968.07

Range of valuations for PBV method:
Min $1,635,607
Average $2,167,179
Mid-range $2,849,188
Max $3,725,861
Since we have some actual performance data (2021 and 2022) and relatively short0range forecast for 2023, some investors will focus on post-2023 valuations.
Shorter term investors would focus on narrower range of estimates.

Scenario 3

Ratio of price to book value should not exceed 22.5
If: Price/BV = 20-->
Enterprise Value $8,505,028.68 $12,140,235.06 $6,047,890.48 Absurdly high valuations
Price/BV = 10-->
Enterprise Value $4,252,514.34 $6,070,117.53 $3,023,945.24 Not much more realistic
Factors for PBV
12.75 10.5 9 7.5
50% of total multiple 50% 50% 50% 50%
60% of total multiple 60% 60% 60% 60%
Full data set $1,626,586.73 $1,339,542.02 $1,148,178.87 $956,815.73
Post-2023 $2,321,819.95 $1,912,087.02 $1,638,931.73 $1,365,776.44
2023-2028 $1,156,659.05 $952,542.75 $816,465.22 $680,387.68
Range of valuations for PBV method:
Min $1,000,993
Average $1,326,316
Mid-range $1,775,509
Max $2,321,820
Since we have some actual performance data (2021 and 2022) and relatively short0range forecast for 2023, some investors will focus on post-2023 valuations.
Shorter term investors would focus on narrower range of estimates.

Scenario 4

Ratio of price to book value should not exceed 22.5
If: Price/BV = 20-->
Enterprise Value $4,553,329.35 $6,761,205.47 $3,063,356.15 Absurdly high valuations
Price/BV = 10-->
Enterprise Value $2,276,664.68 $3,380,602.73 $1,531,678.08 Not much more realistic
Factors for PBV
12.75 10.5 9 7.5
50% of total multiple 50% 50% 50% 50%
60% of total multiple 60% 60% 60% 60%
Full data set $870,824.24 $717,149.37 $614,699.46 $512,249.55
Post-2023 $1,293,080.55 $1,064,889.86 $912,762.74 $760,635.62
2023-2028 $585,866.86 $482,478.59 $413,553.08 $344,627.57
Range of valuations for PBV method:
Min $539,171
Average $714,401
Mid-range $988,826
Max $1,293,081
Since we have some actual performance data (2021 and 2022) and relatively short0range forecast for 2023, some investors will focus on post-2023 valuations.
Shorter term investors would focus on narrower range of estimates.

Scenario 5

Ratio of price to book value should not exceed 22.5
If: Price/BV = 20-->
Enterprise Value $1,375,047.06 $2,442,875.69 $718,593.57 Absurdly high valuations
Price/BV = 10-->
Enterprise Value $687,523.53 $1,221,437.85 $359,296.79 Not much more realistic
Factors for PBV
12.75 10.5 9 7.5
50% of total multiple 50% 50% 50% 50%
60% of total multiple 60% 60% 60% 60%
Full data set $262,977.75 $216,569.91 $185,631.35 $154,692.79
Post-2023 $467,199.98 $384,752.92 $329,788.22 $274,823.52
2023-2028 $137,431.02 $113,178.49 $97,010.13 $80,841.78
Range of valuations for PBV method:
Min $170,119
Average $225,408
Mid-range $357,271
Max $467,200

Since we have some actual performance data (2021 and 2022) and relatively short0range forecast for 2023, some investors will focus on post-2023 valuations.
Shorter term investors would focus on narrower range of estimates.

Scenario 6

Ratio of price to book value should not exceed 22.5
If: Price/BV = 20-->
Enterprise Value ($457,241.55) ($27,400.52) ($569,482.96) Absurdly high valuations
Price/BV = 10-->
Enterprise Value ($228,620.78) ($13,700.26) ($284,741.48) Not much more realistic
Factors for PBV
12.75 10.5 9 7.5
50% of total multiple 50% 50% 50% 50%
60% of total multiple 60% 60% 60% 60%
Full data set ($87,447.45) ($72,015.54) ($61,727.61) ($51,439.67)
Post-2023 ($5,240.35) ($4,315.58) ($3,699.07) ($3,082.56)
2023-2028 ($108,913.62) ($89,693.57) ($76,880.20) ($64,066.83)
Range of valuations for PBV method:
Min ($39,530)
Average ($52,377)
Mid-range ($4,007)
Max ($5,240)
Since we have some actual performance data (2021 and 2022) and relatively short0range forecast for 2023, some investors will focus on post-2023 valuations.
Shorter term investors would focus on narrower range of estimates.

Scenario 7

Ratio of price to book value should not exceed 22.5
If: Price/BV = 20-->
Enterprise Value ($1,299,848.92) ($1,139,491.89) ($1,441,633.36) Absurdly high valuations
Price/BV = 10-->
Enterprise Value ($649,924.46) ($569,745.95) ($720,816.68) Not much more realistic
Factors for PBV
12.75 10.5 9 7.5
50% of total multiple 50% 50% 50% 50%
60% of total multiple 60% 60% 60% 60%
Full data set ($248,596.11) ($204,726.20) ($175,479.60) ($146,233.00)
Post-2023 ($217,927.82) ($179,469.97) ($153,831.41) ($128,192.84)
2023-2028 ($275,712.38) ($227,057.25) ($194,620.50) ($162,183.75)
Range of valuations for PBV method:
Min ($145,537)
Average ($192,836)
Mid-range ($166,651)
Max ($217,928)
Since we have some actual performance data (2021 and 2022) and relatively short0range forecast for 2023, some investors will focus on post-2023 valuations.
Shorter term investors would focus on narrower range of estimates.

Scenario 8

Ratio of price to book value should not exceed 22.5
If: Price/BV = 20-->
Enterprise Value ($1,967,546.56) ($2,013,648.41) ($2,161,513.33) Absurdly high valuations
Price/BV = 10-->
Enterprise Value ($983,773.28) ($1,006,824.21) ($1,080,756.66) Not much more realistic
Factors for PBV
12.75 10.5 9 7.5
50% of total multiple 50% 50% 50% 50%
60% of total multiple 60% 60% 60% 60%
Full data set ($376,293.28) ($309,888.58) ($265,618.79) ($221,348.99)
Post-2023 ($385,110.26) ($317,149.62) ($271,842.54) ($226,535.45)
2023-2028 ($413,389.42) ($340,438.35) ($291,804.30) ($243,170.25)

Range of valuations for PBV method:
Min ($230,352)
Average ($305,216)
Mid-range ($294,496)
Max ($385,110)
Since we have some actual performance data (2021 and 2022) and relatively short0range forecast for 2023, some investors will focus on post-2023 valuations.
Shorter term investors would focus on narrower range of estimates.

Scenario 9

Ratio of price to book value should not exceed 22.5
If: Price/BV = 20-->
Enterprise Value ($2,499,748.70) ($2,704,003.78) ($2,753,425.53) Absurdly high valuations
Price/BV = 10-->
Enterprise Value ($1,249,874.35) ($1,352,001.89) ($1,376,712.77) Not much more realistic
Factors for PBV
12.75 10.5 9 7.5
50% of total multiple 50% 50% 50% 50%
60% of total multiple 60% 60% 60% 60%
Full data set ($478,076.94) ($393,710.42) ($337,466.07) ($281,221.73)
Post-2023 ($517,140.72) ($425,880.59) ($365,040.51) ($304,200.42)
2023-2028 ($526,592.63) ($433,664.52) ($371,712.45) ($309,760.37)
Range of valuations for PBV method:
Min ($298,394)
Average ($395,372)
Mid-range ($395,461)
Max ($517,141)
Since we have some actual performance data (2021 and 2022) and relatively short0range forecast for 2023, some investors will focus on post-2023 valuations.
Shorter term investors would focus on narrower range of estimates.

Scenario 10

Ratio of price to book value should not exceed 22.5
If: Price/BV = 20-->
Enterprise Value ($2,923,319.90) ($3,247,435.89) ($3,238,178.99) Absurdly high valuations
Price/BV = 10-->
Enterprise Value ($1,461,659.95) ($1,623,717.94) ($1,619,089.49) Not much more realistic
Factors for PBV
12.75 10.5 9 7.5
50% of total multiple 50% 50% 50% 50%
60% of total multiple 60% 60% 60% 60%
Full data set ($559,084.93) ($460,422.88) ($394,648.19) ($328,873.49)
Post-2023 ($621,072.11) ($511,471.15) ($438,403.84) ($365,336.54)
2023-2028 ($619,301.73) ($510,013.19) ($437,154.16) ($364,295.14)
Range of valuations for PBV method:
Min ($352,835)
Average ($467,506)
Mid-range ($474,937)
Max ($621,072)
Since we have some actual performance data (2021 and 2022) and relatively short0range forecast for 2023, some investors will focus on post-2023 valuations.
Shorter term investors would focus on narrower range of estimates.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Floyd A. Beams, Joseph H. Anthony, Bruce Bettinghaus, Kenneth Smith

11th Edition

978-0132568968, 9780132568968

More Books

Students also viewed these Accounting questions

Question

8.3. Rederive Eq. (8.34) assuming vertical polarization.

Answered: 1 week ago

Question

Behaviour: What am I doing?

Answered: 1 week ago