Scribd Logo
Upload

Welcome to Scribd!

  • 27 views

    Start File Capital Budgeting - v3

    Uploaded by

    milanomengan
    The document analyzes two capital budgeting projects using net present value (NPV), internal rate of return (IRR), and payback period calculations. Project 1 has a NPV of -$250,000, an IRR of 61.56%, and a payback period of 4.27 years. Project 2's NPV, IRR, and payback period are not provided.

    Copyright:

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

    Start File Capital Budgeting - v3

    Uploaded by

    milanomengan
    27 views5 pages
    The document analyzes two capital budgeting projects using net present value (NPV), internal rate of return (IRR), and payback period calculations. Project 1 has a NPV of -$250,000, an IRR of 61.56%, and a payback period of 4.27 years. Project 2's NPV, IRR, and payback period are not provided.

    Original Description:

    fmdfina excel

    Original Title

    Start-File-Capital-Budgeting_v3

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document analyzes two capital budgeting projects using net present value (NPV), internal rate of return (IRR), and payback period calculations. Project 1 has a NPV of -$250,000, an IRR of 61.56%, and a payback period of 4.27 years. Project 2's NPV, IRR, and payback period are not provided.

    Copyright:

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

    Start File Capital Budgeting - v3

    Uploaded by

    milanomengan
    The document analyzes two capital budgeting projects using net present value (NPV), internal rate of return (IRR), and payback period calculations. Project 1 has a NPV of -$250,000, an IRR of 61.56%, and a payback period of 4.27 years. Project 2's NPV, IRR, and payback period are not provided.

    Copyright:

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

    Capital Budgeting File

    Get 10% OFF our Complete Finance & Valuation Course using coupon code EMAIL10

    Get Our Complete Finance & Valuation Course

    Made by Kenji Explains / Career Principles


    Note
    All content is copyright material of Kenji Explains / Career Principles
    This Excel model may not be reproduced or distributed by any means, including printing,
    screencapturing, or any other method without the prior permission of the publisher.
    Capital Budgeting Analysis
    NPV, IRR, and Payback Period

    Project 1
    Period 0 1 2 3 4 5
    Cash Inflow $ 30,000.00 $ 40,000.00 $ 35,000.00 $ 25,000.00 $ 20,000.00
    Cash Outflow 100,000 (100,000) (100,000) (100,000) (100,000) (100,000)
    Net Cash Flow 100,000 (70,000) (60,000) (65,000) (75,000) (80,000)
    Cumulative Cash Flow 100,000 30,000 (30,000) (95,000) (170,000) (250,000)
    $ 30,000.00
    Cost of Capital -> 10% $ 40,000.00
    $ 35,000.00
    NPV -> - 250,000 $ 25,000.00
    $ 20,000.00
    IRR -> 61.56%

    Payback Period -> 4.27

    Project 2
    Period 0 1 2 3 4 5
    Cash Inflow 65,000 75,000 82,500 86,000 89,000
    Cash Outflow (250,000) (10,000) (10,000) (10,000) (10,000) (10,000)
    Net Cash Flow
    Cumulative Cash Flow

    Discount Rate -> 8%

    NPV ->
    IRR ->

    Payback Period ->

    You might also like