(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) whenever applicable..)
Ferengi, Inc. is subject to an applicable corporate tax rate of 35 percent, and the weighted average cost of capital (WACC) of 12.5 percent. There is no specific time constraint on investment project payback requirements.
Q1: Ferengi is currently contemplating two capital investment plans. Plan A: the upgrade of an information system with an installed cost of $2,400,000. The upgrade system will be depreciated straight-line to zero over the project’s five-year life, at the end of which the system will be worth $400,000 at the market. The system upgrade will not affect sales, but will save the firm $700,000 per year in pretax operating costs; and the upgrade will increase the working efficiency and reduce the net working capital expenditure by $300,000 at the beginning year.
What is the NPV of Plan A? What is the IRR of Plan A? Should Ferengi accept or reject Plan A?
Q2: Instead of Plan A, Ferengi can alternatively choose Plan B: allocate the $2,400,000 capital budget to develop a new product line. The new product line will be depreciated straight-line to zero over the project’s ten-year life, at the end of which the system will be worth $100,000. The new product line will not only add the firm $830,000 per year in sales, but also add $200,000 per year in pretax operating costs; and the new project line requires an initial investment in net working capital of $300,000 at the beginning year.
What would be the NPV of Plan B? What would be the IRR of Plan B? If these two plans are mutually exclusive, shall Ferengi finally choose Plan A or B?
This should be done in excel and please show me how you got the formulas in excel....
Ferengi should reject both the plans even if they are mutually exclusive. The reason is obvious the IRR is lower than the minimum cost of capital the company has to bear to fund these projects. So it's not worthy of investments.
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…),...
Dog Up! Franks is looking at a new sausage system with an installed cost of $465,000. This cost will be depreciated straight-line to zero over the project’s five-year life, at the end of which the sausage system can be scrapped for $61,000. The sausage system will save the firm $143,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $27,000. If the tax rate is 22 percent and the discount rate...
Your firm is contemplating the purchase of a new $500,000 computer-based order entry system. the system will be depreciated straight-line to zero over its 5-year life. It will be worth $44,000 at the end of that time. You will be able to reduce working capital by $69,000 at the beginning of the project. Working capital will revert back to normal at the end of the project. The tax rate is 23% and the required return on the project is 11%a)...
MUST SHOW CORRECT EXCEL FORMULAS. ONLY ANSWER HIGHLIGHTED PORTIONS. XUR 5 + Calculating NPV - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign in Calibri 11 - A A 23 Paste BIU E! - A % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font . A1 fx A B C D E F G H 1 2 Quad Enterprises is considering a new three-year expansion project that requires an initial fixed...
MUST SHOW ALL CORRECT EXCEL FORMULAS XUR 5 + Calculating NPV - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign in Calibri 11 - A A 23 Paste BIU E! - A % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font . A1 fx A B C D E F G H 1 2 Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of...
Kolby's Korndogs is looking at a new sausage system with an installed cost of $745,000. This cost will be depreciated straight-line to zero over the project's 7-year life, at the end of which the sausage system can be scrapped for $103,000. The sausage system will save the firm $219,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $71,000. If the tax rate is 23% and the discount rate is 10%,...
Kolby’s Korndogs is looking at a new sausage system with an installed cost of $725,000. This cost will be depreciated straight-line to zero over the project’s 7-year life, at the end of which the sausage system can be scrapped for $99,000. The sausage system will save the firm $211,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $63,000. If the tax rate is 24 percent and the discount rate is...
Kolby’s Korndogs is looking at a new sausage system with an installed cost of $740,000. This cost will be depreciated straight-line to zero over the project’s 7-year life, at the end of which the sausage system can be scrapped for $102,000. The sausage system will save the firm $217,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $69,000. If the tax rate is 22 percent and the discount rate is...
Kolby’s Korndogs is looking at a new sausage system with an installed cost of $730,000. This cost will be depreciated straight-line to zero over the project’s 7-year life, at the end of which the sausage system can be scrapped for $100,000. The sausage system will save the firm $213,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $65,000. If the tax rate is 25 percent and the discount rate is...
Kolby’s Korndogs is looking at a new sausage system with an installed cost of $675,000. This cost will be depreciated straight-line to zero over the project’s 5-year life, at the end of which the sausage system can be scrapped for $89,000. The sausage system will save the firm $191,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $43,000. If the tax rate is 24 percent and the discount rate is...
Kolby’s Korndogs is looking at a new sausage system with an installed cost of $660,000. This cost will be depreciated straight-line to zero over the project’s 5-year life, at the end of which the sausage system can be scrapped for $86,000. The sausage system will save the firm $185,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $37,000. If the tax rate is 21 percent and the discount rate is...