FINAL ASSESSMENT- ASSIGNMENT Due By 11:55 pm Adelaide, South Australia time 12 April 2019. Weighting 50% of total grade Format Written report(2500 words +/- 10%) Submit Assignment Supporting files...

1 answer below »

View more »
Answered Same DayMar 15, 2021

Answer To: FINAL ASSESSMENT- ASSIGNMENT Due By 11:55 pm Adelaide, South Australia time 12 April 2019. Weighting...

Pallavi answered on Apr 14 2021
147 Votes
(a) Annual cash flows in BRL that the subsidiary of Pretty Face expects to remit to the United States have been calculated in the below tables:
In order to calculate the Annual cash flow for each year, we would first have to calculate the net profit after tax generated each year. This will be calculated in following manner:
(all amounts have been rounded upto 2 decimal places)
Calculation of Net Profit after Tax for each year in BRL
    Year
    No of units sold per year
    Selling price per unit
    Variable cost per unit

    Gross margin per unit
    Fixed Cost per year
    Depreciation
    Net profit before tax
    Tax @25%
    Net profit after tax
    1
    1400000
    18
    8
    14000000
    2000000
    10800000
    1200000
    300000
    900000
    2
    1400000
    19.08
    8.48
    14840000
    2120000
    10800000
    1920000
    480000
    1440000
    3
    1400000
    20.22
    8.99
    15730400
    2247200
    10800000
    2683200
    670800
    2012400
    4
    1400000
    21.44
    9.53
    16674224
    2382032
    10800000
    3492192
    873048
    2619144
    5
    1400000
    22.72
    10.10
    17674677
    2524954
    10800000
    4349724
    1087431
    3262293
The cash flow inflow from sale of units each year will be calculated by adding non-cash expenditure (Depreciation) and then the sum of profit after tax and depreciation would be discounted to arrive at the present value of cash inflows for each year.
Calculation of Present Values of cash flow Inflows for each year in BRL
    Year
    Net profit after tax
    Depreciation
    Cash flows after tax
    Discount factor @ 8%
    Present value of cash flow after tax
    1
    900000
    10800000
    11700000
    1.08
    10833333.33
    2
    1440000
    10800000
    12240000
    1.17
    10493827.16
    3
    2012400
    10800000
    12812400
    1.26
    10170896.2
    4
    2619144
    10800000
    13419144
    1.36
    9863471.439
    5
    3262292.64
    10800000
    14062292.64
    1.47
    9570560.083
    Total
    10233836.64
    54000000
    64233836.64
     
    50932088.22
Net Present Value of the Investment
    = Total Present value of cash inflows - Total Present value of cash outflows+ Present value of Salvage
    = 50932088.22 – 60000000+ 29401194.11
    = 20333282.33            
    
Notes:
1. Break up initial investment of 60 million BRL
    60%
    36000000
    Facilities
    30%
    18000000
    Machines
    10%
    6000000
    Working capital
    Total
    60000000
     
2. Calculation of depreciation each year
     
    Facilities
    Machines
    Total
    Depreciation per year
    7200000
    3600000
    10800000
(b) (i) Calculation of the annual cash flows (i.e. in USD) that Pretty Face will receive if its subsidiary hedges BRL$8million annually during the project’s lifetime
It has been given in question that Spot rate of the Brazilian real is being quoted at USD$0.30, and the company expects the same rate to prevail in the next 5 years (i.e. before accounting for inflation). Thus the given spot rate will have to be adjusted in order to take account the impact of inflation. This has been done in below table.
The Spot rate for next five years after taking into account the inflation factor is given below:
    BRL
    USD
    1
    0.3
    1.06
    0.3
    1.1236
    0.3
    1.191016
    0.3
    1.26247696
    0.3
( The inflation will cause the Brazilian currency to decline in value, hence, the same amount of USD will be receivable against the increasing BRL value)
From above table we can calculate the spot rate for 1 unit of BRL (after considering the effect of inflation) , which is calculated below:
    1 BRL = USD
    Spot Rate
    1
    0.3
    1
    0.283019
    1
    0.266999
    1
    0.251886
    1
    0.237628
    
    
The following forward rates have been provided for next 5 years
    1 BRL = USD
    Year
    Forward rate
    1
    1
    0.33
    2
    1
    0.3
    3
    1
    0.27
    4
    1
    0.27
    5
    1
    0.25
By applying the above spot rate and forward rate, we will calculate how much USD will be received by the company if it hedges $ 8 million of revenue during the project’s lifetime.
Table showing total amount receivable in USD if hedging is used
    Value of $8 million of revenue hedged in USD
    Remaining revenue in USD calculated using spot rate
    Total amount received in USD
    Year
    Revenue hedged
    Forward rate
    Cash flow in USD
    Total Cash flow less amount hedged
    Spot Rate
    Cash flow in USD
    Total annual cash flows received in USD
    1
    8000000
    0.33
    2640000.00
    3700000.00
    0.30
    1110000
    3750000.00
    2
    8000000
    0.3
    2400000.00
    4240000.00
    0.28
    1200000
    3600000.00
    3
    8000000
    0.27
    2160000.00
    4812400.00
    0.27
    1284905.66
    3444905.66
    4
    8000000
    0.27
    2160000.00
    5419144.00
    0.25
    1365005.34
    3525005.34
    5
    8000000
    0.25
    2000000.00
    6062292.64
    0.24
    1440571.075
    3440571.08
     
    Total
     
    11360000.00
     
     
    6400482.08
    17760482.08
Calculation of Net Present value (if hedging is done)
Present Value of cash inflows from project
    Total annual cash flows received in USD
    Discount factor @ 8%
    Present value of cash flows in USD
    3750000.00
    1.08
    3472222.222
    3600000.00
    1.17
    3086419.753
    3444905.66
    1.26
    2734677.18
    3525005.34
    1.36
    2590984.156
    3440571.08
    1.47
    2341594.862
    17760482.08
     
    14225898.17
Present Value of proceeds from sale of facilities at the end of project
    Total annual cash flows received in USD
    Discount factor @ 8% for 5th year
    Present...
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