I\'ve been provided with an excel spreadsheet containing a balance sheet and an

Question

I've been provided with an excel spreadsheet containing a balance sheet and an income statement with figures for periods ending in 12/31/1987-12/31/1990, now for the the 1991 the information is only on the first quarter (1/1/1991-04/30/1991), and next to it another column labeled as Year-to-Date and the number figures corresponding to each items in the income statement. I am trying to find what does this column mean? How to anualize the figures? Are the numbers in the the Year-to-Date column the annualized figures for 1991?? Very confused in this matter

Explanation / Answer

The annual figure can be extrapolated from the quaterly figure or the Year-to-Date figure.In case of quaterly figues , one has to multiply 4 to get the annualised figures. In case of Year-to-Date figures , one has to multiply by appropriate number ( 2 in case YTD for 6 months , 4/3 in case the YTD is 9 months) to get the annual figure. All such figures arrived at are projections only and may vary from the actual figures.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.