Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

To calculate the company's ROS, how can I get these two numbers I have circled in red? (pls give formula and numbers in details) thanks

To calculate the company's ROS, how can I get these two numbers I have circled in red?
(pls give formula and numbers in details)
thanks
image text in transcribed
image text in transcribed
image text in transcribed
(CNY million) 2007 2008 2009 2010e 2011e 2012e 2013e 2014e 2015e Sales revenue 1,290.4 1,394.6 1,602.7 1,923.2 2,307.9 2,769.5 3.323.4 3,988.0 4,785.6 Cost of goods sold (849.4) (943.4) (1.110.0) (1.294.0) (1,610.3) (2,000.7) (2.491.1) (3,096.8) (3,848.2) Gross profit 441.0 451.2 492.7 629.3 697.6 768.8 832.2 891.2 937.4 Gross margin 34.2% 32.4% 30.7% 32.7% 30.2% 27.8% 25.0% 22.3% 19.6% Selling expense (216.0) (208.0) (201.8) (242.3) (290.8) (349.0) (418.7) (502.5) (603.0) G&A expense (19.6) (20.0) (20.1) (24.1) (28.9) (34.7) (41.7) (50.0) (60.0) EBITDA 205.7 223.6 271.1 362.8 377.9 385.1 371.8 338.7 274.4 EBITDA margin 15.9% 16.0% 16.9% 18.9% 16.4% 13.9% 11.2% 8.5% 5.7% Depreciation (40.3) (45.3) (49.4) (57.5) (60.8) (64.0) (67.3) (70.5) (73.7) EBIT 165.6 178.4 221.9 305.3 317.1 321.1 304.5 268.2 200.7 EBIT margin 12.8% 12.8% 13.8% 15.9% 13.7% 11.6% 9.2% 6.7% 4.2% Interest expense (7.1) (12.0) (15.1) (15.9) (13.9) (11.2) (7.7) (4.4) (2.2) EBT 158.5 166.4 206.8 289.4 303.2 309.9 296.8 263.8 198.5 Income tax (8.4) (18.0) (20.0) (28.9) (30.3) (31.0) (29.7) (26.4) (19.9) Net income 150.1 148.4 186.8 260.5 272.9 278.9 267.1 237.5 178.7 Return on sales 11.6% 10.8% 11.7% 13.5% 11.8% 10.1% 8.0% 6.0% 3.7% Assumes sales growth of 20% per year. Estimated costs assume INR 1344 1.00 RMB. Projected selling expenses assumed 12.6% of sales, G&A expenses at 1.3% of sales, and income tax expenses at 10% of EBT. Cost of goods sold assumptions for 20102-2015e are based on Exhibit C, which follows. Indonesian rupiah = 1 Chinese yuan 2,200 2,050 2,000 1,915 Forward Rat Quotations 1,784 1,800 1,652 1,600 1,431 1,450 1,470 1,400 1,352 1.357 1,397 1,410 1,405 1,343 1,373 1,338 Spot Rate Forecasts 1,299 1.200 1.260 1,000 Spot 20 2010 30 2010 40 2010 2011 2012 2013 2014 2015 rates, (b) forward rate quotes, or (c) fixed rate baseline assumption? When China Noah replaces the Chinese wood supplier with Indonesian supplier, the prices of CNY 62.6/m2 came with the rough estimation of 8% cheaper than the current Chinese prices. China Noah started traded with Indonesian company in 2010 with the evaluation of 30% Indonesian sourcing of the total 17.2 million square meters of flooring. The price which was quoted for wood per square meter is IDR 84,090 i.e. 62.6 in Chinese yuan per square meter. Return on sales for 2010 a) If the exchange rate is to be change as per the forecast i.e. 1 CNY = IDR, the return on sales is figured at 14.9% b) If China Noah were to use the currency forward, the 2010 forward rate is IDR 1450 = 1 CNY, where return on sales is 14.6%. c) If the change in exchange rate remains constant, IDR 1344 = 1 CNY, the forecast return on sales to be figured at 13.5% These return on sales forecast with the change in the exchange rate of IDR and CNY helps the company to secure the normal profit within the time frame mentioned. (CNY million) 2007 2008 2009 2010e 2011e 2012e 2013e 2014e 2015e Sales revenue 1,290.4 1,394.6 1,602.7 1,923.2 2,307.9 2,769.5 3.323.4 3,988.0 4,785.6 Cost of goods sold (849.4) (943.4) (1.110.0) (1.294.0) (1,610.3) (2,000.7) (2.491.1) (3,096.8) (3,848.2) Gross profit 441.0 451.2 492.7 629.3 697.6 768.8 832.2 891.2 937.4 Gross margin 34.2% 32.4% 30.7% 32.7% 30.2% 27.8% 25.0% 22.3% 19.6% Selling expense (216.0) (208.0) (201.8) (242.3) (290.8) (349.0) (418.7) (502.5) (603.0) G&A expense (19.6) (20.0) (20.1) (24.1) (28.9) (34.7) (41.7) (50.0) (60.0) EBITDA 205.7 223.6 271.1 362.8 377.9 385.1 371.8 338.7 274.4 EBITDA margin 15.9% 16.0% 16.9% 18.9% 16.4% 13.9% 11.2% 8.5% 5.7% Depreciation (40.3) (45.3) (49.4) (57.5) (60.8) (64.0) (67.3) (70.5) (73.7) EBIT 165.6 178.4 221.9 305.3 317.1 321.1 304.5 268.2 200.7 EBIT margin 12.8% 12.8% 13.8% 15.9% 13.7% 11.6% 9.2% 6.7% 4.2% Interest expense (7.1) (12.0) (15.1) (15.9) (13.9) (11.2) (7.7) (4.4) (2.2) EBT 158.5 166.4 206.8 289.4 303.2 309.9 296.8 263.8 198.5 Income tax (8.4) (18.0) (20.0) (28.9) (30.3) (31.0) (29.7) (26.4) (19.9) Net income 150.1 148.4 186.8 260.5 272.9 278.9 267.1 237.5 178.7 Return on sales 11.6% 10.8% 11.7% 13.5% 11.8% 10.1% 8.0% 6.0% 3.7% Assumes sales growth of 20% per year. Estimated costs assume INR 1344 1.00 RMB. Projected selling expenses assumed 12.6% of sales, G&A expenses at 1.3% of sales, and income tax expenses at 10% of EBT. Cost of goods sold assumptions for 20102-2015e are based on Exhibit C, which follows. Indonesian rupiah = 1 Chinese yuan 2,200 2,050 2,000 1,915 Forward Rat Quotations 1,784 1,800 1,652 1,600 1,431 1,450 1,470 1,400 1,352 1.357 1,397 1,410 1,405 1,343 1,373 1,338 Spot Rate Forecasts 1,299 1.200 1.260 1,000 Spot 20 2010 30 2010 40 2010 2011 2012 2013 2014 2015 rates, (b) forward rate quotes, or (c) fixed rate baseline assumption? When China Noah replaces the Chinese wood supplier with Indonesian supplier, the prices of CNY 62.6/m2 came with the rough estimation of 8% cheaper than the current Chinese prices. China Noah started traded with Indonesian company in 2010 with the evaluation of 30% Indonesian sourcing of the total 17.2 million square meters of flooring. The price which was quoted for wood per square meter is IDR 84,090 i.e. 62.6 in Chinese yuan per square meter. Return on sales for 2010 a) If the exchange rate is to be change as per the forecast i.e. 1 CNY = IDR, the return on sales is figured at 14.9% b) If China Noah were to use the currency forward, the 2010 forward rate is IDR 1450 = 1 CNY, where return on sales is 14.6%. c) If the change in exchange rate remains constant, IDR 1344 = 1 CNY, the forecast return on sales to be figured at 13.5% These return on sales forecast with the change in the exchange rate of IDR and CNY helps the company to secure the normal profit within the time frame mentioned

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

Step: 3

blur-text-image

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

Accounting Principles Volume 2 Chapters 13 To 26

Authors: Jerry J. Weygandt

11th Edition

1118342070, 978-1118342077

More Books

Students also viewed these Accounting questions

Question

How effective have these groups been in the past?

Answered: 1 week ago

Question

What are their reputations?

Answered: 1 week ago

Question

How serious a response is warranted to this situation?

Answered: 1 week ago