- Questions & Answers
- Accounting
- Computer Science
- Automata or Computationing
- Computer Architecture
- Computer Graphics and Multimedia Applications
- Computer Network Security
- Data Structures
- Database Management System
- Design and Analysis of Algorithms
- Information Technology
- Linux Environment
- Networking
- Operating System
- Software Engineering
- Big Data
- Android
- iOS
- Matlab

- Economics
- Engineering
- Finance
- Thesis
- Management
- Science/Math
- Statistics
- Writing
- Dissertations
- Essays
- Programming
- Healthcare
- Law

- Log in | Sign up

all work must be done in excel showing all calculations

Instructions Please complete the following: · Problem P13-1 · Problem P13-15 · Problem P13-21 · Problem P14-8 · Problem P14-14 Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems. There are several assigned problems where the solution will require graphing. This will require using the graphing function in Excel. · If you submit your answer without an Excel graph points will be deducted. · If you submit your answer by drawing a graph even if it is correct, points will be deducted. Remember to show all calculations. You must show your calculation and solution. please see the example below. If you do not show how you arrived at your answers, you will not receive credit. Merely showing the formula without the calculations is not sufficient. The problems should be set up in columns or using other appropriate formats—do not hide all steps in formulas behind one answer. I must still be able to see how you arrived at the answer. EXAMPLE OF HOW WORK SHOULD LOOK Please see below Example (please be sure to show the formula in answers and calculations) · Problem P13-1 EPS calculations and degree of financial leverage: Northwestern Savings and Loan has a current capital structure consisting of $250,000 of 16% annual interest debt and 2,000 shares of common stock. The firm pays taxes at the rate of 21%. a. Using EBIT values of $80,000 and $12,000, determine the associated earnings per share (EPS). b. Using $80,000 of EBIT as a base, calculate the degree of financial leverage (DFL). c. Rework parts a and b, assuming that the firm has $100,000 of 16% (annual interest) debt and 3,000 shares of common stock. · Problem P13-15 Modigliani & Miller Proposition: A certain firm with no debt that operates in perfect capital markets generates a 7.5% return for its shareholders and can issue debt at a cost of 5%. Determine the firm’s ROE at the following debt-to- equity ratios o.5, 1.0, and 1.5. · Problem P13-21 Agency Cost and Capital Structure: Galaxy Enterprises has earnings before interest and taxes of $9 million and $90 million of debt outstanding with a required rate of return of 7.3%. The required rate of return on assets in the industry is 12%. The corporate tax rate is 21%, but there are no personal taxes. The present value of Galaxy’s bankruptcy cost is $18 million. Compute Galaxy’s firm value. · Problem P14-8 Dividend Constraints: A firm has $800,000 in paid-in capital, retained earnings of $40,000 (including the current year’s earnings), and 25,000 shares of common stock outstanding, In current year, it has $29,000 of earnings. 1. What is the most the firm can pay in cash dividends to each common stockholder? ( Assume that legal capital includes all paid-in-capital.) 2. How would an $0.80/share dividend affects the firm’s balance sheet? 3. If the firm cannot rise new external funds, what do you consider the key constraints with respect to the magnitude of the firm’s dividend payment? why? · Problem P14-14 Stock dividend: Investor: Sarah owns 400 shares of Nutri-Foods. The firm has 40,000 shares outstanding. The firm most recently had earnings available for common stockholders of $80,000,and it’s stock has been selling for $22 per share. The firm intends to retain its earnings and pay a 10% stock dividend 1. How much does the firm currently earn per share? 2. What proportion of the firm does Sarah currently own? 3. What proportion of the firm will Sarah own after the stock dividend? Explain 4. What should be the stock price after the stock dividend ? 5. Discuss what effect, if any, the payment of stock dividends will have on Sarah’s share ownership and earnings of Nurti-Foods.

Instructions Please complete the following: · Problem P13-1 · Problem P13-15 · Problem P13-21 · Problem P14-8 · Problem P14-14 Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems. There are several assigned problems where the solution will require graphing. This will require using the graphing function in Excel. · If you submit your answer without an Excel graph points will be deducted. · If you submit your answer by drawing a graph even if it is correct, points will be deducted. Remember to show all calculations. You must show your calculation and solution. please see the example below. If you do not show how you arrived at your answers, you will not receive credit. Merely showing the formula without the calculations is not sufficient. The problems should be set up in columns or using other appropriate formats—do not hide all steps in formulas behind one answer. I must still be able to see how you arrived at the answer. EXAMPLE OF HOW WORK SHOULD LOOK Please see below Example (please be sure to show the formula in answers and calculations) · Problem P13-1 EPS calculations and degree of financial leverage: Northwestern Savings and Loan has a current capital structure consisting of $250,000 of 16% annual interest debt and 2,000 shares of common stock. The firm pays taxes at the rate of 21%. a. Using EBIT values of $80,000 and $12,000, determine the associated earnings per share (EPS). b. Using $80,000 of EBIT as a base, calculate the degree of financial leverage (DFL). c. Rework parts a and b, assuming that the firm has $100,000 of 16% (annual interest) debt and 3,000 shares of common stock. · Problem P13-15 Modigliani & Miller Proposition: A certain firm with no debt that operates in perfect capital markets generates a 7.5% return for its shareholders and can issue debt at a cost of 5%. Determine the firm’s ROE at the following debt-to- equity ratios o.5, 1.0, and 1.5. · Problem P13-21 Agency Cost and Capital Structure: Galaxy Enterprises has earnings before interest and taxes of $9 million and $90 million of debt outstanding with a required rate of return of 7.3%. The required rate of return on assets in the industry is 12%. The corporate tax rate is 21%, but there are no personal taxes. The present value of Galaxy’s bankruptcy cost is $18 million. Compute Galaxy’s firm value. · Problem P14-8 Dividend Constraints: A firm has $800,000 in paid-in capital, retained earnings of $40,000 (including the current year’s earnings), and 25,000 shares of common stock outstanding, In current year, it has $29,000 of earnings. 1. What is the most the firm can pay in cash dividends to each common stockholder? ( Assume that legal capital includes all paid-in-capital.) 2. How would an $0.80/share dividend affects the firm’s balance sheet? 3. If the firm cannot rise new external funds, what do you consider the key constraints with respect to the magnitude of the firm’s dividend payment? why? · Problem P14-14 Stock dividend: Investor: Sarah owns 400 shares of Nutri-Foods. The firm has 40,000 shares outstanding. The firm most recently had earnings available for common stockholders of $80,000,and it’s stock has been selling for $22 per share. The firm intends to retain its earnings and pay a 10% stock dividend 1. How much does the firm currently earn per share? 2. What proportion of the firm does Sarah currently own? 3. What proportion of the firm will Sarah own after the stock dividend? Explain 4. What should be the stock price after the stock dividend ? 5. Discuss what effect, if any, the payment of stock dividends will have on Sarah’s share ownership and earnings of Nurti-Foods.

Answered 1 days AfterFeb 12, 2024

Part A:

Particular Case 1 Case 2

EBIT $80,000.00 $12,000.00

Less: Interest $40,000.00

EBT $40,000.00 ($28,000.00)

Less: Tax @21% $8,400.00 ($5,880.00)

PAT $31,600.00 ($22,120.00)

No. of Shares 2,000.00 2,000.00

EPS $15.80 ($11.06)

Part B:

Particular Case 1

EBIT $80,000.00

Less: Interest $40,000.00

EBT $40,000.00

Degree of Financial Leverage 2.00

Part C:

Particular Case 1 Case 2

EBIT $80,000.00 $12,000.00

Less: Interest $16,000.00 $16,000.00

EBT $64,000.00 ($4,000.00)

Less: Tax @21% $13,440.00 ($840.00)

PAT $50,560.00 ($3,160.00)

No. of...

SOLUTION.PDF## Answer To This Question Is Available To Download

- InstructionsPlease complete the following:· Problem P17-4· Problem P17-9· Problem P18-1· Problem P18-15· Problem P19-1Carry all calculations to TWO decimal places to reduce rounding...SolvedFeb 25, 2024
- InstructionsPlease complete the following:· Problem P15-1· Problem P15-4· Problem P15-13· Problem P16-2· Case - Kanton CompanyCarry all calculations to TWO decimal places to reduce...SolvedFeb 15, 2024
- InstructionsPlease complete the following · Problem P10-24· Problem P10-28· Problem P11-11· Problem P11-16· Problem P12-12· Problem P12-20· Problem P12-28Carry all calculations to...SolvedFeb 07, 2024
- InstructionsPlease complete the following:· Problem P8-18· Problem P8-28· Problem P9-5· Problem P9-15· Integrative Case 4 - Enviro Plastics CompanyGeneral Instructions for...SolvedFeb 05, 2024
- InstructionsPlease complete the following:· Problem P6-9· Problem P6-17· Problem P6-31· Problem P7-20· Problem P7-23Carry all calculations to TWO decimal places to reduce rounding error,...SolvedFeb 02, 2024
- InstructionsPlease complete the following:Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems.Remember to show all calculations. You must...SolvedJan 30, 2024
- CASE STUDY ON EXCEL MUST SHOW WORK AND CALCULATIONSJan 30, 2024
- Assignment Notes: Carry all calculations to TWO decimal places to reduce rounding error, especially in multi-step problems.Remember to show all calculations.General Instructions for Written...SolvedJan 26, 2024
- ALL WORK MUST BE DONE ON EXCEL SPREEDSHEETS PLEASE USE SEPERATE SHEET FOR EACH PROBLEM P1-4Marginal cost-benefit analysis and the goal of the firm Monsanto Corporation is considering the...SolvedJan 20, 2024
- The initialperiod 4dialoguepost has two parts. To complete the first part of your post, read the attached Upstate NY Real Estate .pdffileandindicate your leasing decision. Cite specific ratios and...SolvedApr 27, 2023

Copy and Paste Your Assignment Here

Copyright © 2024. All rights reserved.