四大之一的财务分析全套分析Excel模型.docxVIP

Company Name Project Name Company Name Project Name Prepared by Number of Years WACC Business Case Analysis 8.69% Multi-Lane Project Construction Machinery Manufacturer #1 Client X Cash Flow Analysis (Yearly) Graphs Multi- Lane Project Year 1 Year 2 Year 3 Year 4 Year 5 Total Costs ($630,605) ($674,184) ($225,215) ($14,171) $0 Total Benefits $318,859 $968,229 $1,830,923 $1,910,737 $1,595,453 Benefits Allocation Multi-Lane Strategy Business Case Total Gross Benefits by Benefit Category Range Range Benefits Low High Average Margin $2,101,615 $7,814,867 $4,958,241 Manufacturing $45,444 $91,105 $68,274 Quality $12,370 $13,607 $12,989 Inventory $1,032,234 $1,562,207 $1,297,221 Transportation $183,017 $391,934 $287,476 Total $3,374,680 $9,873,721 $6,624,201 Total Projected (Average) Benefits by Year Total Benefits Projected Benefits Average Benefits Year 1 Year 2 Year 3 Year 4 Year 5 Margin $4,958,241 $318,859 $637,718 $1,120,543 $1,454,605 $1,426,516 Manufacturing $68,274 $0 $6,207 $12,414 $24,827 $24,827 Quality $12,989 $0 $0 $1,443 $4,330 $7,216 Inventory $1,297,221 $0 $324,305 $648,610 $324,305 $0 Transportation $287,476 $0 $0 $47,913 $102,670 $136,893 Total $6,624,201 $318,859 $968,229 $1,830,923 $1,910,737 $1,595,453 1. Incremental Margin Projected Value % Benefits Realized Low High Year 1 Year 2 Year 3 Year 4 Year 5 1.1: Sales Uplift from Popular Configurations $401,266 $1,605,065 25% 50% 75% 100% 100% 1.2: Sales uplift from packaged configurations $200,633 $601,899 13% 25% 75% 100% 100% 1.3: Additional Parts Services Uplift $48,152 $176,557 13% 25% 50% 25% 0% 1.4: Improved Margin from Reduced Need for Variances $5,300 $38,868 18% 35% 50% 100% 100% % Benefits Realized Year 1 Year 2 Year 3 Year 4 Year 5 Low $132,342 $264,685 $478,151 $619,238 $607,200 High $505,375 $1,010,751 $1,762,936 $2,289,972 $2,245,833 Average $318,859 $637,718 $1,120,543 $1,454,605 $1,426,516 2. Increase in Manufacturing Efficiency Projected Value % Benefits Realized Low High Year 1 Year 2