Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q4 You have performed the common sizing and horizontal analysis to the financial statement of X co. You have selectively considered the current (Year 0)

Q4 You have performed the common sizing and horizontal analysis to the financial statement of X co. You have selectively considered the current (Year 0) parameters as mentioned in the table below. Based on the value's, you have calculated the Year 1 ratios and growth rates (05 Marks)

Particulars Year 0 Year 1
Growth rate in Sales revunes (y-o-y) N/A 4%
Gross Profit Margin 33% 34%
SG& A expenses/ Saled revenue 25% 25%
Depreciation Net PPEt-1 10% 10%
Net working Capital Turnover 5 5.5
Net PPE turnover 2 2.5
Corporate Tax rate 25% 25%

Net working Capital: Sales revenue/Net Working Capital , Net PPE Turnover: Sales revenue/Net PPE, Depreciation/Net PPE : Depreciation/ Beginning Period Net PPE.

Sales revenue for X Co. at Year 0 = $180 million. The growth rate of 4% at Year 1 denotes growth from year0 to year1 for sale revenue. There is no debt and interest payments. Beginning period Net PPE for Year 0 is $ 80 Million. Project Sales revenue, Net profit, Gross Profit, EBITDA, Net PPE and Net working capital values for Year 1.

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

Financial Innovation Regulation And Crises In History

Authors: Harold James

1st Edition

0367669528, 978-0367669522

More Books

Students also viewed these Finance questions

Question

What are the objectives of Human resource planning ?

Answered: 1 week ago

Question

Explain the process of Human Resource Planning.

Answered: 1 week ago