Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This screenshot is an example of the steps in answering a similar question. The question is complete and there is no extra data, just what

image text in transcribed

This screenshot is an example of the steps in answering a similar question. The question is complete and there is no extra data, just what it in the question below.

Provide a full 5 year forecast given the following:

ABC Ltd had sales this year of $36,333 which are expected to increase for the next 2 years at 4% and 2% for the following 3 years. ATO is expected to hold steady at 1.2 from next year as will the profit margin of 11%. The WACC is 6.1%, return on equity is 6.4% and the after tax cost of debt is 4%. Tax is 30% and the dividend payout ratio is 67%. Assets currently stand at $22,388 and Equity is $18428.

1.Forecast sales Sales growth rate - estimated Sales 2.Forecast ATO and calculate NOA forecast ATO Calculate NOA (NOA=sales/ATO) 3.Revise sales forecasts 4.Forecast PM and calculate NOPAT Forecast PM Calculate NOPAT (NOPAT = Sales x PM) 5.Forecast any other operating income (unusual items) 6.Calculate free cash flow (NOPAT - change in NOA) change in NOA calculate FCF 7.Forecast net dividend payout estimated as a % of NOPAT 8.Calculate net payments to debt holders payments = FCF - dividend 9.Forecast cost of debt and debt balance Forecast cost of debt after tax Opening debt balance Calculate cost of debt (net financing after tax) Calculate closing debt (opening + interest - repayment) check leverage (doa ratio) 10.Calculate comprehensive income NOPAT - NFEAT 11.Calculate equity (and check it works both ways) equity = assets - liabilities closing equity = opening equity + income - dividend 1.Forecast sales Sales growth rate - estimated Sales 2.Forecast ATO and calculate NOA forecast ATO Calculate NOA (NOA=sales/ATO) 3.Revise sales forecasts 4.Forecast PM and calculate NOPAT Forecast PM Calculate NOPAT (NOPAT = Sales x PM) 5.Forecast any other operating income (unusual items) 6.Calculate free cash flow (NOPAT - change in NOA) change in NOA calculate FCF 7.Forecast net dividend payout estimated as a % of NOPAT 8.Calculate net payments to debt holders payments = FCF - dividend 9.Forecast cost of debt and debt balance Forecast cost of debt after tax Opening debt balance Calculate cost of debt (net financing after tax) Calculate closing debt (opening + interest - repayment) check leverage (doa ratio) 10.Calculate comprehensive income NOPAT - NFEAT 11.Calculate equity (and check it works both ways) equity = assets - liabilities closing equity = opening equity + income - dividend

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

Introductory Econometrics For Finance

Authors: Chris Brooks

3rd Edition

1107661455, 9781107661455

More Books

Students also viewed these Finance questions

Question

Describe reviewing applications and rsums.

Answered: 1 week ago

Question

Identify the uses of performance appraisal.

Answered: 1 week ago

Question

Discuss selection in a global environment.

Answered: 1 week ago