FINC302 Finance 322 Assignment 12 Please read each question carefully before answering. Other Instructions: Financial calculators and/or Excel may be used. Please show all work. If necessary, be sure...

1 answer below »

View more »
Answered Same DayApr 07, 2021

Answer To: FINC302 Finance 322 Assignment 12 Please read each question carefully before answering. Other...

Khushboo answered on Apr 07 2021
153 Votes
Solution 1
                Calculation of initial investment
                Year    0
                Cost of new model    25000000
                Increase in working capital    1350000
            
    Total initial outlay    26350000
                Year    0    1    2    3    4    5    6    7    8
                Units sales        60000    61800    63654    65564    67531    69556    71643    73792
                Selling price        995    995    995    995    995    995    995    995
                Revenue        59700000    61491000    63335730    65235801.9    67192875.957    69208662.23571    71284922.1027813    73423469.7658647
                Less: Expenses
                Direct material and labor costs        26865000    27670950    28501078.5    29356110.855    30236794.18065    31143898.0060695    32078214.9462516    33040561.3946391
                Selling and general adminsitarative expenses        17910000    18447300    19000719    19570740.57    20157862.7871    20762598.670713    21385476.6308344    22027040.9297594
                Opoortunity cost        3496500    3496500    3496500    3496500    3496500    3496500    3496500    3496500
                Fixed costs        4500000    4500000    4500000    4500000    4500000    4500000    4500000    4500000
                Depreciation        3125000    3125000    3125000    3125000    3125000    3125000    3125000    3125000
                Total expenses        55896500    57239750    58623297.5    60048351.425    61516156.96775    63027996.6767825    64585191.577086    66189102.3243986
                Net income before tax        3803500    4251250    4712432.5    5187450.475    5676718.98925    6180665.5589275    6699730.52569532    7234367.44146618
                less: tax @21%        798735    892762.5    989610.825    1089364.59975    1192110.9877425    1297939.76737477    1406943.41039602    1519217.1627079
                Net...
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