Budgeting and Forecasting Cutting Edge-Landscaping Essay
Professor Eric Teel
Table of Contents
Section | Title | Subsection | Title | Page Number | 1.0 | Executive Summary | | | 4 | 2.0 | Sales Forecast | | | 4 | | | 2.1 | Sales Forecast | 5 | | | 2.2 | Methods and Assumptions | 5 | 3.0 | Capital Expenditure Budget | | | | 4.0 | Investment Analysis | | | | | | 4.1 | Cash Flows | | | | 4.2 | NPV Analysis | | | | 4.3 | Rate of Return Calculations | | | | 4.4 | Payback Period Calculations | | 5.0 | Pro Forma Financial Statements | | | | | | 5.1 | Pro Forma Income Statement | | | | 5.2 | …show more content…
2.2 Methods and Assumptions * * In order for our company to calculate for the forecast we would need our previous sales figures and the volume of sales for the past years for thorough sales forecast. We need to be sure to keep in mind to consider all elements that can affect are sales whether they are internal and external. Remembering that the economic factors will dull precision if trying to forecast sales with some meticulousness since these factors are out of control. * * 3.0 Capital Expenditure Budget
3.0 Capital Expenditure Budget
* * Here you should provide a screenshot of your capital expenditure budget, also listing the sources of data and assumptions that led to each line item in table format. Briefly describe the total investment and, if necessary, why major items are necessary to achieve the company’s strategy. * * 4.0 Investment Analysis
4.0 Investment Analysis
Briefly describe the NVP, IRR, accounting rate of return, and payback period for this analysis. Indicate the discount rate you used, and how you arrived at it.
4.1 Cash flows * Provide an Excel spreadsheet screenshot that shows how you arrive at the net cash flows for each period in your planning horizon and describe its highlights.