英文版年度预算报表

HarvardManageMentor-BUDGETINGTOOLSAnnualBudgetingandTrackingWorksheetUsethistooltoprepareandtrackanannualbudgetwithmonthlyorquarterlyrevenuesandexpenses.Enteryourannualbudgetnumbersonthissheetinthewhitecells.Usewholedollarsforallentries.MonthlynumberswillautomaticallybecalculatedontheEnterQ1,Q2andEnterQ3,Q4sheetswhichfollow.Ifyouwouldliketoalterthemonthlynumbersinordertoshowtimingofrevenuesorexpenses,dosobysimplyoverwritingtheformulasinthemonthlybudgetcolumns.UsetheAnnualBudgetCheckcolumnstomakesurethatyouhavenotchangedtheannualtotalsbyreallocatingthemonthlynumbers.UnitNameFiscalYearStartDateofYearJanuary1,2005EnterAnnualQ1Q2Q3Q4YTDYTDYTDBudgetBudgetActualBudgetActualBudgetActualBudgetActualthroughApr-20DifferencePercentRevenuesHereBudgetActualDifferenceSource1000000000000%Source2000000000000%Source3000000000000%Source4000000000000%Source5000000000000%Source6000000000000%TotalRevenues0000000000000%ExpensesItem1000000000000%Item2000000000000%Item3000000000000%TotalCategory10000000000000%Item4000000000000%Item5000000000000%Item6000000000000%Item7000000000000%TotalCategory20000000000000%Item8000000000000%Item9000000000000%Item10000000000000%TotalCategory30000000000000%Item11000000000000%Item12000000000000%Item13000000000000%Item14000000000000%TotalCategory40000000000000%TotalExpenses0000000000000%OperatingIncomeOperatingIncome000000000000asa%ofRevenue0%0%0%0%0%0%0%0%0%0%0%0%Submittedby:DateUpdated:©2004HarvardBusinessSchoolPublishing.Allrightsreserved.DevelopedbyVillageSoftware,Inc.HarvardManageMentor-BUDGETINGTOOLSAnnualBudgetingandTrackingWorksheet:MonthlyDataAdjustmonthlyvalueshere.UnitNameFiscalYearStartDateofYearJanuary1,2005AnnualJanuaryFebruaryMarchQ1TotalAprilMayJuneQ2TotalAnnualBudgetBudgetActualBudgetActualBudgetActualBudgetActualBudgetActualBudgetActualBudgetActualBudgetActualRevenuesBudgetCheckSource1000000000000Source2000000000000Source3000000000000Source4000000000000Source5000000000000Source6000000000000TotalRevenues000000000000000000ExpensesItem1000000000000Item2000000000000Item3000000000000TotalCategory1000000000000000000Item4000000000000Item5000000000000Item6000000000000Item7000000000000TotalCategory2000000000000000000Item8000000000000Item9000000000000Item10000000000000TotalCategory3000000000000000000Item11000000000000Item12000000000000Item13000000000000Item14000000000000TotalCategory4000000000000000000TotalExpenses000000000000000000OperatingIncomeOperatingIncome000000000000000000asa%ofRevenues0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%Submittedby:DateUpdated:©2004HarvardBusinessSchoolPublishing.Allrightsreserved.DevelopedbyVillageSoftware,Inc.HarvardManageMentor-BUDGETINGTOOLSAnnualBudgetingandTrackingWorksheet:MonthlyDataAdjustmonthlyvalueshere.UnitNameFiscalYearStartDateofYearJanuary1,2005AnnualJulyAugustSeptemberQ3TotalOctoberNovemberDecemberQ4TotalAnnualBudgetBudgetActualBudgetActualBudgetActualBudgetActualBudgetActualBudgetActualBudgetActualBudgetActualRevenuesBudgetCheckSource1000000000000Source2000000000000Source3000000000000Source4000000000000Source5000000000000Source6000000000000TotalRevenues000000000000000000ExpensesItem1000000000000Item2000000000000Item3000000000000TotalCategory1000000000000000000Item4000000000000Item5000000000000Item6000000000000Item7000000000000TotalCategory2000000000000000000Item8000000000000Item9000000000000Item10000000000000TotalCategory3000000000000000000Item11000000000000Item12000000000000Item13000000000000Item14000000000000TotalCategory4000000000000000000TotalExpenses000000000000000000OperatingIncomeOperatingIncome000000000000000000asa%ofRevenues0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%Submittedby:DateUpdated:©2004HarvardBusinessSchoolPublishing.Allrightsreserved.DevelopedbyVillageSoftware,Inc.