Question: When forecasting pro forma, why did the tutor use (13234/13994)-1 = -5.43 instead of ((13234-13994) / 13994) *100 =-5.45? And why do Net Sales and

When forecasting pro forma, why did the tutor use (13234/13994)-1 = -5.43 instead of ((13234-13994) / 13994) *100 =-5.45? And why do Net Sales and COGS share the same growth assumption?

G5 1 2 fx =(13234/13994)-1 A B C D E F G Kodak Case 9-1 Forecasting Pro Forma Financial Statements 3 Income Statement 4 20x7 20x6 20x5 20x7 AG 20x6 AG 5 Net Sales 12515 13234 13994 -5.43% -5.43% 6 Cost of Goods Sold 8199 8670 8375 -5.43% -5.43%

Step by Step Solution

★★★★★

3.43 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To calculate the values in cells G5 and G6 we need to use the given formula X 1323413994 1 C... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The reason SPC is still used is because it has found its way into the standards that customers impose on their suppliers. What do you think about it?

In this question assume that p and q are atomic formulae. (a) Compare and contrast path formulae and state formulae in temporal logic. [4 marks] (b) Describe and contrast the meanings of F(G p) and...

Question: Check you are in charge of the design of both hardware and software for a new (but fairly conventional) workstation which will have its peripherals (for example a disc drive and a printer)...

Question I would like you to make an effort to calculate the WACC for Marriott overall which requires following a couple of steps: First, we need to unlever Marriott's Equity Beta with the actual...

Assume that there are no corporate taxes (i.e. = 0). You may also assume that debt is riskless (i.e., D =0). All tables are provided. Please show steps. Question 1. Compute the a sset beta and cost...

Assume that there are no corporate taxes (i.e. = 0). You may also assume that debt is riskless (i.e., D =0). *** All tables are provided. lease show steps how how to get each calc (betta, CAPM, WACC,...

If Marriott used a single cost of capital (must compute from the tables/pages) for evaluating investment opportunities in each of its lines of business, what would happen to the company over time? Be...

Read the case then answer the questions in Excel -- Marriott Corporation: The Cost of Capital (Abridged) In April 1988, Dan Cohrs, vice president of project finance at the Marriott Corporation, was...

Read this case and answer the following Questions in Excel using WACC Marriott Corporation: The Cost of Capital (Abridged) In April 1988, Dan Cohrs, vice president of project finance at the Marriott...

Analyze the case and answer the questions: Assume a marginal tax rate of 42%. For purposes of your analysis, use arithmetic instead of geometric averages where averages are necessary. For purposes of...

Use the data from Exercise 1 and the equation = 818.13 + 0.434571x to calculate a. The residuals b. The sum of the residuals c. The squares of the residuals d. The sum of the squares of the residuals...

ABC Associates has decided to value the goodwill of the firm using capitalisation method. Find the goodwill of the firm if capital employed of the firm is Rs.24, 00,000. Reasonable return on capital...

Glorious Gadgets is a retailler of astronomy equipment. They purchase equipment from a supplier and then sell it to customers in their store. The function C ( x ) = 2 . 5 x 5 6 0 0 0 x - 1 1 6 0 0 0...

Gaskin Company derives the following items from its adjusted trial balance as of December 31, 2016: The following additional information is also available. The December 31, 2016, ending inventory is...

For the past several years, Steffy Lopez has operated a part-time consulting business from his home. As of July 1, 2014, Steffy decided to move to rented quarters and to operate the business, which...

CLOSING JOURNAL ENTRIES Prepare closing journal entries for Medina Company for the year ended December 31. Data for the closing entries are as follows: Factory overhead, debit and credit balance...

Matt Holmes recently joined Klax Company as a staff accountant in the controllers office. Klax Company provides warehousing services for companies in several European cities. The location in Koblenz,...

Schuch Company presents you with the following account balances taken from its December 31, 2016, adjusted trial balance: Additional data: 1. A physical count reveals an ending inventory of $22,500...

6 Theory of Machines 5. A shaft carries five masses A, B, C, D and E which revolve at the same radius in planes which are equidistant from one another. The magnitude of the masses in planes A, C and...

Two machined parts must be assembled as shown in the diagram below. To function properly a clearance must be maintained between the two parts. The critical dimension on Part A has specifications of...

For each of the following identify an appropriate device to measure the dimension indicated. a. Diameter of a hole b. Depth of a keyway slot c. To sort out shaft diameters in a production lot that...

The following machine-incident matrix has been prepared for a manufacturing plant that produces seven parts on six machines. Use the PFA group technology technique to cluster the seven parts in...

=+23. Retail trade index. The index of deflated turnover for retail trade shows the activity in volume of the retail trade sector. The United Nations Statistics Division reports Retail trade deflated...

=+b) Do you think a linear model is appropriate? Explain.

=+c) Find the equation of the regression line.