92财务利润表2 (2).xlsx

财务利润表财务利润表1月2月营业收入 Revenue销售收入 Sales50,000.00 52,500.00减：退回 Sales Returns-减：折扣 Sales Discounts5,000.00 5,250.00其他收入-净收入 Net Sales 45,000.00 47,250.00销货成本 Cost of Goods Sold20,000.00 22,500.00毛利 Gross Profit 25,000.00 24,750.00营业费用 Operating Expenses薪资 Salaries&Wages7,500.00 7,875.00办公费用 Office Expenses500.00 525.00房租 Rent Expense475.00 498.75差旅 Travel Expenses1,500.00 1,575.00招待 Reception Expenses250.00 262.50广告 Advertising Expenses100.00 105.00-费用总计 Total Operating Expenses 10,325.00 10,841.25营业利润 Income From Operations14,675.00 13,908.75营业外收支 Interest Income Expense-100.00-105.00税前利润 Income Before Income Taxes14,575.00 13,803.75税 Income Tax Expense750.00 787.50净利润 Net Income 13,825.00 13,016.253月4月5月6月7月8月55,000.00 57,500.00 60,000.00 62,500.00 65,000.00 67,500.00-5,512.50 5,788.13 6,077.53 6,381.41 6,700.48 7,035.50-49,487.50 51,711.87 53,922.47 56,118.59 58,299.52 60,464.5025,000.00 27,500.00 30,000.00 32,500.00 35,000.00 37,500.0024,487.50 24,211.87 23,922.47 23,618.59 23,299.52 22,964.508,268.75 8,682.19 9,116.30 9,572.11 10,050.72 10,553.25551.25 578.81 607.75 638.14 670.05 703.55523.69 549.87 577.37 606.23 636.55 668.371,653.75 1,736.44 1,823.26 1,914.42 2,010.14 2,110.65275.63 289.41 303.88 319.07 335.02 351.78110.25 115.76 121.55 127.63 134.01 140.71-11,383.32 11,952.48 12,550.11 13,177.60 13,836.49 14,528.3113,104.18 12,259.39 11,372.36 10,440.99 9,463.03 8,436.19-110.25-115.76-121.55-127.63-134.01-140.7112,993.93 12,143.63 11,250.81 10,313.36 9,329.02 8,295.48826.88 868.22 911.63 957.21 1,005.07 1,055.33 12,167.05 11,275.41 10,339.18 9,356.15 8,323.95 7,240.15财务利润表9月10月11月12月年度70,000.00 72,500.00 75,000.00 77,500.00 765,000.00-7,387.28 7,756.64 8,144.47 8,551.70 79,585.64-62,612.72 64,743.36 66,855.53 68,948.30 844,585.6440,000.00 42,500.00 45,000.00 47,500.00 405,000.0022,612.72 22,243.36 21,855.53 21,448.30 439,585.6411,080.92 11,634.96 12,216.71 12,827.55 119,378.46738.73 775.66 814.45 855.17 7,958.56701.79 736.88 773.72 812.41 7,560.632,216.18 2,326.99 2,443.34 2,565.51 23,875.68369.36 387.83 407.22 427.58 3,979.28147.75 155.13 162.89 171.03 1,591.71-15,254.73 16,017.45 16,818.33 17,659.25 164,344.327,357.99 6,225.91 5,037.20 3,789.05 275,241.32-147.75-155.13-162.89-171.03-1,591.717,210.24 6,070.78 4,874.31 3,618.02 273,649.611,108.09 1,163.50 1,221.67 1,282.75 11,937.856,102.15 4,907.28 3,652.64 2,335.27 261,711.76