- 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

I NEED MY WORK DONE ON EXCEL

ALL WORK MUST BE DONE ON EXCEL SPREEDSHEETS PLEASE USE SEPERATE SHEET FOR EACH PROBLEM P1-4 Marginal cost-benefit analysis and the goal of the firm Monsanto Corporation is considering the replacement of some of its older and outdated carpet manufacturing equipment. Its objective is to improve the efficiency of operations in terms of both speed and reduction in the number of defects. The company’s finance department has compiled pertinent data to conduct a marginal cost-benefit analysis for the proposed equipment replacement. The cash outlay for new equipment would be $600,000. The net salvage value of the old equipment is $250,000. The total benefits over the life of the new equipment (measured in today's dollars) would be $900,00. The sum of benefits from the remaining life of the old equipment (measured in today’s dollars) would be $300,000. a. What are the marginal benefits of the proposed equipment replacement? b. What is the marginal cost of the proposed equipment replacement? c. What is the net benefit of the proposed equipment replacement? d. What would you recommend the firm do? Why? P1-8 Marginal tax rates Using tax rate schedule given in Table 1.2, perform the following a. Find the marginal tax rate for the following levels of sole proprietorship earnings before taxes $15,000; $60,000; $90,000; $150,000: $250,000: $450,000; and $1 million. b. Plot the marginal tax rates (measured on the y-axis). Explain the relationship between these variables P1-12 Interest versus dividend expense MIcheals Corporation expects earnings before interest and taxes to be $50,000 for the current period. Using the flat corporate tax rate of 21%, compute the firm earnings after taxes and earnings available for common stockholders (earnings after taxes and preferred stock dividends, if any) under the following conditions: a. The firm pays $12,000 in interest. b. The firm pays $12,000 in preferred stock dividends. P2-3 Initial public offering On April 18, 2019, the video conferencing company, zoom completed its IPO on the NASDAQ. Zoom sold 9.911,434 shares of Class A stock with one vote per share at an offer price of $36 and an underwriter discount of $1.80 per share. Zoom's closing stock price on the first day of trading on the secondary market was $62, and 24,070,086 Class A shares were outstanding. There were also 232,318,285 shares of Class B common stock with 10 votes each outstanding and held privately by Zoom insiders. a. Calculate the total proceeds for zooms IPO b. Calculate the total percentage underwriter discount c. Calculate the dollar amount of the underwriting fee for Zoom IPO d. Calculate the Zoom IPO underpricing e. Calculate the net proceeds from Zoom IPO underpricing f. Calculate Zooms market capitalization assuming that market value per share is the same for both classes of stock g. What percentage of zooms total common stock Class A plus Class B do Class A stockholders own after the IPO? What percentage of votes do they control?

ALL WORK MUST BE DONE ON EXCEL SPREEDSHEETS PLEASE USE SEPERATE SHEET FOR EACH PROBLEM P1-4 Marginal cost-benefit analysis and the goal of the firm Monsanto Corporation is considering the replacement of some of its older and outdated carpet manufacturing equipment. Its objective is to improve the efficiency of operations in terms of both speed and reduction in the number of defects. The company’s finance department has compiled pertinent data to conduct a marginal cost-benefit analysis for the proposed equipment replacement. The cash outlay for new equipment would be $600,000. The net salvage value of the old equipment is $250,000. The total benefits over the life of the new equipment (measured in today's dollars) would be $900,00. The sum of benefits from the remaining life of the old equipment (measured in today’s dollars) would be $300,000. a. What are the marginal benefits of the proposed equipment replacement? b. What is the marginal cost of the proposed equipment replacement? c. What is the net benefit of the proposed equipment replacement? d. What would you recommend the firm do? Why? P1-8 Marginal tax rates Using tax rate schedule given in Table 1.2, perform the following a. Find the marginal tax rate for the following levels of sole proprietorship earnings before taxes $15,000; $60,000; $90,000; $150,000: $250,000: $450,000; and $1 million. b. Plot the marginal tax rates (measured on the y-axis). Explain the relationship between these variables P1-12 Interest versus dividend expense MIcheals Corporation expects earnings before interest and taxes to be $50,000 for the current period. Using the flat corporate tax rate of 21%, compute the firm earnings after taxes and earnings available for common stockholders (earnings after taxes and preferred stock dividends, if any) under the following conditions: a. The firm pays $12,000 in interest. b. The firm pays $12,000 in preferred stock dividends. P2-3 Initial public offering On April 18, 2019, the video conferencing company, zoom completed its IPO on the NASDAQ. Zoom sold 9.911,434 shares of Class A stock with one vote per share at an offer price of $36 and an underwriter discount of $1.80 per share. Zoom's closing stock price on the first day of trading on the secondary market was $62, and 24,070,086 Class A shares were outstanding. There were also 232,318,285 shares of Class B common stock with 10 votes each outstanding and held privately by Zoom insiders. a. Calculate the total proceeds for zooms IPO b. Calculate the total percentage underwriter discount c. Calculate the dollar amount of the underwriting fee for Zoom IPO d. Calculate the Zoom IPO underpricing e. Calculate the net proceeds from Zoom IPO underpricing f. Calculate Zooms market capitalization assuming that market value per share is the same for both classes of stock g. What percentage of zooms total common stock Class A plus Class B do Class A stockholders own after the IPO? What percentage of votes do they control?

Answered 1 days AfterJan 20, 2024

a Marginal benefits Total benefits of new equipment 900,000

Less:- sum of benefits from

Marginal benefits 600,000

b Marginal costs Cash Outlay for New Equipment 600,000

Less: Net Salvage Value of Old Equipment 250,000

Marginal costs 350,000

c Net Benefit Marginal Benefits 600,000

Less: Marginal costs 350,000

Net Benefit 250,000

d Based on net marginal benefits it is recommended to replace old equipment.

P1-8

Earnings before taxes Taxes

15,000.00 1,602.50

60,000.00 8,990.00

90,000.00 15,679.50

150,000.00 30,079.50

250,000.00 62,295.00

450,000.00 132,295.00

1,000,000.00 334,427.00

Tax rate From...

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
- Instructions Please complete the following:· Problem P13-1· Problem P13-15· Problem P13-21· Problem P14-8· Problem P14-14Carry all calculations to TWO decimal places to reduce rounding...SolvedFeb 12, 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
- 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.