Computer-Related ProblemThe problem requires you to use File C03 on the computer problem spreadsheet. DictionPublishing estimates that it needs $500,000 to support its expected growth. The underwritingfees charged by the investment banking firm for which you work are 6.5% for such issue sizes.In addition, it is estimated that Diction will incur $4,900 in other expenses related to the IPO.If your analysis indicates that Diction's stock can be sold for $40 per share,how many shares must be issued to net the company the $500,000 it needs?b. Suppose that Diction's investment banker charges 10% rather than 6.5%.Assuming that all other information given earlier is the same, how manyshares must Diction issue in this situation to net the company the $500,000a.it needs?Suppose that Diction's investment banker charges 8.2% rather than 6.5%.Assuming that all other information given earlier is the same, how many sharesmust Diction issue in this situation to net the company the $500,000 it needs?d. Suppose everything is the same as originally presented, except Diction willincur $5,835 in other expenses rather than $4,900. In this situation, howmany shares must Diction issue to net the company the $500,000 it needs?Now suppose that Diction decides it only needs $450,000 to support itsgrowth. In this case, its investment banker charges 7% flotation costs, andDiction will incur only $3,840 in other expense. How many shares must Dic-tion issue to net the company the $450,000 it needs?C₁e.f.Suppose the scenario presented in part (e) exists, except the price of Diction'sstock is $32 per share. How many shares must Diction issue to net the com-pany the $450,000 it needs?

As per the honor code of Bartleby we are bound to give the answer of first three sub part, please…

Answered: The problem requires you to use File…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Hi, I am working on this problem. Can you please show a step-by-step solution without using excel? Innovation company is thinking about marketing a new software product. Upfront costs to market and develop the product are $5 million. The product is expected to generate profits of $1 million per year for 10 years; following that, the company will have to provie support costs expected to be $100,000 a year in perpetuity. What is the NPV if the cost of capital is 6%?
Prepare the financial section of a business case for the Cloud-Computing Case that is listed above this assignment in Canvas. Assume that this project will take eight months to complete (in Year 0) and will cost $600,000. The costs to implement some of the technologies will be $300,000 for year one and $200,000 for years two and three. Estimated benefits will start in year 1 at$400,000 and will be $600,000 for years 2 and 3. There is no benefit in year 0. Use the business case spreadsheet template (business_case_financials.xls) template provided below this assignment in Canvas to calculate the NPV, ROI, and the year in which payback occurs. Assume a 7 percent discount rate for the template. notes* Payback occurs in the first year that there is a positive value for cumulative benefits - costs. (*Negative values are presented in parenthesis) Financial Analysis for Project Name Created by: Date: Note: Change the inputs, shown in green below (i.e. interest rate, number of…
Prepare the financial section of a business case for the Cloud-Computing Case that is listed above this assignment in Canvas. Assume that this project will take eight months to complete (in Year 0) and will cost $600,000. The costs to implement some of the technologies will be $300,000 for year one and $200,000 for years two and three. Estimated benefits will start in year 1 at $400,000 and will be $600,000 for years 2 and 3. There is no benefit in year 0. Use the business case spreadsheet template (business_case_financials.xls) template provided below this assignment in Canvas to calculate the NPV, ROI, and the year in which payback occurs. Assume a 7 percent discount rate for the template. notes* Payback occurs in the first year that there is a positive value for cumulative benefits - costs. (*Negative values are presented in parenthesis) What I have so far is attached I need to make it so Pay back occurs in year 3 where there is positive cumulative benefits - costs.
1. Hassle-Free Web is bidding to provide web hosting services for Hotel Lisbon. Hotel Lisbon pays its current provider $10,200 per year for hosting its web page, handling transactions, etc. Hassle-Free figures that it will need to purchase equipment worth $15,200 up front and then spend $2,000 per year on monitoring, updates, and bandwidth to provide the service for 3 years. If Hassle-Free's cost of capital is 9.8%, can it bid less than $10,200 per year to provide the service and still increase its value by doing so? **round to the nearest dollar**
Cullumber Company is a private company with sales of $1,100,000 a year. Management wants to take the company public but has to wait until the sales reach $2,000,000. If sales are expected to grow 15 percent annually, when is the earliest that Cullumber will go public? (If you solve this problem with algebra round intermediate calculations to 4 decimal places, in all cases round your final answer to 1 decimal place, e.g. 5.4.) Excel Template(Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you’ve been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.)
Please include the excel formula Your firm is contemplating the purchase of a new $535,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $30,000 at the end of that time. You will save $165,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $60,000 (this is a one-time reduction). If the tax rate is 24 percent, what is the IRR for this project? Input area: Initial investment $535,000 Pretax salvage value $30,000 Cost savings per year $165,000 Working capital reduction $60,000 Tax rate 24% Project and asset life 5 Output area: Aftertax salvage value Sell equipment Taxes Aftertax cash flow Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Costs Depreciation EBT…
To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3000, and the average first-year commission for each new account opened is $5800. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account. Determine the equation for computing Gustin’s profit per seminar, given values of the relevant parameters. Round your answers to the nearest dollar.Profit = (New Accounts Opened × $( ) – $ ( ) What type of random variable is the number of new accounts opened? (Hint: Review Appendix 16.1 for descriptions of various types of probability distributions.)The number of new accounts opened is a random variable with fill in the blank 4 trials and fill in the blank 5 probability of a success on a single trial. Assume that the number of new accounts…
You are a manager at Percolated Fiber, which is considering expanding its operations in synthetic fiber manufacturing. Your boss comes into your office, drops a consultant's report on your desk, and complains, "We owe these consultants $ 1.1 million for this report, and I am not sure their analysis makes sense. Before we spend the $ 29 million on new equipment needed for this project, look it over and give me your opinion." You open the report and find the following estimates (in millions of dollars): Project Year Earnings Forecast ($ million) 1 2 . . . 9 10 Sales revenue 28.00028.000 28.00028.000 28.00028.000 28.00028.000 minus−Cost of goods sold 16.80016.800 16.80016.800 16.80016.800 16.80016.800 equals=Gross profit 11.20011.200 11.20011.200 11.20011.200 11.20011.200 minus−Selling, general, and administrative expenses 2.3202.320 2.3202.320 2.3202.320 2.3202.320…
To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3000, and the average first-year commission for each new account opened is $4600. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account. Determine the equation for computing Gustin’s profit per seminar, given values of the relevant parameters. Round your answers to the nearest dollar.Profit = (New Accounts Opened × $ fill in the blank 1) – $ fill in the blank 2 What type of random variable is the number of new accounts opened? (Hint: Review Appendix 16.1 for descriptions of various types of probability distributions.)The number of new accounts opened is a random variable with fill in the blank 4 trials and fill in the blank 5 probability of a success on a single trial. Assume that the…
Important: EXCEL Spreadsheet Must be Used for this Problem. Per your request, Table 14-1 is included as an attachment. The Hurricane Lamp Company forecasts that next year’s sales will be $6 million. Fixed operating costs are estimated to be $800,000, and the variable cost ratio (that is, variable costs as a fraction of sales) is estimated to be 0.75. The firm has a $600,000 loan at 10 percent interest. It has 20,000 shares of $3 preferred stock and 60,000 shares of common stock outstanding. Hurricane Lamp is in the 40 percent corporate income tax bracket. a) Forecast Hurricane Lamp’s earnings per share (EPS) for next year. Develop a complete income statement using the revised format illustrated in Table 14.1. Then determine what Hurricane Lamp’s EPS would be if sales were 10 percent above the projected $6 million level. Answer: EPS (Sales = $6 million) = $5.40 b) Calculate Hurricane Lamp’s degree of operating leverage (DOL) at a sales level of $6 million using the following: The…
The Howe Computer Company has grown rapidly during thepast 5 years. Recently, its commercial bank urged the company to consider increasing itspermanent financing. Its bank loan under a line of credit has risen to $150,000, carrying a10% interest rate, and Howe has been 30 to 60 days late in paying trade creditors. Discussions with an investment banker have resulted in the decision to raise $250,000at this time. Investment bankers have assured Howe that the following alternatives arefeasible (flotation costs will be ignored):Alternative 1: Sell common stock at $10 per share.Alternative 2: Sell convertible bonds at a 10% coupon, convertible into 80 shares ofcommon stock for each $1,000 bond (i.e., the conversion price is $12.50 per share).Alternative 3: Sell debentures with a 10% coupon; each $1,000 bond will have 80 warrantsto buy 1 share of common stock at $12.50.Keith Howe, the president, owns 80% of Howe’s common stock and wants to maintain controlof the company; 50,000 shares are…
Harris Inc. is a book publisher that is considering developing an e-reader. The project requires 270 ($ thousand) in capital expenditures upfront. The production will continue for two years, and the FCFs in years 1 and 2 are 150 and 170 (in $ thousand). The tax rate is 50%. The asset cost of capital for the book publishing industry is 8%. Harris’s cost of debt is 6%. Turbo Inc. is a public firm that sells e-readers. It has a debt-to-value ratio 1/2. Its equity cost of capital is 22% and its debt cost of capital is 4%. (a) What is the NPV of the project if it is entirely financed with equity (in $ thousand)?(Round to two decimal places.) (b) What is the NPV of the project if Harris maintains a fixed D/E ratio of 1/1 and finances the project with this D/E ratio (in $ thousand)?(Round to two decimal places.)

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS