Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Total (30 Points). Please complete the following table. Forecast Year 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Sales growth rate 9.3996
Total (30 Points). Please complete the following table. Forecast Year 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Sales growth rate 9.3996 8.31% 8.42% 7.6096 6.80% 6.00% 5.30% 4.50% 3.8096 3.00% NOPAT margin 9.899 10.49% 11.099 10.5096 9.90% 9.30% 8.70% 8.10% 7.60% 7.00% Beginning net operating working/sales 10.60% 9.60% 8.6096 8.6096 8.60% 8.60% 8.60% 8.60% 8.609 8.60% Beginning net operating long-term assets/sales 58.10% 57.00% 55.70% 55.70% 55.70% 55.70% 55.7096 55.70% 55.70% 55.70% Beginning net debt to captial ratio 57.2096 57.2096 57.2096 57.20% 57.20% 57.20% 57.20% 57.20% 57.20% 57.20% After-tax cost of debt 1.50% 1.70% 1.909 2.10% 2.30% 2.50% 2.50% 2.50% 2.5096 2.50% Beginning Balance Sheet Beg net working capital + Beg net long term assets =net operating assets 23191.95 127118.15 150310.10 Net Debt 85977.38 +Preferred stock (Assume zero for all the years) 0.00 + Shareholders' equity 64332.72 = Net Capital 150310.10 Income Statement Sales 218792.00 Net operating profits after tax 21645.97 -Net interes expese after tax 1289.66 = Net Income 20356.31 -Preferred dividends (Assume O for all the years) 0.00 = Net Income to common 20356.31 Operating return on assets 14.40% Return on common equity 31.64% Book value of assets growth rate 5.00% Book value of common equity growth rate 5.00% Net operatin asset turnover 1.46 Cash Flow Data Net income 20356.31 -Change in net working capital -23191.95 -Change in net long-term assets -127118.15 +Change in net debt -85977.38 Free cash flow to equity 84689.03 Net operating profit after tax 21645.97 -Change in net working capital -change in net long term assets = Free cash flow to capital -23191.95 -127118.15 171956.07
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started