Triple D Corporation is all equity financed with total assets valued at $1 million, which are...

Transcribed Image Text:

Triple D Corporation is all equity financed with total assets valued at $1 million, which are assumed constant. The corporation's ordinary shares are valued at $25 each, and the firm is in the 40 percent tax bracket. The corporation wishes to analyze five possible capital structures-0, 15, 30, 45, and 60 percent debt-equity ratios. Exhibit 1 shows the additional data which have been gathered for use in analyzing the five capital structures under consideration. Exhibit 1: Triple D Corporation's alternative capital structures Capital structure Interest rate on debt debt-equity ratio 0% 15 30 45 60 The company's income statements for the previous three years are indicated in Exhibit 2. The balance Sheets for the same period are shown in Exhibit 3. Exhibit 2 Sales (all on credit). Cost of goods sold.. 0.0% 8.0 10.0 13.0 17.0 Operating profit.. Interest expense. Gross profit.. Selling and administrative expense. Net income before taxes. Taxes. Net Income.. Shares.. TRIPLE D CORPORATION Income Statements 2017 $1,500,000 950,000 550,000 380,000 170,000 30,000 140,000 46,120 $93,880 40,000 2018 $1,800,000 1,120,000 680,000 490,000 190,000 40,000 150,000 48,720 $101,280 40,000 2019 $2,160,000 1,300,000 860,000 590.000 270,000 85,000 185,000 64,850 $120,150 46,000 Exhibit 3 Assets Cash.. Marketable securities. Accounts receivable. Inventory.... Total Current Assets. Net Plant and equipment. Total Assets.. Liabilities & Equity Accounts payable. Notes payable (bank). Total Current liabilities.. Long-term liabilities. Total liabilities... Triple D CORPORATION Balance Sheets Common stock ($10 par). Capital paid in excess of par. Retained earnings..... Total stockholders' equity.. Total liabilities and stockholders' equity. 2017 $20,000 30,000 150,000 250,000 2018 $30,000 35,000 450,000 580,000 550,000 720,000 $1,000,000 $1,300,000 200,000 250,000 450,000 230,000 285,000 400,000 50,000 100,000 2019 $20,000 50,000 330,000 325,000 $100,000 $225,000 $200,000 100,000 100,000 300,000 325,000 500,000 331,120 550,740 656,120 1,050,740 400,000 460,000 50,000 80,000 193,880 303,260 550,000 643,880 843,260 $1,000,000 $1,300,000 $1,894,000 725,000 1,169,000 $1,894,000 The actual sales and purchases for Triple D Corporation for September and October 2019, along with its forecast sales and purchases for the period November 2019 through April 2020 are as follows. The actual sales and purchases for Triple D Corporation for September and October 2019, along with its forecast sales and purchases for the period November 2019 through April 2020 are as follows. Exhibit 4: Triple D corporation's Projected sales and purchases Year Sales Month September 2019 $210,000 2019 October 250,000 2019 170,000 2019 160,000 2020 140,000 2020 2020 2020 November December January February March April 180,000 200,000 250,000 2 Purchases $120,000 150,000 140,000 100,000 80,000 110,000 100,000 90,000 The firm makes 20 percent of all sales for cash and collects on 40 percent of its sales in each of the two months following the sale. Other cash inflows are expected to be $12,000 in September and April, $15,000 in January and March, and $27,000 in February. The firm pays cash for 10 percent of its purchases. It pays for 50 percent of its purchases in the following month and for 40 percent of its purchases two months later. Wages and salaries amount to 20 percent of the preceding month's sales. Rent of $20,000 per month must be paid. Interest payments of $10,000 are due in January and April. A principal payment of $30,000 is also due in April. The firm expects to pay cash dividends of $20,000 in January and April. Taxes of $80,000 are due in April. The firm also intends to make a $25,000 cash purchase of fixed assets in December. Triple D Corporation is considering to bring out one of two games this season. The Signs Away game has a higher initial cost but also a higher expected return. Monopolistic Competition, the alternative, has a slightly lower initial cost but also lower expected return. The present values and probabilities associated with each game are listed in Exhibit 5: Exhibit 5: Triple D Corporation's investment choices Game Initial Investment Sign Away $140,000 Monopolistic Competition $120,000 Present value of Probabilities cash inflows $320,000 220,000 -80,000 $260,000 200,000 -50,000 1.00 0.30 0.50 0.20 1.00 0.20 0.45 0.35 Required: Question 1 (25 marks) (a) Calculate the amount of debt, the amount of equity, and the number of outstanding shares for each of the capital structures being considered. (5 marks) (b) Calculate the annual interest on debt under each of the capital structures being considered. (5 marks) (c) Calculate the earnings per share (EPS) associated with $150,000 and $250,000 of EBIT for each of the five capital structures. (5 marks) (d) Calculate the level of EBIT at the point of indifference. (3 marks) (e) Calculate the earnings per share for each of the capital structures. (5 marks) 3 (f) Calculate the dividend payout ratio for each of the capital structures being considered. (2 marks) Question 2 (25 marks) (a) Calculate the net profit margin ratio for each year. (b) Calculate the asset turnover ratio for each year. (3 marks) (c) Calculate the equity multiplier ratio for each year. (3 marks) (d) Using your answers to (a)-(c), explain the factors which influenced the return of equity between 2017 and 2019. (6 marks) (e) Construct the common size Balance Sheet for Adams Corporation for 2017 through 2019. (6 marks) (f) Prepare Indexed Balance Sheet for Adams Corporation with 2019 as the base year. (4 marks) 3 marks) Question 3 (30 marks) (a) Determine the total cash receipts for each moth, November through April. (9 marks) (b) Determine the total cash payments for each moth, November through April. (9 marks) (c) Assuming that the firm has a cash balance of $22,000 at the beginning of November 2019, determine the end-of-month cash balances for each month, November through April. (9 marks) (d) Assuming that the firm wishes to maintain a $15,000 minimum cash balance, determine the monthly total financing requirements or excess cash balances. (3 marks) Question 4 (20 marks)[Exhibit 4] (a) What is the expected value NPV for each game? (4 marks) (b) What is the expected profitability index for each game? (4 marks) (c) What is the standard deviation for each alternative? (9 marks) (d) Which alternative will you choose? Explain your answer. (3 marks) Triple D Corporation is all equity financed with total assets valued at $1 million, which are assumed constant. The corporation's ordinary shares are valued at $25 each, and the firm is in the 40 percent tax bracket. The corporation wishes to analyze five possible capital structures-0, 15, 30, 45, and 60 percent debt-equity ratios. Exhibit 1 shows the additional data which have been gathered for use in analyzing the five capital structures under consideration. Exhibit 1: Triple D Corporation's alternative capital structures Capital structure Interest rate on debt debt-equity ratio 0% 15 30 45 60 The company's income statements for the previous three years are indicated in Exhibit 2. The balance Sheets for the same period are shown in Exhibit 3. Exhibit 2 Sales (all on credit). Cost of goods sold.. 0.0% 8.0 10.0 13.0 17.0 Operating profit.. Interest expense. Gross profit.. Selling and administrative expense. Net income before taxes. Taxes. Net Income.. Shares.. TRIPLE D CORPORATION Income Statements 2017 $1,500,000 950,000 550,000 380,000 170,000 30,000 140,000 46,120 $93,880 40,000 2018 $1,800,000 1,120,000 680,000 490,000 190,000 40,000 150,000 48,720 $101,280 40,000 2019 $2,160,000 1,300,000 860,000 590.000 270,000 85,000 185,000 64,850 $120,150 46,000 Exhibit 3 Assets Cash.. Marketable securities. Accounts receivable. Inventory.... Total Current Assets. Net Plant and equipment. Total Assets.. Liabilities & Equity Accounts payable. Notes payable (bank). Total Current liabilities.. Long-term liabilities. Total liabilities... Triple D CORPORATION Balance Sheets Common stock ($10 par). Capital paid in excess of par. Retained earnings..... Total stockholders' equity.. Total liabilities and stockholders' equity. 2017 $20,000 30,000 150,000 250,000 2018 $30,000 35,000 450,000 580,000 550,000 720,000 $1,000,000 $1,300,000 200,000 250,000 450,000 230,000 285,000 400,000 50,000 100,000 2019 $20,000 50,000 330,000 325,000 $100,000 $225,000 $200,000 100,000 100,000 300,000 325,000 500,000 331,120 550,740 656,120 1,050,740 400,000 460,000 50,000 80,000 193,880 303,260 550,000 643,880 843,260 $1,000,000 $1,300,000 $1,894,000 725,000 1,169,000 $1,894,000 The actual sales and purchases for Triple D Corporation for September and October 2019, along with its forecast sales and purchases for the period November 2019 through April 2020 are as follows. The actual sales and purchases for Triple D Corporation for September and October 2019, along with its forecast sales and purchases for the period November 2019 through April 2020 are as follows. Exhibit 4: Triple D corporation's Projected sales and purchases Year Sales Month September 2019 $210,000 2019 October 250,000 2019 170,000 2019 160,000 2020 140,000 2020 2020 2020 November December January February March April 180,000 200,000 250,000 2 Purchases $120,000 150,000 140,000 100,000 80,000 110,000 100,000 90,000 The firm makes 20 percent of all sales for cash and collects on 40 percent of its sales in each of the two months following the sale. Other cash inflows are expected to be $12,000 in September and April, $15,000 in January and March, and $27,000 in February. The firm pays cash for 10 percent of its purchases. It pays for 50 percent of its purchases in the following month and for 40 percent of its purchases two months later. Wages and salaries amount to 20 percent of the preceding month's sales. Rent of $20,000 per month must be paid. Interest payments of $10,000 are due in January and April. A principal payment of $30,000 is also due in April. The firm expects to pay cash dividends of $20,000 in January and April. Taxes of $80,000 are due in April. The firm also intends to make a $25,000 cash purchase of fixed assets in December. Triple D Corporation is considering to bring out one of two games this season. The Signs Away game has a higher initial cost but also a higher expected return. Monopolistic Competition, the alternative, has a slightly lower initial cost but also lower expected return. The present values and probabilities associated with each game are listed in Exhibit 5: Exhibit 5: Triple D Corporation's investment choices Game Initial Investment Sign Away $140,000 Monopolistic Competition $120,000 Present value of Probabilities cash inflows $320,000 220,000 -80,000 $260,000 200,000 -50,000 1.00 0.30 0.50 0.20 1.00 0.20 0.45 0.35 Required: Question 1 (25 marks) (a) Calculate the amount of debt, the amount of equity, and the number of outstanding shares for each of the capital structures being considered. (5 marks) (b) Calculate the annual interest on debt under each of the capital structures being considered. (5 marks) (c) Calculate the earnings per share (EPS) associated with $150,000 and $250,000 of EBIT for each of the five capital structures. (5 marks) (d) Calculate the level of EBIT at the point of indifference. (3 marks) (e) Calculate the earnings per share for each of the capital structures. (5 marks) 3 (f) Calculate the dividend payout ratio for each of the capital structures being considered. (2 marks) Question 2 (25 marks) (a) Calculate the net profit margin ratio for each year. (b) Calculate the asset turnover ratio for each year. (3 marks) (c) Calculate the equity multiplier ratio for each year. (3 marks) (d) Using your answers to (a)-(c), explain the factors which influenced the return of equity between 2017 and 2019. (6 marks) (e) Construct the common size Balance Sheet for Adams Corporation for 2017 through 2019. (6 marks) (f) Prepare Indexed Balance Sheet for Adams Corporation with 2019 as the base year. (4 marks) 3 marks) Question 3 (30 marks) (a) Determine the total cash receipts for each moth, November through April. (9 marks) (b) Determine the total cash payments for each moth, November through April. (9 marks) (c) Assuming that the firm has a cash balance of $22,000 at the beginning of November 2019, determine the end-of-month cash balances for each month, November through April. (9 marks) (d) Assuming that the firm wishes to maintain a $15,000 minimum cash balance, determine the monthly total financing requirements or excess cash balances. (3 marks) Question 4 (20 marks)[Exhibit 4] (a) What is the expected value NPV for each game? (4 marks) (b) What is the expected profitability index for each game? (4 marks) (c) What is the standard deviation for each alternative? (9 marks) (d) Which alternative will you choose? Explain your answer. (3 marks)

Answer rating: 100% (QA)

Question no 1 a Calculation of amount of debt equity and no of shares outstanding for each alternative capital structure Alternative Amount of debt Amount of equity No of shares outstanding If Debt eq... View the full answer