Scribd Logo
Upload

Welcome to Scribd!

  • 120 views

    ASME Career Development Series: Sample Engineering Project Financial Evaluation Worksheet ($1000s)

    Uploaded by

    Aitazaz Ahsan
    This document is a financial evaluation worksheet for analyzing the costs and profits of an engineering project over 10 years. It includes projections for capital investment, revenue, costs, profits, cash flows, and metrics to evaluate the project such as net present value, internal rate of return, and payback period. All values are currently set to $0 as it is a blank template to be filled in with data for a specific project.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    ASME Career Development Series: Sample Engineering Project Financial Evaluation Worksheet ($1000s)

    Uploaded by

    Aitazaz Ahsan
    120 views1 page
    This document is a financial evaluation worksheet for analyzing the costs and profits of an engineering project over 10 years. It includes projections for capital investment, revenue, costs, profits, cash flows, and metrics to evaluate the project such as net present value, internal rate of return, and payback period. All values are currently set to $0 as it is a blank template to be filled in with data for a specific project.

    Original Description:

    Flange

    Original Title

    18341

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document is a financial evaluation worksheet for analyzing the costs and profits of an engineering project over 10 years. It includes projections for capital investment, revenue, costs, profits, cash flows, and metrics to evaluate the project such as net present value, internal rate of return, and payback period. All values are currently set to $0 as it is a blank template to be filled in with data for a specific project.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    120 views1 page

    ASME Career Development Series: Sample Engineering Project Financial Evaluation Worksheet ($1000s)

    Uploaded by

    Aitazaz Ahsan
    This document is a financial evaluation worksheet for analyzing the costs and profits of an engineering project over 10 years. It includes projections for capital investment, revenue, costs, profits, cash flows, and metrics to evaluate the project such as net present value, internal rate of return, and payback period. All values are currently set to $0 as it is a blank template to be filled in with data for a specific project.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    ASME Career Development Series : Sample Engineering Project Financial Evaluation Worksheet ($1000s)

    Analysis Prepared By :
    Project Title or Description:
    Year
    Calender Year

    0
    2002

    1 Capital Investment

    2
    3
    4
    5
    6
    7
    8
    9
    10

    Operating Cash Flows


    Revenue
    Variable Cost (or COGS)
    Gross Profit or Margin
    Fixed Costs (or Sales & Admin)
    Fixed Costs (R&D)
    Depreciation (Tax)
    Profit Before Tax (Net Profit)
    Tax (no interest charge)
    Profit After Tax

    11
    12
    13
    14

    Other Cash Flows


    Capital Investment
    Change in Working Capital
    Depreciation (Tax)
    Total Cash Annual Cash Flow

    4
    2006

    5
    2007

    6
    2008

    7
    2009

    8
    2010

    9
    2011

    10
    2012

    Totals

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0
    0
    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0

    0
    0
    0

    0
    0
    0

    0
    0
    0

    0
    0
    0

    0
    0
    0

    0
    0
    0

    0
    0
    0

    0
    0
    0

    0
    0
    0

    18 Net Present Value


    19 Internal Rate of Return
    20 Payback (Years)

    #NUM!

    Working Capital Schedule


    Working Capital Req't
    Change In Working Capital
    Working Capital Recovery
    Total WC Change

    3
    2005

    0
    0
    0

    1.00000
    0
    0
    0

    Depreciation Schedule
    Assumed Gov't Allowable
    Depreciation

    2
    2004

    15 Discount Factor
    16 Discounted Cash Flow
    17 Cumulative Cash Flow
    Payback evaluation

    Base Assumptions
    Cost of Goods Sold/Price
    Sales & Admin/Revenue
    Typical Working Capital Rate
    Income Tax Rate
    Discount Rate

    1
    2003

    0
    0

    0.90909
    0
    0
    0

    0.82645
    0
    0
    0

    0.75131
    0
    0
    0

    0.68301
    0
    0
    0

    0.62092
    0
    0
    0

    0.56447
    0
    0
    0

    0.51316
    0
    0
    0

    0.46651
    0
    0
    0

    0.42410
    0
    0
    0

    0.38554
    0
    0
    0

    0.0655
    0

    0.0656
    0

    0.0983
    0

    ( at
    10.0% discount rate)
    ( with
    10.0% initial guess - increase or decrease to find a solution)
    ( Calc ulated as the first non-zero year)

    Notes
    Blue values are inputs
    Red values are calculated but may be over-written
    Black values are all calculated

    80.0%
    10.0%
    5.0%
    39.0%
    10.0%

    0.0000
    0

    0
    0
    0
    0

    0.1000
    0

    0
    0
    0
    0

    0.1800
    0

    0
    0
    0
    0

    0.1440
    0

    0
    0
    0
    0

    0.1152
    0

    0
    0
    0
    0

    0.0922
    0

    0
    0
    0
    0

    0.0737
    0

    0
    0
    0
    0

    0.0655
    0

    0
    0
    0
    0

    0
    0
    0
    0

    0
    0
    0
    0

    NOTICE: Neither ASME nor the preparer make any representation as to the accuracy or usefulness of this spreadsheet. It is intended as a teaching aid only.
    The user is responsible for use or application of the spreadsheet.

    0
    0
    0
    0

    You might also like