BSBFIM501 Manage Budget and Financial Plan Assignment Help
Delivery in day(s): 4
John Brown earns sole income from the trust and the capital market rate of interest is 5% per annum. John will receive $40,000 now in Year 0, $30,000 at the end of Year 1 and $60,000 at the end of Year 2. In this way John will have the following amounts as funds during the period of three years:
Year 0 = $40,000
Year 1 = $40,000 + $40,000*0.05 + $30,000
= $42,000 + $30,000
= $72,000
Year 2 = $42,000+ $42,000*0.05 + $30,000 + $30,000*0.05 + $60,000
= $44,100 + $31,500 + $60,000
= $135,600
Thus, John Brown will have an amount of $135,600 in two years’ time of he does not consume during this period (Fair, 2014). If John consumes as per his $32,000 now and $ 42,000 in one year then the amount for consumption remaining with him at the end of each period will be as follows:
Year 0 = $40,000 – $32,000
= $8,000
Year 1 = $8,000 + $8,000*0.05 + $30,000
= $8,400 +$30,000
= $38,400
Here, John wishes to consume $42,000 but he has funds of $38,400 only and therefore he cannot consume $42,000. He will have to limit his consumption up to $38,400.
Name of company 
Expected return 
Beta 
Formula 
CAPM 
Shamrock Ltd. 
10.40% 
0.4 
=8% + 0.4*6% 
10.40% 
Camellia Ltd. 
12.90% 
0.7 
=8% + 0.7*6% 
12.20% 
Rose Ltd. 
13.80% 
1.1 
=8% + 1.1*6% 
14.600% 
Daffodil Ltd. 
17.60% 
1.6 
=8% + 1.6*6% 
17.600% 
Shamrock Ltd. = In this case, expected return is 10.40% and expected return using the CAPM model is 10.40%. Both the expected return and expected return using CAPM is same. This shows that shares are correctly valued.
Camellia Ltd. = In this case, expected return is 12.90% and expected return using the CAPM model is 12.20%. Expected return using CAPM is lower than the expected return. This shows that shares are overvalued.
Rose Ltd. = In this case expected return is 13.80% and expected return using the CAPM model is 14.60%. Expected return using CAPM is higher than the expected return. This shows that shares are undervalued (Noda, et. al., 2016).
Daffodil Ltd. = In this case, expected return is 17.60% and expected return using the CAPM model is 17.60%. Both the expected return and expected return using CAPM is same. This shows that shares are correctly valued.
This graph shows the presentation of CAPM formula. This chart represents beta on the X axis and returns on the Y axis. This chart shows expected return on securities on beta.
Name of company 
CAPM 
Beta 
Riskfree rate 
8% 
0 
Shamrock Ltd 
10.40% 
0.4 
Camellia Ltd 
12.20% 
0.7 
Rose Ltd 
14.60% 
1.1 
Daffodil Ltd 
17.60% 
1.6 
This security market line graph shows expected return on beta. As described in the table Xaxis of this chart shows beta and Y axis of this chart shows expected return on securities (Elbannan, 2014).
(i) Present value of the constant income flows at the beginning of the eighth year
Year 
Return 
PV factor 
Present value 
1 
0 
0.943396 
0 
2 
0 
0.889996 
0 
3 
0 
0.839619 
0 
4 
0 
0.792094 
0 
5 
$80,000 
0.747258 
$59,780.65 
6 
$130,000 
0.704961 
$91,644.87 
7 
$180,000 
0.665057 
$119,710.28 
Inflow at beginning of eight year 
$271,135.80 
This calculation shows that the present value of income cash flow at the beginning of the eighth year will be $271,135.80.
(ii) Present value of whole income stream
Perpetuity: Perpetuity is a type of annuity when an infinite amount is received for periodic payments. Perpetuity formula is applied for calculation of present value of such annuity amount. This helps in calculation of present value of future cash flows (Yu, et. al., 2010). The formula for calculation of present value of a perpetuity is as follows.
Present value of perpetuity= D/R
Present value of perpetuity= $250000+ ($271,135.80/6%)
Present value of perpetuity= $4,437,802.47
This shows that present value of whole stream income is $4,437,802.47.
Lisa Brown obtained a loan of $700,000 with equal monthly repayments over 12 years and the rate of interest is 8.4% compounded monthly. The installment amounts for monthly repayment can be calculated as follows in excel:
Instalment = PMT (rate, nper, PV)
= $7,731.54
The Balance of the loan at the end of the second year can be calculated as follows:
Month 
Principal 
Interest 
Balance 
1 
2832 
4900 
697168 
2 
2852 
4880 
694316 
3 
2872 
4860 
691444 
4 
2892 
4840 
688552 
5 
2912 
4820 
685640 
6 
2933 
4799 
682708 
7 
2953 
4779 
679755 
8 
2974 
4758 
676781 
9 
2995 
4737 
673787 
10 
3015 
4717 
670771 
11 
3037 
4695 
667734 
12 
3058 
4674 
664677 
13 
3079 
4653 
661597 
14 
3101 
4631 
658497 
15 
3123 
4609 
655374 
16 
3144 
4588 
652230 
17 
3166 
4566 
649063 
18 
3189 
4543 
645875 
19 
3211 
4521 
642664 
20 
3233 
4499 
639430 
21 
3256 
4476 
636174 
22 
3279 
4453 
632896 
23 
3302 
4430 
629594 
24 
3325 
4407 
626269 
Thus, the Balance of loan at the end of the second year is $626,269
Now, Lisa Brown has two options. The first alternative is to increase the monthly repayment and the second alternative is to extend the period of the loan.
First Option
If Lisa accepts the first alternative then in such case the revised installments calculated using excel will be as follows:
Revised Instalments = PMT (10.2%/12, 12*10, 626,269)
= $8,346
Thus, the new monthly repayment will be $8,346 if Lisa accepts the first alternative.
Second alternative
If Lisa accepts the second alternatives then the installment amount will be $7,732. In this case, the number of installments or the period of loan will increase. The calculated number of periods using interpolation for an instalment of $7,731 compounded monthly at the rate of 10.2% per annum to repay $626,269 will be 138 months or 11.5 years (Ally, 2015). Thus the extra period will be 11.5 years – 10 years = 1.5 years. Therefore if Lisa adopts the second alternative, the extra period that will be added to her loan period will be 1.5 years or 18 months.
Expected Return = WA* ER(A) + WB* ER(B)
Where W is the weight of security
And ER is the Expected Return of security\
Billy’s portfolio consists of two shares A and B. He has invested 1/4^{th} of his investment in Share A and remaining 3/4^{th} in Share B. Thus, W(A) = 0.25 and W(B) = 0.75.The expected return from Share A is 14% and that of Share B is 20%. Thus, ER(A) = 14% and ER(B) = 20%.
Expected Return on Billy’s Portfolio = W(A)* ER(A) + WB* ER(B)
= 0.25*14% + 0.75*20%
= 18.5%
Thus the expected return of Billy’s portfolio is 18.5%
Standard Deviation of Portfolio can be calculated using the following formula:
Portfolio Standard Deviation = √W_{A}^{2}σ_{A}^{2 }+ W_{B}^{2}σ_{B}^{2 }+ 2W_{A} W_{B }σ_{A }σ_{B }p
Where W is the weight of security,
σ is the standard deviation of security
And p is the correlation of the security
The Standard deviation of Share A in Billy’s portfolio is 17% and that of Share B is 24% and the correlation between the returns of the two shares is 0.5 (Gajera, et. al., 2015).
Standard Deviation of Billy’s portfolio
=√0.25*0.25*0.17*0.17 + 0.75*0.75*0.24*0.24 + 2*0.25*0.75*0.17*0.24*0.5
=√0.041856
= 0.2045
= 20.45%
Billy has currently invested in a two share portfolio. He can either retain his investments in both the shares in the ratio of 1:3 as presently held or he can make 100% investment in any on the two shares. In order to make the recommendation about whether he shall maintain its existing twoshare portfolio or he shall invest all his funds in one of the two securities the analysis can be made as follows:
Portfolio 
Expected Return 
Standard Deviation 
Onequarter investment in Share A and threequarter investment in Share B 
18.5% 
20.45% 
100% investment in Share A 
14% 
17% 
100% investment in Share B 
20% 
24% 
It can be observed from the above table that both the expected return and standard deviation of Share A is higher and similarly for Share B both the return and risk is low. Win case of two share portfolios both the risk and return are medium. Thus, Billy is recommended to maintain its two share portfolio since in this case, he will be able to earn a good return with a medium level of risk (Merriman and Nam, 2015). However, if Billy wishes to invest in one of the two shares completely then he shall invest his funds in Share A since it has a lower risk as compared to that of Share B and has the potential to earn higher returns with lesser risk. If we compare the returns and risk of each of the two shares from the present risk and return with the two shares portfolio, then it can be observed that Share A will give good returns with lesser risks and Share B will give higher returns with higher risks.
(i) Calculation of Price
Face value of bonds = $100,000
Rate of interest up to 15^{th} October 2016 = 8% per annum compounded halfyearly
Revised interest rate after 15^{th} October 2016 = 8% + 2% = 10%
Future Value of Bond on 15^{th} January 2017
= $100,000 + $100,000*0.08*92/365
= $102,016.44
Future Value of Bond on 15^{th} April 2017
= $100,000 + $100,000*0.08*182/365
= $103,989.04
Calculation of price of bonds maturing on 15 April 2019
Present Value of Bond on 15^{th} April 2017 = 103,989/PV Factor @ 4%, 4 half years
= $103,989/0.855
= $121,625
Sales value of Bond on 15 January 2017 = $121,265/PV factor @2%, 4 quarters
= $121,265/0.924
= $131,239
Calculation of price of bonds maturing on 15 April 2023
Present Value of Bond on 15^{th} April 2017 = 103,989/PV Factor @ 4%, 12 half years
= $103,989/0.625
= $166,382
Sales value of Bond on 15 January 2017 = $166,382/PV factor @2%, 4 quarters
= $166,382/0.924
= $180,067
Thus the sales value of bond maturing in the year 2019 will be $131,239 and the bonds maturing in the year 2023 will be $180,067.
ii. Relative price movements in bonds
As evidenced in the above answer the price movements of both the bonds have been fluctuating. With the increase in the period of maturity, the value of bond also increases due to higher amounts of interest accumulated.
Year 
0 
1 
2 
3 
4 
5 
Total 
Cost 







Equipment cost 
400000 






Interest payments 

40000 
40000 
40000 
40000 
40000 

Working capital 
27,000 






Lease compensation 
22000 






Overhauling expenses 



10,000 

10,000 

Total costs 
449,000 
40,000 
40,000 
50,000 
40,000 
50,000 

Present Value Factor @14% 
1 
0.877193 
0.769468 
0.674972 
0.59208 
0.03779 

Present value of costs 
449000 
35087.72 
30778.7 
33748.58 
23683.21 
1889.508 
574187.7 








Benefits 







Reduction in labour cost after tax 

119,000 
119,000 
119,000 
119,000 
119,000 

Salvage value after tax 





21,000 

Recovery of working capital 





18,900 

Tax saving on depreciation 

24000 
24000 
24000 
24000 
24000 

Tax saving on interest expense 

12000 
12000 
12000 
12000 
12000 

Tax saving on overhauling expenses 



3000 

3000 

Total Benefits 

155,000 
155,000 
158,000 
155,000 
197,900 

Present Value Factor @14% 
1 
0.877193 
0.769468 
0.674972 
0.59208 
0.03779 

Present Value of benefits 
0 
135964.9 
119267.5 
106645.5 
91772.44 
7478.672 
461129 








Incremental cash flows 
449000 
100877.2 
88488.77 
72896.92 
68089.23 
5589.164 

Above table shows the calculation of NPV and incremental cash flows.
(a) NPV = Total costTotal benefits
NPV = 574787.7 461129
NPV = (113059)
In the present value terms, there is a net loss as total costs are higher than total benefits. Costs are higher than the benefits hence equipment will cause a net loss.
Calculation of incremental cash flow is shown in the above table.
(b) Purchase of equipment is to be finalized on the basis of NPV and this can be seen that the NPV of this project is negative which shows that this equipment will not be profitable for Capital Constructions Ltd (Becker and Ivashina, 2015). A cost of this equipment is higher than the benefits that are going to arise from this project. From this, it can be concluded that company should not purchase this equipment.
Ally, A.M., 2015, “An Empirical Analysis of Financial Performance of Higher Education Students’ Loan Scheme (HESLS) in Tanzania”, International Journal of Management Sciences and Business Research, vol 4, issue 3, pp 4559.\
Becker, B. and Ivashina, V., 2015. Reaching for yield in the bond market. The Journal of Finance, 70(5), pp.18631902.
Elbannan, M.A., 2014, “The capital asset pricing model: an overview of the theory”, International Journal of Economics and Finance, vol 7, issue 1, p.216.
Fair, R.C., 2014, “How might a central bank report uncertainty?”.
Gajera, M.A., Vyas, M.P. and Patoliya, M.P., 2015. Risk and Return Analysis Of BSE Small, Medium & Large Capitalization Indices. Scholedge International Journal of Management & Development ISSN 23943378, 2(4), pp.3237.
Merriman, K.K. and Nam, D.I., 2015, “A Managerial Perspective on Risk and Return for Corporate Innovation Projects”, Organization Management Journal, vol 12, issue 4, pp.200207.
Noda, R.F., Martelanc, R. and Kayo, E.K., 2016, “The earnings/price risk factor in capital asset pricing models”, Revista Contabilidade & Finanças, vol 27, issue 70, pp.6779.
Yu, J.C., Wee, H.M., Widyadana, G.A. and Chang, J.Y., 2010, “The effects of inflation and time value of money on a production model with a random product life cycle”, AsiaPacific Journal of Operational Research, vol 27, issue 04, pp.437456.