Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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_2

Step: 3

blur-text-image_3

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

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield.

9th Canadian Edition, Volume 2

470964731, 978-0470964736, 978-0470161012

More Books

Students also viewed these Accounting questions

Question

State the rule of complements. LO4

Answered: 1 week ago

Question

State the additive rule of probability for any two events. LO4

Answered: 1 week ago