Use the same data as in Problem 1. a. Recalculate the percentage of sales income statement, but

Question:

Use the same data as in Problem 1.

a. Recalculate the percentage of sales income statement, but this time use the TREND function to forecast depreciation expense, other income, and interest expense.

b. Recalculate the percentage of sales balance sheet, but this time use the TREND function to forecast cash, property plant and equipment (gross), intangibles, and other non-current assets.

c. Do these new values appear to be more realistic than the original values? Does this technique make sense for each of these items? Might other income statement or balance sheet items be forecasted in this way?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Financial Analysis With Microsoft Excel

ISBN: 9780324407501

4th Edition

Authors: Timothy R Mayes, Todd M Shank

Question Posted: