Hi there I have to do 15 questions it is all from book I took photos and uploading it. I have 17 photos I just uploaded 5 I couldn’t upload more, so I can have your email that will be help me to...

1 answer below »
Hi there I have to do 15 questions it is all from book I took photos and uploading it. I have 17 photos I just uploaded 5 I couldn’t upload more, so I can have your email that will be help me to upload everything.Thanks
Answered Same DayOct 28, 2021

Answer To: Hi there I have to do 15 questions it is all from book I took photos and uploading it. I have 17...

Ishmeet Singh answered on Oct 31 2021
150 Votes
Ques 12
            10/30/20    10/30/21    10/30/22
        Years    0    1    2
        Project A    -8000    4820    5860
        Project B    -5000    2850    4220
        IRR a    20.86%
        IRR b    24.69%
        Therefore, project B just on behalf of IRR
        Other criteria        Discount
    13.769%
        NPV a    764.064024687
        NPV b    765.4286663558
        Note: Click on data solver to find the optimal discount for NPV a = NPV b
Ques 15
            Year    Inv. A    Cumulative    Inv. B    Cumulative
        10/30/20    0    -10000    -10000    -10000    -10000
        10/30/21    1    4000    -6000    6000    -4000
        10/30/22    2    6000    0    6000    2000
        10/30/23    3    9000    9000    6000    8000
                Yrs.        Yrs.
            Payback A    3    Payback B    2    & 8 months    as 4000/6000
    Discount Rates for NPV profiles    NPV a     NPV b    IRR a     IRR b
    4%    7394.4583522986    6650.5461993628    34.43%    36.31%
    6%    6670.1370930365    6038.0716967698
    8%    5992.2267946959    5462.5819234873
    10%    5356.8745304283    4921.1119459053
    12%    4760.6140670554    4410.9876093294
    14%    4200.3207464645    3929.7921627707
    16%    3673.1723317889    3475.3372421993
    18%    3176.6149411576    3045.637577357
    20%    2708.3333333333    2638.8888888889
    22%    2266.2249263154    2253.4485265286
    24%    1848.3770266188    1887.818468665        Crossover Points
    26%    1453.0468271965    1540.630361492
    28%    1078.6437988281    1210.6323242188
    30%    723.7141556668    896.6772872098
    Therefore, select project A for NPV results
    Irr a is range till project A is accepted.
NPV a     0.04    0.06    0.08    0.1    0.12    0.14000000000000001    0.16    0.18    0.2    0.22    0.24    0.26    0.28000000000000003    0.3    7394.4583522985877    6670.1370930365301    5992.2267946959291    5356.8745304282465    4760.6140670553905    4200.3207464644956    3673.1723317889218    3176.6149411575689    2708.3333333333339    2266.224926315419    1848.3770266187776    1453.0468271964864    1078.6437988281241    723.71415566681662    NPV b    0.04    0.06    0.08    0.1    0.12    0.14000000000000001    0.16    0.18    0.2    0.22    0.24    0.26    0.28000000000000003    0.3    6650.5461993627659    6038.0716967698145    5462.5819234872715    4921.1119459053316    4410.9876093294433    3929.7921627707283    3475.3372421993527    3045.6375773569853    2638.8888888888891    2253.448526528653    1887.8184686650329    1540.6303614920384    1210.6323242187495    896.67728720983041    
Ques 20
        Profitability Index:    NPV/ Cost incurred at beginning
    whereas    NPV:    Sum of all cash flow values...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here