Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFS) during the next 3 years, after which FCF is expected to grow at a constant7% rate. Dantzler's WACC is 14%.Year0123FCF (Smillions)- $17$30$50The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.XOpen spreadsheeta. What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Round your answer to two decimal places. Enter youranswer in millions. For example, an answer of $13,550,000 should be entered as 13.55.Smillionb. What is the firm's value today? Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55. Do not roundyour intermediate calculations.Smillionc. Suppose Dantzler has $92 million of debt and 19 million shares of stock outstanding. What is your estimate of the current price per share? Round your answer to two decimal places. Writeout your answer completely. For example, 0.00025 million should be entered as 250.

Here,FCF of Year 1 is -$17FCF of Year 2 is $30FCF of Year 3 is $50Growth Rate is 7%WACC is 14%

Answered: Dantzler Corporation is a fast-growing…

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

Price Mart is considering outsourcing its billing operations. A consultant estimates that outsourcing should result in cash savings of $9,500 the first year, $15.500 for the next two years, and $18,500 for the next two years. Interest is at 10%. Assume cash flows occur at the end of the year. Required: Calculate the total present value of the cash flows. Note: Use tables, Excel, or a financial calculator. Do not round intermediate calculations. Round your final answer to nearest whole dollar. (FV of $1. PV of $1. FVA of $1. PVA of $1, EVAD of $1 and PVAD of $1) Total present value of the cash flows
Nakamichi Bancorp has made an investment in banking software at a cost of $1,655,438. Management expects productivity gains and cost savings over the next several years. If, as a result of this investment, the firm is expected to generate additional cash flows of $629,533, $794,591, $485,013, and $369,752 over the next four years, what is the investment’s payback period? (Round answer to 2 decimal places, e.g. 15.25.) Payback period is __________years
Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFs) during the next 3 years, after which FCF is expected to grow at a constant 5% rate. Dantzler's WACC is 13%. Year 0 1 2 3 ....... ....... ....... ....... ....... ....... ....... ....... FCF ($ millions) ....... ....... ....... ....... ....... ....... ....... ...... - $9 $19 $49 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Round your answer to two decimal places. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55. $ fill in the blank 2 million What is the firm's value today? Round your answer to two decimal places. Enter your answer…
Dantzler Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFs) during the next 3 years, after which FCF is expected to grow at a constant 5% rate. Dantzler's WACC is 12%. Year 0 1 2 3 ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ....... ...... FCF ($ millions) - $22 $19 $52 What is Dantzler's horizon, or continuing, value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55. Do not round intermediate calculations. Round your answer to two decimal places.$ million What is the firm's market value today? Assume that Dantzler has zero nonoperating assets. Enter your answer in millions. For example, an answer of $13,550,000 should be entered as 13.55. Do not round intermediate calculations. Round your answer to two…
Your company is planning to purchase a new log splitter for its lawn and garden business. The new splitter has an initial investment of $312,000. It is expected to generate $40,000 of annual cash flows, provide incremental cash revenues of $165,488, and incur incremental cash expenses of $80,000 annually. What is the payback period and accounting rate of return (ARR)? Round your answers to 1 decimal place. Payback period fill in the blank 1 years ARR fill in the blank 2%
Below are four cases that you will have to solve using Excel spreadsheets. 2nd case The COMPETIDORA SA company has the possibility of investing in three different projects . The projections show us the following information on which a decision must be made: PROJECT X Y Initial Z$310,000 It is requested: investment $180,000 $250,000 Year 1 cash flows $50,000 $80,000 $150,000 1. Determine the internal rate of return. 2. Determine the present value. Year 2 cash flows 3. Determine the recovery period. 4. Define which is the most viable project. $70,000 $80,000 $120,000 The discount rate for the project will be 9% and the investors propose a MARR of 22%. Year 3 cash flows $80,000 $80,000 $100,000 Year 4 cash flows $100,000 $80,000
After analysing the financial data of Q-Constructions, you notice that they are trending in the right direction. A new 12-month construction proposal has come to the company worth $1,000,000 and an important question is whether it will be financially viable. They want you to analyse the proposal, in particular, the recommended cash flow schedule and to understand the key financial points during the construction project. The following cash flow schedule is summarised below. To ensure that all upfront and on-going outlay costs are covered in advance, Q-Constructions incur an initial start-up cost of $200,000. The proposal states that they will receive a deposit from the client of 10% of the total project price at the beginning. They then receive four equal instalment payments of 20% of the total project price associated to project milestones from the client at the end of the 2nd, 6th, 8th and 10th month. Finally, they receive the last 10% project milestone on lock-up which occurs at the…
You must type in both the answer and all of your work to receive credit. Use the financial statements and additional data provided by management to calculate the firm's Free Cash Flow for the projected year. • Tax rate = 25% • Plans for the projected year will require $500 of new machinery and equipment • Firm expects next year's dividend to be $260 Acme Products, Inc. Balance Sheets ASSETS Cash Receivables Inventory Property, plant & equipment Total assets LIABILITIES & EQUITY Accounts payables Accrued expenses Long-term debt Common stock Paid-in Capital Retained earnings Total liabilities and equity current yr 400 600 900 2,200 4,100 500 400 1,400 600 200 1,000 4,100 projected yr 500 750 1,125 2,750 Acme Products, Inc. Income Statement Operating expenses 5,125 Depreciation 5,125 Sales (all credit) Cost of Goods Sold Gross Profit Operating income Interest expense 625 Taxable income 500 Taxes (25%) 1,750 Net income 750 250 1,250 projected yr 7,000 4,000 3,000 1,400 400 1,200 100 1,100…
ARCI Instruments manufactures a ventilation controller designed for monitoring and controlling carbon monoxide in parking garages, boiler rooms, tunnels, etc. The net cash flow associated with one phase of the operation is shown on the next page. (a) How many possible rate of returnvalues are there for this cash flow series? (b) Find all the rate of return values between 0 and 100% using tabulated factors and a spreadsheet.
WorldTrans Industries is planning its operations for next year. The CEO, wants you to forecast the firm's additional funds needed (AFN). Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Dollars are in millions. Last year's sales = S0 $350 Last yr's accounts payable $40 Sales growth rate = g 30% Last yr's notes payable $50 Last year's total assets = A0* $460 Last yr's accruals $30 Last year's prof margin = PM 5% Target payout ratio 60% Group of answer choices $87.4 $120.8 $90.6 $124.1 $107.9
Your company is planning to purchase a new log splitter for its lawn and garden business. The new splitter has an initial investment of $320,000. It is expected to generate $40,000 of annual cash flows, provide incremental cash revenues of $215,760, and incur incremental cash expenses of $130,000 annually. What is the payback period and accounting rate of return (ARR)? Round your answers to 1 decimal place. Payback period years ARR %
Please solve parts A, B, AND C!

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