Project Cost Summary (Excel) by pegawaiteknik4

VIEWS: 1,242 PAGES: 2

More Info
									Project Cost Summary
Use this template to analyze financial factors before undertaking a major project and to track its performance after it is approved. The template calls for calculating a set of financial evaluations that are not included in the file, but that you can find in most financial management texts. The projected numbers are included so that you can compare the estimates with actuals; either set of projected or actual numbers can be entered without the other numbers. You may enter the data in the template itself. The various analyses are intended to be entered as values. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
Copyright © KMT Software, Inc. All Rights Reserved.

Project Cost Summary
Project Title Project Number Plant Manager APPROPRIATION DETAIL Product Lines Purpose of Request PROJECT DESCRIPTION Cost Distribution Completion Date Responsibility Center #

PROJECT JUSTIFICATION

INVESTMENT SUMMARY
PROJECTED by YEAR START UP 1 2 3 4 5 START UP 1 2 ACTUAL by YEAR 3 4 5

Capital Investment Working Capital Total Investment Sales Net Income Cash Flow Cum. Cash Flow Discounted Return on Investment Profitability Index ANALYSIS Internal Rate of Return Modified Internal Rate of Return APPROVALS VP Finance
PREPARED BY VP RESPONSIBLE SIGNATURE SIGNATURE

Payback in Years Discounted Payback

President
SIGNATURE SIGNATURE

Date

Date


								
To top