Scribd Logo
Upload

Welcome to Scribd!

  • 65 views

    Capital Investment Model - NPV IRR Payback: Strictly Confidential

    Uploaded by

    sh munna

    Copyright:

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

    Capital Investment Model - NPV IRR Payback: Strictly Confidential

    Uploaded by

    sh munna
    65 views4 pages

    Original Title

    Capital-Investment-Model

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    65 views4 pages

    Capital Investment Model - NPV IRR Payback: Strictly Confidential

    Uploaded by

    sh munna

    Copyright:

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

    Capital Investment Model - NPV IRR Payback Strictly Confidential

    Notes
    This Excel model is for educational purposes only and should not be used for any other reason.
    All content is Copyright material of CFI Education Inc.
    https://corporatefinanceinstitute.com/

    © 2019 CFI Education Inc.


    All rights reserved.  The contents of this publication, including but not limited to all written material, content layout, images, formulas, and code, are protected under international copyright and trademark laws.  
    No part of this publication may be modified, manipulated, reproduced, distributed, or transmitted in any form by any means, including photocopying, recording, or other electronic or mechanical methods,
    © Corporate Finance Institute®. All rights reserved.

    Capital Investment Model


    1 2 3 4 5 6 7

    Revenues $0 $0 $75,000 $75,000 $75,000 $75,000 $75,000


    Expense 1 $0 $0 $8,000 $8,000 $8,000 $8,000 $8,000
    Expense 2 $500 $500 $1,000 $1,000 $1,000 $1,000 $1,000
    Expense 3 $0 $0 $12,500 $12,500 $12,500 $12,500 $12,500
    Expense 4 $0 $0 $6,300 $6,300 $6,300 $6,300 $6,300
    Profit ($500) ($500) $47,200 $47,200 $47,200 $47,200 $47,200

    Capital Investment $50,000 $50,000 $100 $100 $100 $100 $100


    Cash Flow (Annual) ($50,500) ($50,500) $47,100 $47,100 $47,100 $47,100 $47,100

    Cash Flow (Cumulative) ($50,500) ($101,000) ($53,900) ($6,800) $40,300 $87,400 $134,500

    NPV
    10% $120,021 Cash Flow
    15% $77,715
    Cash Flow (Annual) Cash Flow (Cumulative)
    20% $48,354
    $300,000

    $250,000
    IRR 36%
    $200,000

    Payback 5 Years $150,000

    $100,000

    $50,000

    $0

    ($50,000)

    ($100,000)

    ($150,000)
    1 2 3 4 5 6 7

    This file is for educational purposes only. E&OE


    Corporate Finance Institute®
    https://corporatefinanceinstitute.com/
    8 9 10

    $75,000 $75,000 $75,000


    $8,000 $8,000 $8,000
    $1,000 $1,000 $1,000
    $12,500 $12,500 $12,500
    $6,300 $6,300 $6,300
    $47,200 $47,200 $47,200

    $100 $100 $100


    $47,100 $47,100 $47,100

    $181,600 $228,700 $275,800

    Flow
    Cash Flow (Cumulative)

    5 6 7 8 9 10

    You might also like