I need help with the finance problems below Complete the following problem sets in Financial Management using Microsoft Excel Chapter 10 17 Working capital and capital budgeting Farbucks Tea Shops is thinking about opening another tea shop The incremental cash flow for the first five years is as follows Initial capital cost $3,500,000 Operating cash flow for each year $1,000,000 Recovery of capital assets after five years $250,000 The hurdle rate for this project is 12 If the initial cost of working capital is $500,000 for items such as teapots, teacups, saucers, and napkins, should Farbucks open this new shop if it will be in business for only five years What is the most it can invest in working capital and still have a positive net present value 18 Working capital and capital budgeting Working capital investment is 25 of the anticipated first year sales for Wallys Waffle House The first year sales are currently projected at $4,300,000 The incremental cash flow (not including working capital investment) is Initial cash flow $13,700,000 outflow Cash flow years 1 through 10 $2,850,000 What is the internal rate of return of the ten year project with working capital factored into the cash flow What is the net present value at a 15 weighted average cost of capital What is the maximum investment in working capital for an acceptable project with a 15 weighted average cost of capital 9 Finding the WACC Monica is the CFO of Cooking for Friends (CFF) and uses the pecking order hypothesis philosophy when she raises capital for company projects Currently, she can borrow up to $600,000 from her bank at a rate of 8 5 , float a bond for $1,100,000 at a rate of 9 25 , or issue additional stock for $1,300,000 at a cost of 17 What is the WACC for CFF if Monica chooses to invest a $1,000,000 in new projects b $2,000,000 in new projects c $3,000,000 in new projects 10 Finding the WACC Chandler has been hired by Cooking for Friends to raise capital for the company Chandler increases the funding available from the bank to $900,000, but with a new rate of 8 75 Using the data in Problem 9, determine what the new WACC is for borrowing $1,000,000, $2,000,000, and $3,000,000

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 24, 2024

I need help with the finance problems below. Complete the following problem sets in Financial Management using Microsoft Excel: Chapter 10 17. Working capital and

I need help with the finance problems below.

Complete the following problem sets in Financial Management using Microsoft Excel:

Chapter 10

17. Working capital and capital budgeting. Farbucks Tea Shops is thinking about opening another tea shop. The incremental cash flow for the first five years is as follows:

Initial capital cost = $3,500,000 Operating cash flow for each year = $1,000,000 Recovery of capital assets after five years = $250,000

The hurdle rate for this project is 12%. If the initial cost of working capital is $500,000 for items such as teapots, teacups, saucers, and napkins, should Farbucks open this new shop if it will be in business for only five years? What is the most it can invest in working capital and still have a positive net present value?

18.Working capital and capital budgeting. Working capital investment is 25% of the anticipated first year sales for Wallys Waffle House. The first-year sales are currently projected at $4,300,000. The incremental cash flow (not including working capital investment) is

Initial cash flow = $13,700,000 outflow Cash flow years 1 through 10 = $2,850,000

What is the internal rate of return of the ten-year project with working capital factored into the cash flow? What is the net present value at a 15% weighted average cost of capital? What is the maximum investment in working capital for an acceptable project with a 15% weighted average cost of capital?

9. Finding the WACC. Monica is the CFO of Cooking for Friends (CFF) and uses the pecking order hypothesis philosophy when she raises capital for company projects. Currently, she can borrow up to $600,000 from her bank at a rate of 8.5%, float a bond for $1,100,000 at a rate of 9.25%, or issue additional stock for $1,300,000 at a cost of 17%. What is the WACC for CFF if Monica chooses to invest

a.$1,000,000 in new projects?
b.$2,000,000 in new projects?
c.$3,000,000 in new projects?

10. Finding the WACC. Chandler has been hired by Cooking for Friends to raise capital for the company. Chandler increases the funding available from the bank to $900,000, but with a new rate of 8.75%. Using the data in Problem 9, determine what the new WACC is for borrowing $1,000,000, $2,000,000, and $3,000,000.