FNCE 623 1 Homework NPV, IRR and other project evaluation criteria. Develop a proposal for the case if UCW wants to invest in a new Program. The project under consideration costs...

1 answer below »

View more »
Answered 1 days AfterNov 24, 2022

Answer To: FNCE 623 1 Homework NPV, IRR and other project evaluation criteria. Develop a...

Khushboo answered on Nov 26 2022
51 Votes
Sheet1
        Solution 1
            Base Case Input
            Initial investment    7,000,000
            Required rate of return    17%
            Sales    1500    students/year
            Tuition fee per student    5500
            Variable co
st per unit    2500
            Fixed costs    1500000
            Tax rate    30%
            Calculation of NPV and IRR
            Year    0    1    2    3    4    5
            Total sales        8250000    8250000    8250000    8250000    8250000
            Less: costs
            Variable costs        3750000    3750000    3750000    3750000    3750000
            Fixed costs        1500000    1500000    1500000    1500000    1500000
            Depreciation        1400000    1400000    1400000    1400000    1400000
            Total costs        6650000    6650000    6650000    6650000    6650000
            Income before tax        1600000    1600000    1600000    1600000    1600000
            Tax @ 30%        480000    480000    480000    480000    480000
            Net income        1120000    1120000    1120000    1120000    1120000
            Add: Depreciation        1400000    1400000    1400000    1400000    1400000
            Free cash flow    -7,000,000    2520000    2520000    2520000    2520000    2520000
            Pvf @ 17%    1    0.855    0.731    0.624    0.534    0.456
            Present Value    -7000000    2153846.15384615    1840894.14858646    1573413.80221065    1344798.12154756    1149400.1038868
            Net Present Value    1062352.33007762
            IRR    23%
            Based on the NPV and IRR the proposal should be accepted. The positive net present value indicates that the present value of the cash inflows are more than the present value of the cash outflows. IRR is also greater than the cost of capital. Hence this will be beneficial for the entity as it will result in additional cash flow and benefit to the entity.
        Solution 2    Best Case Input            Worst Case Input
            Initial investment    7,000,000        Initial investment    7,000,000
            Required rate of return    17%        Required rate of return    17%
            Sales    1725    students/year    Sales    1275    students/year
            Tuition fee per student    5500        Tuition fee per student    5500
            Variable cost per unit    2500        Variable cost per unit    2500
            Fixed...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30