Year-to-date Balance Sheet

Year-to-date

Year-to-date is a period, starting from the beginning of the current year, and continuing up to the present day. The year usually starts on January 1 (calendar year), but depending on purpose, can start also on July 1, April 1 (UK corporation tax and government financial statements), and April 6 (UK fiscal year for personal tax and benefits). Year-to-date is used in many contexts, mainly for recording results of an activity in the time between a date (exclusive, since this day may not yet be "complete") and the beginning of either the calendar or fiscal year.

In the context of finance, YTD is often provided in financial statements detailing the performance of a business entity. Providing current YTD results, as well as YTD results for one or more past years as of the same date, allows owners, managers, investors, and other stakeholders to compare the company's current performance to that of past periods. Employees' income tax may be based on total earnings in the tax year to date.

YTD describes the return so far this year. For example: the year to date (ytd) return for the stock is 8%. This means from January 1 of the current year to date, stock has appreciated by 8%.

Another example: the year to date (ytd) rental income of a property (whose Fiscal Year End is March 31, 2009) is $1000.00 as of June 30, 2008. This means that the property brought in $1000.00 of rental income during the period April 1 through June 30, 2008 (= the ytd period for the property).

Comparing YTD measures can be misleading if not much of the year has occurred, or the date is not clear. YTD measures are more sensitive to early changes than late changes. Contrast YTD with the concept of 12-months-ending (or Year-ending), which are more resistant to seasonal influences.

Example: to calculate Year-To-Date Invoicing for a company, invoice totals for each previous month of the current year are added to total invoices for the current month to date.

Example: YTD Invoicing report for May 3

  January Invoices-----$ 35,000

  February Invoices----  40,000

  March Invoices-------  25,000

  April Invoices-------  45,000

  May Invoices---------   5,000

                        _______

  YTD Invoices          150,000

Alternate method:

  1st quarter Invoices-----$ 100,000

  April Invoices-----------   45,000

  May Invoices-------------    5,000

                             _______

  YTD Invoices               150,000

tax due as of the end of week 33 of the tax year is calculated on total pay from the beginning of week 1 until the end of week 33; tax payable for that week will be this total tax minus tax already paid.

• Quarter-To-Date (QTD)
• Month-To-Date (MTD)
• Year-ending
• Moving Annual Total (MAT)

 

Font: http://en.wikipedia.org/wiki/Year-to-date

 

…………….

 

 

Balance Sheet Template

---

This FREE Balance Sheet Template features a column for the current year and a column for the prior year. The template auto calculates Total Assets, Total Liabilities, and Total Equity.

This Balance Sheet has a classic and professional design. Enter your year to date values, and the template will auto populate all calculated fields. Shading on the spreadsheet makes it easy to compare Assets to Liabilities and Equity to ensure all accounts are in balance.

Click on the below image or link to download the spreadsheet. Choose "Open"to immediately open the template for editing, or choose "Save" to save the template to a location on your computer.

If this spreadsheet does not meet your needs, consider a Custom Spreadsheet solution.

 

Font:  http://www.practicalspreadsheets.com/Balance-Sheet-Template.html