Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    Nguyễn Quốc Luân - B1900399 - Kiểm tra quá trình

    Uploaded by

    Thắm Hồng
    The document contains financial projections for 5 years for an investment including projections for sales, costs, profits, assets, liabilities and cash flows. It shows increasing sales, profits and cash flows each year. The net present value of the investment is $465,676.79 and the internal rate of return is 26.99%.

    Copyright:

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

    Nguyễn Quốc Luân - B1900399 - Kiểm tra quá trình

    Uploaded by

    Thắm Hồng
    14 views3 pages
    The document contains financial projections for 5 years for an investment including projections for sales, costs, profits, assets, liabilities and cash flows. It shows increasing sales, profits and cash flows each year. The net present value of the investment is $465,676.79 and the internal rate of return is 26.99%.

    Original Title

    Nguyễn-Quốc-Luân-_-B1900399_Kiểm-tra-quá-trình

    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 contains financial projections for 5 years for an investment including projections for sales, costs, profits, assets, liabilities and cash flows. It shows increasing sales, profits and cash flows each year. The net present value of the investment is $465,676.79 and the internal rate of return is 26.99%.

    Copyright:

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

    Nguyễn Quốc Luân - B1900399 - Kiểm tra quá trình

    Uploaded by

    Thắm Hồng
    The document contains financial projections for 5 years for an investment including projections for sales, costs, profits, assets, liabilities and cash flows. It shows increasing sales, profits and cash flows each year. The net present value of the investment is $465,676.79 and the internal rate of return is 26.99%.

    Copyright:

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

    Nguyễn Quốc Luân - B1900399

    Investmnet 730,000.00
    Sales year 1 1,030,000.00
    growth 12.30%
    COGS 43.00% sales
    Varible cost 18.000% sales
    fixed cost 115,000
    Tax rate 30%
    inventory 17.00000% COGS
    receivables 18.0% sales
    payables 15.0% OEBD
    selling price 253,000.00
    Uselife 7
    COC 11%

    Income table
    Year 1 2 3 4 5
    Sales 1,030,000 1,156,690.00 1,298,962.87 1,458,735.30 1,638,159.75
    COGS 442,900 497,376.70 558,554.03 627,256.18 704,408.69
    Gross profit 587,100 659,313.30 740,408.84 831,479.12 933,751.05
    Varible cost 185,400 208,204.20 233,813.32 262,572.35 294,868.75
    Fixed cost 115,000 115,000 115,000 115,000 115,000
    DA $260,714 $167,602 $107,744 $69,264 $44,527
    EBIT $25,985.71 $168,507.06 $283,851.35 $384,642.66 $479,355.37
    I 0 0 0 0 0
    EBT $25,985.71 $168,507.06 $283,851.35 $384,642.66 $479,355.37
    TAX $7,795.71 $50,552.12 $85,155.41 $115,392.80 $143,806.61
    NET INCOME $18,190.00 $117,954.94 $198,695.95 $269,249.86 $335,548.76

    Depriciation table
    Year 0 1 2 3 4 5
    Gross PPE 730,000 730,000 730,000 730,000 730,000 730,000
    Depriciation $260,714 $167,602 $107,744 $69,264 $44,527
    Accumulate D.A $260,714 $428,316 $536,060 $605,325 $649,852
    Net PPE 730,000 469,286 301,684 193,940 124,675 80,148

    NWC TABLE
    Year 0 1 2 3 4 5
    Inventory 75,293.00 84,554.04 94,954.19 106,633.55 119,749.48
    Receivables 185,400.00 208,204.20 233,813.32 262,572.35 294,868.75
    Payables 45,060.00 48,480.63 52,322.00 56,635.85 61,480.31
    NWC 215,633.00 244,277.61 276,445.50 312,570.05 353,137.92
    DELTA NWC 215,633.00 28,644.61 32,167.90 36,124.55 40,567.87

    FCF TABLE
    Year 0 1 2 3 4 5
    EBIT $25,985.71 $168,507.06 $283,851.35 $384,642.66 $479,355.37
    EBIT(1-T) $18,190.00 $117,954.94 $198,695.95 $269,249.86 $335,548.76
    DA $260,714 $167,602 $107,744 $69,264 $44,527
    Less delta NWC 215,633.00 28,644.61 32,167.90 36,124.55 40,567.87
    Less CAPEX (730,000)
    Salvage 554,282.46
    Net PPE 201,145
    NWC 353,137.92
    FCF (730,000) 63,271 256,912 274,272 302,389 893,790
    NPV $465,676.79
    IRR 26.99%
    6 7
    730,000 730,000
    $28,624 $18,401
    $678,476 $696,877
    51,524 33,123

    You might also like