Accounting and Finance: Capital Budgeting Analysis and Capital Structure of ARB Corporation Limited
VerifiedAdded on  2023/06/14
|20
|4073
|475
AI Summary
This report provides a detailed analysis of capital budgeting techniques and capital structure of ARB Corporation Limited. It includes recommendations for improving the capital structure and maximizing wealth for shareholders.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
0ACCOUNTING AND FINANCE
Accounting and Finance
Student Name
University Name
Accounting and Finance
Student Name
University Name
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
1ACCOUNTING AND FINANCE
Table of Contents
Answer to Part A.........................................................................................................................3
Selection among the projects...........................................................................................................3
Product Cannibalization...................................................................................................................4
Capital budgeting options available to compensate excess sales....................................................4
Original value of the vacant Wodonga to be considered or not......................................................4
Answer to Part B..............................................................................................................................5
Executive Summary.........................................................................................................................5
Introduction......................................................................................................................................5
Answer to 2i)...................................................................................................................................5
Current capital structure of the firm ARB Corporation Limited.....................................................5
WACC of the organization ARB Corporation Limited...................................................................6
CAPM..............................................................................................................................................6
Answer to 2ii) Comparison of the capital structure of ARB Corporation Limited with its
competitor........................................................................................................................................6
Answer to 2iii) Analysis of Key Financial Ratios of ARB Corporation Limited...........................6
Answer to 2iv): ARB Corporation Limited capital structure comparison over the years...............8
Answer to 2v) Maximizing wealth for shareholders.......................................................................9
Table of Contents
Answer to Part A.........................................................................................................................3
Selection among the projects...........................................................................................................3
Product Cannibalization...................................................................................................................4
Capital budgeting options available to compensate excess sales....................................................4
Original value of the vacant Wodonga to be considered or not......................................................4
Answer to Part B..............................................................................................................................5
Executive Summary.........................................................................................................................5
Introduction......................................................................................................................................5
Answer to 2i)...................................................................................................................................5
Current capital structure of the firm ARB Corporation Limited.....................................................5
WACC of the organization ARB Corporation Limited...................................................................6
CAPM..............................................................................................................................................6
Answer to 2ii) Comparison of the capital structure of ARB Corporation Limited with its
competitor........................................................................................................................................6
Answer to 2iii) Analysis of Key Financial Ratios of ARB Corporation Limited...........................6
Answer to 2iv): ARB Corporation Limited capital structure comparison over the years...............8
Answer to 2v) Maximizing wealth for shareholders.......................................................................9
2ACCOUNTING AND FINANCE
Answer to 2vi) Conclusion and recommendations..........................................................................9
References......................................................................................................................................10
Appendices................................................................................................................................11
Answer to 2vi) Conclusion and recommendations..........................................................................9
References......................................................................................................................................10
Appendices................................................................................................................................11
3ACCOUNTING AND FINANCE
Answer to Part A
Selection among the projects
In the given case study, the organization Saturn Petcare Australia and New Zealand has
two alternative projects to be selected. The Demand and Strategy Finance director of the
organization, Nathan Quinlivan want to select one of the two projects based on capital budgeting
analysis. The major findings from both the projects is as follows:-
Important Information
Two projects to be considered Bathurst and Wodonga
Sales Growth Rate 10%
Margin After conversion Rate 30%
Expected Return on Investment 22%
Initial Investment $27,500,000
Expected life 10years
Existing dry food factory for Bathurst 8000000
Table 1: Key information about the projects
The calculation of capital budgeting for both the projects has been shown in Appendix 1.
From the calculation, it can be inferred that, the organization needs to select Wodonga project for
their new manufacturing production line. Firstly, net project value (NPV) of the project is
$9,594,827 while in case of Bathurst, NPV is just $5,844,567. In addition to this, payback period
for Wodonga project is 3.45, while in case of Bathurst, it is 3.86. Similarly, profitability index
for Wodonga is 1.35, while in case of Bathurst, it is 1.18. Therefore, it can be inferred that
Wodonga project will be more profitable for Saturn as it can recover its initial investment of 27.5
million quickly than in case of Bathurst. Appendix 1 also reflects after tax cash flows of both the
projects. The detailed summary is as follows:-
Answer to Part A
Selection among the projects
In the given case study, the organization Saturn Petcare Australia and New Zealand has
two alternative projects to be selected. The Demand and Strategy Finance director of the
organization, Nathan Quinlivan want to select one of the two projects based on capital budgeting
analysis. The major findings from both the projects is as follows:-
Important Information
Two projects to be considered Bathurst and Wodonga
Sales Growth Rate 10%
Margin After conversion Rate 30%
Expected Return on Investment 22%
Initial Investment $27,500,000
Expected life 10years
Existing dry food factory for Bathurst 8000000
Table 1: Key information about the projects
The calculation of capital budgeting for both the projects has been shown in Appendix 1.
From the calculation, it can be inferred that, the organization needs to select Wodonga project for
their new manufacturing production line. Firstly, net project value (NPV) of the project is
$9,594,827 while in case of Bathurst, NPV is just $5,844,567. In addition to this, payback period
for Wodonga project is 3.45, while in case of Bathurst, it is 3.86. Similarly, profitability index
for Wodonga is 1.35, while in case of Bathurst, it is 1.18. Therefore, it can be inferred that
Wodonga project will be more profitable for Saturn as it can recover its initial investment of 27.5
million quickly than in case of Bathurst. Appendix 1 also reflects after tax cash flows of both the
projects. The detailed summary is as follows:-
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
4ACCOUNTING AND FINANCE
Bathurst Wodonga
Payback Period-Part 2 3.86 3.45
Net Present Value-Part 3 $5,844,567 $9,594,827
Profitability Index-Part 4 1.18 1.35
Table 2: Summary analysis for both the projects
Product Cannibalization
Product Cannibalization is defined as a concept when a particular organization has
different types of products competing with each other within a same market or industry. In case
of capital budgeting techniques, the organizations can reduce the sales of existing products while
launching new products in the market (Abbey, Blackburn & Guide Jr, 2015). The organization
Saturn Petcare Australia and New Zealand may consider Product Cannibalization while
launching manufacturing production line while evaluating the alternatives among the two given
projects.
Capital budgeting options available to compensate excess sales
It has been seen that the Saturn’s marketing department’s budgeted sales estimates may
be excessive. This can be compensated with the capital budgeting technique of Net Present
value. With the assist of NPV method, the estimated net cash flow may be increased which will
further nullify the excess sales (Burns & Walker, 2015).
Bathurst Wodonga
Payback Period-Part 2 3.86 3.45
Net Present Value-Part 3 $5,844,567 $9,594,827
Profitability Index-Part 4 1.18 1.35
Table 2: Summary analysis for both the projects
Product Cannibalization
Product Cannibalization is defined as a concept when a particular organization has
different types of products competing with each other within a same market or industry. In case
of capital budgeting techniques, the organizations can reduce the sales of existing products while
launching new products in the market (Abbey, Blackburn & Guide Jr, 2015). The organization
Saturn Petcare Australia and New Zealand may consider Product Cannibalization while
launching manufacturing production line while evaluating the alternatives among the two given
projects.
Capital budgeting options available to compensate excess sales
It has been seen that the Saturn’s marketing department’s budgeted sales estimates may
be excessive. This can be compensated with the capital budgeting technique of Net Present
value. With the assist of NPV method, the estimated net cash flow may be increased which will
further nullify the excess sales (Burns & Walker, 2015).
5ACCOUNTING AND FINANCE
Original value of the vacant Wodonga to be considered or not
It can be inferred that the Original value of the vacant Wodonga should not been taken
into consideration as the technique of capital budgeting (NPV) only considers costs related to
newly developed sites as initial investment (Brooks,2015). In addition to this, it can be also
inferred that if original value of the vacant Wodonga is included, then, the entire capital
budgeting analysis will be changed and completely wrong, as shown in Appendix 1B.
Answer to Part B
Executive Summary
The given report reflects about the structure of capital of the organization ARB Corporation
Limited. It has been found that the organization has given 100 percent weightage to
shareholder’s equity in its capital structure. However, there are several issues highlighted with
the organization. Based on which, certain recommendations have been suggested.
Introduction
The given report highlights about ARB Corporation Limited and its financial
performance over the years. It has been also compared with one of its competitors in terms of its
capital structure. Based on the analysis, suitable recommendations have been given.
Answer to 2i)
Current capital structure of the firm ARB Corporation Limited
From Appendix 2i, it can be inferred that the organization ARB Corporation Limited
gives 100 percent weightage to equity in its capital structure (Arb.com.au, 2018). There is no
Original value of the vacant Wodonga to be considered or not
It can be inferred that the Original value of the vacant Wodonga should not been taken
into consideration as the technique of capital budgeting (NPV) only considers costs related to
newly developed sites as initial investment (Brooks,2015). In addition to this, it can be also
inferred that if original value of the vacant Wodonga is included, then, the entire capital
budgeting analysis will be changed and completely wrong, as shown in Appendix 1B.
Answer to Part B
Executive Summary
The given report reflects about the structure of capital of the organization ARB Corporation
Limited. It has been found that the organization has given 100 percent weightage to
shareholder’s equity in its capital structure. However, there are several issues highlighted with
the organization. Based on which, certain recommendations have been suggested.
Introduction
The given report highlights about ARB Corporation Limited and its financial
performance over the years. It has been also compared with one of its competitors in terms of its
capital structure. Based on the analysis, suitable recommendations have been given.
Answer to 2i)
Current capital structure of the firm ARB Corporation Limited
From Appendix 2i, it can be inferred that the organization ARB Corporation Limited
gives 100 percent weightage to equity in its capital structure (Arb.com.au, 2018). There is no
6ACCOUNTING AND FINANCE
sign of debt and therefore, it can be opined that the firm is not exposed to financial risk (Robb &
Robinson, 2014).
WACC of the organization ARB Corporation Limited
From the calculation shown in Appendix 2i, it can be inferred that WACC of ARB Corporation
Limited is 18.05 percent in 2017. In comparison with the previous two years, it can be deduced
that the cost of capital has decreased (19.01 percent in 2016 and 19.39 percent in 2015). This can
be taken as a good sign for the organization as the firm is being successful in minimizing the cost
of capital financing (Zeitun & Tian, 2014).
CAPM
From the calculation shown in Appendix 2i, it can be inferred that, the expected cost of equity is
coming to be 7.9 percent. This can be taken as a good sign for the organization as market rate of
return RM is more than the expected cost of equity (8.54 percent).
Answer to 2ii) Comparison of the capital structure of ARB Corporation Limited with its
competitor
The capital structure of the organization ARB Corporation Limited has been compared
with its competitor Bell Equipment Limited. In case of Bell Equipment Limited, the capital
structure of the firm is mixed of debt and equity (81 percent equity and 19 percent debt). The
total equity of the company is $3,657. While, in case of ARB Corporation Limited, the entire
capital structure is formed on the basis of equity and there is no sign of debt in capital structure.
The total equity of the firm is $272,341.
sign of debt and therefore, it can be opined that the firm is not exposed to financial risk (Robb &
Robinson, 2014).
WACC of the organization ARB Corporation Limited
From the calculation shown in Appendix 2i, it can be inferred that WACC of ARB Corporation
Limited is 18.05 percent in 2017. In comparison with the previous two years, it can be deduced
that the cost of capital has decreased (19.01 percent in 2016 and 19.39 percent in 2015). This can
be taken as a good sign for the organization as the firm is being successful in minimizing the cost
of capital financing (Zeitun & Tian, 2014).
CAPM
From the calculation shown in Appendix 2i, it can be inferred that, the expected cost of equity is
coming to be 7.9 percent. This can be taken as a good sign for the organization as market rate of
return RM is more than the expected cost of equity (8.54 percent).
Answer to 2ii) Comparison of the capital structure of ARB Corporation Limited with its
competitor
The capital structure of the organization ARB Corporation Limited has been compared
with its competitor Bell Equipment Limited. In case of Bell Equipment Limited, the capital
structure of the firm is mixed of debt and equity (81 percent equity and 19 percent debt). The
total equity of the company is $3,657. While, in case of ARB Corporation Limited, the entire
capital structure is formed on the basis of equity and there is no sign of debt in capital structure.
The total equity of the firm is $272,341.
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
7ACCOUNTING AND FINANCE
Answer to 2iii) Analysis of Key Financial Ratios of ARB Corporation Limited
The analysis of the key financial ratios of the firm can be analyzed with the help of the following
graphs.
2017 2016 2014 2015
0.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
9.00
7.53 8.03 7.81 7.49
4.92
5.83
5.18
4.36
1.18 1.22 1.22 1.23
Efficiency Ratios
Receivables Turnover Ratio PayableTurnover Ratio Asset Turnover Ratio
Graph 1: Efficiency Ratios
Answer to 2iii) Analysis of Key Financial Ratios of ARB Corporation Limited
The analysis of the key financial ratios of the firm can be analyzed with the help of the following
graphs.
2017 2016 2014 2015
0.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
9.00
7.53 8.03 7.81 7.49
4.92
5.83
5.18
4.36
1.18 1.22 1.22 1.23
Efficiency Ratios
Receivables Turnover Ratio PayableTurnover Ratio Asset Turnover Ratio
Graph 1: Efficiency Ratios
8ACCOUNTING AND FINANCE
2017 2016 2014 2015
0.00
0.05
0.10
0.15
0.20
0.25
0.13 0.13 0.13 0.14
0.18 0.19 0.19
0.22
Profitability Ratios
Net Profit Margin Return on Equity (ROE)
Graph 2: Profitability Ratios
2017 2016 2014 2015
0.00
0.50
1.00
1.50
2.00
2.50
3.00
3.50
4.00
3.40 3.63
3.15
3.48
0.19 0.17 0.19 0.22
Solvency Ratios
Current Ratio Debt-to-Equity Ratio
Graph 3: Solvency Ratios
From the above three graphs and appendix 2iii, few significant changes can be highlighted.
Current ratio of the organization has declined in comparison with the last few years. This is not a
good sign for ARB Corporation Limited as the firm is failing to maintain its liquidity. In addition
2017 2016 2014 2015
0.00
0.05
0.10
0.15
0.20
0.25
0.13 0.13 0.13 0.14
0.18 0.19 0.19
0.22
Profitability Ratios
Net Profit Margin Return on Equity (ROE)
Graph 2: Profitability Ratios
2017 2016 2014 2015
0.00
0.50
1.00
1.50
2.00
2.50
3.00
3.50
4.00
3.40 3.63
3.15
3.48
0.19 0.17 0.19 0.22
Solvency Ratios
Current Ratio Debt-to-Equity Ratio
Graph 3: Solvency Ratios
From the above three graphs and appendix 2iii, few significant changes can be highlighted.
Current ratio of the organization has declined in comparison with the last few years. This is not a
good sign for ARB Corporation Limited as the firm is failing to maintain its liquidity. In addition
9ACCOUNTING AND FINANCE
to this, return on equity has also declined. This is also not a good sign as the shareholders are not
getting a good amount of return on their equity. On the contrary, debt-equity ratio has increased
from 0.169 to 0.187, which can be considered as a positive sign for the organization (Robb &
Robinson, 2014).
Answer to 2iv): ARB Corporation Limited capital structure comparison over the years
From Appendix 2iv, it can be inferred that there has been significant percent of changes in total
equity over the years. In 2017, the total equity increased by 9.11 percent in comparison with the
previous year. However, the organization has given 100 percent weightage to shareholder’s
equity over the years and there is no sign of debt in the capital structure.
Answer to 2v) Maximizing wealth for shareholders
From Appendix 2v, it can be inferred that the organization ARB Corporation Limited is not
growing at the rate what it is expected to be. On the positive side, the amount of Profit after Tax
has increased over the years (Zeitun & Tian, 2014).
Answer to 2vi) Conclusion and recommendations
It can be concluded that several recommendations can be given to the firm ARB Corporation
Limited. These are as follows:-
ï‚· Capital structure needs to be improved in the coming years. Ideally, there is should be 50-
50 percent of debt and equity.
ï‚· The management of the firm needs to concentrate on wealth maximization of the
concerned shareholders
ï‚· The organization needs to maintain its liquidity to maintain its working capital cycle.
to this, return on equity has also declined. This is also not a good sign as the shareholders are not
getting a good amount of return on their equity. On the contrary, debt-equity ratio has increased
from 0.169 to 0.187, which can be considered as a positive sign for the organization (Robb &
Robinson, 2014).
Answer to 2iv): ARB Corporation Limited capital structure comparison over the years
From Appendix 2iv, it can be inferred that there has been significant percent of changes in total
equity over the years. In 2017, the total equity increased by 9.11 percent in comparison with the
previous year. However, the organization has given 100 percent weightage to shareholder’s
equity over the years and there is no sign of debt in the capital structure.
Answer to 2v) Maximizing wealth for shareholders
From Appendix 2v, it can be inferred that the organization ARB Corporation Limited is not
growing at the rate what it is expected to be. On the positive side, the amount of Profit after Tax
has increased over the years (Zeitun & Tian, 2014).
Answer to 2vi) Conclusion and recommendations
It can be concluded that several recommendations can be given to the firm ARB Corporation
Limited. These are as follows:-
ï‚· Capital structure needs to be improved in the coming years. Ideally, there is should be 50-
50 percent of debt and equity.
ï‚· The management of the firm needs to concentrate on wealth maximization of the
concerned shareholders
ï‚· The organization needs to maintain its liquidity to maintain its working capital cycle.
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
10ACCOUNTING AND FINANCE
In this manner, the organization will be able to attain its desired aims and objectives and sustain
with respect to its competitors.
In this manner, the organization will be able to attain its desired aims and objectives and sustain
with respect to its competitors.
11ACCOUNTING AND FINANCE
References
Abbey, J. D., Blackburn, J. D., & Guide Jr, V. D. R. (2015). Optimal pricing for new and
remanufactured products. Journal of Operations Management, 36, 130-146.
ARB 4x4 Accessories - Your partner in adventure. (2018). Retrieved from
https://www.arb.com.au/
Brooks, R. (2015). Financial management: core concepts. Pearson.
Burns, R., & Walker, J. (2015). Capital budgeting surveys: the future is now.
Robb, A. M., & Robinson, D. T. (2014). The capital structure decisions of new firms. The
Review of Financial Studies, 27(1), 153-179.
Zeitun, R., & Tian, G. (2014). Capital structure and corporate performance: evidence from
Jordan.
References
Abbey, J. D., Blackburn, J. D., & Guide Jr, V. D. R. (2015). Optimal pricing for new and
remanufactured products. Journal of Operations Management, 36, 130-146.
ARB 4x4 Accessories - Your partner in adventure. (2018). Retrieved from
https://www.arb.com.au/
Brooks, R. (2015). Financial management: core concepts. Pearson.
Burns, R., & Walker, J. (2015). Capital budgeting surveys: the future is now.
Robb, A. M., & Robinson, D. T. (2014). The capital structure decisions of new firms. The
Review of Financial Studies, 27(1), 153-179.
Zeitun, R., & Tian, G. (2014). Capital structure and corporate performance: evidence from
Jordan.
12ACCOUNTING AND FINANCE
Appendices
Appendix 1A: Calculation of capital budgeting of both the projects
Bathurst
Particulars 0 1 2 3 4 5 6 7 8 9 10
Initial Investment:
Construction on Manufacturing Unit -$27,500,000
Existing dry food factory -$8,000,000
Infrastructure Grant $2,500,000
Total Initial Investment -$33,000,000
Operational Cash Flow:
Sales Growth Rate 10% 10% 10% 10% 10% 10% 10% 10% 10%
Margin After conversion Rate 30% 30% 30% 30% 30% 30% 30% 30% 30% 30%
Annual Sales $30,000,000 $33,000,000 $36,300,000 $39,930,000 $43,923,000 $48,315,300 $53,146,830 $58,461,513 $64,307,664 $70,738,431
Conversion Cost -$21,000,000 -$23,100,000 -$25,410,000 -$27,951,000 -$30,746,100 -$33,820,710 -$37,202,781 -$40,923,059 -$45,015,365 -$49,516,902
Rebate on Municipal Rate $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000
Depreciation on Plant and Equipment -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000
Depreciation on Building -$320,000 -$320,000 -$320,000 -$320,000 -$320,000 -$320,000 -$320,000 -$320,000 -$320,000 -$320,000
Net Profit before Tax $6,430,000 $7,330,000 $8,320,000 $9,409,000 $10,606,900 $11,924,590 $13,374,049 $14,968,454 $16,722,299 $18,651,529
(-) Income Tax @ 30% -$1,929,000 -$2,199,000 -$2,496,000 -$2,822,700 -$3,182,070 -$3,577,377 -$4,012,215 -$4,490,536 -$5,016,690 -$5,595,459
Net Profit after Tax $4,501,000 $5,131,000 $5,824,000 $6,586,300 $7,424,830 $8,347,213 $9,361,834 $10,477,918 $11,705,610 $13,056,070
Add: Depreciation on Plant and Equipment $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000
Add: Depreciation on Building $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000
After-Tax Cash Flows-Part 1 $7,571,000 $8,201,000 $8,894,000 $9,656,300 $10,494,830 $11,417,213 $12,431,834 $13,547,918 $14,775,610 $16,126,070
Net Cash Flow -$33,000,000 $7,571,000 $8,201,000 $8,894,000 $9,656,300 $10,494,830 $11,417,213 $12,431,834 $13,547,918 $14,775,610 $16,126,070
Cumulative Cash Flow -$33,000,000 -$25,429,000 -$17,228,000 -$8,334,000 $1,322,300 $11,817,130 $23,234,343 $35,666,177 $49,214,095 $63,989,705 $80,115,775
Discount Rate 22% 22% 22% 22% 22% 22% 22% 22% 22% 22% 22%
Discounted Cash Flows -$33,000,000 $6,205,738 $5,509,944 $4,897,987 $4,358,845 $3,883,079 $3,462,590 $3,090,412 $2,760,539 $2,467,783 $2,207,650
Payback Period-Part 2 3.86
Net Present Value-Part 3 $5,844,567
Profitability Index-Part 4 1.18
Bathurst Site: Capital Budgeting Analysis
Years
Appendices
Appendix 1A: Calculation of capital budgeting of both the projects
Bathurst
Particulars 0 1 2 3 4 5 6 7 8 9 10
Initial Investment:
Construction on Manufacturing Unit -$27,500,000
Existing dry food factory -$8,000,000
Infrastructure Grant $2,500,000
Total Initial Investment -$33,000,000
Operational Cash Flow:
Sales Growth Rate 10% 10% 10% 10% 10% 10% 10% 10% 10%
Margin After conversion Rate 30% 30% 30% 30% 30% 30% 30% 30% 30% 30%
Annual Sales $30,000,000 $33,000,000 $36,300,000 $39,930,000 $43,923,000 $48,315,300 $53,146,830 $58,461,513 $64,307,664 $70,738,431
Conversion Cost -$21,000,000 -$23,100,000 -$25,410,000 -$27,951,000 -$30,746,100 -$33,820,710 -$37,202,781 -$40,923,059 -$45,015,365 -$49,516,902
Rebate on Municipal Rate $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000
Depreciation on Plant and Equipment -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000
Depreciation on Building -$320,000 -$320,000 -$320,000 -$320,000 -$320,000 -$320,000 -$320,000 -$320,000 -$320,000 -$320,000
Net Profit before Tax $6,430,000 $7,330,000 $8,320,000 $9,409,000 $10,606,900 $11,924,590 $13,374,049 $14,968,454 $16,722,299 $18,651,529
(-) Income Tax @ 30% -$1,929,000 -$2,199,000 -$2,496,000 -$2,822,700 -$3,182,070 -$3,577,377 -$4,012,215 -$4,490,536 -$5,016,690 -$5,595,459
Net Profit after Tax $4,501,000 $5,131,000 $5,824,000 $6,586,300 $7,424,830 $8,347,213 $9,361,834 $10,477,918 $11,705,610 $13,056,070
Add: Depreciation on Plant and Equipment $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000
Add: Depreciation on Building $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000
After-Tax Cash Flows-Part 1 $7,571,000 $8,201,000 $8,894,000 $9,656,300 $10,494,830 $11,417,213 $12,431,834 $13,547,918 $14,775,610 $16,126,070
Net Cash Flow -$33,000,000 $7,571,000 $8,201,000 $8,894,000 $9,656,300 $10,494,830 $11,417,213 $12,431,834 $13,547,918 $14,775,610 $16,126,070
Cumulative Cash Flow -$33,000,000 -$25,429,000 -$17,228,000 -$8,334,000 $1,322,300 $11,817,130 $23,234,343 $35,666,177 $49,214,095 $63,989,705 $80,115,775
Discount Rate 22% 22% 22% 22% 22% 22% 22% 22% 22% 22% 22%
Discounted Cash Flows -$33,000,000 $6,205,738 $5,509,944 $4,897,987 $4,358,845 $3,883,079 $3,462,590 $3,090,412 $2,760,539 $2,467,783 $2,207,650
Payback Period-Part 2 3.86
Net Present Value-Part 3 $5,844,567
Profitability Index-Part 4 1.18
Bathurst Site: Capital Budgeting Analysis
Years
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
13ACCOUNTING AND FINANCE
Wodanga
Particulars 0 1 2 3 4 5 6 7 8 9 10
Initial Investment:
Construction on Manufacturing Unit -$27,500,000
Vacant office space
Total Initial Investment -$27,500,000
Operational Cash Flow:
Sales Growth Rate 10% 10% 10% 10% 10% 10% 10% 10% 10%
Margin After conversion Rate 30% 30% 30% 30% 30% 30% 30% 30% 30% 30%
Annual Sales $30,000,000 $33,000,000 $36,300,000 $39,930,000 $43,923,000 $48,315,300 $53,146,830 $58,461,513 $64,307,664 $70,738,431
Conversion Cost -$21,000,000 -$23,100,000 -$25,410,000 -$27,951,000 -$30,746,100 -$33,820,710 -$37,202,781 -$40,923,059 -$45,015,365 -$49,516,902
Depreciation on Plant and Equipment -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000
Depreciation on Building $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit before Tax $6,250,000 $7,150,000 $8,140,000 $9,229,000 $10,426,900 $11,744,590 $13,194,049 $14,788,454 $16,542,299 $18,471,529
(-)Income Tax @ 30% -$1,875,000 -$2,145,000 -$2,442,000 -$2,768,700 -$3,128,070 -$3,523,377 -$3,958,215 -$4,436,536 -$4,962,690 -$5,541,459
Net Profit after Tax $4,375,000 $5,005,000 $5,698,000 $6,460,300 $7,298,830 $8,221,213 $9,235,834 $10,351,918 $11,579,610 $12,930,070
Add: Depreciation on Plant and Equipment $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000
Add: Depreciation on Building $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
After-Tax Cash Flows-Part 1 $7,125,000 $7,755,000 $8,448,000 $9,210,300 $10,048,830 $10,971,213 $11,985,834 $13,101,918 $14,329,610 $15,680,070
Net Cash Flow -$27,500,000 $7,125,000 $7,755,000 $8,448,000 $9,210,300 $10,048,830 $10,971,213 $11,985,834 $13,101,918 $14,329,610 $15,680,070
Cumulative Cash Flow -$27,500,000 -$20,375,000 -$12,620,000 -$4,172,000 $5,038,300 $15,087,130 $26,058,343 $38,044,177 $51,146,095 $65,475,705 $81,155,775
Discount Rate 22% 22% 22% 22% 22% 22% 22% 22% 22% 22% 22%
Discounted Cash Flow -$27,500,000 $5,840,164 $5,210,293 $4,652,372 $4,157,521 $3,718,060 $3,327,328 $2,979,542 $2,669,662 $2,393,293 $2,146,593
Payback Periods- Part 2 3.45
Net Present Values- Part 3 $9,594,827
Profitability Index-Part 4 1.35
Wodonga Site: Capital Budgeting Analysis
Years
Wodanga
Particulars 0 1 2 3 4 5 6 7 8 9 10
Initial Investment:
Construction on Manufacturing Unit -$27,500,000
Vacant office space
Total Initial Investment -$27,500,000
Operational Cash Flow:
Sales Growth Rate 10% 10% 10% 10% 10% 10% 10% 10% 10%
Margin After conversion Rate 30% 30% 30% 30% 30% 30% 30% 30% 30% 30%
Annual Sales $30,000,000 $33,000,000 $36,300,000 $39,930,000 $43,923,000 $48,315,300 $53,146,830 $58,461,513 $64,307,664 $70,738,431
Conversion Cost -$21,000,000 -$23,100,000 -$25,410,000 -$27,951,000 -$30,746,100 -$33,820,710 -$37,202,781 -$40,923,059 -$45,015,365 -$49,516,902
Depreciation on Plant and Equipment -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000
Depreciation on Building $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit before Tax $6,250,000 $7,150,000 $8,140,000 $9,229,000 $10,426,900 $11,744,590 $13,194,049 $14,788,454 $16,542,299 $18,471,529
(-)Income Tax @ 30% -$1,875,000 -$2,145,000 -$2,442,000 -$2,768,700 -$3,128,070 -$3,523,377 -$3,958,215 -$4,436,536 -$4,962,690 -$5,541,459
Net Profit after Tax $4,375,000 $5,005,000 $5,698,000 $6,460,300 $7,298,830 $8,221,213 $9,235,834 $10,351,918 $11,579,610 $12,930,070
Add: Depreciation on Plant and Equipment $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000
Add: Depreciation on Building $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
After-Tax Cash Flows-Part 1 $7,125,000 $7,755,000 $8,448,000 $9,210,300 $10,048,830 $10,971,213 $11,985,834 $13,101,918 $14,329,610 $15,680,070
Net Cash Flow -$27,500,000 $7,125,000 $7,755,000 $8,448,000 $9,210,300 $10,048,830 $10,971,213 $11,985,834 $13,101,918 $14,329,610 $15,680,070
Cumulative Cash Flow -$27,500,000 -$20,375,000 -$12,620,000 -$4,172,000 $5,038,300 $15,087,130 $26,058,343 $38,044,177 $51,146,095 $65,475,705 $81,155,775
Discount Rate 22% 22% 22% 22% 22% 22% 22% 22% 22% 22% 22%
Discounted Cash Flow -$27,500,000 $5,840,164 $5,210,293 $4,652,372 $4,157,521 $3,718,060 $3,327,328 $2,979,542 $2,669,662 $2,393,293 $2,146,593
Payback Periods- Part 2 3.45
Net Present Values- Part 3 $9,594,827
Profitability Index-Part 4 1.35
Wodonga Site: Capital Budgeting Analysis
Years
14ACCOUNTING AND FINANCE
Appendix 1B
If cost of vacant office space is considered
Particulars 0 1 2 3 4 5 6 7 8 9 10
Initial Investment:
Construction on Manufacturing Unit -$27,500,000
Vacant office space -$6,000,000
Total Initial Investment -$33,500,000
Operational Cash Flow:
Sales Growth Rate 10% 10% 10% 10% 10% 10% 10% 10% 10%
Margin After conversion Rate 30% 30% 30% 30% 30% 30% 30% 30% 30% 30%
Annual Sales $30,000,000 $33,000,000 $36,300,000 $39,930,000 $43,923,000 $48,315,300 $53,146,830 $58,461,513 $64,307,664 $70,738,431
Conversion Cost -$21,000,000 -$23,100,000 -$25,410,000 -$27,951,000 -$30,746,100 -$33,820,710 -$37,202,781 -$40,923,059 -$45,015,365 -$49,516,902
Depreciation on Plant & Equipment -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000
Depreciation on Building -$240,000 -$240,000 -$240,000 -$240,000 -$240,000 -$240,000 -$240,000 -$240,000 -$240,000 -$240,000
Net Profit before Tax $6,010,000 $6,910,000 $7,900,000 $8,989,000 $10,186,900 $11,504,590 $12,954,049 $14,548,454 $16,302,299 $18,231,529
Less: Income Tax @ 30% -$1,803,000 -$2,073,000 -$2,370,000 -$2,696,700 -$3,056,070 -$3,451,377 -$3,886,215 -$4,364,536 -$4,890,690 -$5,469,459
Net Profit after Tax $4,207,000 $4,837,000 $5,530,000 $6,292,300 $7,130,830 $8,053,213 $9,067,834 $10,183,918 $11,411,610 $12,762,070
Add: Depreciation on Plant $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000
Add: Depreciation on Building $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000
After-Tax Cash Flows-Part 1 $7,197,000 $7,827,000 $8,520,000 $9,282,300 $10,120,830 $11,043,213 $12,057,834 $13,173,918 $14,401,610 $15,752,070
Net Cash Flow -$33,500,000 $7,197,000 $7,827,000 $8,520,000 $9,282,300 $10,120,830 $11,043,213 $12,057,834 $13,173,918 $14,401,610 $15,752,070
Cumulative Cash Flow -$33,500,000 -$26,303,000 -$18,476,000 -$9,956,000 -$673,700 $9,447,130 $20,490,343 $32,548,177 $45,722,095 $60,123,705 $75,875,775
Discount Rate 22% 22% 22% 22% 22% 22% 22% 22% 22% 22% 22%
Discounted Cash Flow -$33,500,000 $5,899,180 $5,258,667 $4,692,023 $4,190,022 $3,744,700 $3,349,164 $2,997,440 $2,684,332 $2,405,318 $2,156,450
Payback Periods- Part 2 4.073
Net Present Values- Part 3 $3,877,296
Profitability Index-Part 4 1.116
Years
Wodonga Site: Capital Budgeting Analysis
Appendix 1B
If cost of vacant office space is considered
Particulars 0 1 2 3 4 5 6 7 8 9 10
Initial Investment:
Construction on Manufacturing Unit -$27,500,000
Vacant office space -$6,000,000
Total Initial Investment -$33,500,000
Operational Cash Flow:
Sales Growth Rate 10% 10% 10% 10% 10% 10% 10% 10% 10%
Margin After conversion Rate 30% 30% 30% 30% 30% 30% 30% 30% 30% 30%
Annual Sales $30,000,000 $33,000,000 $36,300,000 $39,930,000 $43,923,000 $48,315,300 $53,146,830 $58,461,513 $64,307,664 $70,738,431
Conversion Cost -$21,000,000 -$23,100,000 -$25,410,000 -$27,951,000 -$30,746,100 -$33,820,710 -$37,202,781 -$40,923,059 -$45,015,365 -$49,516,902
Depreciation on Plant & Equipment -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000 -$2,750,000
Depreciation on Building -$240,000 -$240,000 -$240,000 -$240,000 -$240,000 -$240,000 -$240,000 -$240,000 -$240,000 -$240,000
Net Profit before Tax $6,010,000 $6,910,000 $7,900,000 $8,989,000 $10,186,900 $11,504,590 $12,954,049 $14,548,454 $16,302,299 $18,231,529
Less: Income Tax @ 30% -$1,803,000 -$2,073,000 -$2,370,000 -$2,696,700 -$3,056,070 -$3,451,377 -$3,886,215 -$4,364,536 -$4,890,690 -$5,469,459
Net Profit after Tax $4,207,000 $4,837,000 $5,530,000 $6,292,300 $7,130,830 $8,053,213 $9,067,834 $10,183,918 $11,411,610 $12,762,070
Add: Depreciation on Plant $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000 $2,750,000
Add: Depreciation on Building $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000 $240,000
After-Tax Cash Flows-Part 1 $7,197,000 $7,827,000 $8,520,000 $9,282,300 $10,120,830 $11,043,213 $12,057,834 $13,173,918 $14,401,610 $15,752,070
Net Cash Flow -$33,500,000 $7,197,000 $7,827,000 $8,520,000 $9,282,300 $10,120,830 $11,043,213 $12,057,834 $13,173,918 $14,401,610 $15,752,070
Cumulative Cash Flow -$33,500,000 -$26,303,000 -$18,476,000 -$9,956,000 -$673,700 $9,447,130 $20,490,343 $32,548,177 $45,722,095 $60,123,705 $75,875,775
Discount Rate 22% 22% 22% 22% 22% 22% 22% 22% 22% 22% 22%
Discounted Cash Flow -$33,500,000 $5,899,180 $5,258,667 $4,692,023 $4,190,022 $3,744,700 $3,349,164 $2,997,440 $2,684,332 $2,405,318 $2,156,450
Payback Periods- Part 2 4.073
Net Present Values- Part 3 $3,877,296
Profitability Index-Part 4 1.116
Years
Wodonga Site: Capital Budgeting Analysis
15ACCOUNTING AND FINANCE
Appendix 2
2i -Capital Structure of the firm ARB corporations limited
WACC
CAPM
Calculation of Expected Cost of equity via CAPM:
Particulars Amount
Beta (Reuters) 0.89
Market Return (RM) (Capital Return) 8.54%
Risk Free Rate (RF) 2.78%
Expected Cost of Equity (RE) 7.906%
WACC of the firm over the years
Particulars 2017 2016 2015 2014
('000s) ('000s) ('000s) ('000s)
Net profit after Tax (PAT) $49,152 $47,439 $44,093 $42,570
Total Equity $272,341 $249,608 $226,348 $197,814
Cost of Equity 18.05% 19.01% 19.48% 21.52%
Weightage of Equity 100.00% 100.00% 99.12% 100.00%
Interest Expenses for borrowings 0 0 220 0
Secured Borrowings $0 $0 $2,000 $0
Cost of Debt 0% 0% 11.00% 0%
Weightage of Debt (Financial leverage) 0% 0% 1% 0%
Given Tax Rate 30% 30% 30% 30%
Weighted Average Cost of Capital (WACC) 18.05% 19.01% 19.39% 21.52%
Appendix 2
2i -Capital Structure of the firm ARB corporations limited
WACC
CAPM
Calculation of Expected Cost of equity via CAPM:
Particulars Amount
Beta (Reuters) 0.89
Market Return (RM) (Capital Return) 8.54%
Risk Free Rate (RF) 2.78%
Expected Cost of Equity (RE) 7.906%
WACC of the firm over the years
Particulars 2017 2016 2015 2014
('000s) ('000s) ('000s) ('000s)
Net profit after Tax (PAT) $49,152 $47,439 $44,093 $42,570
Total Equity $272,341 $249,608 $226,348 $197,814
Cost of Equity 18.05% 19.01% 19.48% 21.52%
Weightage of Equity 100.00% 100.00% 99.12% 100.00%
Interest Expenses for borrowings 0 0 220 0
Secured Borrowings $0 $0 $2,000 $0
Cost of Debt 0% 0% 11.00% 0%
Weightage of Debt (Financial leverage) 0% 0% 1% 0%
Given Tax Rate 30% 30% 30% 30%
Weighted Average Cost of Capital (WACC) 18.05% 19.01% 19.39% 21.52%
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
16ACCOUNTING AND FINANCE
Appendix 2ii Capital Structure Comparison
Part 2ii
Particulars Amount Weightage Amount Weightage
('000s) (millions)
Total Equity $272,341 100% $2,977.00 81%
Short Term Debt $607.0
Long Term Debt $73.0
Total Borrowings $0 0% $680.00 19%
Total Capital $272,341 100% $3,657 100%
Comparing ARB with Bell Equipment Ltd
ARB Be ll Equipment
Appendix 2iii- Financial Ratios
Part 2-iii-Financial Ratios
Particulars 2017 2016 2014 2015
Total Assets 323243 291808 269869 241764
Trade Receivables 50840 44425 42216 39762
Trade Payables 35279 27754 28874 30202
Cost of Goods Sold 173600 161857 149646 131764
Sales Revenue 382599 356905 329755 297779
Receivables Turnover Ratio 7.53 8.03 7.81 7.49
PayableTurnover Ratio 4.92 5.83 5.18 4.36
Asset Turnover Ratio 1.18 1.22 1.22 1.23
Efficiency Ratios
Particulars 2017 2016 2014 2015
Total Revenue 382599 356905 329755 297779
Net Profit 49152 47439 44093 42570
Total equity 272341 249608 226348 197814
Net Profit Margin 0.13 0.13 0.13 0.14
Return on Equity (ROE) 0.18 0.19 0.19 0.22
Profitability Ratios
Particulars 2017 2016 2014 2015
Total Equity 272341 249608 226348 197814
Total Debt 50902 42200 43521 43950
Current Assets 169177 148466 133820 150620
Current Liabilities 49785 40944 42544 43230
Current Ratio 3.40 3.63 3.15 3.48
Debt-to-Equity Ratio 0.19 0.17 0.19 0.22
Solvency Ratios
Calculation
Appendix 2ii Capital Structure Comparison
Part 2ii
Particulars Amount Weightage Amount Weightage
('000s) (millions)
Total Equity $272,341 100% $2,977.00 81%
Short Term Debt $607.0
Long Term Debt $73.0
Total Borrowings $0 0% $680.00 19%
Total Capital $272,341 100% $3,657 100%
Comparing ARB with Bell Equipment Ltd
ARB Be ll Equipment
Appendix 2iii- Financial Ratios
Part 2-iii-Financial Ratios
Particulars 2017 2016 2014 2015
Total Assets 323243 291808 269869 241764
Trade Receivables 50840 44425 42216 39762
Trade Payables 35279 27754 28874 30202
Cost of Goods Sold 173600 161857 149646 131764
Sales Revenue 382599 356905 329755 297779
Receivables Turnover Ratio 7.53 8.03 7.81 7.49
PayableTurnover Ratio 4.92 5.83 5.18 4.36
Asset Turnover Ratio 1.18 1.22 1.22 1.23
Efficiency Ratios
Particulars 2017 2016 2014 2015
Total Revenue 382599 356905 329755 297779
Net Profit 49152 47439 44093 42570
Total equity 272341 249608 226348 197814
Net Profit Margin 0.13 0.13 0.13 0.14
Return on Equity (ROE) 0.18 0.19 0.19 0.22
Profitability Ratios
Particulars 2017 2016 2014 2015
Total Equity 272341 249608 226348 197814
Total Debt 50902 42200 43521 43950
Current Assets 169177 148466 133820 150620
Current Liabilities 49785 40944 42544 43230
Current Ratio 3.40 3.63 3.15 3.48
Debt-to-Equity Ratio 0.19 0.17 0.19 0.22
Solvency Ratios
Calculation
17ACCOUNTING AND FINANCE
Appendix 2iv) Capital structure changes of the firm
Part 2 iv
Particulars Amount Weightage of equity and debt Amount Weightage of equity and debt Amount Weightage of equity and debt Amount Weightage
('000s) ('000s) ('000s) ('000s)
Total Equity $272,341 100% $249,608 100% $226,348 99% $197,814 100%
Secured Borrowings $0 0% $0 0% $2,000 1% $0 0%
Total Capital $272,341 100% $249,608 100% $228,348 100% $197,814 100%
Percentage change in Total Capital 9.11% 9.31% 15.44%
Significant Change s in Capital Structure
2017 2016 2015 2014
Appendix 2v) Shareholder’s wealth
Part 2-v
2017 2016 2015 2014
Particulars Amount Amount Amount Amount
('000s) ('000s) ('000s) ('000s)
Net profit after Tax (PAT) $49,152 $47,439 $44,313 $42,570
Total Capital Employed $272,341 $249,608 $228,348 $197,814
Weighted Average Cost of Capital (WACC) 18.05% 19.01% 19.39% 21.52%
Total Capital Cost $49,152 $47,439 $44,269 $42,570
Economic Value Added $0 $0 $44 $0
Maximimizing Wealth of the shareholder
Appendix 2iv) Capital structure changes of the firm
Part 2 iv
Particulars Amount Weightage of equity and debt Amount Weightage of equity and debt Amount Weightage of equity and debt Amount Weightage
('000s) ('000s) ('000s) ('000s)
Total Equity $272,341 100% $249,608 100% $226,348 99% $197,814 100%
Secured Borrowings $0 0% $0 0% $2,000 1% $0 0%
Total Capital $272,341 100% $249,608 100% $228,348 100% $197,814 100%
Percentage change in Total Capital 9.11% 9.31% 15.44%
Significant Change s in Capital Structure
2017 2016 2015 2014
Appendix 2v) Shareholder’s wealth
Part 2-v
2017 2016 2015 2014
Particulars Amount Amount Amount Amount
('000s) ('000s) ('000s) ('000s)
Net profit after Tax (PAT) $49,152 $47,439 $44,313 $42,570
Total Capital Employed $272,341 $249,608 $228,348 $197,814
Weighted Average Cost of Capital (WACC) 18.05% 19.01% 19.39% 21.52%
Total Capital Cost $49,152 $47,439 $44,269 $42,570
Economic Value Added $0 $0 $44 $0
Maximimizing Wealth of the shareholder
18ACCOUNTING AND FINANCE
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
19ACCOUNTING AND FINANCE
1 out of 20
Related Documents
Your All-in-One AI-Powered Toolkit for Academic Success.
 +13062052269
info@desklib.com
Available 24*7 on WhatsApp / Email
Unlock your academic potential
© 2024  |  Zucol Services PVT LTD  |  All rights reserved.