Calculate the relevant cash flows (for each year) for the following capital budgeting proposal Enter the total net cash flows for each year in the box below according to the provided format $90,000 initial cost for machinery depreciated straight line over 4 years to a book value of $10,000 35 marginal tax rate $55,000 additional annual revenues $25,000 additional annual cash expense annual expense for debt financing is $7,500 $3,500 previously spent for engineering study The project requires inventory increase by $32,000 and accounts payable increase by $14,000 at the beginning of the project The investment in working capital occurs one time at the beginning of the project and it requires working capital return to the original level when the project ends in 4 years 11 cost of capital life of the project is 4 years and The new equipment will be sold at the end of 4 years expected market value of the new equipment at the end of 4 years is $15,000 For full credit please copy and paste any Excel tables you used to arrive at your answer Clearly label each year's cash flow ( Year 0 CF , Year 1 CF , Year 2 CF , Year 3 CF , Year 4 CF ) at the top of the answer box Please format your final answer to the nearest $,X Paste all Excel tables and work below the final answers HTML EditorKeyboard Shortcuts Font Sizes Paragraph p Flag this QuestionQuestion 285pts You are analyzing a capital budgeting project and, as shown by , some numbers are unreadable You can read the following information Cash Flows at the end of Year 0 $25,000 Year 1 $8,000 Year 2 $ 6,000 Year 3 $ 2,600 Year 4 $ Year 5 $ 9,500 The Cost of Capital is 13 , the NPV $5,650 01 and the IRR Your superior, ignoring the important fact that we should reject the project, is demanding to know the Cash Flow in Year 4 Calculate the cash flow in Year 4 (format as $XX XX) For full credit please copy and paste any Excel tables you used to arrive at your answer

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 25, 2024

Calculate the relevant cash flows (for each year) for the following capital budgeting proposal. Enter the total net cash flows for each year in the

Calculate the relevant cash flows (for each year)for the following capital budgeting proposal. Enter the total net cash flows for each year in the box below according to the provided format.

$90,000 initial cost for machinery;
depreciated straight-line over 4 years to a book value of $10,000;
35% marginal tax rate;
$55,000 additional annual revenues;
$25,000 additional annual cash expense;
annual expense for debt financing is $7,500.
$3,500 previously spent for engineering study;
The project requires inventory increase by $32,000 and accounts payable increase by $14,000 at the beginning of the project;
The investment in working capital occurs one time at the beginning of the project and it requires working capital return to the original level when the project ends in 4 years;
11% cost of capital;
life of the project is 4 years; and
The new equipment will be sold at the end of 4 years; expected market value of the new equipment at the end of 4 years is $15,000;

*For full credit please copy and paste any Excel tables you used to arrive at your answer.

Clearly label each year's cash flow ("Year 0 CF = ____, Year 1 CF = ____, Year 2 CF = ____, Year 3 CF = ____, Year 4 CF = ___") at the top of the answer box. Please format your final answer to the nearest $,X. Paste all Excel tables and work below the final answers.

HTML EditorKeyboard Shortcuts

Font SizesParagraph

Flag this QuestionQuestion 285pts

You are analyzing a capital budgeting project and, as shown by ???, some numbers are unreadable. You can read the following information: Cash Flows at the end of:

Year 0 = -$25,000
Year 1 = +$8,000
Year 2 = +$ 6,000
Year 3 = +$ 2,600
Year 4 = $ ???
Year 5 = +$ 9,500

The Cost of Capital is 13%, the NPV = -$5,650.01 and the IRR = ???%. Your superior, ignoring the important fact that we should reject the project, is demanding to know the Cash Flow in Year 4.Calculate the cash flow in Year 4. (format as $XX.XX)

*For full credit please copy and paste any Excel tables you used to arrive at your answer.