文档介绍：财务规划案例财务规划案例: 点击下面衔接查看各项规划表历史经营状况表销售预测表里程/ 进度表人员计划表重要财务假设关键财务指标盈亏平衡分析损益分析表现金流分析表资产平衡预测财务比率分析长期财务分析表公司过去经营状况表: 2001 2002 2003 销售额$0 $4,467,549 $3,102,908 总毛利润$0 $1,548,246 $1,085,268 总毛利润% % % % 运转费用$0 $491,320 $686,456 收现期(天)000 存货周转率 资产负债表流动资产 2001 2002 2003 现金$0 $140,492 $88,510 应收帐款$0 $452,684 $452,192 存货量$0 $374,964 $349,533 其他流动资产$0 $358,274 $236,594 总流动资产$0 $1,326,414 $1,126,829 长期资产资金资产$0 $4,434,497 $5,504,468 累计折旧$0 $1,711,449 $1,811,284 长期资产总计$0 $2,723,048 $3,693,185 资产总计$0 $4,049,462 $4,820,014 资金和负债 2001 2002 2003 应付款$0 $104,573 $318,650 短期借款$0 $0 $0 其他的短期负债$0 $471,037 $575,143 短期负债小计$0 $575,610 $893,794 长期负债$0 $0 $150,966 总负债$0 $575,610 $1,044,760 普通股本金$0 $724,638 $724,638 股东权益$0 $2,338,357 $2,848,677 收益留存$0 $410,857 $201,940 资金总计$0 $3,473,851 $3,775,254 资金和负债总计$0 $4,049,462 $4,820,014 公司过去经营状况图: 销售预测: 产品销售 2004 2005 2006 2007 2008 胶囊剂产品$5,771,739 $7,695,652 $9,619,565 $9,619,565 $9,619,565 片剂产品$2,024,638 $2,699,517 $3,374,396 $3,374,396 $3,374,396 颗粒剂产品$1,501,147 $2,001,530 $2,501,912 $2,501,912 $2,501,912 栓剂产品$4,202,898 $5,603,864 $7,004,831 $7,004,831 $7,004,831 总销售额$13,500,42 2 $18,000,563 $22,500,704 $22,500,704 $22,500,704 生产成本 2004 2005 2006 2007 2008 胶囊剂产品$3,391,159 $4,641,592 $5,771,983 $5,771,983 $5,771,983 片剂产品$1,189,665 $1,628,334 $2,024,891 $2,024,891 $2,024,891 颗粒剂产品$881,973 $1,207,186 $1,501,178 $1,501,178 $1,501,178 栓剂产品$2,724,848 $3,729,591 $4,637,877 $4,637,877 $4,637,877 生产成本小计$8,187,645 $11,206,703 $13,935,930 $13,935,930 $13,935,930 月销售变化表: 产品销售 1月2月3月4月5月6月7月8月9月 10 月 11 月 12 月胶囊剂产品$430,300 $438,906 $447,684 $456,638 $465,771 $475,086 $484,588 $494,279 $504,165 $514,248 $524,533 $535,541 片剂产品$150,962 $153,981 $157,061 $160,202 $163,406 $166,674 $170,008 $173,408 $176,876 $180,414 $184,022 $187,624 颗粒剂产品$111,929 $114,168 $116,451 $118,780 $121,156 $123,579 $126,050 $128,571 $131,143 $133,766 $136,441 $139,115 其他的$313,367 $319,634 $326,027 $332,548 $339,199 $345,982 $352,902 $359,960 $367,159 $374,503 $38