20.6k views
4 votes
1 15 points: 5 for showing work, 10 for accuracy

Based upon your financial forecast for the years 2023 - 2027, compute the following ratios, placing your final results in the yellow highlighted area:

Industry Averages 2023 2024 2025 2026 2027
a Profit Margin 12.20%
b ROA 8.75%
c ROE 22.42%
d Current ratio 2.33X
e Quick ratio 1.45X
f Debt-to-Total Assets 43.05%
g Times Interest Earned 10.28X
(HINT: Enter Interest Expense as a positive number for TIE)

1 Answer

6 votes

To calculate the present value of future payments at a 15% interest rate, you discount the payments to find their value today, and then divide the total by the number of shares to find the price per share, which would be $256,500 per share in this case.

To compute the present value of future payments using a 15% interest rate, we discount the future payments to their present value (PV) as follows:

$15 million is already in present value, so no calculation is needed.

$20 million received in one year: $20 million / (1 + 0.15)¹ = $17.4 million.

$25 million received in two years: $25 million / (1 + 0.15)² = $18.9 million.

By adding up these amounts: $15 million + $17.4 million + $18.9 million = $51.3 million, which represents the total present value of the future payments.

Next, to find the price per share, we divide this total present value by the number of shares, which is 200 in this case:

51.3 million / 200 = 0.2565 million, or $256,500 per share.

User MyNewName
by
8.1k points