Dear Student , below complete calculation of Net present value for new project along with IRR calculation method . Always good to calculate IRR in excel sheet with below formula IRR = SUM OF CASH INFLOW AND CASH OUTFLOW
Maxi care Corporation - a Non Profit organization | ||||||
To open new chain care - need new facility | ||||||
initial Cash outlay lease , renovation etc - $ 17 Mio | ||||||
Projected cash inflow obver the 10 years time in multiple phase wise | ||||||
the lease agreement will be over 10 years period | ||||||
Cost of capital @ 12% | ||||||
First need to derived Net present Value of this project | ||||||
Discount factor | 12% | |||||
Year | Cash flow movement $ A | PV factor-B | Value$ (A*B) | |||
Initial Investemnt | 0 | -1,70,00,000 | 1 | -1,70,00,000 | ||
Cash inflow | 1 | - | 0.8929 | - | ||
Cash inflow | 2 | 40,00,000 | 0.7972 | 31,88,776 | ||
Cash inflow | 3 | 40,00,000 | 0.7118 | 28,47,121 | ||
Cash inflow | 4 | 25,00,000 | 0.6355 | 15,88,795 | ||
Cash inflow | 5 | 30,00,000 | 0.5674 | 17,02,281 | ||
Cash inflow | 6 | 30,00,000 | 0.5066 | 15,19,893 | ||
Cash inflow | 7 | 30,00,000 | 0.4523 | 13,57,048 | ||
Cash inflow | 8 | 30,00,000 | 0.4039 | 12,11,650 | ||
Cash inflow | 9 | 30,00,000 | 0.3606 | 10,81,830 | ||
Cash inflow | 10 | 30,00,000 | 0.3220 | 9,65,920 | ||
NEGATIVE NPV | -15,36,687 | |||||
So as per above calculation , NPV is showing NEGATIVE . ($15,36,687) | ||||||
IRR Calcuate is Sum of ( Cash Inflow and Cash Outflow ) | 9.928% | |||||
( in the above case | ||||||
to derived IRR , need to sum total Cash inflow and cash outflow ) and derived IRR rate | ||||||
Year | Cash flow movement $ A | |||||
Initial Investemnt | 0 | -1,70,00,000 | ||||
Cash inflow | 1 | - | ||||
Cash inflow | 2 | 40,00,000 | ||||
Cash inflow | 3 | 40,00,000 | ||||
Cash inflow | 4 | 25,00,000 | ||||
Cash inflow | 5 | 30,00,000 | ||||
Cash inflow | 6 | 30,00,000 | ||||
Cash inflow | 7 | 30,00,000 | ||||
Cash inflow | 8 | 30,00,000 | ||||
Cash inflow | 9 | 30,00,000 | ||||
Cash inflow | 10 | 30,00,000 | ||||
IRR | 9.928% |
Break even Selling price = PV of all Cash inflow $ 15463313
Year | Cash flow movement $ A | PV factor-B | Value$ (A*B) | |
Cash inflow | 1 | - | 0.8929 | - |
Cash inflow | 2 | 40,00,000 | 0.7972 | 31,88,776 |
Cash inflow | 3 | 40,00,000 | 0.7118 | 28,47,121 |
Cash inflow | 4 | 25,00,000 | 0.6355 | 15,88,795 |
Cash inflow | 5 | 30,00,000 | 0.5674 | 17,02,281 |
Cash inflow | 6 | 30,00,000 | 0.5066 | 15,19,893 |
Cash inflow | 7 | 30,00,000 | 0.4523 | 13,57,048 |
Cash inflow | 8 | 30,00,000 | 0.4039 | 12,11,650 |
Cash inflow | 9 | 30,00,000 | 0.3606 | 10,81,830 |
Cash inflow | 10 | 30,00,000 | 0.3220 | 9,65,920 |
Break even Sales point | 1,54,63,313 |
After consider above Break even Sales point value as cash outflow , we can see , NPv is at break even point as below
Year | Cash flow movement $ A | PV factor-B | Value$ (A*B) | |
Initial Investemnt | 0 | -1,54,63,313 | 1 | -1,54,63,313 |
Cash inflow | 1 | - | 0.8929 | - |
Cash inflow | 2 | 40,00,000 | 0.7972 | 31,88,776 |
Cash inflow | 3 | 40,00,000 | 0.7118 | 28,47,121 |
Cash inflow | 4 | 25,00,000 | 0.6355 | 15,88,795 |
Cash inflow | 5 | 30,00,000 | 0.5674 | 17,02,281 |
Cash inflow | 6 | 30,00,000 | 0.5066 | 15,19,893 |
Cash inflow | 7 | 30,00,000 | 0.4523 | 13,57,048 |
Cash inflow | 8 | 30,00,000 | 0.4039 | 12,11,650 |
Cash inflow | 9 | 30,00,000 | 0.3606 | 10,81,830 |
Cash inflow | 10 | 30,00,000 | 0.3220 | 9,65,920 |
NPV Break Even | - |
MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether...
MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether to expand operations by opening a new chain of care centers in the inner city of large metropolitan areas. For a new facility, initial cash outlays for lease, renovations, net working capital, training, and other costs are expected to be about $24 million. The corporation expects the cash inflows of each new facility in its first year of operation to equal the initial investment...
MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether to expand operations by opening a new chain of care centers in the inner city of large metropolitan areas. For a new facility, initial cash outlays for lease, renovations, net working capital, training, and other costs are expected to be about $14 million. The corporation expects the cash inflows of each new facility in its first year of operation to equal the initial investment...
MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether to expand operations by opening a new chain of care centers in the inner city of large metropolitan areas. For a new facility, initial cash outlays for lease, renovations, net working capital, training, and other costs are expected to be about $12 million. The corporation expects the cash inflows of each new facility in its first year of operation to equal the initial investment...
MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether to expand operations by opening a new chain of care centers in the inner city of large metropolitan areas. For a new facility, initial cash outlays for lease, renovations, net working capital, training, and other costs are expected to be about $16 million. The corporation expects the cash inflows of each new facility in its first year of operation to equal the initial investment...
MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether to expand operations by opening a new chain of care centers in the inner city of large metropolitan areas. For a new facility, initial cash outlays for lease, renovations, net working capital, training, and other costs are expected to be about $16 million. The corporation expects the cash inflows of each new facility in its first year of operation to equal the initial investment...
MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether to expand operations by opening a new chain of care centers in the inner city of large metropolitan areas. For a new facility, initial cash outlays for lease, renovations, net working capital, training, and other costs are expected to be about $20 million. The corporation expects the cash inflows of each new facility in its first year of operation to equal the initial investment...
MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether to expand operations by opening a new chain of care centers in the inner city of large metropolitan areas. For a new facility, initial cash outlays for lease, renovations, net working capital, training, and other costs are expected to be about $26 million. The corporation expects the cash inflows of each new facility in its first year of operation to equal the initial investment...
Please help these answers are not correct MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether to expand operations by opening a new chain of care centers in the inner city of large metropolitan areas. For a new facility, initial cash outlays for lease, renovations, net working capital, training, and other costs are expected to be about $20 million. The corporation expects the cash inflows of each new facility in its first year...
MaxiCare Corporation, a not-for-profit organization, specializes in health care for senior citizens. Management is considering whether to expand operations by opening a new chain of care centers in the inner city of large metropolitan areas. For a new facility, initial cash outlays for lease, renovations, net working capital, training, and other costs are expected to be about $17 million. The corporation expects the cash inflows of each new facility in its first year of operation to equal the initial investment...
14 J. Morgan of SparkPlug Inc. has been approached to take over a production facility from B.R. Machine Company. The acquisition will cost $1,900,000, and the after-tax net cash inflow will be $306,000 per year for 12 years. SparkPlug currently uses 9% for its after-tax cost of capital. Tom Morgan, production manager, is very much in favor of the investment. He argues that the total after-tax net cash inflow is more than the cost of the investment, even if the...