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
Financial Analysis With Microsoft Excel
ISBN: 9780324407501
4th Edition
Authors: Timothy R Mayes, Todd M Shank
Question Posted: