Forecasting With Excel - Forecasting With Excel Running...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Forecasting With Excel 1 Running head: FORECASTING WITH EXCEL Forecasting With Excel Victoria Crow Microcomputer Applications For Accountants Strayer University November 5, 2009
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Forecasting With Excel 2 Forecasting With Excel Background Article Name: Regression Analysis Can Help Predict Revenues And Costs Author: James A. Weisel Date Of Publication: February, 2009 Retrieval Date: November 4, 2009
Background image of page 2
Forecasting With Excel 3 Excel contains several tools necessary to forecast revenues and costs. The FORECAST function is a good way for accountants to create financial forecasts by analyzing historical data. The use of regression analysis by accountants can make the budgeting process more efficient by improving the accuracy of the financial forecasts. Linear regression is a statistical tool used to analyze the link between a certain type of activity, such as the amount of money spent on advertising, versus an output, such as how much is generated in sales. There is a relative certainty that the more a company spends on advertising, the more revenue they will generate. However, it is up to the accountants to determine the correlation between exactly how much is
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

Forecasting With Excel - Forecasting With Excel Running...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online