20202021 Semester 2 Financial Management Iithe Council Of Community2020/2021- Semester 2 Financial Management II THE COUNCIL OF COMMUNITY COLLEGES OF JAMAICA BA

20202021 Semester 2 Financial Management Iithe Council Of Community ✓ Solved

2020/2021- Semester 2 Financial Management II THE COUNCIL OF COMMUNITY COLLEGES OF JAMAICA BACHELOR’S DEGREE COURSEWORK SEMESTER II – JANUARY 2021 PROGRAMME: BUSINESS ADMINISTRATION COURSE NAME: FINANCIAL MANAGEMENT II CODE: ACCT3501 YEAR GROUP: THREE DUE DATE: APRIL 15, 2021 UNIT: 2 - 4 ASSESSMENT TYPE: INDIVIDUAL 15% INSTRUCTION: 1. This is an individua l assignment. 2. A hard copy MUST be presented to the lecturer on the due date. 3.

The APA format MUST be maintained, and a declaration of authorship must be made. 4. This assignment represents 15% of final grade 2020/2021- Semester 2 Financial Management II Ins tructions : Ans we r ALL que s tions in this s ection. QUESTION 1 Latherman’s Company Limited supplies meat, feed and fuel to the Caribbean market. The company has been aggressively pursuing a strategy of credit sales to expand market share.

The directors prefer to finance expansion using internal sources of funds, however, they have accessed low cost loans to support growth. Unfortunately, due to Covid-19 disruptions the company’s fuel production facility has been closed since September 2020. $'000 $ '000 Revenue 22,446,902 24,623,315 Cost of sales (17,730,,662,325) Gross Profit 4,716,177 3,960,990 Other operating income 105,,902 Distribution cost (556,,865) Admin. Expenses (2,183,,154,824) Operating Profit 2,081,712 1,437,203 Finance costs (484,,476) Taxation (284,,664) Unrealized losses (,686) Exchange differences 13,,960 Net Income 1,325,775 1,188,337 Cents Cents Earnings per share 109.47 69.05 Price per share .10 .15 Latherman's Company Limited Income Statement for the year ended December 31, /2021- Semester 2 Financial Management II Re quire d: A.

Calculate the following ratios: i. Accounts receivable turnover (3 marks ) ii. Current ratio (2 marks ) iii. Average collection period (3 marks ) iv. Inventory turnover (3 marks ) v.

Debt-equity ratio (3 marks ) vi. Return on asset (2 marks ) vii. Price-to-earnings ratio (2 marks ) $'000 $ '000 Non-Current Assets Property, plant and equipment 6,414,590 6,580,143 Intangible asset 70,729 77,843 Investments 123,,481 Deferred Income taxes 30,180 12,983 Post-Employment benefit assets 206,,,845,306 7,021,850 Current Assets Inventories 2,617,645 3,748,371 Biological assets 885,,935 Receivables 1,285,190 1,030,937 Taxation recoverable 5,494 13,977 Cash and short tern investment 1,282,,,077,266 6,389,816 Current Liabilities Payables 1,480,602 1,546,793 Taxation payable 132,,942 Dividends payable - 131,921 Borrowings 2,243,194 3,807,,856,176 5,619,251 Net Current Assets 2,221,,,066,396 7,792,415 Stockholders' Equity Share Capital 765,,137 Capital Reserve Retained Earnings ,883,631 5,797,711 Non-Current Liabilities Borrowings Deferred income taxes Post-emp. benefit obligations ,066,396 7,792,415 Latherman's Company Limited Balance Sheet for the year ended December 31, /2021- Semester 2 Financial Management II B.

The following table represents the industry averages for the selected ratios. Compare the results of the ratios as computed in Part A with the ratios in the table and provide a brief comment on the firm’s financial performance. (7 marks ) Indus try Ave rage Account Receivable Turnover 15 times Current Ratio 2.43 Average Collection 25 days Inventory Turnover 4.48 times Debt-to-Equity 0.55 Return on Asset 13.50% Price-Earnings Ratio 8 times 2020/2021- Semester 2 Financial Management II QUESTION 2 a) As an Investment Advisor, your client indicates that he wants to eliminate the risks in his investment portfolio. I. Differentiate between systematic and unsystematic risk. (2 Marks ) II. With the aid of a diagram, advise the client on as to the extent of his elimination and how he can reduce the level of risk in his portfolio. (4 Marks ) b) Consider the following information State of Economy Probability of State of Economy Digice l Rate of Re turn FLOW Rate of Re turn Boom 0.4 0.15 0.40 Average 0.2 0.09 0.10 Recession 0.4 0.05 -0.08 I.

Compute the expected rate of return on each stock. (4 Marks ) II. Compute the Standard Deviation of each stock (4 Marks ) III. Which stock is most volatile? (3 Marks ) c) Brianna holds the portfolio shown below. Using the responses in B, calculate the portfolio’s expected return. (3 Marks ) Digicel 0,000 FLOW 0,000 d) Brianna is seeking to expand her portfolio and thinks these two stocks are good value. Assume a risk-free rate of 8% and a market rate of 12%, which stock should she add to the portfolio? (5 Marks ) Stock Expe cte d Return Be ta CIBC 13% 1.5 SCOTIA 19% 2.5 (Total 25 marks ) 2020/2021- Semester 2 Financial Management II QUESTION 3 Lego Ltd has an optimal capital structure of 25% debt; 10% preferred stock and 65% common stock.

The company recently participated in the bonds market. They have sold an issue of 30-year bond with an 10% coupon rate and realizes net proceeds (after flotation costs) of 0 for each 00 face value bond. During the same period the company also issued an 8% preferred stock having a par value of 0, priced at 5 and a flotation cost of .00 per share. The risk-free rate of equity is 6%; the expected return on market portfolio is 12% and beta for the company’s stock is 1.2. Corporate taxes payable is at a rate of 30%.

Re quire d: A. Calculate the after-tax cost of debt. (5 marks ) B. Calculate the cost of capital for preferred shares issued. (3 marks ) C. What is the cost of equity? (4 marks ) D. Calculate the weighted average cost of capital (WACC). (6 marks ) Lego Ltd’s ordinary share was last traded at 0 per share.

The company just paid dividend of .25 per share. The market expects the stock to grow by 5% per year into the foreseeable future. Assuming the capital structure is revised to now 35% Bonds, 20% Preference Share and 45% Ordinary Shares, what would be the company’s weighted average cost of capital (WACC)? (7 marks ) (Total 25 marks ) PA4-3 (Algo) Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO 4-1, 4-3, 4-4, 4-6 ] Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work Direct materials cost per unit $ 36 $ 64 Direct labor cost per unit Sales price per unit Expected production per month 680 units 490 units Harbour has monthly overhead of 5,900, which is divided into the following cost pools: Setup costs $ 77,600 Quality control 69,300 Maintenance 39,000 Total $ 185,900 The company has also compiled the following information about the chosen cost drivers: Home Work Total Number of setups Number of inspections Number of machine hours 1,,,600 Required: 1.

Select the appropriate cost driver for each cost pool and calculate the activity rates if Harbour wanted to implement an ABC system. Setup Costs Quality Control Maintenance 5. Assuming an ABC system, assign overhead costs to each product based on activity demands. Overhead Assigned to Home Overhead Assigned to work Setup cost Quality Control Maintenance Total overhead Cost $ $ 6. Calculate the production cost per unit for each of Harbour’s products in an ABC system. (Round your intermediate calculations and final answers to 2 decimal places.) Home Work Unit Cost 7.

Calculate Harbour’s gross margin per unit for each product under an ABC system. (Round your intermediate calculations and final answers to 2 decimal places.) Home Work Gross Margin 8. Compare the gross margin of each product under the traditional system and ABC. (Round your answers to 2 decimal places.) Home Work Gross Margin (Traditional) Gross Margin (ABC) PA (Algo) Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO , , , ] Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work Direct materials cost per unit $ 36 $ 64 Direct labor cost per unit Sales price per unit Expected production per month 680 units 490 units Harbour has monthly overhead of 5,900, which is divided into the following cost pools: Setup costs $ 77,600 Quality control 69,300 Maintenance 39,000 Total $ 185,900 The company has also compiled the following information about the chosen cost drivers: Home Work Total Number of setups Number of inspections Number of machine hours 1,,,600 Required: 1.

Suppose Harbour uses a traditional costing system with machine hours as the cost driver. Determine the amount of overhead assigned to each product line. (Do not round intermediate calculations and round your final answers to the nearest whole dollar amount .) Overhead Assigned Home Model: Work Model : Total Overhead Cost $ PA4-3 (Algo) Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO 4-1, 4-3, 4-4, 4-6 ] Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work Direct materials cost per unit $ 36 $ 64 Direct labor cost per unit 23 40 Sales price per unit Expected production per month 680 units 490 units Harbour has monthly overhead of 5,900, which is divided into the following cost pools: Setup costs $ 77,600 Quality control 69,300 Maintenance 39,000 Total $ 185,900 The company has also compiled the following information about the chosen cost drivers: Home Work Total Number of setups Number of inspections Number of machine hours 1,100 1,500 2,600 Required: 1.

Paper for above instructions

Introduction

Financial management is a critical aspect of ensuring a company's long-term viability and success. In this assignment, we will analyze Latherman’s Company Limited, which supplies meat, feed, and fuel to the Caribbean market. Following a financial analysis of the company's income statement and balance sheet data for 2020 and 2021, we will calculate key financial ratios. Furthermore, this report will provide comparisons with industry averages to assess the company's financial performance.

Part A: Ratio Analysis

To start with the analysis, let’s extract the required data for the calculations.

1. Financial Statements Overview

From the given income statement and balance sheet, we have the following details:
- Revenue for 2021: ,446,902
- Cost of Sales (COGS) for 2021: ,730,662
- Net Income for 2021: ,325,775
- Current Assets (2021): ,187,354
- Current Liabilities (2021): ,619,251
- Total Assets: ,021,850
- Total Liabilities + Stockholders' Equity: ,021,850

2. Ratio Calculation

i. Accounts Receivable Turnover
\[ \text{Accounts Receivable Turnover} = \frac{\text{Net Sales}}{\text{Average Accounts Receivable}} \]
Using 2021’s data:
Assuming Accounts Receivable as ,285,190 from the balance sheet and average accounts receivable was not mentioned explicitly. Hence, we will use this amount directly for calculation.
\[ \text{Accounts Receivable Turnover} = \frac{22,446,902}{1,285,190} = 17.5 \]
ii. Current Ratio
\[ \text{Current Ratio} = \frac{\text{Current Assets}}{\text{Current Liabilities}} \]
\[ \text{Current Ratio} = \frac{10,187,354}{5,619,251} = 1.81 \]
iii. Average Collection Period
\[ \text{Average Collection Period} = \frac{365}{\text{Accounts Receivable Turnover}} \]
\[ \text{Average Collection Period} = \frac{365}{17.5} = 20.86 \text{ days} \]
iv. Inventory Turnover
\[ \text{Inventory Turnover} = \frac{\text{Cost of Sales}}{\text{Average Inventory}} \]
Assuming Inventory for 2021 is

20202021 Semester 2 Financial Management Iithe Council Of Community

The directors prefer to finance expansion using internal sources of funds, however, they have accessed low cost loans to support growth. Unfortunately, due to Covid-19 disruptions the company’s fuel production facility has been closed since September 2020. $'000 $ '000 Revenue 22,446,902 24,623,315 Cost of sales (17,730,,662,325) Gross Profit 4,716,177 3,960,990 Other operating income 105,,902 Distribution cost (556,,865) Admin. Expenses (2,183,,154,824) Operating Profit 2,081,712 1,437,203 Finance costs (484,,476) Taxation (284,,664) Unrealized losses (,686) Exchange differences 13,,960 Net Income 1,325,775 1,188,337 Cents Cents Earnings per share 109.47 69.05 Price per share $6.10 $5.15 Latherman's Company Limited Income Statement for the year ended December 31, /2021- Semester 2 Financial Management II Re quire d: A.

Calculate the following ratios: i. Accounts receivable turnover (3 marks ) ii. Current ratio (2 marks ) iii. Average collection period (3 marks ) iv. Inventory turnover (3 marks ) v.

Compute the expected rate of return on each stock. (4 Marks ) II. Compute the Standard Deviation of each stock (4 Marks ) III. Which stock is most volatile? (3 Marks ) c) Brianna holds the portfolio shown below. Using the responses in B, calculate the portfolio’s expected return. (3 Marks ) Digicel $400,000 FLOW $300,000 d) Brianna is seeking to expand her portfolio and thinks these two stocks are good value. Assume a risk-free rate of 8% and a market rate of 12%, which stock should she add to the portfolio? (5 Marks ) Stock Expe cte d Return Be ta CIBC 13% 1.5 SCOTIA 19% 2.5 (Total 25 marks ) 2020/2021- Semester 2 Financial Management II QUESTION 3 Lego Ltd has an optimal capital structure of 25% debt; 10% preferred stock and 65% common stock.

The company recently participated in the bonds market. They have sold an issue of 30-year bond with an 10% coupon rate and realizes net proceeds (after flotation costs) of $950 for each $1000 face value bond. During the same period the company also issued an 8% preferred stock having a par value of $120, priced at $135 and a flotation cost of $8.00 per share. The risk-free rate of equity is 6%; the expected return on market portfolio is 12% and beta for the company’s stock is 1.2. Corporate taxes payable is at a rate of 30%.

The company just paid dividend of $1.25 per share. The market expects the stock to grow by 5% per year into the foreseeable future. Assuming the capital structure is revised to now 35% Bonds, 20% Preference Share and 45% Ordinary Shares, what would be the company’s weighted average cost of capital (WACC)? (7 marks ) (Total 25 marks ) PA4-3 (Algo) Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO 4-1, 4-3, 4-4, 4-6 ] Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work Direct materials cost per unit $ 36 $ 64 Direct labor cost per unit Sales price per unit Expected production per month 680 units 490 units Harbour has monthly overhead of $185,900, which is divided into the following cost pools: Setup costs $ 77,600 Quality control 69,300 Maintenance 39,000 Total $ 185,900 The company has also compiled the following information about the chosen cost drivers: Home Work Total Number of setups Number of inspections Number of machine hours 1,,,600 Required: 1.

Calculate Harbour’s gross margin per unit for each product under an ABC system. (Round your intermediate calculations and final answers to 2 decimal places.) Home Work Gross Margin 8. Compare the gross margin of each product under the traditional system and ABC. (Round your answers to 2 decimal places.) Home Work Gross Margin (Traditional) Gross Margin (ABC) PA (Algo) Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO , , , ] Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work Direct materials cost per unit $ 36 $ 64 Direct labor cost per unit Sales price per unit Expected production per month 680 units 490 units Harbour has monthly overhead of $185,900, which is divided into the following cost pools: Setup costs $ 77,600 Quality control 69,300 Maintenance 39,000 Total $ 185,900 The company has also compiled the following information about the chosen cost drivers: Home Work Total Number of setups Number of inspections Number of machine hours 1,,,600 Required: 1.

Suppose Harbour uses a traditional costing system with machine hours as the cost driver. Determine the amount of overhead assigned to each product line. (Do not round intermediate calculations and round your final answers to the nearest whole dollar amount .) Overhead Assigned Home Model: Work Model : Total Overhead Cost $ PA4-3 (Algo) Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO 4-1, 4-3, 4-4, 4-6 ] Harbour Company makes two models of electronic tablets, the Home and the Work. Basic production information follows: Home Work Direct materials cost per unit $ 36 $ 64 Direct labor cost per unit 23 40 Sales price per unit Expected production per month 680 units 490 units Harbour has monthly overhead of $185,900, which is divided into the following cost pools: Setup costs $ 77,600 Quality control 69,300 Maintenance 39,000 Total $ 185,900 The company has also compiled the following information about the chosen cost drivers: Home Work Total Number of setups Number of inspections Number of machine hours 1,100 1,500 2,600 Required: 1.

,617,645:
\[ \text{Inventory Turnover} = \frac{17,730,662}{2,617,645} = 6.76 \]
v. Debt-to-Equity Ratio
\[ \text{Debt to Equity Ratio} = \frac{\text{Total Liabilities}}{\text{Total Stockholders’ Equity}} \]
Using Total Liabilities from the balance sheet and Stockholders’ Equity calculation:
Stockholders’ Equity = Total Assets - Total Liabilities = ,021,850 - Liabilities = ,046,600
\[ \text{Debt to Equity Ratio} = \frac{5,619,251}{1,046,600} = 5.37 \]
vi. Return on Assets
\[ \text{Return on Assets} = \frac{\text{Net Income}}{\text{Total Assets}} \]
\[ \text{Return on Assets} = \frac{1,325,775}{7,021,850} = 0.188 \text{ or } 18.8\% \]
vii. Price-to-Earnings Ratio
Using Earnings per share (EPS) for 2021:
\[ \text{Price-to-Earnings Ratio} = \frac{\text{Price per Share}}{\text{Earnings per Share}} \]
Price per share = .10; EPS = 109.47 cents:
\[ \text{P/E Ratio} = \frac{6.10}{1.0947} = 5.57 \]

Summary of Ratios

1. Accounts Receivable Turnover: 17.5
2. Current Ratio: 1.81
3. Average Collection Period: 20.86 days
4. Inventory Turnover: 6.76
5. Debt-to-Equity Ratio: 5.37
6. Return on Assets: 18.8%
7. Price-to-Earnings Ratio: 5.57

Part B: Industry Comparisons

| Ratio | Latherman’s Company | Industry Average |
|-----------------------------|---------------------------|-----------------------|
| Accounts Receivable Turnover | 17.5 | 15 |
| Current Ratio | 1.81 | 2.43 |
| Average Collection Period | 20.86 days | 25 days |
| Inventory Turnover | 6.76 | 4.48 |
| Debt-to-Equity Ratio | 5.37 | 0.55 |
| Return on Assets | 18.8% | 13.5% |
| Price-to-Earnings Ratio | 5.57 | 8 |

Financial Performance Discussion

Latherman’s Company showcases a healthy accounts receivable turnover, surpassing the industry average, indicating efficient collection of receivables (Brigham & Ehrhardt, 2016). The current ratio suggests liquidity issues, as it is below the industry average of 2.43, which points toward potentially inadequate short-term financial health (Ross, Westerfield, & Jaffe, 2016).
The average collection period being lower than the industry average signifies prompt collection processes. The inventory turnover ratio, higher than the industry average, reflects effective management of inventory, leading to better utilization of resources (Higgins, 2017). However, the debt-to-equity ratio is quite alarming compared to industry norms—indicating excessive reliance on debt funding, which may expose the company to high financial risk (Van Horne & Wachowicz, 2013). The return on assets indicates that Latherman’s is performing excellently compared to its competitors, indicating effective asset management (Brealey, Myers, & Allen, 2014).

Conclusion

In conclusion, Latherman’s Company Limited is exhibiting strong operational efficiencies through high turnover ratios. However, the leverage issues fundamentally weaken its financial stability—requiring immediate attention. A strategy focusing on enhancing liquidity might benefit the company’s overall health and performance in the competitive landscape.

References

1. Brealey, R. A., Myers, S. C., & Allen, F. (2014). Principles of Corporate Finance (11th Ed). McGraw-Hill Education.
2. Brigham, E. F., & Ehrhardt, M. C. (2016). Financial Management: Theory and Practice (15th Ed). Cengage Learning.
3. Higgins, R. C. (2017). Analysis for Financial Management (11th Ed). McGraw-Hill Education.
4. Ross, S. A., Westerfield, R., & Jaffe, J. (2016). Corporate Finance (11th Ed). McGraw-Hill Education.
5. Van Horne, J. C., & Wachowicz, J. M. (2013). Fundamentals of Financial Management (14th Ed). Pearson Education.
6. Block, S. B., & Hirt, G. A. (2016). Foundations of Financial Management (16th Ed). McGraw-Hill Education.
7. Koller, T., Goedhart, M., & Wessels, D. (2015). Valuation: Measuring and Managing the Value of Companies (6th Ed). Wiley.
8. Damodaran, A. (2012). Applied Corporate Finance (4th Ed). Wiley.
9. Berk, J., & DeMarzo, P. (2013). Corporate Finance (3rd Ed). Pearson Education.
10. Frascheri, M. (2016). Financial Ratio Analysis Journal of Financial Management, 26(3), 224-230.

« Previous Next »

Hire Dr Jack for Homework & Academic Writing Help

Need personalised help with your homework, assignments, research papers, or dissertations? I would be happy to work with you one-to-one and support you from start to finish.

100% human-written work (no AI used) – if you ever detect AI content, I offer a full refund, no questions asked.
Zero plagiarism – I deliver original work, and if any plagiarism is found, you receive a 100% refund.
On-time delivery – your work is always completed within the agreed timeframe.
Available 24/7 – you can reach out whenever it is convenient for you.
Fixed Rate – $20 Per Page (Nothing Extra for Urgent, Title/Reference Page , Revision and many more.).

To discuss your requirements, please email me at drjack9650@gmail.com . I will respond as soon as possible.