For UPS and FedEx 2016-2018 yrs to model This module describes methods commonly used to forecast financial statements. The module shows how to forecast a complete set of financial statements (for one or more years). The module concludes with a parsimonious forecast of select balance sheet and income statement metrics. A project can include both types of forecasts. We can use the full set of financial statements to analyze the company’s near-term future performance and position. We can then use the parsimonious forecast for longer-term forecasts as inputs for valuation models that estimate the company’s stock price. Importantly, use a spreadsheet for the forecasting process. The SEC website has “interactive data” for annual reports—these are spreadsheet-like arrays that can be copied into a spreadsheet. Also, many companies include on their investor relations page an Excel version of their financial statements. Define as many cells as possible with formulas, and reference income statement totals to the related balance sheet accounts. To balance the balance sheet, define the cash account to be equal to the difference between forecasted assets and liabilities plus stockholders’ equity.Model Assumptions and Inputs. The assumptions we use critically impact forecasted numbers. Be as thorough as possible in research and analysis in determining model inputs. The most critical assumption is ales growth. Before we begin, adjust any fiscal years to take care of the “13th week” (or 53rd week) problem. Then, use all the reported years’ sales numbers to compute historical growth numbers. Observe any trends. If the company reports segment sales, compute growth of each segment and compare it with total sales growth. We should forecast each segment separately if growth differs by segment. Read the company’s MD&A, the footnotes, and any guidance the company voluntarily provides. Obtain an industry report and, determine a consensus about sales expectations and the cost environment. As discussed in the chapter, we assume most costs (including COGS and SGA) will not deviate from their historical percentages unless there is evidence to suggest otherwise. Again, scour the footnotes. In the end, use sound judgment and remember that forecasted numbers are subjective.




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.