I'm honestly not sure how to fill out the rest of this chart.
How do I forecast the numbers for 2022 without the numbers I need?
What is the present value (and everything after it)? Please
help!
I M Honestly Not Sure How To Fill Out The Rest Of This Chart How Do I Forecast The Numbers For 2022 Without The Numbers 1 (239.62 KiB) Viewed 25 times
A B с D E 2019 8094 2021 6037 -79.7 2022 (1) 5735 2020 2957 -1713.9 3176 -7239.4 799.7 1474 -3796.8 2966 -4576.7 1 DISCOUNTED CASH FLOW 2 Sales 3 NOPAT (sales x nopm) 4 NOA (sales / noat) 5 FCFF (nopat - avg. noa) 6 Present Value 7 Firm Value (cum. horizon and terminal pv) 8 Equity Value (firm value - nno) 9 Value Per Share (equity value / out. Shares) 10 11 RESIDUAL OPERATING INCOME 12 Sales 13 NOPAT 14 NOA 15 ROPI [nopat - noa beg. Xrw) 16 Present Value 17 Firm Value (noa + cum. horizon & terminal pv) 18 Equity Value (firm value - nno) 19 Value Per Share (equity value / out. Shares) 20 21 (other info used: rw = -8.5%) 2022 (f) 5735 2019 8094 799.7 1474 -3796.8 2020 2957 -1713.9 3176 -7239.4 2021 6037 -79.7 2966 -4576.7 22
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!