What is the value of the firm using the Free Cash Flow model for Lowell Inc.?

Lowell..inc.pdf

	1.	84,876.92
	2.	93,230.72
	3.	88,827.32
	4.	87,104.60
	5.	None of the options provided

2023 LOWELL NC INCOME STATEMENT 2019 Average Adjusted 2020 2021 2022 IST GROWTH RATE = 2% (positive two) 2024 4 LT GROWTH RATE negative four Revenue Operating expenses Operating income (EBIT) Non operating expenses Taxable income (EBT) Tax Net Income 55,632.00 44,505.00 11,126.00 555.00 10,570.00 5,007.00 5.563.00 100% 0% 20% 1% 19% 100.0% BOOK 20.0% 10% 19.0% 55,744.64 45,395.71 11,348.93 567.45 10,781.48 5.107.02 5.674.46 57,879.53 46,303.63 11,575.91 579.80 10.997.11 5.209.15 5,787.95 59,037.12 47 229,20 11.80742 590.37 11.217.05 5.313.34 5.903.71 60 217.87 48.174.29 12.043.57 602.18 11.441.39 5.419.51 6,021.79 10% 100% 7 BALANCE SHEET Operating assets Non operating assets Total assets 89.011.00 5,553.00 94,574.00 150% 1600 10 100% 1704 170 0% 90,791.42 5.574.45 96465.89 92.607.25 5.787.95 98.395.21 94459.40 5.90271 100.363.11 96.348.59 5,021.79 102.370.37 7 55% 25% Operating Liabilities Non operating Liabilities Shareholder's gay Diluted no. of shares Net Non operating Obligations (NNO) - Non oper Liab - Non-oper assets WACC -5 30.598.00 13,908.00 50.069.00 1,639.00 8,345.00 55.0% 25.0% 90.0% 31,209.55 14,186.15 51,070.18 31.833.74 14,469.88 52,091.58 32.470.42 14,759.28 53.133.41 33.119.83 15,054.47 54,196 08 SON 8.511.70 8.581.93 8.855.57 9,032.58 7 NOPAT = EBIT - (Tax + (Non-oper exp tax rate of 21%) Net Oper assets (NOA - Operating assets - Operating Liab) Increase in NOA 6.00224 58,413.00 3,325.35 6,122.75 59,581.87 1.168.17 6 245.20 60,773.51 1.191.64 6,370.11 61 988.98 1.215.47 6,497.51 63,228.75 123978 Free Cash Flow FCF) NOPAT - INCREASE IN NOA 2.675.89 4953.87 5.053.55 5.154.64 5.257.73 ? Value of firm - PV of Future Free Cash Flows Value of Equity Value of firm. NNO Value per share - Value of equit No. of shares Resid.al Operating Income ROPI - NOPATINOA beg WACC) 1,528.87 2,617.97 2.670.29 2.723.70 2.778.17 PV of Future ROP Value of fimm = NOA+PV of Future ROPI Value of Equity Value of fim - NNO Value per share Value of equit No. of shares 2023 LOWELL NC INCOME STATEMENT 2019 Average Adjusted 2020 2021 2022 IST GROWTH RATE = 2% (positive two) 2024 4 LT GROWTH RATE negative four Revenue Operating expenses Operating income (EBIT) Non operating expenses Taxable income (EBT) Tax Net Income 55,632.00 44,505.00 11,126.00 555.00 10,570.00 5,007.00 5.563.00 100% 0% 20% 1% 19% 100.0% BOOK 20.0% 10% 19.0% 55,744.64 45,395.71 11,348.93 567.45 10,781.48 5.107.02 5.674.46 57,879.53 46,303.63 11,575.91 579.80 10.997.11 5.209.15 5,787.95 59,037.12 47 229,20 11.80742 590.37 11.217.05 5.313.34 5.903.71 60 217.87 48.174.29 12.043.57 602.18 11.441.39 5.419.51 6,021.79 10% 100% 7 BALANCE SHEET Operating assets Non operating assets Total assets 89.011.00 5,553.00 94,574.00 150% 1600 10 100% 1704 170 0% 90,791.42 5.574.45 96465.89 92.607.25 5.787.95 98.395.21 94459.40 5.90271 100.363.11 96.348.59 5,021.79 102.370.37 7 55% 25% Operating Liabilities Non operating Liabilities Shareholder's gay Diluted no. of shares Net Non operating Obligations (NNO) - Non oper Liab - Non-oper assets WACC -5 30.598.00 13,908.00 50.069.00 1,639.00 8,345.00 55.0% 25.0% 90.0% 31,209.55 14,186.15 51,070.18 31.833.74 14,469.88 52,091.58 32.470.42 14,759.28 53.133.41 33.119.83 15,054.47 54,196 08 SON 8.511.70 8.581.93 8.855.57 9,032.58 7 NOPAT = EBIT - (Tax + (Non-oper exp tax rate of 21%) Net Oper assets (NOA - Operating assets - Operating Liab) Increase in NOA 6.00224 58,413.00 3,325.35 6,122.75 59,581.87 1.168.17 6 245.20 60,773.51 1.191.64 6,370.11 61 988.98 1.215.47 6,497.51 63,228.75 123978 Free Cash Flow FCF) NOPAT - INCREASE IN NOA 2.675.89 4953.87 5.053.55 5.154.64 5.257.73 ? Value of firm - PV of Future Free Cash Flows Value of Equity Value of firm. NNO Value per share - Value of equit No. of shares Resid.al Operating Income ROPI - NOPATINOA beg WACC) 1,528.87 2,617.97 2.670.29 2.723.70 2.778.17 PV of Future ROP Value of fimm = NOA+PV of Future ROPI Value of Equity Value of fim - NNO Value per share Value of equit No. of shares