Sales for the Forever Young Cosmetics Company (in $ millions) are as follows:

Sales for the Forever Young Cosmetics Company (in $ millions) are as follows:

Year	Sales ($ millions)	Year	Sales ($ Millions)	Year	Sales ($ Milions
1996	2.4	2003	4.4	2010	4.5
1997	2.7	2004	4.8	2011	4.8
1998	3.3	2005	5.1	2012	5.1
1999	4.6	2006	5.3	2013	5.5
2000	3.2	2007	5.2	2014	5.7
2001	3.9	2008	4.6
2002	4	2009	4.5

(a) Develop a three-year moving average.

(b) Develop a four-year moving average.

(c) Develop a five-year moving average.

(d) Develop a seven-year rmoving average.

Expert Solution

Request: Please put each question on a separate post, it helps to provide detailed answers.

Below given is the solution and the formula to be used in excel

orchestra answered 2 years ago

Young Corporation has an expected EBIT of $19,750 every year forever. The company currently has no...

Young Corporation has an expected EBIT of $19,750 every year forever. The company currently has no debt, and its cost of equity is 15 percent. a) What is the current value of the company? b) Suppose that the company can borrow at 10 percent. If the corporate tax rate is 35 percent what will the value of the firm be if the company takes on debt equal to 50 percent of its unlevered value? c) Calculate the cost of equity,...

Young Corporation expects an EBIT of $25,250 every year forever. The company currently has no debt,...

Young Corporation expects an EBIT of $25,250 every year forever. The company currently has no debt, and its cost of equity is 12 percent. The corporate tax rate is 35 percent. a. What is the current value of the company? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Company value $ b-1. Suppose the company can borrow at 7 percent. What will the value of the company be if it...

Case study: In order to direct decision-making, a relatively young cosmetics company, which sells a range...

Case study: In order to direct decision-making, a relatively young cosmetics company, which sells a range of organic and eco-friendly beauty products, decides to investigate the impact of their marketing strategy. As the company is only five years old, there has been significant investment in advertising and marketing their brand. In order to assess the impact that their marketing initiatives have had, they have implemented a four-month survey-research project in order to determine how their customers heard about their brand....

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 190 $ 210 $ 230 $ 260 Sales for the first quarter of the year after this one are projected at $205 million. Accounts receivable at the beginning of the year were $81 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 50 percent of the next quarter’s forecast sales, and suppliers...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 145 $ 165 $ 185 $ 215 Sales for the first quarter of the year after this one are projected at $160 million. Accounts receivable at the beginning of the year were $63 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecasted sales, and...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 105 $ 125 $ 145 $ 175 Sales for the first quarter of the following year are projected at $120 million. Accounts receivable at the beginning of the year were $47 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecast sales, and suppliers are normally...

Wildcat Inc has estimates sales (in millions) for the next four months as follows: January: $230...

Wildcat Inc has estimates sales (in millions) for the next four months as follows: January: $230 February: $195 March: $270 April: $290 Gross sales in November were $250, in December were $200, and May are projected at $250 million. Wildcat has a 60-day collection period. Wildcat’s purchases from suppliers in a month are equal to 55 percent of the next month’s forecasted sales, and suppliers are normally paid in 30 days. Wages, taxes, and other expenses run about 30 percent...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 180 $ 200 $ 220 $ 250 Sales for the first quarter of the year after this one are projected at $195 million. Accounts receivable at the beginning of the year were $77 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 50 percent of the next quarter’s forecasted sales, and suppliers...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 175 $ 195 $ 215 $ 245 Sales for the first quarter of the year after this one are projected at $190 million. Accounts receivable at the beginning of the year were $75 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 50 percent of the next quarter’s forecast sales, and suppliers...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 170 $ 190 $ 210 $ 240 Sales for the first quarter of the year after this one are projected at $185 million. Accounts receivable at the beginning of the year were $73 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s forecasted sales, and...

Question

Sales for the Forever Young Cosmetics Company (in $ millions) are as follows:

Solutions

Expert Solution

Related Solutions

Young Corporation has an expected EBIT of $19,750 every year forever. The company currently has no...

Young Corporation expects an EBIT of $25,250 every year forever. The company currently has no debt,...

Case study: In order to direct decision-making, a relatively young cosmetics company, which sells a range...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...

Wildcat Inc has estimates sales (in millions) for the next four months as follows: January: $230...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...

Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2...