use the following information to develop a spreadsheet model that will calculate the free cash flows and

Fantastic news! We've Found the answer you've been seeking!

Question:

use the following information to develop a spreadsheet model that will calculate the free cash flows and the value of the equity for the company.

cost of capital 12%

most recent year's sales $1000

nonoperating assets $100

interest-bearing debt $250

operating profit margin 12%

working capital/sales 35%

fixed assets/sales 20%

noninterest-bearing

current liabilities/sales 10%

rax rate 40%

forecasted sales growth

years 1-2 12%

years 3-5 8%

years 6-∞ 4%

calculate the value of the firm and the value of the equity in the firm using DCF analysis.

Related Book For answer-question

Principles of managerial finance

ISBN: 978-0132479547

12th edition

Authors: Lawrence J Gitman, Chad J Zutter

See More Books

Posted Date: Jun 22, 2022 09:59 AM

See More Questions

Use the following information to answer the questions: Assets Liabilities and Equity Cash 10,000 Accounts payable 17,000 Marketable securities 2,000 Notes payable 6,000 Accounts receivable 3,000...
Use the following information to complete Keith and Jennifer Hamilton's 2015 federal income tax return. If information is missing, use reasonable assumptions to fill in the gaps. Form 1040,...
1. Calculate current ratio and acid test ratio for the firm. 2. Calculate DSO, fixed assets turnover, and total asset turnover for the firm. 3. Calculate liabilities-to-assets ratio and...
Assume you have just been hired as a business manager of PizzaPalace, a regional pizza restaurant chain. The companys EBIT was $120 million last year and is not expected to grow. PizzaPalace is in...
From the auditors point of view, inventory counts are more acceptable prior to the year- end when a. Internal control is weak. b. Accurate perpetual inventory records are maintained. c. Inventory is...
Australia is land abundant, and India is labor abundant. Wheat is land intensive relative to textiles. Graphically demonstrate the pre trade and post trade equilibria between these two countries....
Why are proof test plans needed?
A pharmaceutical company produces the drug NasaMist from four chemicals. Today, the company must produce 1000 pounds of the drug. The three active ingredients in NasaMist are A, B, and C. By weight,...
Use the trapezoidal rule, the midpoint rule, and Simpson's rule to approximate the given integral with the specified value of n. (Round your answers to six decimal places.) 5 cos(3x) dx, n = 4 (a)...
Each compound in List 1 has a matching description in List 2. Correctly match the partners. There is only one correct statement for each compound. List 1 CaCl BeO Be(OH)2 Cao CaF2 List 2 BaCl, BeCl...
Brooklyn is going to finance new office equipment at a 1% rate over a 2.5 year term. If she can afford monthly payments of $125, how much can she pay for the new office equipment? Round your answer...
The Chernobyl reactor accident in what is now Ukraine was the worst nuclear disaster of all time. Fission products from the reactor core spread over a wide area. The primary radiation exposure to...
The regression curve of daily quantity demanded of tablet computers in a Midwestern market, measured in thousands of units and expressed as a function of price, all else held equal, is given by...
The quark compositions of the proton and neutron are, respectively, uud and udd, where $\mathrm{u}$ is an up quark (charge $+\frac{2}{3} e$ ) and $\mathrm{d}$ is a down quark (charge...
The decay chain of uranium includes radon, a noble gas. When uranium in the soil decays to radon, it may seep into houses; this can be a significant source of radiation exposure. Most of the exposure...
A $75 \mathrm{~kg}$ patient swallows a $30 \mu \mathrm{Ci}$ beta emitter with a half life of 5.0 days, and the radioactive nuclei are quickly distributed throughout his body. The beta particles...
Discuss Australian practices of equal opportunity and social inclusion in detail?
4. Jobe dy -Y 2 et by
a. Use the historical and projected financial data provided to prepare a pro forma income statement for the year ended December 31, 2010. (Use the percent- of-sales method to estimate all values...
Without referring to the preprogrammed function on your financial calculator or to tables, use the basic formula for present value, along with the given opportunity cost, i, and the number of...
a. Determine the total annual cost of each of the three possible financing strategies. b. Assuming that the firm expects its current assets to total $4 million throughout the year determine the...
Consider a process with the following streams: When $\Delta T_{\text {min }}=10^{\circ} \mathrm{C}$, the minimum utilities for heating and cooling are $237 \mathrm{~kW}$ and $145 \mathrm{~kW}$,...
Figure 11.64 presents the PFD of a process for the production of organic fibers (Smith, 2005). In the process, the organic solvent is removed from the fibers in dryer D-100 using circulated warmed...
Consider a process with the following streams: (a) Determine MER targets for $\Delta T_{\text {min }}=10^{\circ} \mathrm{C}$. (b) Design a HEN for MER using no more than 10 heat exchangers...

use the following information to develop a spreadsheet model that will calculate the free cash flows and

Question:

Expert Answer:

Solution Year n Sales yoy growth rate Operating profit Working Capital Current Liabilities Net worki... View the full answer

Principles of managerial finance

Students also viewed these accounting questions