In your internship with Lewis, Lee, & Taylor Inc. you have been asked to forecast the firm's additional funds needed (AFN)for next year. The firm is operating at full capacity. Data for use in your forecast are shown below. Based on the AFNequation, what is the AFN for the coming year?Last year's sales = SoSales growth rate = gLast year's total assets =Ao*Last year's profit margin=PM-$14,440B -$15,200Ⓒ-$16,000D-$16,800$200,00040%$135,00020.0%Last year's accountspayableLast year's notes payableLast year's accrualsTarget payout ratio$50,000$15,000$20,00025.0%

AFN is the amount of external finance required to maintain the growth in sales next year that may be…

Answered: In your internship with Lewis, Lee, &…

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

XYZ Corporation is considering a capital budgeting project and requires a detailed analysis. The company has provided youwith the following financial information and ratios:Return on Investment (ROI): 15%Payback Period: 3 yearsNet Present Value (NPV): R50,000Internal Rate of Return (IRR): 12%Cash Flows:Year 1: R20 000Year 2: R30 000Year 3: R40 0001.4 Calculate the ARR for XYZ Corporation. Assume depreciation is calculated on the straight-linemethod and that the project has a scrap value of R5000
Daniel Sawyer, the CEO of the Sawyer Group, is initiating planning for the company's operations next year, and he wants you to forecast the firm's additional funds needed (AFN). The firm is operating at full capacity. 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 year's accounts payable $40 Sales growth rate = g 30% Last year's notes payable $50 Last year's total assets = A0* $320 Last year's accruals $30 Last year's profit margin = PM 5% Target payout ratio 60% Select the correct answer. a. $69.3 b. $72.7 c. $62.5 d. $65.9 e. $76.1
Hi there, I am working on this problem, how do i solve it without using excel? CCM ltd. has a budget of $32 million dollars to spend on these investments (the table attached). Choose the best combination of investments using the profitability index. The cost of capital is 6%. Cash flow from investments are all per year in perpetuity.
The pictures is the formula and example. Compute the additional funds needed. JHOPE "I am your hope" Company has 10% net profit margin on sales in previous years and expects to maintain the same next year. The Business is expected to increase its sales level from P1,000,000 to P1 255 000. The percentages of current sales and current liabilities that have direct relationship with sales are 60% and 35%, respectively. Out of the total earnings at are expected to be realized next year, 25% will be retumed to the shareholders in the form of dividends. Compute the following: 5. Projected increase in current assets 6. Spontaneous increase in current liabilities 7. Increase in retained earings 8. Additional fund needed.
In your internship with Lewis, Lee, & Taylor Inc. you have been asked to forecast the firm's additional funds needed (AFN) for next year. The firm is operating at full capacity. Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Last year's sales = S0 $200,000 Last year's accounts payable $50,000 Sales growth rate = g 40% Last year's notes payable $15,000 Last year's total assets = A0* $125,000 Last year's accruals $20,000 Last year's profit margin = PM 20.0% Target payout ratio 25.0% Select the correct answer. a. - $20,040 b. - $19,960 c. - $20,060 d. - $20,020 e. - $20,000
Revenues generated by a new fad product are forecast as follows: Year Revenues 1 $50,000 2 35,000 3 30,000 4 20,000 Thereafter 0 Expenses are expected to be 40% of revenues, and working capital required in each year is expected to be 20% of revenues in the following year. The product requires an immediate investment of $60,000 in plant and equipment. a. What is the initial investment in the product? Remember working capital. b. If the plant and equipment are depreciated over 4 years to a salvage value of zero using straight-line depreciation, and the firm’s tax rate is 20%, what are the project cash flows in each year? Assume the plant and equipment are worthless at the end of 4 years. c. If the opportunity cost of capital is 10%, what is the project's NPV? d. What is the project IRR?
Towson Industries is considering an investment of $256,950 that is expected to generate returns of $90,000 per year for each of the next four years. Using the IRR formula in the textbook and the Appendix B PV FV Tables.pdf download, what is the present value factor for this investment? Given the answer above, what is the investment’s internal rate of return? and Use the appropriate EXCEL spreadsheet in the Chapter11 TVOM Examples.xlsx downloadto prove your answer above: Using the appropriate EXCEL spreadsheet, the answer = PLEASE NOTE: All PV Factors will be rounded to three decimal places (i.e. 1.234). Round your IRR answers, in percentage format, to one decimal place (i.e. 12.3%).
Rachel the chief financial officer of sunrise fruit snakcs, needed to determine the compnays projected cost of capital for next year, to do so , wshe needed to know the following infomraiont expect a) the proejcted equity level for next year b) the projected intereset rate on next years debt The projected debt level for next year D0 the projected cash balance for next year
In your internship with Lewis, Lee, & Taylor Inc. you have been asked to forecast the firm's additional funds needed (AFN) for next year. The firm is operating at full capacity. Data for use in your forecast are shown below. Based on the AFN equation, what is the AFN for the coming year? Last year's sales = S0 $200,000 Last year's accounts payable $50,000 Sales growth rate = g 40% Last year's notes payable $15,000 Last year's total assets = A0* $135,000 Last year's accruals $20,000 Last year's profit margin = PM 20.0% Target payout ratio 25.0% Select the correct answer. a. - $15,940 b. - $16,000 c. - $16,060 d. - $16,030 e. - $16,090
A firm is considering a new inventory system that will cost $120,000. The system is expected to generate positive cash flows over the next four years in the amounts of $35,000 in year 1, $55,000 in year 2, $65,000 in year 3, and $40,000 in year 4. The firm’s required rate of return is 9%. What is the payback period of this project? 1.95 years 2.46 years 2.99 years 3.10 years Based on the information from Question 47. What is the net present value (NPV) of the project? $28,830.29 $30,929.26 $36,931.43 $39,905.28 Based on the information from Question 47, what is the internal rate of return (IRR) of this project? 14.03% 17.56% 19.26% 21.78% Based on the information from Question 47, what is the profitability index (PI) of this project? 0.87 1.11 1.31 1.83.
A. Assume that you have completed your plans and proformas for the next year of operations. The upcoming year looks promising. What would you most likely do from the following list? a. From your proformas project your company’s weighted average cost of capital and return on assets, and compare the two b. Take a vacation because you have been working so hard c. Purchase a new house for your personal use because the future is looking so good d. Make sure that your company’s weighted average cost of capital exceeds your company’s return on assets, if not, rework your plans and proformas B. Assume that all sales are on account. If the average accounts receivable balance was $1,000,000 and accounts receivable turnover was 12 for the last year of operations, what was sales revenue? a. $10,000,000 b. $15,000,000 c. $12,000,000 d. $6,000,000

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